that was the part of the header after authorization and oauth. Just
read back and you will see it.
On Sep 21, 12:42 am, Tom van der Woerdt <i...@tvdw.eu> wrote:
> That Base String looks fine. But what was the thing you showed us a few
> posts back? (Really, it looked like a base string!)
>
> Tom
>
> On 9/21/10 12:39 AM, Randomness wrote:
>
>
>
> > I am really getting confused. I did not show the base string, as I
> > believe it is only used to caclulate the signature, but it looks like
> > this:
>
> > POST&http%3A%2F%2Fapi.twitter.com%2F1%2Fstatuses
> > %2Fupdate.xml&oauth_consumer_key%3DMUCONSUMERKEY%26oauth_nonce
> > %3DBy0mBhrkliegb29E2gek6japm6Cqkg4wiuoy0834d%26oauth_signature_method
> > %3DHMAC-SHA1%26oauth_timestamp%3D1285028392%26oauth_token%MYOAUTHTOKEN
> > %26oauth_version%3D1.0%26status%3Dtesting
>
> > Combining this with the composite signing key and base64 encoding
> > gives me the oauth signature.
>
> > Following this, it is my understanding that two lines are needed. One
> > with the url and one with the authorization haeder as shown above....
>
> > On Sep 21, 12:30 am, Tom van der Woerdt <i...@tvdw.eu> wrote:
> >> Bad: xml.setRequestHeader "Authorization", "OAuth" & Cells(17, 3)
> >> Good: xml.setRequestHeader "Authorization", "OAuth " & Cells(17, 3)
>
> >> Also, if I am not mistaken, %22 is " and I definitely see those in your
> >> Base String ;-) I'm not saying that it's impossible to have them there,
> >> just that it's very unlikely that you need them there.
>
> >> Also, like Taylor pointed out: there's no status= in your base string ;-)
>
> >> Tom
>
> >> On 9/21/10 12:22 AM, Randomness wrote:
>
> >>> 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 -- 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
