Anyone got a calculation for Amazons new signed requests?

[Cabinetman]

I don't know for sure where this question should go... but this seems right to me.

I use the open URL to get XML product data from Amazon and they are changing things to require a signature.

Old:

http://webservices.amazon.com/onca/xml?Service=AWSECommerceService&AWSAccessKeyId=*******&Operation=ItemLookup&ItemId=9781585672844&IdType=EAN&ResponseGroup=small

New:

http://webservices.amazon.com/onca/xml?AWSAccessKeyId=*******&IdType=EAN&ItemId=9781585672844&Operation=ItemLookup&ResponseGroup=small&Service=AWSECommerceService&Timestamp=2009-08-10T22%3A45%3A28.000Z&Signature=9%2BTIDVYxBNBQB72mvmb%2Bnxjc%2BjE2LzGv2wln7%2Bdh8hQ%3D

This page shows the process:

http://associates-amazon.s3.amazonaws.com/signed-requests/helper/index.html

I'm thinking a calc could do it but this is beyond me and I depend heavily on this for my selling.

Anyone?

[fseipel]

Hello,

Unfortunately the canonical string must be signed with HMAC-RSA256 encoding, so it is beyond the scope of a simple custom function or script. That's not to say it couldn't be done, it's just difficult using Filemaker custom functions or scripts.

The signature is only valid for a certain period of time, so the timestamp must also be fresh. Signatures go into effect 15 Aug; after that, no unsigned requests will be processed.

I wrote a plugin for Windows to sign ECS requests a couple months ago. http://www.lillysmedialogistics.com/software/ -- alternately, you can write your own plugin to achieve this, or use a signing service (typically requires giving out your key&secret key to 3rd party), or write something up using the PHP or ScriptMaster plugins, from which HMAC-RSA256 encryption are trivial. I'm sure there are other alternatives too.

[Cabinetman]

I'm NOT a programmer so trying to do this is like trying to learn brain surgery in under a week... lol

Add to that ... this is still a secondary job until Nov. when it becomes my full time so needless to say I was in panic mode.

I have a long way to go with my database but all my listing/pricing functions depend on getting Amazons info into the database.....

I was so praying that someone might have a plugin for this because I still have about a month of heavy work in my main business before starting to close it down. No time to figure this out now OR have my stuff go down...

Thanks! I look forward to trying it!