 |
 |
Hi Lisa One thing that comes to mind would be for you to query a book price API from OpenRefine using the "Add column by fetching URLs" function: https://github.com/OpenRefine/OpenRefine/wiki/Fetching-URLs-From-Web-Services Querying the Amazon database has become quite a complex affair nowadays. You might have better luck with the ISBNdb: http://isbndb.com/api/v2/docs/prices Getting a free key is a matter of seconds, and you can then query their service using the ISBN directly. The OpenRefine tutorial cited above should help you parse the JSON returned by the ISBNdb API call to extract only the price information. A free key only grants you 500 queries per day, so you may want to parse your list into smaller chunks. Or get a paid key. ISBNdb aggregates information from different sources, so you might need to decide what to do with the different prices you get: take the minimum, or an average, etc. However, ISBNdb's database may be less extensive than Amazon's. If you want to query Amazon, I'm not sure what the GitHub script you are referring to does, but my understanding is that it acts as a wrapper around Amazon's native API and reformats its output. Since this code is 5 years old, there are chances the API has changed since then, but you can try. You might have better luck querying Amazon's Product Advertising API directly, e.g. with https://docs.aws.amazon.com/AWSECommerceService/latest/DG/ItemLookup.html Good luck! Thomas On Thu, Aug 13, 2015 at 11:25 AM, Lisa McColl <[log in to unmask]> wrote: > Hello, > > We have a large spreadsheet of titles/isbns etc that lists books from our > collection that are missing. To help our selectors decide whether or not > they want to replace the books, we would like to add a price column to the > spreadsheet. > > There is an Amazon "price check" script on GitHub ( > https://github.com/JohnKimDev/Amazon-Price-Check) but I was wondering if > anyone knows of an extension that enables OpenRefine with Amazon. It seems > it would work well for our needs. > > Thank you. > -- > *Lisa McColl* > *Cataloging/Metadata Librarian* > *Lehigh University* > *610-758-2639* >