# Airtable API

**Provider:** Airtable
**Category:** storage
**Base URL:** `https://api.airtable.com/v0`
**Auth:** bearer — `Authorization: Bearer patXXXXXXXXXXXXX...`
**Rate Limit:** 5 requests/sec per base
**Free Tier:** Yes — [object Object]
**Pricing:** Free tier available (freemium)
**Docs:** https://airtable.com/developers/web/api/introduction

## Description

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.

## Endpoints

| Method | Endpoint | Description |
|--------|----------|-------------|
| GET | `https://api.airtable.com/v0/{baseId}/{tableIdOrName}` | List records with filtering, sorting, and field selection |
| POST | `https://api.airtable.com/v0/{baseId}/{tableIdOrName}` | Create one or more records |
| PATCH | `https://api.airtable.com/v0/{baseId}/{tableIdOrName}` | Update records (upsert supported) |
| DELETE | `https://api.airtable.com/v0/{baseId}/{tableIdOrName}/{recordId}` | Delete a single record |
| GET | `https://api.airtable.com/v0/meta/bases` | List all bases accessible to the token |
| GET | `https://api.airtable.com/v0/meta/bases/{baseId}/tables` | Get table schemas and field definitions |

## 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...
```

## Sample Request

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

## Sample Response

```json
{
  "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
    }
  }]
}
```

## Pricing Details

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

---

*Source: [API Map](https://apimap.dev/apis/airtable/) — CC BY 4.0*