Help needed - Pagination API loop

[TimHilverts]

Hi all,

I am in need of some help, we are using the API of Workable ( https://workable.readme.io/reference/job-candidates-index ). Which works fine. However we are facing issues with loading in the whole dataset of the source. The API limits the amount of rows by 1000 and sends back a 'next page' url which is based on the next following ID. 

In the meantime I have searched on this forum to find information about pagination, but I could not get it to work since all of the examples contain less complexity with the next page number populated.

It would be great if someone could help me out here. Many thanks!

Query and screenshots below:

Source = Json.Document(Web.Contents("https://<subsite>.workable.com/spi/v3/candidates?limit=1000", [Headers=[Authorization="Bearer <KEY>"]])),
candidates = Source[candidates],

[SL97641]

I am also interested in this since I have a similar issue.