Amazon lookup in Script

[deego55]

Hi-

I have a script in a database that does a lookup on Amazon and pulls in book information. How it works is that i input an ISBN in the ISBN field and press a button that runs a lookup script using Amazon's Web Services and pulls in the Title, Author, Publisher, Price, etc. into the respective fields.

What I want to know is: How can i run this script on every record at once? I want to import a list of ISBNs and have the script run on every record. This would be easy as a lookup, but I have never done this using an external source like Amazon. Any help is appreciated. I dont want to have to press the button for each record!

[-Queue-]

Create a script that loops through the found set and performs the script that is attached to the button.

Go to Record/Request/Page [First]

Loop

Perform Script ["Amazon Lookup"]

Go to Record/Request/Page [Exit after last; Next]

End Loop

[kisscass]

This functionality would be perfect for my library database.

I've signed up to Amazon Web Services, but neither their documentation or their forums have any FM specific information.

Would I use XML or XSLT within a script to make the Amazon search then copy the text/image into the relevant fields?

Any advice would be welcome.