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....
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
Super User
Super UserFair 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... 😐