I am trying to iterate between pages of results from Airtable in Integromat.
I tried to do this with Search Records but couldn’t work out a way to back and iterate through any bundles above 100 (it was reporting the first 100 bundles, being the default page size in Airtable).
So I’m using a custom API call and can pull the first 100 records, with an offset. I can then pass the offset in a second query and get more records. However, I can’t work out a way to repeat the process programatically based on the total number of bundles - I don’t want to include an arbitrary number of calls as that isn’t flexible if the records exceed the number of calls, and in any case using multiple calls (rather than say one call with a repeater) seems tricky.
Any input very gratefully received!