Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Load all pages from Web API

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....