Sign up for free
Functions

GET_RECORDS_AIRTABLE

Get data columns from an Airtable base by defining the base ID, the table name, and the fields available on the table.

icon of AirtableAirtable
Not a big fan of functions?
Use the Actions Wizard to configure any action in Rows without functions.

Parameter List

Syntax
GET_RECORDS_AIRTABLE(base_id, table_name, 
[fields]
, 
[filter1, criterion1]
)
base_id

The ID of your Base on Airtable. For example: "appqK4jJW4C1Rp2G0".

table_name

The table name from your Base. For example: "Design projects".

[optional] fields

Column, row, or JSON with the fields to get from Airtable. For example: A:A, A1:B1 or '["Name", "Age"]'.

[optional] filter1

The field name to be used as a filter. For example: "Name".

More details

Follow Airtable's guide to get your API key.

To get your Base ID, log in to your -Airtable REST API portal and select the base you want to access.

Examples

GET_RECORDS_AIRTABLE("appqK4jJW4C1Rp2G0", "Contacts", '["Name","Email"]', "Age", ">25") returns all records' name and email from contacts with more than 25 years old.