Airtable

Read Airtable bases, their tables and their records.

Connect it in the console under Integrations > Connectors. See Connectors for how connectors work and who can use them.

Create a read-only credential

Create a personal access token at airtable.com/create/tokens with the scopes data.records:read and schema.bases:read, and give it access to the bases you want to read.

Settings

Setting		Notes
Personal access token	Required	Scopes: data.records:read, schema.bases:read. Stored encrypted and never shown again.

Tables

Table	Filters	Returns
bases	offset	Bases the token can read.
tables	baseId (required)	Tables in one base.
records	baseId (required), tableName (required), view, filterByFormula, offset	Records in one table (formula and view filters optional).

Query from the API

curl -s -X POST "https://api.vaif.studio/database/connector/$VAIF_PROJECT_ID/query" \
  -H "Authorization: Bearer $VAIF_TOKEN" -H "Content-Type: application/json" \
  -d '{"wrapperId":"airtable_fdw","table":"records","filters":{"baseId":"appXXXXXXXXXXXXXX","tableName":"Tasks","filterByFormula":"{Status} = \"Done\""},"limit":50}'

$VAIF_TOKEN is a console access token. See Connectors for the routes.

How it stays read-only

The token’s scopes are read-only, so Airtable itself refuses writes. Records can be narrowed through a view or an Airtable formula.