Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Kathir
Frequent Visitor

API JSON Codes

Kathir_0-1660619353256.png

 

hi, I need an help with the above code. I encountered an error: Expression.Error: We cannot convert a value of type Record to type Number. 

Need help on this please. 

6 REPLIES 6
lbendlin
Super User
Super User

Post a sanitized version of the returned JSON.

Sure thanks

 

Kathir_0-1660703969787.png

************************************************************************************************************

let
baseuri = "https://xxxx/devices/641524/stream-data-full",
initReq = Json.Document(Web.Contents(baseuri),[Headers=[Authorization="JWT "&GetToken()]]),
initData = initReq[results],
gather = (data as list, uri) =>

let
newOffset = Json.Document(Web.Contents("https://xxxx/devices/641524/stream-data-full"))[paging][next][after],
newUri = baseuri & "&after=" & newOffset,
newReq = Json.Document(Web.Contents(newUri)) ,
newdata = newReq[results] ,
data = List.Combine({data, newdata}),
check = if Table.Contains ( Record.ToTable(newReq) , [Name = "paging"] ) = true then @gather (data , newUri) else data
in check,

outputList = if Table.Contains ( Record.ToTable (initReq) , [Name = "paging"] ) = true then gather( initData , baseuri ) else initData ,
expand = Table.FromRecords(outputList)
in
expand

Your call result is a list, not a record. Replace Table.FromRecords with the appropriate list extractor.

Thanks but if i click goto error, its pointing to this line:

 

initReq = Json.Document(Web.Contents(baseuri),[Headers=[Authorization="JWT "&GetToken()]]),

Use "Bearer " instead of "JWT".

Sorry for the delayed reply. It still doesnt work. 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.