JSON. Again...

[peterbos]

Hi,

Not for the first time I have trouble extracting data from a JSON table. I have this table in a HTTPResponse:

Code: Select all

{
 "Prices": [
  {
   "price": 0.11,
   "readingDate": "2024-01-08T22:00:00Z"
  }
 ],
 "intervalType": 4,
 "average": 0.11,
 "fromDate": "2024-01-08T22:00:00Z",
 "tillDate": "2024-01-08T22:59:59Z"
}

There's only one value in the subtable Prices. How do I extract the value of the field "price"? I tried

Code: Select all

item.json.Prices[1].price

but that returns nil.

Peter

[philchillbill]

item.Prices[0].price would do it, assuming the snippet you showed above is called item

[peterbos]

Hi philchillbill,

That does not work but I found the solution. Before reading the json I have to do some mysterious converting with

Code: Select all

local json = domoticz.utils.fromJSON(item.data)
local Prijs = json.Prices[1].price  -- Prices[1], not Prices[0]

The confusing thing is that I can get the value of (say) the "average" field with item.json.average without the conversion.

Peter

[philchillbill]

Sorry, my answer assumed normal json parsing whereas your solution shows you’re trying to parse it inside some environment which you didn’t specify in your question.