Forum Discussion
Loop API request and append results to one table
I use API as a source and it gives me the following result: result = List total_results = 11829 total_pages = 592 Each page contains 20 results. My source code ends with the "page=1", "page...
At first, you can use the total pages to generate a number list, say(1,2,3...592 in each row), check Nested Loop With List.Generate In Power Query.
And then call the API in each row by passing the page number and extend the reponse text(json,xml). This link may give you some inspiration.