Airtable connector

The Airtable REST API connector is used for data extracted from an Airtable base, using their REST API.

Creation

Caution

It is mandatory to be the owner of the Airtable table to be able to connect it to Opendatasoft.

  1. Find your Airtable API URL from:

  • your workspace: Help > API documentation > [your base] > Authentication

  • your base: Choose your table, then go to Help > API documentation > Authentication

  1. Check the show API key checkbox and copy the EXAMPLE USING QUERY PARAMETER without the curl. This is your API URL. (for example, https://api.airtable.com/v0/base_id/table_name?api_key=api_key)

  2. Enter the URL to the layer in the Enter a URL area when creating a new dataset.

  3. Press Enter or click the + button.

Note

In the example https://api.airtable.com/v0/base_id/table_name?api_key=api_key, the base_id field stands for the ID of your Airtable database. The table_name field stands for the name of the table to import from the database in Unicode.

Configuration

Name Description Default Value
Base ID ID of your Airtable database By default, the textbox is extracted from the base_id field of the URL.
Table Name Name of the table to import from the database By default, the textbox is extracted from the table_name field of the URL.
API key Airtable account API key By default, the textbox is extracted from the api_key field of the URL.

Note

The Airtable REST API is limited to 5 requests per second per base. Try not to schedule updates of tables from the same base all at once.