Forum Discussion
tempranello
Advocate I
Advocate Ihow to create a query that paginates?
Hello there I've a Dovico web API that I need to access to pull down all records. For clarity, I'm calling the Time Entries function. The API lists request restritcions as: ...limited to...
With List.Generate you should be able to "harvest" the list of URL's - you can even try to "harvest" the content at the same time. (But watch out: There's an error in the documentation: Result of last example should be {2, 4, 6, 8})
See Chris' article on how List.Generate works in general: http://blog.crossjoin.co.uk/2014/06/25/using-list-generate-to-make-multiple-replacements-of-words-in-text-in-power-query/
