Importing JSON data with multiple pages

[jtpiazzamn]

I'm importing JSON data via an API which has multiple pages due to the amount of data. I can import 1 page fine, however I'm not sure how to configure this for multiple pages. 

The format for pulling information to a JSON file is something like this:

https://site.com/api/v1/xxxx/?limit=1000&page=1&include=id,name

Where I would change the page # to 2 then to page 3 etc. 

[amitchandak · Accepted solution]

@jtpiazzamn , refer if this can help

https://medium.com/@marktiedemann/how-to-do-pagination-in-power-query-430460c17c78