Well, you most likely misinterpreted ;-)
>>> headerstring="oauth_consumer_key=myconsumerkey,
>>> oauth_token=mytoken,
>>> oauth_signature_method =HMAC-SHA1,
>>> oauth_signature=calculatedsignature,
>
This is what you said in your first reply:
* You should put quotes around the values in headerstring, and if
you
haven't done so already, URLencode the values
thanks for confusing me...:-)
On Sep 21, 12:46 am, Tom van der Woerdt wrote:
> There's no need for URL encoding in the header. The head
There's no need for URL encoding in the header. The header is simple:
Authorization: OAuth oauth_timestamp="", oauth_nonce="",
oauth_signature="", etc (of course, fill in the values)
Tom
On 9/21/10 12:45 AM, Randomness wrote:
> that was the part of the header after authorization and oauth. Just
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 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
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
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
%3DBy0mBhrkliegb29E2gek6japm6Cqkg4wiuoy0834
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
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 wrote:
> Multiple things
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
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
> can
I still get the same mistake all the time, after I get asked and
cancel for a username and password:
Could not authenticate you
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", "O
11 matches
Mail list logo