API JSON Codes

[Kathir]

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. 

[lbendlin]

Post a sanitized version of the returned JSON.

[Kathir]

Sure thanks

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

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

[lbendlin]

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

[Kathir]

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

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

[lbendlin]

Use "Bearer " instead of "JWT".

[Kathir]

Sorry for the delayed reply. It still doesnt work.