Airtable
Airtable organizes data as Bases → Tables → Records. Bases have base_id (appXXX). Tables have table names or ids. Records have id (recXXX).
Data Model
- Bases are workspaces. List bases to get base_id (appXXXXXXXXXXXXXX format).
- Tables live in bases. Use base_id plus table name or tblXXX id for record operations.
- Records have fields (column values). Linked records store arrays of record ids. Attachments use {url} objects.
- Hierarchy: base_id → table_id → record_id. All record ops require base and table.
Gotchas
- base_id format: appXXXXXXXXXXXXXX. From bases list or base URL.
- Table by name or id: table_id can be table name (spaces encoded) or tblXXX.
- Formula syntax: Single quotes for strings; {FieldName} for field ref.
- Rate limit: 5 requests/second. Batch creates when possible.