Airtable

Read and write records in Airtable bases via a Personal Access Token

Credentials form7 toolshttps://api.airtable.com/v0

GET

airtable_list_bases

List the Airtable bases this Personal Access Token can access

/meta/bases

1 parameter

Param	Type	Required	Description
offset	string	optional	Pagination cursor from a previous response

GET

airtable_list_tables

List the tables in a base, including each table's fields and views — the base's schema

/meta/bases/{base_id}/tables

1 parameter

Param	Type	Required	Description
base_id	string	required	Base ID, e.g. 'appXXXXXXXXXXXXXX'

GET

airtable_list_records

List records from a table, optionally filtered by an Airtable formula and scoped to a view

/{base_id}/{table_id_or_name}

7 parameters

Param	Type	Required	Description
base_id	string	required	Base ID, e.g. 'appXXXXXXXXXXXXXX'
table_id_or_name	string	required	Table ID ('tblXXXXXXXXXXXXXX') or current table name
view	string	optional	View ID or name to scope/order results by
filterByFormula	string	optional	Airtable formula string; only matching records are returned
maxRecords	integer	optional	Maximum total records to return
pageSize	integer	optional	Records per page (max 100, default 100)
offset	string	optional	Pagination cursor from a previous response

GET

airtable_get_record

Get a single record by ID

/{base_id}/{table_id_or_name}/{record_id}

3 parameters

Param	Type	Required	Description
base_id	string	required	Base ID, e.g. 'appXXXXXXXXXXXXXX'
table_id_or_name	string	required	Table ID ('tblXXXXXXXXXXXXXX') or current table name
record_id	string	required	Record ID, e.g. 'recXXXXXXXXXXXXXX'

POST

airtable_create_records

Create up to 10 records in a table in one call

/{base_id}/{table_id_or_name}

4 parameters

Param	Type	Required	Description
base_id	string	required	Base ID, e.g. 'appXXXXXXXXXXXXXX'
table_id_or_name	string	required	Table ID ('tblXXXXXXXXXXXXXX') or current table name
records	array	required	Records to create (max 10), each shaped as { fields: { <field name>: <value>, ... } }
typecast	boolean	optional	Automatically convert string values to the field's configured type

PATCH

airtable_update_record

Update (patch) specific fields on an existing record, leaving others unchanged

/{base_id}/{table_id_or_name}/{record_id}

5 parameters

Param	Type	Required	Description
base_id	string	required	Base ID, e.g. 'appXXXXXXXXXXXXXX'
table_id_or_name	string	required	Table ID ('tblXXXXXXXXXXXXXX') or current table name
record_id	string	required	Record ID, e.g. 'recXXXXXXXXXXXXXX'
fields	object	required	Field name/value pairs to update, e.g. { Status: 'Done' }
typecast	boolean	optional	Automatically convert string values to the field's configured type

DELETE

airtable_delete_record

Permanently delete a single record

/{base_id}/{table_id_or_name}/{record_id}

3 parameters

Param	Type	Required	Description
base_id	string	required	Base ID, e.g. 'appXXXXXXXXXXXXXX'
table_id_or_name	string	required	Table ID ('tblXXXXXXXXXXXXXX') or current table name
record_id	string	required	Record ID, e.g. 'recXXXXXXXXXXXXXX'