← Back to Marketplace

Airtable

Bearer

Spreadsheet-database hybrid. Structured data with a friendly API.

https://api.airtable.com
OVERVIEW

Airtable's API gives you full CRUD access to your bases (databases), tables, and records. Think of it as a database with a spreadsheet UI. Rich field types (attachments, linked records, formulas, rollups) accessible via a clean REST API.

Each base has a unique ID, and records are accessed via the base ID + table name. The API supports filtering with a formula language, sorting, and field selection. Batch operations let you create, update, or delete up to 10 records per request.

GET YOUR API KEY

Authentication setup

  1. Go to airtable.com/create/tokens
  2. Click Create new token
  3. Name the token and select scopes (e.g. data.records:read, data.records:write)
  4. Select which bases to grant access to
  5. Copy the token. It starts with pat
Token format pat...
Auth type bearer
QUICK CONNECT

Create a connection in one request.

CONNECT AIRTABLE
POST /connections Authorization: Bearer $TOKEN Content-Type: application/json { "name": "Airtable", "base_url": "https://api.airtable.com", "auth_type": "bearer", "auth_config": {"token": "pat..."} } → {"id": "cn_xxxxxxxx", "name": "Airtable"}
KEY ENDPOINTS

What you can call via proxy.

MethodPathDescription
GET /v0/{baseId}/{tableName} List records (supports filter, sort, fields)
POST /v0/{baseId}/{tableName} Create one or more records (up to 10)
PATCH /v0/{baseId}/{tableName} Update records (up to 10)
DELETE /v0/{baseId}/{tableName} Delete records (up to 10)
GET /v0/{baseId}/{tableName}/{recordId} Get a single record
GET /v0/meta/bases List all bases the token can access
GET /v0/meta/bases/{baseId}/tables List tables and fields in a base
EXAMPLE

List Records

PROXY CALL
GET /proxy/cn_xxxxxxxx/v0/appXXXXXX/Tasks?filterByFormula=%7BStatus%7D%3D%22Active%22&maxRecords=3 Authorization: Bearer $TOKEN { "records": [ { "id": "recABC123", "fields": { "Name": "Ship homepage redesign", "Status": "Active", "Assignee": "Alice", "Due Date": "2026-04-01" } }, { "id": "recDEF456", "fields": { "Name": "Write API docs", "Status": "Active", "Assignee": "Bob", "Due Date": "2026-03-28" } } ], "offset": "itr..." }
USE CASES

What people build with Airtable.

CRM Backend

Track leads, deals, and contacts with rich field types and linked records.

Content Calendar

Manage editorial schedules, assignments, and publication status.

Inventory Tracking

Track products, stock levels, and orders with formula-based calculations.

Survey & Form Data

Collect and process form submissions with automatic field mapping.

← Back to Marketplace Developer Guide →
# Airtable > Spreadsheet-database hybrid. Structured data with a friendly API. ## Overview Airtable's API gives you full CRUD access to your bases (databases), tables, and records. Think of it as a database with a spreadsheet UI. Rich field types (attachments, linked records, formulas, rollups) accessible via a clean REST API. Each base has a unique ID, and records are accessed via the base ID + table name. The API supports filtering with a formula language, sorting, and field selection. Batch operations let you create, update, or delete up to 10 records per request. - **Base URL:** https://api.airtable.com - **Auth type:** bearer - **Token format:** pat... ## Get Your API Key 1. Go to airtable.com/create/tokens 2. Click Create new token 3. Name the token and select scopes (e.g. data.records:read, data.records:write) 4. Select which bases to grant access to 5. Copy the token. It starts with pat ## Quick Connect bashcurl -X POST https://api.liteio.dev/connections \ -H "Authorization: Bearer $TOKEN" \ -H "Content-Type: application/json" \ -d '{ "name": "Airtable", "base_url": "https://api.airtable.com", "auth_type": "bearer", "auth_config": {"token": "pat..."} }' ## Key Endpoints MethodPathDescription GET/v0/{baseId}/{tableName}List records (supports filter, sort, fields) POST/v0/{baseId}/{tableName}Create one or more records (up to 10) PATCH/v0/{baseId}/{tableName}Update records (up to 10) DELETE/v0/{baseId}/{tableName}Delete records (up to 10) GET/v0/{baseId}/{tableName}/{recordId}Get a single record GET/v0/meta/basesList all bases the token can access GET/v0/meta/bases/{baseId}/tablesList tables and fields in a base ## Example: List Records bashcurl https://api.liteio.dev/proxy/cn_xxx/v0/appXXXXXX/Tasks?filterByFormula=%7BStatus%7D%3D%22Active%22&maxRecords=3 \ -H "Authorization: Bearer $TOKEN" ## Use Cases - **CRM Backend**: Track leads, deals, and contacts with rich field types and linked records. - **Content Calendar**: Manage editorial schedules, assignments, and publication status. - **Inventory Tracking**: Track products, stock levels, and orders with formula-based calculations. - **Survey & Form Data**: Collect and process form submissions with automatic field mapping. ## Links - Back to Marketplace - Developer Guide - Get API Key