Airtable

Manage Airtable bases and records via the REST API.

Environment Variables

• AIRTABLE_ACCESS_TOKEN - Personal access token (generate at https://airtable.com/create/tokens)

List records

curl -s -H "Authorization: Bearer $AIRTABLE_ACCESS_TOKEN" \
  "https://api.airtable.com/v0/BASE_ID/TABLE_NAME?maxRecords=20" | jq '.records[] | {id, fields}'

Get record

curl -s -H "Authorization: Bearer $AIRTABLE_ACCESS_TOKEN" \
  "https://api.airtable.com/v0/BASE_ID/TABLE_NAME/RECORD_ID" | jq '{id, fields}'

Create record

curl -s -X POST -H "Authorization: Bearer $AIRTABLE_ACCESS_TOKEN" \
  -H "Content-Type: application/json" \
  "https://api.airtable.com/v0/BASE_ID/TABLE_NAME" \
  -d '{"records":[{"fields":{"Name":"New record","Status":"Active"}}]}' | jq '.records[] | {id, fields}'

Update record

curl -s -X PATCH -H "Authorization: Bearer $AIRTABLE_ACCESS_TOKEN" \
  -H "Content-Type: application/json" \
  "https://api.airtable.com/v0/BASE_ID/TABLE_NAME" \
  -d '{"records":[{"id":"RECORD_ID","fields":{"Status":"Done"}}]}' | jq '.records[] | {id, fields}'

Delete record

curl -s -X DELETE -H "Authorization: Bearer $AIRTABLE_ACCESS_TOKEN" \
  "https://api.airtable.com/v0/BASE_ID/TABLE_NAME/RECORD_ID" | jq '{id, deleted}'

List bases

curl -s -H "Authorization: Bearer $AIRTABLE_ACCESS_TOKEN" \
  "https://api.airtable.com/v0/meta/bases" | jq '.bases[] | {id, name, permissionLevel}'

Get base schema

curl -s -H "Authorization: Bearer $AIRTABLE_ACCESS_TOKEN" \
  "https://api.airtable.com/v0/meta/bases/BASE_ID/tables" | jq '.tables[] | {id, name, fields: [.fields[] | {id, name, type}]}'