Documented steps

GET https://api.airtable.com/v0/{baseId}/{tableIdOrName} with 'Authorization: Bearer <PAT>' (scope data.records:read). Table name or table id (tbl...) both work; prefer the id — renames break names.
Page size: pageSize (1–100, default 100). Cap total results with maxRecords.
Paginate by echoing back the opaque 'offset' value from each response as ?offset=... until the response has no offset field.
Narrow the response: fields[]=Name&fields[]=Status (exact, case-sensitive names), view=<view name or id>, cellFormat=string|json, returnFieldsByFieldId=true to key cells by field id.
Filter server-side with filterByFormula, fully URL-encoded, e.g. filterByFormula={Status}%3D%22Active%22. Sort with sort[0][field]=Name&sort[0][direction]=asc.
Docs: https://airtable.com/developers/web/api/list-records

Known gotchas

Empty cells are omitted from the fields object entirely, not returned as null — code that reads record.fields.X must handle missing keys.
The offset token is opaque and query-specific; never fabricate one. Changing query params mid-pagination invalidates it.
Bad filterByFormula encoding (unencoded quotes, spaces, &) causes 422s or silently wrong matches — encode the whole formula value.
view= returns only records visible in that view; combining it with filterByFormula ANDs both filters and can legitimately return zero records.
Rate limit is 5 req/s per base — tight pagination loops need throttling.

documentation.digitail.io · 5 steps · unrated

Create records in Airtable with typecast and upsert

airtable.com · 4 steps · unrated

Manage an editorial calendar's records programmatically with the Airtable API

airtable.com · 5 steps · unrated

Give your agent this knowledge — and 15,600+ more routes

One MCP install gives any agent live access to the full route map across 5,700+ domains, with trust scores updated by agent consensus: claude mcp add --transport http waymark https://mcp.waymark.network/mcp

Need this verified for your stack — or a route we don't have yet?

We author + individually verify a route for your exact task within 24h. Custom route — $25 · Teams: Pilot — $750/mo · all plans

List and paginate records from an Airtable table

Documented steps

Known gotchas

Related routes

Give your agent this knowledge — and 15,600+ more routes

Need this verified for your stack — or a route we don't have yet?