Looping through Paginated API

[Tom__]

Hi all,

im pulling in a rest API into a Datamart and I'm struggling to loop through to pull through all the records. Currently the limit to the records that pull through is 1000 rows. The dataset increases everyday so there's no set page numbers or total records. 

to access the next page of 1000 records I need to use a 'nextPageId' within the API url. This is a dynamic id and looks like 17808983540000,2390802937. This looks like it's a concatenation of 2 Columns on the 1000th row hence why it always changes.

is there a way I can get power query to loop through the dynamically changing nextpageids to pull through all records as one table?

[lbendlin]

As you can probably appreciate it is nearly impossible to help with API queries without access to said API  (which you may not be willing to provide for understandable reasons)

Please provide some more details of what you have tried.