MockBase
All templates

Productivity

Mock the Airtable API

Records with the rec-prefixed ids and the fields wrapper, minus the base.

3 routes · live immediately · no account needed

Airtable's records come wrapped in a shape that catches people out the first time: the row's real data sits under fields, with id and createdTime as siblings rather than columns. These routes return exactly that, so the mapping layer between Airtable and your own model can be written and tested without a base, an API key, or a row limit.

What you get

GET/v0/{baseId}/{tableName}200 OK
POST/v0/{baseId}/{tableName}templated200 OK
GET/v0/{baseId}/{tableName}/{recordId}templated200 OK

Example response

GET /v0/{baseId}/{tableName}

{
  "records": [
    {
      "id": "rec560UJdUtocSouk",
      "createdTime": "2022-09-12T21:03:48.000Z",
      "fields": {
        "Name": "Union Square",
        "Address": "333 Post St",
        "Visited": true
      }
    },
    {
      "id": "rec3sSK1oyVwFHCzz",
      "createdTime": "2022-09-12T21:04:19.000Z",
      "fields": {
        "Name": "Ferry Building",
        "Address": "1 Ferry Building",
        "Visited": false
      }
    }
  ]
}

Good for

  • Write the Airtable-to-model mapping before a base exists
  • Test against a fixed set of records that nobody edits mid-run
  • Keep API keys and real bases out of CI

Response payloads are representative examples using this API's real field names and object shapes, not an exhaustive replica of its schema. MockBase is an independent tool and is not affiliated with, endorsed by, or sponsored by Airtable.