A

Airtable API

by Airtable Free tier

Airtable's REST API treats every base like a relational database with a spreadsheet interface. Each table has typed fields (text, number, date, select, attachment, linked records, formula, lookup). The API lets you list records with filtering and sorting, create and update multiple records in bulk, manage views and field metadata, trigger automations, and download attachments. Ideal for lightweight data backends, content management, and no-code app data layers.

spreadsheetdatabaseno-coderecordsviewsattachmentsautomation

Quick Reference

Base URL https://api.airtable.com/v0 Auth type Bearer Token Auth header Authorization: Bearer patXXXXXXXXXXXXX... Rate limit 5 requests/sec per base Pricing Free tier available Free quota 2 GB attachments Documentation https://airtable.com/developers/web/api/introduction Endpoint status Server online — HTTP 404 — server is online but path returned an error (may require auth)824ms (checked Mar 29, 2026) Builder score B 73% builder-friendly
Pricing
90
Latency
38
Depth
86

Authentication

Generate a Personal Access Token at airtable.com/create/tokens with the required scopes. Pass it as a Bearer token in the Authorization header.

Authorization: Bearer patXXXXXXXXXXXXX...

Pricing

Model freemium Starting price Free tier available Free quota 2 GB attachments
PlanPrice/moIncluded
Free Free 1,000 records/base, 2 GB attachments
Team $20 Per user/mo, 50k records/base
Business $45 Per user/mo, 250k records/base
Enterprise $0 Custom pricing

Free: 1,000 records/base. Plus: $10/user/mo (5k records). Pro: $20/user/mo (50k records). Enterprise: $45/user/mo (unlimited).

Key Endpoints

MethodPathDescription
GET /{baseId}/{tableIdOrName} List records with filtering, sorting, and field selection
POST /{baseId}/{tableIdOrName} Create one or more records
PATCH /{baseId}/{tableIdOrName} Update records (upsert supported)
DELETE /{baseId}/{tableIdOrName}/{recordId} Delete a single record
GET /meta/bases List all bases accessible to the token
GET /meta/bases/{baseId}/tables Get table schemas and field definitions

Sample Request

curl "https://api.airtable.com/v0/$AIRTABLE_BASE_ID/APIs?filterByFormula=%7BCategory%7D%3D'AI'" \
  -H "Authorization: Bearer $AIRTABLE_TOKEN"

Sample Response

{
  "records": [{
    "id": "recXXXXXXXXXXXXXX",
    "createdTime": "2024-03-15T10:00:00.000Z",
    "fields": {
      "Name": "OpenAI API",
      "Category": "AI",
      "Base URL": "https://api.openai.com/v1",
      "Has Free Tier": false
    }
  }]
}

Data sourced from API Map. Always verify pricing and rate limits against the official Airtable documentation.