Forum Discussion
REST Api pagination
Hello, I am wondering if you can help me with api pagination... I am trying to get all records from an external api but it restricts me with only getting maximum of 10. There are around 40k records....
lbendlin
Super User
Super UserMost likely that site allows GET parameters or POST payloads specifying the page number, and a larger amount of results per page. Do they provide any type of API documentation?
Thanks for you reply... They only allow page numbers in the "body" and the maximum is 10 records by default. dont allow to fetch more.
- lbendlin
Fair enough.
1. Run the initial query and fetch the totalCount value
2. Generate a series of page numbers from 2 to TotalCount/10
3. add the page number to your content payload and fetch the individual results
4. combine with the result from page 1 (step 1)
Thankyou lbendlin
But I have no clue how can i write your given 4 steps in the editor. I am very new to Power Query... 😐