0

My question is very clear. Is it possible to sign Amazon product advertising API request with VBA in Excel or is this not possible? There are so many discussions on this topic open on the web, but I couldn't find a working example or a clear answer. So, Amazon experts, I am challanging you.

The functionality should return the same result as this online module: http://associates-amazon.s3.amazonaws.com/signed-requests/helper/index.html

And here is some help about hot to do it: http://docs.aws.amazon.com/AWSECommerceService/latest/DG/rest-signature.html

But it looks like nobody has yet been able to accomplish this taks with pure VBA.

Anybody?

gdolenc
  • 301
  • 1
  • 2
  • 16
  • As you note, the signing process is documented, and as I'll mention, it's not an especially complicated task... except that you have to generate a SHA256 HMAC... which I seem to have found [here on SO](http://stackoverflow.com/a/28453704/1695906) before noticing that it also appears to be the 2nd hit when googling "hmac sha256"... so, "yes, it's possible." Unless "pure VBA" means no dependencies at all, in which case you'd have to write HMAC in VBA. Not impossible, but not pleasant. – Michael - sqlbot Feb 15 '17 at 12:11
  • But if you're just going to click these, why not write a web microservice that generates the signed URLs and either redirects you or proxies the request through to the real endpoint. Then you would avoid having your secret key in the spreadsheet (cells or VBA code), which would be a pretty bad idea depending on who has access to the spreadsheet. – Michael - sqlbot Feb 15 '17 at 12:15
  • Thanks for the answer. I have found sha256 class for VBA also. But the thing is, that signature does not match - Amazon returns an error. I would like to hear a feedback of someone who has a working solution, not from someone, who just think it is possible. – gdolenc Feb 15 '17 at 14:48
  • Can you please share that class which create signature for the request ? – Pankaj Jun 08 '18 at 02:02

0 Answers0