Airtable

Flexible database-spreadsheet hybrid API for reading, writing, and managing structured records across bases and tables. Best for workflows that need to persist, query, or sync structured data without running a dedicated database. Unlike Google Sheets, Airtable exposes typed fields, linked records, and webhooks as first-class primitives. 11 example endpoints available through Lava’s AI Gateway. See the Airtable API docs for full documentation.

This provider requires your own credentials — connect your API key or OAuth account before use.

This is a catch-all provider — any valid URL under https://api.airtable.com is supported. Any Airtable Web API endpoint. Data plane: https://api.airtable.com/v0/{baseId}/{tableIdOrName}. Meta API: https://api.airtable.com/v0/meta/bases. Webhooks: https://api.airtable.com/v0/bases/{baseId}/webhooks. See https://airtable.com/developers/web/api/introduction for full reference. The endpoints below are curated examples.

Endpoints

List records in a table. Supports filterByFormula, sort, view, and pagination.

GET https://api.airtable.com/v0/{base_id}/{table_id_or_name}?maxRecords=100 — Free

SDK
cURL

const data = await lava.gateway('https://api.airtable.com/v0/{base_id}/{table_id_or_name}?maxRecords=100', { method: 'GET' });

curl "https://api.lava.so/v1/forward?u=https%3A%2F%2Fapi.airtable.com%2Fv0%2F%7Bbase_id%7D%2F%7Btable_id_or_name%7D%3FmaxRecords%3D100" \
  -H "Authorization: Bearer $LAVA_SECRET_KEY"

Retrieve a single record by ID.

GET https://api.airtable.com/v0/{base_id}/{table_id_or_name}/{record_id} — Free

SDK
cURL

const data = await lava.gateway('https://api.airtable.com/v0/{base_id}/{table_id_or_name}/{record_id}', { method: 'GET' });

curl "https://api.lava.so/v1/forward?u=https%3A%2F%2Fapi.airtable.com%2Fv0%2F%7Bbase_id%7D%2F%7Btable_id_or_name%7D%2F%7Brecord_id%7D" \
  -H "Authorization: Bearer $LAVA_SECRET_KEY"

Create one or more records in a table (up to 10 per call).

POST https://api.airtable.com/v0/{base_id}/{table_id_or_name} — Free

SDK
cURL

const data = await lava.gateway('https://api.airtable.com/v0/{base_id}/{table_id_or_name}', {
  body: {
"records": [
  {
    "fields": {
      "Name": "Example",
      "Status": "Active"
    }
  }
]
},
});

curl -X POST "https://api.lava.so/v1/forward?u=https%3A%2F%2Fapi.airtable.com%2Fv0%2F%7Bbase_id%7D%2F%7Btable_id_or_name%7D" \
  -H "Authorization: Bearer $LAVA_SECRET_KEY" \
  -H "Content-Type: application/json" \
  -d '{"records":[{"fields":{"Name":"Example","Status":"Active"}}]}'

Update one or more records, preserving fields not included in the request.

PATCH https://api.airtable.com/v0/{base_id}/{table_id_or_name} — Free

SDK
cURL

const data = await lava.gateway('https://api.airtable.com/v0/{base_id}/{table_id_or_name}', { method: 'PATCH', body: {"records":[{"id":"rec123","fields":{"Status":"Done"}}]} });

curl -X PATCH "https://api.lava.so/v1/forward?u=https%3A%2F%2Fapi.airtable.com%2Fv0%2F%7Bbase_id%7D%2F%7Btable_id_or_name%7D" \
  -H "Authorization: Bearer $LAVA_SECRET_KEY" \
  -H "Content-Type: application/json" \
  -d '{"records":[{"id":"rec123","fields":{"Status":"Done"}}]}'

Upsert records. Use performUpsert with fieldsToMergeOn to match on existing values.

PUT https://api.airtable.com/v0/{base_id}/{table_id_or_name} — Free

SDK
cURL

const data = await lava.gateway('https://api.airtable.com/v0/{base_id}/{table_id_or_name}', {
  method: 'PUT',
  body: {
"performUpsert": {
  "fieldsToMergeOn": [
    "Email"
  ]
},
"records": [
  {
    "fields": {
      "Email": "a@b.com",
      "Name": "Ada"
    }
  }
]
},
});

curl -X PUT "https://api.lava.so/v1/forward?u=https%3A%2F%2Fapi.airtable.com%2Fv0%2F%7Bbase_id%7D%2F%7Btable_id_or_name%7D" \
  -H "Authorization: Bearer $LAVA_SECRET_KEY" \
  -H "Content-Type: application/json" \
  -d '{"performUpsert":{"fieldsToMergeOn":["Email"]},"records":[{"fields":{"Email":"a@b.com","Name":"Ada"}}]}'

Delete one or more records by ID (pass records[] query param).

DELETE https://api.airtable.com/v0/{base_id}/{table_id_or_name}?records[]={record_id} — Free

SDK
cURL

const data = await lava.gateway('https://api.airtable.com/v0/{base_id}/{table_id_or_name}?records[]={record_id}', { method: 'DELETE' });

curl -X DELETE "https://api.lava.so/v1/forward?u=https%3A%2F%2Fapi.airtable.com%2Fv0%2F%7Bbase_id%7D%2F%7Btable_id_or_name%7D%3Frecords%5B%5D%3D%7Brecord_id%7D" \
  -H "Authorization: Bearer $LAVA_SECRET_KEY" \
  -H "Content-Type: application/json"

List all bases the authorized user has access to.

GET https://api.airtable.com/v0/meta/bases — Free

SDK
cURL

const data = await lava.gateway('https://api.airtable.com/v0/meta/bases', { method: 'GET' });

curl "https://api.lava.so/v1/forward?u=https%3A%2F%2Fapi.airtable.com%2Fv0%2Fmeta%2Fbases" \
  -H "Authorization: Bearer $LAVA_SECRET_KEY"

Get the schema (tables, fields, views) for a base.

GET https://api.airtable.com/v0/meta/bases/{base_id}/tables — Free

SDK
cURL

const data = await lava.gateway('https://api.airtable.com/v0/meta/bases/{base_id}/tables', { method: 'GET' });

curl "https://api.lava.so/v1/forward?u=https%3A%2F%2Fapi.airtable.com%2Fv0%2Fmeta%2Fbases%2F%7Bbase_id%7D%2Ftables" \
  -H "Authorization: Bearer $LAVA_SECRET_KEY"

List webhooks registered on a base.

GET https://api.airtable.com/v0/bases/{base_id}/webhooks — Free

SDK
cURL

const data = await lava.gateway('https://api.airtable.com/v0/bases/{base_id}/webhooks', { method: 'GET' });

curl "https://api.lava.so/v1/forward?u=https%3A%2F%2Fapi.airtable.com%2Fv0%2Fbases%2F%7Bbase_id%7D%2Fwebhooks" \
  -H "Authorization: Bearer $LAVA_SECRET_KEY"

Register a new webhook for changes in a base.

POST https://api.airtable.com/v0/bases/{base_id}/webhooks — Free

SDK
cURL

const data = await lava.gateway('https://api.airtable.com/v0/bases/{base_id}/webhooks', {
  body: {
"notificationUrl": "https://example.com/airtable-webhook",
"specification": {
  "options": {
    "filters": {
      "dataTypes": [
        "tableData"
      ]
    }
  }
}
},
});

curl -X POST "https://api.lava.so/v1/forward?u=https%3A%2F%2Fapi.airtable.com%2Fv0%2Fbases%2F%7Bbase_id%7D%2Fwebhooks" \
  -H "Authorization: Bearer $LAVA_SECRET_KEY" \
  -H "Content-Type: application/json" \
  -d '{"notificationUrl":"https://example.com/airtable-webhook","specification":{"options":{"filters":{"dataTypes":["tableData"]}}}}'

Return information about the currently authorized user.

GET https://api.airtable.com/v0/meta/whoami — Free

SDK
cURL

const data = await lava.gateway('https://api.airtable.com/v0/meta/whoami', { method: 'GET' });

curl "https://api.lava.so/v1/forward?u=https%3A%2F%2Fapi.airtable.com%2Fv0%2Fmeta%2Fwhoami" \
  -H "Authorization: Bearer $LAVA_SECRET_KEY"

Get Started

AI Gateway

AI Spend

Monetize

Integration

SDK

Cookbook

Comparisons

Endpoints

Retrieve a single record by ID.

Create one or more records in a table (up to 10 per call).

Update one or more records, preserving fields not included in the request.

Upsert records. Use performUpsert with fieldsToMergeOn to match on existing values.

Delete one or more records by ID (pass records[] query param).

List all bases the authorized user has access to.

Get the schema (tables, fields, views) for a base.

List webhooks registered on a base.

Register a new webhook for changes in a base.

Return information about the currently authorized user.

Next Steps

All Providers

Forward Proxy

​Endpoints

​List records in a table. Supports filterByFormula, sort, view, and pagination.

​Retrieve a single record by ID.

​Create one or more records in a table (up to 10 per call).

​Update one or more records, preserving fields not included in the request.

​Upsert records. Use performUpsert with fieldsToMergeOn to match on existing values.

​Delete one or more records by ID (pass records[] query param).

​List all bases the authorized user has access to.

​Get the schema (tables, fields, views) for a base.

​List webhooks registered on a base.

​Register a new webhook for changes in a base.

​Return information about the currently authorized user.

​Next Steps

All Providers

Forward Proxy

Endpoints

List records in a table. Supports filterByFormula, sort, view, and pagination.

Retrieve a single record by ID.

Create one or more records in a table (up to 10 per call).

Update one or more records, preserving fields not included in the request.

Upsert records. Use performUpsert with fieldsToMergeOn to match on existing values.

Delete one or more records by ID (pass records[] query param).

List all bases the authorized user has access to.

Get the schema (tables, fields, views) for a base.

List webhooks registered on a base.

Register a new webhook for changes in a base.

Return information about the currently authorized user.

Next Steps