Airtable
To paginate over an Airtable, you need the following setup:
Original Data Source
First, create a simple URL/REST data source. Use the List records endpoint that you can find in your Airtable API documentation as the URL. Make sure to add the variable offset={offset} to the end of the URL.
First, create a simple URL/REST data source. Use the List records
endpoint that you can find in your Airtable API documentation as the URL. Make sure to add offset={offset}
variable at the end of the URL.
Now test if the data source is working by using 0
in the offset variable:
Paginated Data Source
Create a second data source of type Paginated Data Source
and select the previously created data source as its source. Since pagination in Airtable is cursor-based, use this type as the pagination type. Select offset
as a cursor variable with an initial cursor value of 0
as we tested earlier.
To select the results, use $.records[*]
in the result selector. This will capture the records from each page.
Airtable sends an offset variable as long as more pages exist, until the last page where the offset field is missing. The Finish Condition
should therefore be set to Empty Target
and the Finish Target
should be $.offset
. This will trigger a search for more pages until the target value is empty.
If the pagination testing gives a valid result, the paginated data source is now ready for use.