Integrations / Databases

Airtable

Look up bases, tables and records, filter records with formulas, create and update records, and comment on them in Airtable.

9 tools

Tools

airtable.list_bases

List the bases the token can reach. Base IDs look like appLkNDICXNqxSDhG.

airtable.get_base_schema

List a base's tables with their fields and views, to learn table and field names. Base IDs look like appLkNDICXNqxSDhG.

base_id*

airtable.list_records

List a table's records, optionally filtered by a formula or limited to a view, 100 per page. Base IDs look like appLkNDICXNqxSDhG and table IDs like tblXXXXXXXXXXXXXX; a table name works too.

base_id*table*filterByFormulaviewfieldsmaxRecordspageSizeoffset

airtable.get_record

Get one record's fields. Record IDs look like rec560UJdUtocSouk.

base_id*table*record_id*

airtable.create_record writes

Create a record in a table. Base IDs look like appLkNDICXNqxSDhG; a table ID or name works.

base_id*table*fields*typecast

airtable.update_record writes

Update some of a record's fields, leaving the rest as they are. Record IDs look like rec560UJdUtocSouk.

base_id*table*record_id*fields*typecast

airtable.add_comment writes

Add a comment to a record. Needs the data.recordComments:write scope. Record IDs look like rec560UJdUtocSouk.

base_id*table*record_id*text*

airtable.api_get

Send a GET request to any Airtable API path under https://api.airtable.com/v0 and return the response. For endpoints the named tools don't cover.

path*params

airtable.api_request writes

Send a POST, PUT, PATCH or DELETE request to any Airtable API path under https://api.airtable.com/v0.

method*path*paramsbody

Tick Allow raw writes on the connection to add api_request, which can send POST, PUT, PATCH and DELETE requests to any Airtable API path.

Connect

  1. In Airtable, open the personal access tokens page (airtable.com/create/tokens) and create a new token.
  2. Give it the scopes data.records:read and schema.bases:read, plus data.records:write and data.recordComments:write if workflows change records or comment, and add the bases it may use.
  3. Paste the token on the connection. Base IDs start with app and table IDs with tbl, and both appear in the base's URL.

Credentials

Personal access token

Airtable API docs

Your next automation is one sentence away.

14-day free trial with $5 of built-in AI included. Cancel anytime.

Start free trial Talk to us