Forum Discussion
Solved
Generating a list from a REST response with pagination
Hi Experts, beeing new to Power Query I am trying to access the pages of a REST response and transform those to one single list by using List.Generate. Unfortunately I don't receive the full list. ...
Since your "next" URL is well structured with Offset and Limit you could choose to fetch the total rowcount in your first call and the use List.Generate to create all the urls (and maybe up the limit a bit so you don't have to fetch in groups of 10). Then it would be a simple Table.AddColumn with the Web.Contents of the generated URLs.
Since your "next" URL is well structured with Offset and Limit you could choose to fetch the total rowcount in your first call and the use List.Generate to create all the urls (and maybe up the limit a bit so you don't have to fetch in groups of 10). Then it would be a simple Table.AddColumn with the Web.Contents of the generated URLs.