App Logo
airtable.com

List Airtable records

Automatically list Airtable records on airtable.com. List the records of one table in an Airtable base, with every field's value, plus the table's fields (name, type and select options) and the base's other tables. Pick the table by name or id; without one, the base's first table is read. Get base ids from list_bases.

Input

baseId required

Base id (app...), from list_bases or the base's URL.

table optional

Table name or id (tbl...). Leave it out for the base's first table.

maxRecords optional

Most records to return, in the table's own order.

Default: 1000

Output

base required
table required
total required

How many records the table holds.

fields required

The table's fields in order, the primary field first.

tables required

Every table of the base, to pick another one.

records required
truncated required

True when the table holds more records than maxRecords.

FAQ

List the records of one table in an Airtable base, with every field's value, plus the table's fields (name, type and select options) and the base's other tables. Pick the table by name or id; without one, the base's first table is read. Get base ids from list_bases.
Ask an AI agent connected to Reduck to run reduck/airtable.com/list_records, or run it from a terminal with the Reduck CLI: npx @reduck-ai/cli@latest run --script reduck/airtable.com/list_records
You do not need one. "List Airtable records" drives the real airtable.com pages in a browser, so it works whether or not airtable.com offers an API for this.
Required: baseId. Optional: table, maxRecords.
It returns base, table, total, fields, tables, records, truncated.
Yes. It acts as you on airtable.com: on your own Chrome it reuses your session, and on a Reduck-hosted browser it loads the airtable.com cookies saved by the Reduck extension.
It only reads. It looks things up on airtable.com and changes nothing there.
Ask an AI agent connected to Reduck to run reduck/airtable.com/list_records, or run it from a terminal with the Reduck CLI: npx @reduck-ai/cli@latest run --script reduck/airtable.com/list_records
It is part of Reduck's official curated catalogue.

Related scripts

airtable.com

List Airtable invoices

List Airtable workspace billing invoices across every workspace you have billing access to. Returns total plus invoices (workspace, date, amount, status, hosted_invoice_url: the invoice's hosted page, where it can be downloaded). Billing is per workspace and only the workspace billing owner sees it; workspaces without paid history return no invoices. Requires a signed-in Airtable account; fails with a sign-in error otherwise.

airtable.com

Airtable login

Log into Airtable via Google SSO, picking a specific account when an email is given. Only works on your own paired browser — it relies on that browser's own signed-in Google session rather than injected cookies.

airtable.com

Airtable whoami (signed-in account)

Report which Airtable account this browser is signed in as: the user id and email. When the browser is signed out, the run fails with a signed-out error that says to sign in to Airtable and retry.

Start building not clicking

Get started for free