Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Thanks to @lbendlin, I found a tip to terminate an API loop with List.Empty.
However my reference to the projNo column in the List.Generate() is erroring when I expand the table list.
#"02ListGenerate = Table.AddColumn(#"01filterProject", "dRofusRecord", each List.Generate(() =>
[proj = [projNo], skip = 0, top = 50, recordList = getURI(proj, top, skip)],
each not List.IsEmpty([recordList]),
each [proj=[projNo],
skip = [skip] + [top],
top = [top],
recordList = getURI(proj, top, skip)]
))
Thank you for any guidance.
Solved! Go to Solution.
In the List.Generate() I changed proj=[projNo] to projNo = [projNo].
This now works!
= Table.AddColumn(#"01filterProject", "dRofusRecord", each List.Generate(() =>
[projNo = [projNo], skip = 0, top = 50, recordList = getURI(projNo, top, skip)],
each not List.IsEmpty([recordList]),
each [projNo = [projNo],
skip = [skip] + [top],
top = [top],
recordList = getURI(projNo, top, skip)]
))
Thank you again @lbendlin for prompting the question. I appreciate this forum because submitting the question forces me to better understand the "problem statement."
What's the error message?
Expression.Error: The field 'projNo' of the record wasn't found.
getURI()
(projNo as text, topVal as number, skipVal as number)=>
let
#"FilterColumnTable" = Table.SelectRows(#"102APImapRooms100", each ([ObjectType] = "rooms")),
GetWebContents =
Web.Contents(
"https://api-us.drofus.com/api/company/",
[
RelativePath= projNo
& "/rooms"
& "?$select=" & Text.Combine(#"FilterColumnTable"[dRofus.ID], ",")
& "&$top=" & Number.ToText(topVal)
& "&$skip=" & Number.ToText(skipVal)
]
),
convertedJson = Json.Document(GetWebContents,65001),
in
convertedJson
In the List.Generate() I changed proj=[projNo] to projNo = [projNo].
This now works!
= Table.AddColumn(#"01filterProject", "dRofusRecord", each List.Generate(() =>
[projNo = [projNo], skip = 0, top = 50, recordList = getURI(projNo, top, skip)],
each not List.IsEmpty([recordList]),
each [projNo = [projNo],
skip = [skip] + [top],
top = [top],
recordList = getURI(projNo, top, skip)]
))
Thank you again @lbendlin for prompting the question. I appreciate this forum because submitting the question forces me to better understand the "problem statement."
User | Count |
---|---|
5 | |
4 | |
3 | |
2 | |
2 |
User | Count |
---|---|
8 | |
6 | |
4 | |
4 | |
4 |