Help with API to DB Import

I have a Server API Action that queries an API end point which contains around 7000 records. I can use a count condition to get say ‘50’ records and another condition to GET page 1.

I then have a repeat and query the database to check if the ID exists in a table, if it does, it skips and if not inserts some of the info as a record.
It works as expected.

But I want to then loop and get the next page and so on…

I have created a GET variable which default to 1 and set that as the page parameter.
Any thoughts how I can loop and then page 2 etc.

Your help is appreciated

Community Page
Last updated: