airtable

Send a POST request to /v0/{baseId}/{table} with a JSON body containing a fields object to create records, or use PATCH on a record ID to merge updates. For idempotent syncs, use performUpsert with fieldsToMergeOn to match existing records by a key field like Email.

Pass a URL-encoded Airtable formula in the filterByFormula query parameter, such as {Status}='Todo' or AND({Status}='Todo', {Priority}='High'). Always encode the formula with a tool like Python's urllib.parse.quote rather than hand-escaping characters.

Create a Personal Access Token at airtable.com/create/tokens with data.records:read, data.records:write, and schema.bases:read scopes. You must also add each base to the token's Access list, since PATs are scoped per base and legacy key... API keys were deprecated in February 2024.

A 403 on a specific base means the token's Access list does not include that base, not an authentication failure. Open the token settings at airtable.com/create/tokens and add the missing base to the token's access scope.

The API allows 5 requests per second per base and returns at most 100 records per page. When a response includes an offset field, pass it back on the next request and loop until the field is absent; back off when you receive a 429 status.

Use PATCH for updates because it merges only the supplied fields and preserves everything else. PUT replaces the entire record and clears any field you did not include, which can silently delete data.