Loop API request and append results to one table

[tondeli]

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?

[Eric_Zhang]

@tondeli

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.