Airtable Web API
★ Only Publicly Available OpenAPI DocumentStorageDatabasebearer21 EndpointsREST
For Agents
Read, create, update, and delete records in Airtable bases, list tables and fields, and subscribe to webhook change events.
Use for: I want to list records from an Airtable table with a filter formula, Create a new record in a base I have access to, Update specific fields on an existing Airtable record, Delete a record by its record ID
Not supported: Does not handle row-level RBAC beyond Airtable's built-in scopes, full-text indexing across bases, or running scripts inside an Airtable extension — use for record CRUD and schema operations only.
Jentic publishes the only available OpenAPI specification for Airtable Web API, keeping it validated and agent-ready. Airtable is a cloud database that combines spreadsheet familiarity with relational features such as linked records, formulas, and views. The 21 documented endpoints expose record-level CRUD inside a base/table, metadata for bases, tables, and fields, and webhook subscriptions for change notifications. Authentication uses bearer personal access tokens or OAuth 2.0 tokens with scoped permissions per base.
Install Jentic One Beta
Connect the Airtable Web API to your agent
Jentic One is a self-hosted execution layer for AI agents. It lets your agent call the Airtable Web API, or any other public or private API you need. You set the rules, the agent never sees your credentials, and every call is logged.
Two steps, two machines. Install the instance in a safe environment, then register your agent from wherever it runs.
1
Step 1: Jentic One Host machine
# On the machine that will host your Jentic One instance:
curl -fsSL https://raw.githubusercontent.com/jentic/jentic-one/main/tools/install.sh | sh2
Step 2: Agent machine
# On the machine where your agent runs (keep this separate from the instance):
curl -fsSL https://raw.githubusercontent.com/jentic/jentic-one/main/tools/install.sh | sh
jentic register # connects your agent to your Jentic One instanceJentic One is in public beta. The setup above keeps your agent separate from the instance, which is what you want before using real credentials: an agent running as the same OS user as Jentic One can read its stored keys directly. Just evaluating? A single local install is fine to start. See the secure deployment guide for the tiers.
Capabilities
What an agent can do with Airtable Web API.
List records in a table with filterByFormula, sort, and view parameters via GET /{baseId}/{tableIdOrName}
Create one or more records in a table via POST /{baseId}/{tableIdOrName}
Update records partially with PATCH or fully with PUT on the table endpoint
Delete one record by id or many records via the deleteRecords path
List bases, tables, and fields a token can access through the /meta endpoints
Subscribe to record changes via webhooks for near real-time syncs
Use Cases
Patterns agents use Airtable Web API for, with concrete tasks.
★ Spreadsheet-Style Record Sync
Sync rows between Airtable and an external system by listing records with GET /{baseId}/{tableIdOrName} (using filterByFormula and pagination via offset), then upserting changes back with PATCH /{baseId}/{tableIdOrName}/{recordId}. Suitable for keeping CRM, billing, or content data aligned with an Airtable working copy used by non-engineers.
List records in table 'Customers' under base 'appXYZ' with filter '{Status}="Active"' and update each matching record to set field 'LastSyncedAt' to today
Lightweight Backend for Internal Tools
Use Airtable as the persistence layer for internal apps where non-engineers need to edit data directly. POST creates, PATCH updates, and DELETE removes records — all scoped to a base/table by ID. Schema introspection via /meta/bases and /meta/bases/{baseId}/tables lets the calling app render columns dynamically without hard-coding field names.
Create three new records in table 'Tasks' with fields { 'Name': 'Audit', 'Owner': 'Sam' } and verify all three IDs are returned
Webhook-Driven Change Listener
Subscribe to Airtable webhooks to react to base, table, or record-level changes without polling. Webhook subscriptions report inserts, updates, and deletes so downstream systems can update caches, trigger notifications, or sync external sources. Manage subscriptions through the /meta/bases/{baseId}/webhooks endpoints.
Create a webhook subscription on base 'appXYZ' that fires when any record in table 'Orders' is created or updated, then verify the subscription is listed
Schema-Aware Bulk Migrations
Migrate or normalise data inside an Airtable base by introspecting field types via /meta/bases/{baseId}/tables, then issuing PATCH or PUT calls in batches of up to 10 records per call. Useful when consolidating multiple bases, renaming fields, or back-filling new columns.
Read the schema of base 'appXYZ', identify the 'Email' field in table 'Contacts', and patch all records to lowercase the email value
Agent CRUD via Jentic
Agents perform Airtable CRUD by searching Jentic for the right record-level operation, loading the schema, and executing under a personal access token managed by Jentic. Removes the need for the agent to remember field-specific endpoint paths or pagination semantics.
Search Jentic for 'list records in an airtable table', load the operation, and execute with baseId 'appXYZ' and tableIdOrName 'Customers'
Key Endpoints
21 endpoints — jentic publishes the only available openapi specification for airtable web api, keeping it validated and agent-ready.
METHOD
PATH
DESCRIPTION
GET
/{baseId}/{tableIdOrName}
List records in a table
POST
/{baseId}/{tableIdOrName}
Create records
PATCH
/{baseId}/{tableIdOrName}
Update records (partial)
DELETE
/{baseId}/{tableIdOrName}/deleteRecords
Delete multiple records by IDs
GET
/{baseId}/{tableIdOrName}/{recordId}
Get a single record
PATCH
/{baseId}/{tableIdOrName}/{recordId}
Update a single record
GET
/meta/bases
List accessible bases
GET
/meta/bases/{baseId}/tables
List tables in a base
GET
/{baseId}/{tableIdOrName}
List records in a table
POST
/{baseId}/{tableIdOrName}
Create records
PATCH
/{baseId}/{tableIdOrName}
Update records (partial)
DELETE
/{baseId}/{tableIdOrName}/deleteRecords
Delete multiple records by IDs
GET
/{baseId}/{tableIdOrName}/{recordId}
Get a single record
PATCH
/{baseId}/{tableIdOrName}/{recordId}
Update a single record
GET
/meta/bases
List accessible bases
GET
/meta/bases/{baseId}/tables
List tables in a base
Why Jentic?
Three things that make agents converge on Jentic-routed access.
Credential isolation
Airtable personal access tokens and OAuth bearer tokens are stored encrypted in the Jentic vault. Agents call the operation with a runtime token and the Authorization header is injected at execution time so raw tokens never enter the agent context.
Intent-based discovery
Agents search by intent ('list airtable records', 'create an airtable record') and Jentic returns the matching operation along with the baseId/tableIdOrName parameter schema.
Time to first call
Direct Airtable integration: 1-2 days for token setup, pagination, and rate-limit handling. Through Jentic: under 30 minutes — search, load schema, execute.
Related APIs
Alternatives and complements available in the Jentic catalogue.
FAQs
Specific to using Airtable Web API through Jentic.
Why is there no official OpenAPI spec for Airtable Web API?
Airtable does not publish a public OpenAPI specification for the Web API. Jentic generates and maintains this spec so that AI agents and developers can call Airtable Web API via structured tooling. It is validated against the live API and kept up to date. Get started at https://app.jentic.com/sign-up.
What authentication does the Airtable Web API use?
Bearer tokens. Use either a personal access token from airtable.com/create/tokens or an OAuth 2.0 access token. Pass it as Authorization: Bearer <token>. Through Jentic the token is stored encrypted and injected at execution time.
Can I list records with a filter formula?
Yes. GET /{baseId}/{tableIdOrName} accepts filterByFormula, sort, view, pageSize, and offset query parameters. The formula uses the same syntax as Airtable's UI, e.g. AND({Status}="Active", {Region}="EU").
What are the rate limits for the Airtable Web API?
Airtable enforces 5 requests per second per base. Bursts beyond that return HTTP 429 with a 30-second penalty before further requests succeed. Batch up to 10 records per write call to stay efficient.
How do I update an Airtable record through Jentic?
Install with pip install jentic, search for 'update an airtable record', load the PATCH /{baseId}/{tableIdOrName}/{recordId} operation, and execute with baseId, tableIdOrName, recordId, and the fields object. Jentic injects the bearer token at execution time.
Can I subscribe to record changes via webhooks?
Yes. Use the /meta/bases/{baseId}/webhooks endpoints to register a notification URL and a specification of the change types you care about. Airtable will POST change payloads to the URL when matching records are inserted, updated, or deleted.
GET STARTED