Forum Discussion
jtpiazzamn
3 years agoHelper I
Importing JSON data with multiple pages
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.
1 Reply
- amitchandakSuper User
jtpiazzamn , refer if this can help
https://medium.com/@marktiedemann/how-to-do-pagination-in-power-query-430460c17c78