airtable

Send a POST to /v0/{baseId}/{table} with a JSON body containing a fields object to create records, or PATCH a specific record ID to merge updates. Add performUpsert with fieldsToMergeOn to create-or-update by a key field like Email.

Pass a URL-encoded Airtable formula such as {Status}='Todo' as the filterByFormula query parameter. Encode it with Python's urllib.parse.quote rather than hand-escaping, since field names with spaces and curly braces require encoding.

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.

A 403 with a valid token means the base is not in the token's Access list, since personal access tokens are scoped per base. Edit the token at airtable.com/create/tokens and grant access to that specific base.

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 a maximum of 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 did not include, so it is risky for partial updates.