Forum Discussion
loginerror
6 years agoFrequent Visitor
Help adjusting List.Generate REST function around error "Unable to do a refresh on Web.contents()"
Hi, I have seen multiple posts on how to achieve it, but I have trouble adapting my custom REST API function. Please see below my source function: (queryID) => let
resultCount = 100...
- 6 years ago
I don't like giving up. See my solution below 🙂
(queryID) => let resultCount = 1000, otherNameForPage = 0, GetPage = (otherNameForPage) => let content1 = "params={""page"":""" & Number.ToText(otherNameForPage) & """}", RawData = Json.Document(Web.Contents( "https://baseURL/admin/plugins/explorer/queries", [RelativePath=Number.ToText(queryID) & "/run", Query= [ params="{""page"":""" & Number.ToText(otherNameForPage) & """}" ], Headers = [ #"api-username"="myUsername", #"api-key"="myAPIKey", #"Content-Type" = "application/x-www-form-urlencoded"], Content = Text.ToBinary(content1) ] ) ), resultCount = RawData[result_count] in if RawData[result_count] = 0 then null else RawData, Pages = List.Generate( () => [i = 0, RawData = GetPage(i)], each [RawData] <> null, each [i=[i]+1, RawData = GetPage(i)], //each Record.ToTable([RawData])), each Table.Combine(let raw = [RawData] in List.Transform(raw[rows], each Table.FromRows({_}, raw[columns])))), // Output = Table.Join(each Pages, Pages[rows]) Output = Table.Combine(Pages) in Output
skins
4 years agoFrequent Visitor
So interesting code loginerror ! thank you 🙂
is it possible to add this parameter to it "limit=ALL" ?
I tried many combinations but it doesn't work
thanks again 🙂