Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Unexpected error in the query 'Transform homedailydata file'. (JSON FORMAT ERROR?)

I am trying to get data from Azure Blob Storage. 

 

This is the error I get:

Unexpected error in the query 'Transform homedailydata file'. Expression.Error: Cannot convert a List type value to the Record type.
Details
    Value=List
    Type=Type

This is the content of the file:

 

[{"voltage_mv":228382,"current_ma":21,"timestamp":"2019-05-12T10:36:25.861711","energy_wh":115,"power_mw":0},{"voltage_mv":228410,"current_ma":22,"timestamp":"2019-05-12T10:36:30.942967","energy_wh":115,"power_mw":0},{"voltage_mv":228302,"current_ma":22,"timestamp":"2019-05-12T10:36:35.877081","energy_wh":115,"power_mw":0},{"voltage_mv":228331,"current_ma":21,"timestamp":"2019-05-12T10:36:40.957370","energy_wh":115,"power_mw":0},{"voltage_mv":228565,"timestamp":"2019-05-12T10:37:19.149209","current_ma":22,"energy_wh":115,"power_mw":0},{"timestamp": "2019-05-11T23:45:06.875618", "current_ma": 21, "power_mw": 0, "energy_wh": 0, "voltage_mv": 0}]

It is just power consumption values and the timestamp when they were measured (every 5 seconds).

 

Can anyone offer any help?

Need Help

1 Reply

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    Hi Anonymous 

    Here is a similar thread you could refer to:

    import JSON files from an Azure Blob Storage

    If it doesn't help, please share me the code in Advanced editor untill the error shows.

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.