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!

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

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.