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 <[email protected]> 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
