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=2" parameter. I was planning copy and paste queries before I noticed that there are so many pages. I need to append all the results to one table.
Is there a way to loop my request using QueryEditor for each page that is needed to get all data out?
1 Reply
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.
