Forum Discussion
Combine Rest API Pagination and Multiple Loops
HI Everyone. I hope you all are having a wonderful day. Background: I want extract all data from Rest API but the issue is that its URL provides data of 50 rows per Agent-ID. URL: https://vcc-na8...
You can use List.Generate to peek into the response and see if at a given offset no more data is returned.
You could also use recursive functions but these generally do not work well when you have to return a lot of data.
As you may imagine - without access to your API it is very difficult to help you with the code. That's a problem for any scenario that requires authentication/authorization. Pity that they don't have dummy/test user accounts.
Hi lbendlin
PFB the summarized issue in the below link,
It has a video link through which you will be easily able to explain the the issue and provide solution.
https://community.powerbi.com/t5/Developer/Power-BI-Pagination-amp-Looping-using-List-Generate/m-p/2383290
Best,
Saad.