From the API Docs:
The server returns one page of records at a time. Each page will contain pageSize records, which is 100 by default. If there are more records, the response will contain an offset. To fetch the next page of records, include offset in the next request’s parameters.
So in my code (which is server side PHP), I do a loop at the bottom of which I check if the returned offset is null or not. If it is NOT null, then I let the loop continue with the new offset. Eventually (depending on just how many records match your filter or are in your view/table) the offset isn’t returned, or is NULL, thus breaking the loop.
So no waiting is required, each result contains the information required to determine if an additional request is needed or if all the result have been returned.
Here’s how I do it in PHP
<?php
// Initialize the offset.
$offset = 0;
// Initialize the result set.
$records = array();
// Make calls to Airtable, until all of the data has been retrieved...
while (!is_null($offset)):
// We're using an offset to get specific batches of records.
if ($offset > 0){
$http_params["offset"] = $offset;
}
if (isset($params["view"])){
// And we're specifying a view. The API will honor any filters
// that have been applied to the view, as well as any sort
// order that has been applied to it.
$http_params["view"] = $params["view"];
}
if (isset($params["fields"])){
// By default, the APi will return every column/field
// You can specify smaller specific fields only
// using this query parameter, as we are here.
$http_params["fields"] = $params["fields"];
}
if (isset($params["limit"])){
// By default, the APi will return 100 records per request.
// You can specify smaller batch sizes using the "limit"
// query parameter, as we are here.
$http_params["limit"] = $params["limit"];
}
if (isset($params["sort"])){
// We're also specifying a sort order for the request,
// which will override any sort order that has been
// applied on the view.
if (is_array($params["sort"])){
$http_params["sort"] = $params["sort"];
} else {
$http_params["sort"] = array($params["sort"],"asc");
}
}
if (isset($params["filterByFormula"])){
$http_params["filterByFormula"] = $params["filterByFormula"];
}
// Specify the URL to call.
$curlopt_url = $this->AIRTABLE_API_URL
. $this->APP_ID
. '/' . rawurlencode($endpoint)
. "?" . http_build_query($http_params);
$args = array(
'timeout' => 30,
'redirection' => 5,
'blocking' => $blocking,
'headers' => $http_headers,
'cookies' => array(),
'body' => null,
'compress' => false,
'decompress' => true,
'sslverify' => true
);
$response = wp_remote_get( $curlopt_url, $args );
// When getting a table, we'll build an array of records,
// when getting a record, we'll just return the record.
if (isset($body["records"])){
$records = array_merge($records,$body["records"]);
} else {
$records = $body;
}
// Adjust the offset.
// Airtable returns NULL when the final batch of records has been returned.
$offset = (isset($body["offset"]))? $body["offset"] : null;
endwhile;
?>
