Read All Rows

Reads all rows within a specified Airtable table.

This event works for tables containing fewer than 4,500 rows and will truncate any rows beyond that.

Options

Field Definition Type Required

Base

Available bases in Airtable.

Select the Use Base ID option if the required base is not in the list and provide the base ID in the Base ID field.

 Dropdown TRUE

Base ID

The unique identifier of the base. Use this field if the required base isn't in the Base list.

To get the base ID, open the required base in Airtable. The base ID is part of the URL address of the page.

Airtable URLs are constructed in the following format:

https://airtable.com/<BASE_ID>/<TABLE_ID>/<VIEW_ID>

The value of the Base field takes precedence over the Base ID value.

 Text FALSE

Table

Available tables within the base.

Select the Use Table Name option if the required table is not in the list and provide the table name in the Table Name field.

 Dropdown TRUE

Table Name

The name of the table that's associated with the base. Use this field to provide the table name or table ID if the required base is not presented in the Table list.

To get the table ID, open the required base and table in Airtable. The table ID is part of the URL address of the page.

Airtable URLs are constructed in the following format:

https://airtable.com/<BASE_ID>/<TABLE_ID>/<VIEW_ID>

Airtable recommends using table IDs so you don't need to modify your card when your table name changes.

The value of the Table field takes precedence over the Table Name value.

 Text FALSE

Output

The output fields in this card are dynamically generated based on your instance.

The following field types are supported:

  • Attachment

  • Autonumber

  • Barcode

  • Checkbox

  • Count

  • Currency

  • Date

  • Duration in days

  • Email

  • Formula

  • Link to another record

  • Long text

  • Lookup

  • Multiple select

  • Multiple users

  • Number

  • Phone number

  • Rollup

  • Single line text

  • Single select

  • URL

  • User

Field Definition Type

Rows

List containing objects representing the rows within the table and their data.

 List