Forum Discussion

Gekko1's avatar
Gekko1
Helper I
3 years ago

Paginated API

So, I have this API which is paginated by the GeneralCode of the last row of the table. The parameters used in the endpoint are the code itself, and a range of dates. I tried to loop through the pages using the solution provided by PBI guy as seen here (https://pbi-guy.com/2022/07/05/how-to-loop-through-an-api-with-power-bi-without-knowing-last-page/). I havent achieved any success because my loop within the list.generate function only run the first iteration. The json returned by the API is shaped as seen below:

 

 

["LastCode":0000,

Results:{{ code: 0000

             Value: 11111},

             { code: 0001

             Value: 11112} ........}]

1 Reply

  • please show a sanitized version of your Power Query code.