Forum Discussion

bushead1979's avatar
bushead1979
Regular Visitor
8 years ago

JSON API | Expression.Error: We cannot convert a value of type Record to type List.

Hi,   I'm trying to import some api data into powerbi and get the error;   Expression.Error: We cannot convert a value of type Record to type List. Details: Value=Record Type=Type   The JSON...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

bushead1979,

Could you please post the code in your Advanced Editor? What steps in Query Editor do you add when you get this error?

Regards,

Lydia

bushead1979's avatar
bushead1979
Regular Visitor
8 years ago

Being new to the query editor I can't figure out what I need to amend to get the source into a table with seperate columns.

 

let
Source = Json.Document(Web.Contents("https://url...")),
Table = Table.FromRows(Source)
in
Source

 

I have managed to get a single record but not the whole record set I'm assuming I need iterate through the records in a for loop or something?

  • Phoenixke's avatar
    Phoenixke
    Frequent Visitor
    8 years ago

    bushead1979: You're missing an array bracket in the example respons file that you posted.

    Any chance you can post an actual response? (omitting any personal info of course). It should start with "{ "something" : [".

     

    You should then try Json.Document(Web.Contents("https://url..."))[something]