The Amazon Product Advertising API is a world-class web service used by millions of customers every day.
It gives access to much of the same data that is used by Amazon including the items for sale, customer reviews and seller reviews. You can search for items by keyword, similarity to other products, or by navigating product categories.
What is Gridarrow?Gridarrow is the missing server for Excel. It connects just about any data source to Excel with simple Python scripts.
Why is it awesome?
- It's real-time, so as soon as the data is updated in the Gridarrow App it's updated in Excel, no need to poll or refresh.
- It's multi-user so your colleagues can connect to the same data at the same time.
- It simplifies your spreadsheets by moving data retrieval and pre-processing into Python.
There is a really nice Python client available on Github, making integrating this API with Excel a breeze using Gridarrow.
Here’s a very simple example where we’ve used the API to search for similar items to the game Jenga!
The Amazon Product API isn’t exactly what we’d call a highly dynamic “real-time” data source - but that
doesn’t mean the data doesn’t change! Prices are updated, reviews get added, and new products are
released. If you check the Python code in the example below you can see that we’ve used the
annotation to make our data get updated every 3 hours between Monday and Friday.