Forum Discussion
Web.Contents - Desktop to Service
Hello Everyone, I have been working on this for awhile, but I am just lacking a proper understanding of how Web.Contents is used between the Desktop and Service. Here is my delima: I have Po...
Hi Anonymous ,
problem is the dynamic URL.
You have to use the relative path for it instead: http://blog.datainspirations.com/2018/02/17/dynamic-web-contents-and-power-bi-refresh-errors/
Hi Anonymous ,
problem is the dynamic URL.
You have to use the relative path for it instead: http://blog.datainspirations.com/2018/02/17/dynamic-web-contents-and-power-bi-refresh-errors/
ImkeF - We started trying to give a static URL within the Web.Contents and add the Relative path, but we aren't getting an results. Here is what we changed:
let
BearerToken= "Bearer XXXXXXXXXXXXXXXXX",
PageLimit = 20,
Pagination = List.Buffer(List.Generate( () => [WebCall=[], Page = 1, Counter = 0],
each (try List.IsEmpty([WebCall][client_data])=false otherwise false or [Counter]=0) and [Page]<=PageLimit,
each [ WebCall = Json.Document(Web.Contents("https://api.getdata.com/surveys/clientid",
[RelativePath="/responses?page=" & Text.From([Page]),
Query=[Headers=[Authorization=BearerToken]]])),
Page = [Page]+1,
Counter = [Counter]+1
]
))
in
Pagination
Is there something wrong with syntax of the Relative Path parameter?
w.