Connecting to UPC Database#
First Steps with UPC Database#
Set up an account with UPC Database.
There are both free and paid options for this API.
There are no known rate limits for this API.
How to Connect DataDistillr to UPC Database#
To set up a data source connect for UPC Database, you will need to have:
- A unique name for your data source connection to be used in queries
- An API token generated through your UPC Database account
Data Source Form#
To locate the UPC Database form, follow the steps in Connecting Your Data to DataDistillr. When you get to the window to choose the data source type, select API as shown below.
On the API screen, select UPC Database from the list of API forms.
The following form will appear. Instructions are below on how to find the information required to fill each on the UPC Database API form.
Once you have filled out all the fields, press the green 'Save' button, and your API will be connected!
Enter any name that will help you recognize this data source within your query window.
Acceptable Characters Include
- lowercase alphanumeric characters
An API key is generated within your account page. The following steps will navigate you to its location. Once created, copy the key and enter it in the UPC Database form under 'API key'.
While in the UPC Database home page, click the Your Account drop down menu and then click on Dashboard.
This page displays your account information. Click on API Keys in the sidebar.
In this page you can create and remove tokens from your account.
The table below shows a list of endpoints available to connect within the DataDistillr application. If you need to connect to any endpoints not listed in the table below, please use the Custom API Form.
||id||Get product information for a particular item|
||query||Search for a product based on item parameters|
||base||Retrieve a list of currently supported currencies by the currency API|
|Retrieve a list of historically supported currencies by the currency API|
||Retrieve a list of currencies symbols of the currency API|
The endpoints above will display as follows in the nav tree once your API has successfully connected.
The following queries are intended to help you get started, and make life simpler querying within your API.
For the following examples, suppose that my UPC Database API data source was called
myupcdbapi and I want to query an
endpoint. In the
FROM clause, the endpoint goes after the UPC Database data source name.
With this endpoint you can search information about a SKU with the ID of the product.
Search for Product#
With this endpoint you can search products with keywords.
Retrieve List of The Latest Currency#
With this endpoint you can get the currencies that are supported.
Retrieve List of Historic Currency#
With this endpoint you can get the currencies that were supported throughout history .
Retrieve List of Currency Symbols#
With this endpoint you can get the symbols of the currencies.