How to access the Data Boutique dataset catalog via API?
You can access the catalog of datasets available on Data Boutique by using Softr API (doc available at this link).
with Data Boutique will provide you a Personal Authentication Token that enables you to read a dedicated base and table containing all the currently active contracts on the platform.
You'll need to use the ListRecords endpoint of the API (doc here), pointing to:
- baseId = 'app7DtPHxXIGPxjb9'
- tableId = 'tblts91SHwrNOT3zz'
Here's an example of API call using cUrl
curl "https://api.airtable.com/v0/app7DtPHxXIGPxjb9/tblts91SHwrNOT3zz" -H "Authorization: Bearer YOUR TOKEN"
How to read the API response
A typical response will be a JSON that will look like the following: https://jsonblob.com/1298656660196024320
The server returns one page of records at a time. Each page will contain pageSize records, which is 100 by default. If there are more records, the response will contain an offset. To fetch the next page of records, include offset in the next request's parameters. Pagination will stop when you've reached the end of your table. If the maxRecords parameter is passed, pagination will stop once you've reached this maximum.
Data Dictionary
The content of the catalog is organized in following fields:
| Field | Description |
| Contract | Data seller contract ID, Code that identifies this data feed |
| Title | Short name for the feed |
| Geography Description | Name of the geography |
| Geography Code | Code of Geography |
| Schema Description | Schema short description |
| Schema Code | Schema code |
| Website Name | Website Name |
| Website Image | URL of cover image |
| Geography Image | URL of Geography Flag |
| Refresh Policy | Frequency of refresh of the data feed |
| Price | Purchase price in EUR |
| Sample File | URL of sample file |
| Last Delivered Date | Most recent delivered date in feed |
| DBQ Product URL | URL of product page. The URL is relative, add www.databoutique.com/ to use |