Load all pages from Web API

[Anonymous]

Hi guys

I know this was discussed many times and I find a lot of links that illustrate possible solutions, but I am not in the position to translate those solutions to my problem:

I have a web API call for "tickets" which generally returns only 100 rows per page in JSON Format. I'd like to get all pages in, incl. the possibility to refresh from the Power BI Service. So I need to iterate through all pages until the response of the API in "next_page" is Null.

Can anyone tell me the M Code required to get to that full list of tickets? 

Thanks a lot for the help! I spent hours investigating this challenge on the web and could not find a lead....

[v-eachen-msft · Accepted solution]

Hi @Anonymous ,

After research, there is a blog discribed how to implement REST API pagination with m query.It is a similar thread for your reference.

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