Forum Discussion
Gekko1
Helper I
3 years agoLoop through a paginated API getting the ID of the last record
My company is rebuilding our API's so they are paginated now. The problem is, one of our parameters should be the last ID of the record however, in order to get the loop working I should get the ID o...
ImkeF
Community Champion
3 years agoHi Gekko1 ,
you can use the List.Generate function for it. In this blogpost I have shown a simple implementation for it:
How not to miss the last page when paging with Power BI and Power Query (thebiccountant.com)