airtable

Send a POST to https://api.airtable.com/v0/$BASE_ID/$TABLE with a JSON body containing a fields object and your Bearer token. Use PATCH on a record ID to merge updates, or performUpsert with fieldsToMergeOn to update-or-create without knowing record IDs.

Pass a URL-encoded Airtable formula like {Status}='Todo' as the filterByFormula query parameter. Encode it with Python's urllib.parse.quote rather than hand-escaping, since field names with spaces or special characters break unencoded URLs.

Create a Personal Access Token at airtable.com/create/tokens with data.records:read, data.records:write, and schema.bases:read scopes. Legacy key... API keys were deprecated in February 2024, and each token must be granted access to specific bases.

A 403 usually means the token's Access list does not include that base, since PATs are scoped per-base. Revisit the token settings at airtable.com/create/tokens and add the base, rather than changing scopes or regenerating the token.

The API allows 5 requests per second per base and returns 429 with a Retry-After header when throttled. Batch create and delete endpoints accept at most 10 records per request, and list endpoints return at most 100 records per page.

Use PATCH, which merges only the supplied fields and preserves everything else. PUT replaces the entire record and clears any field you omit, so it is risky unless you intend a full replacement.