Forum Discussion
If statements and RelativePath conversion for Web
I am trying to convert some PowerBI which works on Desktop but not on Web. It is trying to pull down a long list 100 items at a time, via API. Based on whether its the first pass or a subsequent pa...
I believe I have it working now using,
agents", [Query=[limit="100", cursor=cursor], Headers=headers])),
Ive tried with Queries but it just fails. Even If I just do a limit of 100 in the query (and ignore cursor for now) if results in 'null' data [Query=[limit="100"]]. The full Function is below
FnGetMorePages =
(url, cursor, iter) as record =>
let
Source = Json.Document(Web.Contents("https://xxxxx.net/web/api/v2.1/agents", [Query=[limit="100", cursor=cursor]], [Headers = headers])),
data = try Source[data] otherwise null,
next = try Source[pagination][nextCursor] otherwise null,
res = [Data=data, Next=next]
in
res,
might want to check the parameter format. Not sure if Query is smart enough to handle integers and texts in the same URL string.