In this guide

List Records

Records from a table — through a view, filtered and sorted.

Action referenceRead

What this action does #

First, connect Airtable in Services. Then open Actions → + → Airtable and choose List Records.

To find this direct request action, choose Every Airtable endpoint in the integration’s picker. The setup guide also explains the dedicated forms for common tasks.

More about this action

Sent as a POST so a long filter never outgrows the URL. View applies a view's own filter and sort, exactly as it shows in Airtable. Filter is an Airtable formula: a record is returned when it isn't 0, false or empty.

Fields with nothing in them are left out of each record.

Inputs to fill in #

Open an input to choose its value. Keep a fixed value with Text, receive it from Shortcuts, ask when the action runs, or use an Earlier Step. Read how input sources work.

Base

RequiredText

The base's ID — it starts with app.

Example value (replace with your own):

appuy3nUR6Lbdz4YB

Table

RequiredText

The table's ID (tbl…) or its name. The ID keeps working after a rename.

Example value (replace with your own):

tblPB4GqFZqIMqIuK

View

OptionalText

A view's ID (viw…) or name. Only its records, in its order.

Example value (replace with your own):

viwhMyzQEvbEuEh4z

Filter

OptionalText

An Airtable formula. Fields are written in braces — by name or by ID.

Example value (replace with your own):

{Status} = 'Todo'

Sort

OptionalStructured data (JSON)

A list of {field, direction}, applied in order. direction is asc or desc.

Example value (replace with your own):

[{"field":"Name","direction":"asc"}]

Page Size

OptionalWhole number

1–100.

Example value (replace with your own):

At Most

OptionalWhole number

Stops after this many records, across every page.

Offset

OptionalText

The cursor from the previous page.

What comes back #

In the action editor, open Output → Returned Value to choose fields for your shortcut. These are the response fields described by the app; a service may omit an optional field or return an empty list. JSON File contains the full response.

Returned field	Type	Meaning
`records`	array	A list of values.
`records[].id`	string	The record's ID.
`records[].createdTime`	string	ISO 8601.
`records[].fields`	object	Keyed by field name. A field with nothing in it isn't listed at all.
`offset`	string	Present when there is another page.

Run it from Shortcuts #

Give the action a recognizable name and tap Save.
In Apple Shortcuts, add Shortcutify’s Execute Action and select the saved action.
Supply any Param or File slots you bound in the inputs, then run the shortcut.

If the result is unexpected, open Logs in Shortcutify, select the run, and inspect this step’s inputs and response.

This action supports multiple pages of results. Open its Fetch setting to retrieve more pages when one page is not enough. Each page adds a service request.

Advanced reference #

Request, permissions, and identifiers

Request: POST https://api.airtable.com/v0/{base_id}/{table_id}/listRecords

Action identifier: airtable.records.list.v1

Permissions declared for this action: data.records:read. The account’s own access rules also apply.

Input	Request key	Location
Base	`base_id`	path
Table	`table_id`	path
View	`view`	body
Filter	`filterByFormula`	body
Sort	`sort`	body
Page Size	`pageSize`	body
At Most	`maxRecords`	body
Offset	`offset`	body

Airtable API reference