Randomness, I don't have much experience in using OAuth or REST APIs from Excel like this -- but I'd like to recommend that when you are attempting to set a status that you put the status=xyz portion in the actual POST body of the request (rather than on the query string). Make sure that, at least in this exact example, that your signature base string contains the status=xyz portion, properly escaped, as the very last element of the base string.
Taylor On Mon, Sep 20, 2010 at 3:16 PM, 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 - >> > > -- > 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 > -- 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