Airtable

Give your agents the Airtable Web API — records, comments, base schema, and change webhooks — through agntdata.

Overview

The Airtable connection lets deployed agents work with Airtable: read and write records (including bulk create/update, upsert, and delete); read and post record comments; read and manage base schema (list bases, read a base’s tables and fields, and create bases, tables, and fields); and manage change webhooks.

• Base URL: https://api.agntdata.dev/v1/connections/airtable
• Airtable auth: OAuth 2.0 (PKCE) — connect your Airtable account once from the dashboard. agntdata attaches a fresh access token to every call (refreshing it in the background, since Airtable tokens expire and refresh tokens rotate), so you never pass an Authorization header yourself.
• MCP tools: agents call connection_airtable_* tools, e.g. connection_airtable_list_records, connection_airtable_create_records, connection_airtable_update_records, connection_airtable_get_base_schema.

Record paths take {baseId} (starts with app) and {tableIdOrName} (a tbl id or the table name). Reads paginate with pageSize (max 100) and the offset cursor from the previous page, and return { records, offset? }. Writes are batched up to 10 records per call as { records: [{ fields }, ...] }; set typecast: true to coerce string values, and add performUpsert: { fieldsToMergeOn: [...] } to upsert on merge fields. PATCH updates only the fields you pass; PUT replaces the record and clears omitted fields. Delete tools are irreversible.

Setup

1. Connect Airtable

   In the agntdata dashboard open Integrations, pick Airtable, and click Connect. You’ll be redirected to Airtable to authorize and grant access to the bases you want the agent to reach.

2. Pick Airtable tools

   In an agent’s Tools panel, add the Airtable tools the agent needs — for example list_records, create_records, update_records, and get_base_schema. Destructive tools (delete_records, delete_record, delete_comment, delete_webhook) ship too; leave them off an agent you don’t want deleting things.

Examples

List records

curl "https://api.agntdata.dev/v1/connections/airtable/v0/appXXXXXXXX/Tasks?pageSize=100&filterByFormula=%7BStatus%7D%3D%27Todo%27" \
  -H "Authorization: Bearer $AGNTDATA_API_KEY"

Create records

curl -X POST "https://api.agntdata.dev/v1/connections/airtable/v0/appXXXXXXXX/Tasks" \
  -H "Authorization: Bearer $AGNTDATA_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{"records":[{"fields":{"Name":"Investigate flaky test","Status":"Todo"}}],"typecast":true}'

Upsert records on a merge field

curl -X PATCH "https://api.agntdata.dev/v1/connections/airtable/v0/appXXXXXXXX/Tasks" \
  -H "Authorization: Bearer $AGNTDATA_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{"performUpsert":{"fieldsToMergeOn":["External ID"]},"records":[{"fields":{"External ID":"ext-42","Status":"Done"}}]}'

Read a base schema

curl "https://api.agntdata.dev/v1/connections/airtable/v0/meta/bases/appXXXXXXXX/tables" \
  -H "Authorization: Bearer $AGNTDATA_API_KEY"