Get all records from all API pages

[Anonymous]

Hi community,
I am running into an issue with going through all results with a GET API call. The API call will only return 10,000 records along with a pagination NEXT token that can be passed as a parameter to the API call to fetch the next 10,000 records. This will repeat until the API call returns no NEXT token, which means it reaches the end of the results. I dont have much experience in Query Editor to implement it and hope you could share what you did to achieve the looping to get all records. 

[amitchandak]

@Anonymous , refer

https://www.daytodatastuff.co.uk/blog/creating-loops-in-m

or

https://medium.com/@marktiedemann/how-to-do-pagination-in-power-query-430460c17c78