Hi
I had a URL which only give first 25 results due pagination. but i solved it using invoke function.
I have created a Invoke function which repeats itself until the next column does not have any URL to continue. Here I have to input the URL in invoke function and it gives me the results combined together. But since its a dynamic source i cannot refresh it on report server. can anyone help me covert the first 25 to static function and then retrive the rest with URL stored in next column. (Maybe something similar to Folder.Files where we use the invoke function to combine all data.)
Invoke function I created:
let
Source = (url as text) =>
let
getData = (dataURL as text, listFrac as list) =>
let
query = Json.Document(Web.Contents(dataURL, [Headers=[#"x-api-key"="xxxxxxxxxxxxxxx"]])),
Result = if query[next] <> null then @getData(query[next], List.Combine({query[results], listFrac})) else List.Combine({query[results], listFrac})
in
Result,
finalResult = getData(url, {})
in
finalResult
in
Source
