Airtable · api · fg-0428

Airtable list records with a long filterByFormula fails once the URL passes 16,000 characters

Lookup by a list of IDs fails only when the list is long

Verified 2026-10-15 · Confirmed by 0 builders · Trust 50/100

Cause

Airtable rejects request URLs of 16,000 characters or more, and an encoded filterByFormula grows fast. The GET form of list records puts the formula in the query string.

Fix

Send long queries as POST to the listRecords path with the parameters in the JSON body, or split the ID list into smaller groups.

Apply

curl -X POST "https://api.airtable.com/v0/$BASE_ID/$TABLE/listRecords" -H "Authorization: Bearer $AIRTABLE_PAT" -H "Content-Type: application/json" -d '{"filterByFormula": "OR({Email}=\"a@x.com\", {Email}=\"b@x.com\")"}'

Affects: Airtable Web API list records, as of 2026-10

Sources

https://airtable.com/developers/web/api/list-records

Have your agent know this before it fails

claude mcp add --transport http footgun https://getfootgun.com/api/mcp