airtable

Send a POST to /v0/$BASE_ID/$TABLE with a JSON body containing a fields object to create records, or use PATCH with performUpsert and fieldsToMergeOn to upsert by a key field like Email. Batch endpoints accept up to 10 records per request.

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

You need a Personal Access Token starting with pat, created 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 no longer work.

A 403 usually means the token's Access list does not include that specific base, since PATs are scoped per-base. Revisit the token settings at airtable.com/create/tokens and add the base to the token's access list.

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.

Use PATCH, which merges only the supplied fields and preserves everything else. PUT replaces the entire record and clears any field you did not include, so it is risky for partial updates.