I don't see where the space is missing..
I did not put quotes in the base string. I assume that it only serves
as a way to claculate an oauth signature, which is calculated exactly
as by your website and by twitter.

Still stuck....

On Sep 21, 12:16 am, Tom van der Woerdt <i...@tvdw.eu> wrote:
> Multiple things:
>  * You missed a space in the Authorization header. Go look in my post ;)
>  * You don't have to put the quotes in the Base String. Only in the
> Authorization: header.
>
> Tom
>
> On 9/21/10 12:14 AM, Randomness wrote:
>
>
>
> > I still get the same mistake all the time, after I get asked and
> > cancel for a username and password:
>
> > <?xml version="1.0" encoding="UTF-8"?>
> > <errors>
> >   <error code="32">Could not authenticate you</error> </errors>
>
> > The xml part of the VBA now looks like this:
>
> > Set xml = CreateObject("MSXML2.XMLHTTP") xml.Open "POST", Cells(18,
> > 3), False xml.setRequestHeader "Authorization", "OAuth" & Cells(17, 3)
> > xml.Send tResult = xml.responsetext Cells(7, 5) = tResult Debug.Print
> > tResult Set xml = Nothing
>
> > Cells(18,3) =http://api.twitter.com/1/statuses/update.xml?status=testing
> > I believe calling it this way does not need quotes, because it is
> > already called as a string.
>
> > I changed the authorization header.
>
> > I put quotes around the values and url encoded the values. Cells(17,3)
> > now looks like this:
>
> > oauth_consumer_key%3D%22MYCONSUMERKEY%22%2Coauth_token%3D%MYOAUTHTOKEN
> > %22%2Coauth_signature_method %3D%22HMAC-SHA1%22%2Coauth_signature%3D
> > %22AXBM9Mpc2k3+/jYGTvs/JE4G8BQ=%22%2Coauth_timestamp%3D
> > %221285025757%22%2Coauth_nonce%3D
> > %22slnbcv0vxt1gzwfDz2Celv2ojcpqabyxoEB9sEal4%22%2Coauth_version%3D
> > %221.0%22
>
> > When calculating signatures I get the exact same values as are
> > calculated on your Quonos site. They are also the same as calculated
> > with the examples given by Twitter.
>
> > This is a tough nut to crack! :-)
>
> > On Sep 20, 9:06 pm, Tom van der Woerdt <i...@tvdw.eu> wrote:
> >> Hi,
>
> >> I see multiple things that are wrong:
> >>  * You didn't put quotes around your URL
> >>  * You shouldn't send OAuth: as an header. The header is Authorization:
> >> OAuth <headerstring>. (xml.setRequestHeader "Authorization", "OAuth " &
> >> headerstring
> >>  * You should put quotes around the values in headerstring, and if you
> >> haven't done so already, URLencode the values
> >>  * There's no signature in headerstring
>
> >> If you changed those, and it still doesn't work, please give these :
> >>  * A sample Base String
> >>  * A TCP dump of a full request, including response.
>
> >> Tom
>
> >> PS: Do I know you?
>
> >> On 9/20/10 8:38 PM, Randomness wrote:
>
> >>> I believe I have solved all the issues of getting the right
> >>> information to send a tweet using Excel. Calculation of oauth_nonce
> >>> and oauth_timestamp look good and also the calculation of the
> >>> oath_signature seems to be in order.
>
> >>> When I try to post the message I get a message asking for user name
> >>> and password and when I cancel this I get an error 32.
>
> >>> I am doing the following:
>
> >>> Set xml = CreateObject("MSXML2.XMLHTTP")
> >>> xml.Open "POST",http://api.twitter.com/1/statuses/update.xml?status=text
> >>> of the update, False
> >>> xml.setRequestHeader "OAuth", headerstring
> >>> xml.Send
> >>> tResult = xml.responsetext
> >>> Debug.Print tResult
> >>> Set xml = Nothing
>
> >>> headerstring="oauth_consumer_key=myconsumerkey,
> >>>                      oauth_token=mytoken,
> >>>                      oauth_signature_method =HMAC-SHA1,
> >>>                      oauth_signature=calculatedsignature,
> >>>                      oauth_timestamp=1285014608,
>
> >>> oauth_nonce=81A1iuux8jzxgieaxmmp3ta2bDdqefd88hp9soo31,
> >>>                      oauth_version=1.0"
>
> >>> Any help wouldbe appreciated because I am really stuck.- Hide quoted text 
> >>> -
>
> >> - Show quoted text -- Hide quoted text -
>
> - Show quoted text -

-- 
Twitter developer documentation and resources: http://dev.twitter.com/doc
API updates via Twitter: http://twitter.com/twitterapi
Issues/Enhancements Tracker: http://code.google.com/p/twitter-api/issues/list
Change your membership to this group: 
http://groups.google.com/group/twitter-development-talk?hl=en

Reply via email to