Configure Airtable
At a glance
Airtable is a no-code collaborative database platform. With Ontologie, you can sync your bases, tables, and individual records into your workspace for enrichment and analysis.
Before you start
- An Airtable account with access to the bases you want to sync
- A Personal Access Token (PAT) with the required scopes
Get credentials
- Go to Airtable Developer Hub and sign in.
- Click Create new token.
- Give the token a descriptive name and select the scopes:
data.records:read,schema.bases:read. - Select the bases you want the token to access, then click Create token and copy the value.
Screenshots of the Airtable developer hub will be added in a future update.
Configure in Ontologie
- Open Live Data > Connectors.
- Search for Airtable in the catalogue.
- Click the Airtable card.
- Follow the configuration wizard:
- Method: API Key (Personal Access Token)
- See the full guide: API Key Connector
Available streams
| Stream | Description |
|---|---|
| Bases | List of all bases accessible by the token |
| Tables | Table definitions and schema within each base |
| Records | Row-level data from each table, including all field values |
Limits
| Limit | Value |
|---|---|
| API rate limit | 5 requests per second per base |
| Records per request | 100 records per page |
| Token scope | Limited to bases selected during token creation |
Troubleshooting
| Error | Solution |
|---|---|
| 401 Unauthorized | Verify the Personal Access Token is valid and has not been revoked. |
| 403 Forbidden | Ensure the token has been granted access to the target base. |
| Missing tables | Check that the token scopes include schema.bases:read. |
Expected result
Your data appears in Live Data > Streams with the Synced status. Synchronization runs at the configured frequency.
Need help?
See the Troubleshooting page for connection errors or write to us: Support and contact.