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:
