I played around with the ISBNdb OpenRefine queries to extract the minimum
price from their database. I had to parse the returned JSON code to do
this. In case you are interested, I've published these operations here:
They can be applied to your project by using OpenRefine's "Replaying
Have fun, and let me know if you're having any issues.
On Thu, Aug 13, 2015 at 2:36 PM, Thomas Guignard <[log in to unmask]>
> 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:
> Querying the Amazon database has become quite a complex affair nowadays.
> You might have better luck with the ISBNdb:
> 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
> Good luck!
> On Thu, Aug 13, 2015 at 11:25 AM, Lisa McColl <[log in to unmask]> wrote:
>> 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
>> 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*