Productivity Bearer Token

Airtable REST API

Spreadsheet-database hybrid with powerful REST API

Airtable combines the simplicity of a spreadsheet with the power of a database, offering a flexible REST API for programmatic access to bases, tables, records, and attachments. Developers use it to build custom workflows, integrate data across applications, and automate business processes. The API supports full CRUD operations, real-time collaboration features, and sophisticated querying with filtering and sorting capabilities.

Base URL https://api.airtable.com/v0

API Endpoints

Method	Endpoint	Description
GET	`/meta/bases`	List all bases accessible with the current API key
GET	`/meta/bases/{baseId}/tables`	Get schema information for all tables in a base including field types and configurations
GET	`/{baseId}/{tableIdOrName}`	List records in a table with support for filtering, sorting, and pagination
GET	`/{baseId}/{tableIdOrName}/{recordId}`	Retrieve a single record by its ID with all field values
POST	`/{baseId}/{tableIdOrName}`	Create one or more new records in a table with field values
PATCH	`/{baseId}/{tableIdOrName}`	Update multiple existing records by providing record IDs and new field values
PATCH	`/{baseId}/{tableIdOrName}/{recordId}`	Update a single record's fields while preserving unspecified fields
PUT	`/{baseId}/{tableIdOrName}`	Update records and clear unspecified cell values (destructive update)
DELETE	`/{baseId}/{tableIdOrName}`	Delete multiple records by providing an array of record IDs
GET	`/{baseId}/{tableIdOrName}?filterByFormula={formula}`	Query records using Airtable formula syntax for complex filtering
GET	`/{baseId}/{tableIdOrName}?view={viewId}`	Retrieve records as they appear in a specific view with view's filters and sorting
GET	`/{baseId}/{tableIdOrName}?fields[]={fieldName}`	List records with only specified fields returned to optimize response size
POST	`/meta/bases/{baseId}/webhooks`	Create a webhook to receive notifications when records change in specified tables
GET	`/meta/bases/{baseId}/webhooks`	List all webhooks configured for a base
DELETE	`/meta/bases/{baseId}/webhooks/{webhookId}`	Delete a webhook subscription to stop receiving change notifications

Code Examples

curl "https://api.airtable.com/v0/appXXXXXXXXXXXXXX/Tasks?maxRecords=10&view=Grid%20view" \
  -H "Authorization: Bearer patXXXXXXXXXXXXXX"

const response = await fetch('https://api.airtable.com/v0/appXXXXXXXXXXXXXX/Tasks', {
  method: 'POST',
  headers: {
    'Authorization': 'Bearer patXXXXXXXXXXXXXX',
    'Content-Type': 'application/json'
  },
  body: JSON.stringify({
    records: [
      {
        fields: {
          'Name': 'New Task',
          'Status': 'In Progress',
          'Priority': 'High'
        }
      }
    ]
  })
});
const data = await response.json();
console.log(data);

import requests

url = 'https://api.airtable.com/v0/appXXXXXXXXXXXXXX/Tasks'
headers = {
    'Authorization': 'Bearer patXXXXXXXXXXXXXX',
    'Content-Type': 'application/json'
}
params = {
    'filterByFormula': '{Status} = "Active"',
    'sort[0][field]': 'Created',
    'sort[0][direction]': 'desc'
}

response = requests.get(url, headers=headers, params=params)
records = response.json()['records']
for record in records:
    print(record['fields'])

Use Airtable from Claude / Cursor / ChatGPT

Get a hosted MCP endpoint for Airtable. Paste your Airtable API key, copy back one URL, drop it into Claude Desktop, Cursor, or any AI client that supports remote MCP. Your AI calls Airtable directly with your credentials — no local install, works on mobile.

airtable_query_records Search and retrieve records from Airtable tables using natural language queries converted to filterByFormula syntax

airtable_create_record Create new records in Airtable tables with AI-assisted field mapping and validation

airtable_update_records Intelligently update multiple records based on conditions or patterns identified by AI

airtable_analyze_base Analyze base schema, relationships between tables, and suggest optimal data organization strategies

airtable_bulk_operations Perform batch create, update, or delete operations with intelligent chunking to respect rate limits

Connect in 60 seconds

Paste your Airtable key → get an MCP URL → paste into Claude/Cursor. Hosted by IOX, encrypted at rest.

Connect Airtable to your AI →

Airtable REST API

API Endpoints

Sponsor this page

Code Examples

Use Airtable from Claude / Cursor / ChatGPT

Connect in 60 seconds

Related APIs