airtable

Send a POST request to https://api.airtable.com/v0/$BASE_ID/$TABLE with an Authorization Bearer header and a JSON body containing a fields object. You can create up to 10 records in one call by passing a records array instead.

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

PATCH merges the supplied fields into the record and preserves everything else, while PUT replaces the record entirely and clears any field you did not include. Default to PATCH for updates to avoid accidental data loss.

A 403 on a specific base means the personal access token's Access list does not include that base, not an authentication failure. PATs are scoped per-base, so add the base to the token at airtable.com/create/tokens.

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.

Send a PATCH request to the table endpoint with performUpsert specifying fieldsToMergeOn, such as Email. Airtable creates records with new merge-field values and patches records whose values already exist, enabling idempotent syncs.