Forum Discussion
Looping to Multiple id's and pagination in API using Power Query
Hi everyone I hope you all are fine. Any power query expert here in rest API's Really need some help. I'm stuck for days. Background: I am extracting data from an rest api which has get request...
Hi Anonymous ,
In this case seems like it belongs to the 'page number' is known so you may refer this video to do the pagination for the API which introduces it in details:
How to do Pagination on a REST API in Power Query (Part 1)
When the 'page number' is unknown, it has better to use List.Generate(), see:
How to do Pagination without knowing the number of pages (Part 2) in Power Query | List.Generate
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
H v-yingjl if you look at me reply already applied the step. but it only works for single id not for multiple id's.