Fetch API data into airtable until every data point is retrieved usng offsets and limit

[seidumohammed64]

Please any guide on this? 

I am  trying to fetch all the data from the products endpoint of an API using a limit of max 500 data point per fetch and an offset that increment per every fetch

So if the offset is 0, and the fetching max limit of 500 the next offset = 500, 1000, 1500 in that order.

I already have to script fetching the data at max of 500 but I have to always manually set the offsets which is time consuming so I want this to be automated in code. 

If I can get a sample code that does similar I will be glad

[seidumohammed64 · Accepted solution]

After a couple of try and errors I have managed to get this working. The script runs until all the products from the API are populated in my airtable base. I achieved this with a while loop