Airtable

This documentation for the Airtable integration describes the technical capabilities of this integration, including authorization, scopes/permissions, and utilized endpoints. For more information on how to integrate Airtable, visit our connection instructions.

Version

This integration utilizes the Airtable Web API.

Base URL

The base URL used for all Airtable API endpoints:

https://api.airtable.com/v0

---

Authentication & Authorization

The DataGrail Airtable integration connects using token authentication which requires an API Key.

Sensitive Credentials

Publicly exposing your API credentials can allow unauthorized access to Airtable API endpoints by a third party. DataGrail stores your API credentials encrypted and protected.

Scopes

The Airtable integration requires specific scopes that must be granted in order to function for a given capability.

Scope	Access	Deletion
schema.bases:read	✅
data.records:read	✅
data.records:write		✅

Endpoints Utilized

DataGrail uses the following endpoints to authorize and test the connection:

Method	Endpoint	Purpose	Docs
GET	/meta/bases	Validate credentials

---

Limits

Limits in Airtable are calculated using the leaky bucket algorithm. All requests that are made after rate limits have been exceeded are throttled and an HTTP 429 Too Many Requests error is returned. Requests succeed again after enough requests have emptied out of the bucket.

• DataGrail supports requests throttling to stay within 70-80% of specified service rate limits.
• DataGrail processes API responses with HTTP 429 status to interrupt requests, waiting and retrying (using an exponential backoff strategy).

---

Capabilities

Access

DataGrail's Airtable integration provides Synchronous Access capabilities for the following supported identifier category: Email.

Data Interactions

For Access requests, DataGrail will take the following actions:

1. Get a list of all bases.
2. Get a list of the tables.
3. For each collected table, search by formula.
4. Extract records where at least one configured identifier is present in the following fields: email, multilineText, richText, or singleLineText

Endpoints Utilized

Method	Endpoint	Purpose	Docs
GET	/baseId/tableName	Search by formula
GET	/meta/bases	Get a list of all bases
GET	/meta/bases/base_id/tables	Get a list of tables

---

Deletion

DataGrail's Airtable integration provides Synchronous Deletion capabilities for the following supported identifier category: Email.

Data Interactions

For Deletion requests, DataGrail will take the following actions:

1. Get a list of all bases.
2. Get a list of the tables.
3. For each collected table, search by formula.
4. Extract records where at least one configured identifier is present in the following fields: email, multilineText, richText, or singleLineText
5. Deletes records given an array of record IDs retrieved in step 4.

Endpoints Utilized

Method	Endpoint	Purpose	Docs
DEL	/baseId/tableName	Delete a records
GET	/meta/bases	Get a list of all bases
GET	/meta/bases/base_id/tables	Get a list of tables

---