Extracting json body

[Marcel_Ubels]

I have problems getting the information out of a json body.
I tried jsonpath evaluator. The input i have is;
{“energyDetails”:{“timeUnit”:“YEAR”,“unit”:“Wh”,“meters”:[{“type”:“Production”,“values”:[{“date”:“2020-01-01 00:00:00”,“value”:2189424.0}]}]}}

I want out of value the number 2189424.0

the solution from jsonpath is: $.energyDetails.meters.[value]

when i try this in homeyscript it doesn’t work;
var body = await res.json();
var body2 = body.energyDetails.meters.values[‘value’]

or

var body2 = body.energyDetails.meters.[‘value’]

the console gives as result; Undefined

Anyone a idea how to get the correct format?

[johan_bendz]

@Marcel_Ubels

var body = await res.json();
var body2 = body.energyDetails.meters.values[‘value’]

console.log(res.energyDetails.meters[0].values[0].value);

[Marcel_Ubels]

Great, works💪