Let’s say there are 1000 records in Airtable that I need to fetch via the API on a regular schedule (to sync to an SQL DB). How is one supposed to keep within the API limits?
Since Airtable seems limited to only fetching 100 records at a time, this will need 10 requests, and I would assume that fetching them in quick succession could potentially hit the API limit of no more than 5 requests per second.
Can anyone confirm the best way around this? Is it necessary to introduce deliberate delays between the requests in order to combat this?
(The limit of only 100 records at a time is quite frustrating and bothersome IMHO.)