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=32Could not authenticate you/error /errors
The xml part of the VBA now looks like this:
Set xml = CreateObject(MSXML2.XMLHTTP) xml.Open POST,
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
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
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:
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
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:
POSThttp%3A%2F%2Fapi.twitter.com%2F1%2Fstatuses
%2Fupdate.xmloauth_consumer_key%3DMUCONSUMERKEY%26oauth_nonce
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
Well, you most likely misinterpreted ;-)
headerstring=oauth_consumer_key=myconsumerkey,
oauth_token=mytoken,
oauth_signature_method =HMAC-SHA1,
oauth_signature=calculatedsignature,
oauth_timestamp=1285014608,