topic Re: API JSON Codes in Developer

API JSON Codes

Kathir — Tue, 16 Aug 2022 03:15:58 GMT

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.

Re: API JSON Codes

lbendlin — Wed, 17 Aug 2022 00:14:30 GMT

Post a sanitized version of the returned JSON.

Re: API JSON Codes

Kathir — Wed, 17 Aug 2022 02:40:12 GMT

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

Re: API JSON Codes

lbendlin — Wed, 17 Aug 2022 02:56:26 GMT

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

Re: API JSON Codes

Kathir — Wed, 17 Aug 2022 07:31:02 GMT

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

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

Re: API JSON Codes

lbendlin — Wed, 17 Aug 2022 10:50:32 GMT

Use "Bearer " instead of "JWT".

Re: API JSON Codes

Kathir — Mon, 22 Aug 2022 02:41:59 GMT

Sorry for the delayed reply. It still doesnt work.