Data preparation from different object layers

General
1

Hello
I am reading an xml file via http reques. I send this to the xml parser and get a lot of data.
See picture.

nodered1
nodered1869×604 57.2 KB

I always needed only one value and read it directly as object 3.
Unfortunately, the xml file is changed some time and my value is sometimes in object 3 or 4 or at other positions.
So I have to adjust my processing.
I have found that it is always the same ROMId and therefore only one sensor. :grinning: Health says something about the reliability of the measured data and is usually around 7.
Under Themperatur, is still an object lower ,the higly requested value is located.

How can I best summarize the data and create an output with the 3 above values ( ROMId, Health and Temper value) for ALL DS18S20 even if the data supplier has once again one sensor more or less.
Then I can search for the ROMId.

{"Devices-Detail-Response":{"$":{"xmlns":"http://www.embeddeddatasystems.com/schema/owserver","xmlns:xsi":"http://www.w3.org/2001/XMLSchema-instance"},"PollCount":["2038611"],"DevicesConnected":["12"],"LoopTime":["10.749"],"DataErrors":["780"],"owd_DS18S20":[{"$":{"Description":"Parasite power thermometer"},"Name":["DS18S20"],"Family":["10"],"ROMId":["BB00080172AD3010"],"Health":["7"],"RawData":["49004B46FFFF0210ED00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"],"PrimaryValue":["36.5 Deg C"],"Temperature":[{"":"36.5","$":{"Units":"Centigrade"}}],"UserByte1":[{"":"75","$":{"Writable":"True"}}],"UserByte2":[{"":"70","$":{"Writable":"True"}}]},{"$":{"Description":"Parasite power thermometer"},"Name":["DS18S20"],"Family":["10"],"ROMId":["1200080172A1D810"],"Health":["7"],"RawData":["56004B46FFFF0A103500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"],"PrimaryValue":["43.0 Deg C"],"Temperature":[{"":"43.0","$":{"Units":"Centigrade"}}],"UserByte1":[{"":"75","$":{"Writable":"True"}}],"UserByte2":[{"":"70","$":{"Writable":"True"}}]},{"$":{"Description":"Parasite power thermometer"},"Name":["DS18S20"],"Family":["10"],"ROMId":["67000801CA106410"],"Health":["7"],"RawData":["88004B46FFFF0D106D00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"],"PrimaryValue":["68.0 Deg C"],"Temperature":[{"":"68.0","$":{"Units":"Centigrade"}}],"UserByte1":[{"":"75","$":{"Writable":"True"}}],"UserByte2":[{"":"70","$":{"Writable":"True"}}]},{"$":{"Description":"Parasite power thermometer"},"Name":["DS18S20"],"Family":["10"],"ROMId":["5E00080172389410"],"Health":["7"],"RawData":["72004B46FFFF0F107700000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"],"PrimaryValue":["57.0 Deg C"],"Temperature":[{"":"57.0","$":{"Units":"Centigrade"}}],"UserByte1":[{"":"75","$":{"Writable":"True"}}],"UserByte2":[{"":"70","$":{"Writable":"True"}}]},{"$":{"Description":"Parasite power thermometer"},"Name":["DS18S20"],"Family":["10"],"ROMId":["23000801729B9410"],"Health":["7"],"RawData":["70004B46FFFF0C10A400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"],"PrimaryValue":["56.0 Deg C"],"Temperature":[{"":"56.0","$":{"Units":"Centigrade"}}],"UserByte1":[{"":"75","$":{"Writable":"True"}}],"UserByte2":[{"":"70","$":{"Writable":"True"}}]},{"$":{"Description":"Parasite power thermometer"},"Name":["DS18S20"],"Family":["10"],"ROMId":["4F000801728D5A10"],"Health":["7"],"RawData":["84004B46FFFF09106900000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"],"PrimaryValue":["66.0 Deg C"],"Temperature":[{"":"66.0","$":{"Units":"Centigrade"}}],"UserByte1":[{"":"75","$":{"Writable":"True"}}],"UserByte2":[{"":"70","$":{"Writable":"True"}}]},{"$":{"Description":"Parasite power thermometer"},"Name":["DS18S20"],"Family":["10"],"ROMId":["0500080172BEFE10"],"Health":["7"],"RawData":["86004B46FFFF0C101000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"],"PrimaryValue":["67.0 Deg C"],"Temperature":[{"":"67.0","$":{"Units":"Centigrade"}}],"UserByte1":[{"":"75","$":{"Writable":"True"}}],"UserByte2":[{"":"70","$":{"Writable":"True"}}]},{"$":{"Description":"Parasite power thermometer"},"Name":["DS18S20"],"Family":["10"],"ROMId":["62000801CA204510"],"Health":["7"],"RawData":["89004B46FFFF06100D00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"],"PrimaryValue":["68.5 Deg C"],"Temperature":[{"":"68.5","$":{"Units":"Centigrade"}}],"UserByte1":[{"":"75","$":{"Writable":"True"}}],"UserByte2":[{"":"70","$":{"Writable":"True"}}]},{"$":{"Description":"Parasite power thermometer"},"Name":["DS18S20"],"Family":["10"],"ROMId":["7A00080172AB1510"],"Health":["7"],"RawData":["3E004B46FFFF0910AB00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"],"PrimaryValue":["31.0 Deg C"],"Temperature":[{"":"31.0","$":{"Units":"Centigrade"}}],"UserByte1":[{"":"75","$":{"Writable":"True"}}],"UserByte2":[{"":"70","$":{"Writable":"True"}}]},{"$":{"Description":"Parasite power thermometer"},"Name":["DS18S20"],"Family":["10"],"ROMId":["0C000801CA3B2D10"],"Health":["7"],"RawData":["6D004B46FFFF01100500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"],"PrimaryValue":["54.5 Deg C"],"Temperature":[{"":"54.5","$":{"Units":"Centigrade"}}],"UserByte1":[{"":"75","$":{"Writable":"True"}}],"UserByte2":[{"":"70","$":{"Writable":"True"}}]},{"$":{"Description":"Parasite power thermometer"},"Name":["DS18S20"],"Family":["10"],"ROMId":["17000801CA011710"],"Health":["7"],"RawData":["6C004B46FFFF09103000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"],"PrimaryValue":["54.0 Deg C"],"Temperature":[{"":"54.0","$":{"Units":"Centigrade"}}],"UserByte1":[{"":"75","$":{"Writable":"True"}}],"UserByte2":[{"":"70","$":{"Writable":"True"}}]}],"owd_DS2408":[{"$":{"Description":"8-Channel Addressable Switch"},"Name":["DS2408"],"Family":["29"],"ROMId":["FA0000000C56E529"],"Health":["7"],"RawData":["8FFFFF00008000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"],"PrimaryValue":["143"],"PIOLogicState":["143"],"PIOOutputLatchState":[{"":"255","$":{"Writable":"True"}}],"PIOActivityLatchState":[{"":"255","$":{"Writable":"True"}}],"RSTZconfiguration":[{"":"0","$":{"Writable":"True"}}],"PowerOnResetLatch":[{"_":"0","$":{"Writable":"True"}}],"VccPowerStatus":["1"]}]}}

2

Here is an example using JSONata and a change node.

Your temp reading is in an array and does not have a object key. So to get the temps i had to work around the issue.

[{"id":"81cb466e.5f6f2","type":"inject","z":"c74669a0.6a34f8","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"{\"Devices-Detail-Response\":{\"$\":{\"xmlns\":\"http://www.embeddeddatasystems.com/schema/owserver\",\"xmlns:xsi\":\"http://www.w3.org/2001/XMLSchema-instance\"},\"PollCount\":[\"2038611\"],\"DevicesConnected\":[\"12\"],\"LoopTime\":[\"10.749\"],\"DataErrors\":[\"780\"],\"owd_DS18S20\":[{\"$\":{\"Description\":\"Parasite power thermometer\"},\"Name\":[\"DS18S20\"],\"Family\":[\"10\"],\"ROMId\":[\"BB00080172AD3010\"],\"Health\":[\"7\"],\"RawData\":[\"49004B46FFFF0210ED00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\"],\"PrimaryValue\":[\"36.5 Deg C\"],\"Temperature\":[{\"\":\"36.5\",\"$\":{\"Units\":\"Centigrade\"}}],\"UserByte1\":[{\"\":\"75\",\"$\":{\"Writable\":\"True\"}}],\"UserByte2\":[{\"\":\"70\",\"$\":{\"Writable\":\"True\"}}]},{\"$\":{\"Description\":\"Parasite power thermometer\"},\"Name\":[\"DS18S20\"],\"Family\":[\"10\"],\"ROMId\":[\"1200080172A1D810\"],\"Health\":[\"7\"],\"RawData\":[\"56004B46FFFF0A103500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\"],\"PrimaryValue\":[\"43.0 Deg C\"],\"Temperature\":[{\"\":\"43.0\",\"$\":{\"Units\":\"Centigrade\"}}],\"UserByte1\":[{\"\":\"75\",\"$\":{\"Writable\":\"True\"}}],\"UserByte2\":[{\"\":\"70\",\"$\":{\"Writable\":\"True\"}}]},{\"$\":{\"Description\":\"Parasite power thermometer\"},\"Name\":[\"DS18S20\"],\"Family\":[\"10\"],\"ROMId\":[\"67000801CA106410\"],\"Health\":[\"7\"],\"RawData\":[\"88004B46FFFF0D106D00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\"],\"PrimaryValue\":[\"68.0 Deg C\"],\"Temperature\":[{\"\":\"68.0\",\"$\":{\"Units\":\"Centigrade\"}}],\"UserByte1\":[{\"\":\"75\",\"$\":{\"Writable\":\"True\"}}],\"UserByte2\":[{\"\":\"70\",\"$\":{\"Writable\":\"True\"}}]},{\"$\":{\"Description\":\"Parasite power thermometer\"},\"Name\":[\"DS18S20\"],\"Family\":[\"10\"],\"ROMId\":[\"5E00080172389410\"],\"Health\":[\"7\"],\"RawData\":[\"72004B46FFFF0F107700000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\"],\"PrimaryValue\":[\"57.0 Deg C\"],\"Temperature\":[{\"\":\"57.0\",\"$\":{\"Units\":\"Centigrade\"}}],\"UserByte1\":[{\"\":\"75\",\"$\":{\"Writable\":\"True\"}}],\"UserByte2\":[{\"\":\"70\",\"$\":{\"Writable\":\"True\"}}]},{\"$\":{\"Description\":\"Parasite power thermometer\"},\"Name\":[\"DS18S20\"],\"Family\":[\"10\"],\"ROMId\":[\"23000801729B9410\"],\"Health\":[\"7\"],\"RawData\":[\"70004B46FFFF0C10A400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\"],\"PrimaryValue\":[\"56.0 Deg C\"],\"Temperature\":[{\"\":\"56.0\",\"$\":{\"Units\":\"Centigrade\"}}],\"UserByte1\":[{\"\":\"75\",\"$\":{\"Writable\":\"True\"}}],\"UserByte2\":[{\"\":\"70\",\"$\":{\"Writable\":\"True\"}}]},{\"$\":{\"Description\":\"Parasite power thermometer\"},\"Name\":[\"DS18S20\"],\"Family\":[\"10\"],\"ROMId\":[\"4F000801728D5A10\"],\"Health\":[\"7\"],\"RawData\":[\"84004B46FFFF09106900000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\"],\"PrimaryValue\":[\"66.0 Deg C\"],\"Temperature\":[{\"\":\"66.0\",\"$\":{\"Units\":\"Centigrade\"}}],\"UserByte1\":[{\"\":\"75\",\"$\":{\"Writable\":\"True\"}}],\"UserByte2\":[{\"\":\"70\",\"$\":{\"Writable\":\"True\"}}]},{\"$\":{\"Description\":\"Parasite power thermometer\"},\"Name\":[\"DS18S20\"],\"Family\":[\"10\"],\"ROMId\":[\"0500080172BEFE10\"],\"Health\":[\"7\"],\"RawData\":[\"86004B46FFFF0C101000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\"],\"PrimaryValue\":[\"67.0 Deg C\"],\"Temperature\":[{\"\":\"67.0\",\"$\":{\"Units\":\"Centigrade\"}}],\"UserByte1\":[{\"\":\"75\",\"$\":{\"Writable\":\"True\"}}],\"UserByte2\":[{\"\":\"70\",\"$\":{\"Writable\":\"True\"}}]},{\"$\":{\"Description\":\"Parasite power thermometer\"},\"Name\":[\"DS18S20\"],\"Family\":[\"10\"],\"ROMId\":[\"62000801CA204510\"],\"Health\":[\"7\"],\"RawData\":[\"89004B46FFFF06100D00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\"],\"PrimaryValue\":[\"68.5 Deg C\"],\"Temperature\":[{\"\":\"68.5\",\"$\":{\"Units\":\"Centigrade\"}}],\"UserByte1\":[{\"\":\"75\",\"$\":{\"Writable\":\"True\"}}],\"UserByte2\":[{\"\":\"70\",\"$\":{\"Writable\":\"True\"}}]},{\"$\":{\"Description\":\"Parasite power thermometer\"},\"Name\":[\"DS18S20\"],\"Family\":[\"10\"],\"ROMId\":[\"7A00080172AB1510\"],\"Health\":[\"7\"],\"RawData\":[\"3E004B46FFFF0910AB00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\"],\"PrimaryValue\":[\"31.0 Deg C\"],\"Temperature\":[{\"\":\"31.0\",\"$\":{\"Units\":\"Centigrade\"}}],\"UserByte1\":[{\"\":\"75\",\"$\":{\"Writable\":\"True\"}}],\"UserByte2\":[{\"\":\"70\",\"$\":{\"Writable\":\"True\"}}]},{\"$\":{\"Description\":\"Parasite power thermometer\"},\"Name\":[\"DS18S20\"],\"Family\":[\"10\"],\"ROMId\":[\"0C000801CA3B2D10\"],\"Health\":[\"7\"],\"RawData\":[\"6D004B46FFFF01100500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\"],\"PrimaryValue\":[\"54.5 Deg C\"],\"Temperature\":[{\"\":\"54.5\",\"$\":{\"Units\":\"Centigrade\"}}],\"UserByte1\":[{\"\":\"75\",\"$\":{\"Writable\":\"True\"}}],\"UserByte2\":[{\"\":\"70\",\"$\":{\"Writable\":\"True\"}}]},{\"$\":{\"Description\":\"Parasite power thermometer\"},\"Name\":[\"DS18S20\"],\"Family\":[\"10\"],\"ROMId\":[\"17000801CA011710\"],\"Health\":[\"7\"],\"RawData\":[\"6C004B46FFFF09103000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\"],\"PrimaryValue\":[\"54.0 Deg C\"],\"Temperature\":[{\"\":\"54.0\",\"$\":{\"Units\":\"Centigrade\"}}],\"UserByte1\":[{\"\":\"75\",\"$\":{\"Writable\":\"True\"}}],\"UserByte2\":[{\"\":\"70\",\"$\":{\"Writable\":\"True\"}}]}],\"owd_DS2408\":[{\"$\":{\"Description\":\"8-Channel Addressable Switch\"},\"Name\":[\"DS2408\"],\"Family\":[\"29\"],\"ROMId\":[\"FA0000000C56E529\"],\"Health\":[\"7\"],\"RawData\":[\"8FFFFF00008000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\"],\"PrimaryValue\":[\"143\"],\"PIOLogicState\":[\"143\"],\"PIOOutputLatchState\":[{\"\":\"255\",\"$\":{\"Writable\":\"True\"}}],\"PIOActivityLatchState\":[{\"\":\"255\",\"$\":{\"Writable\":\"True\"}}],\"RSTZconfiguration\":[{\"\":\"0\",\"$\":{\"Writable\":\"True\"}}],\"PowerOnResetLatch\":[{\"_\":\"0\",\"$\":{\"Writable\":\"True\"}}],\"VccPowerStatus\":[\"1\"]}]}}","payloadType":"json","x":230,"y":980,"wires":[["5ca87b41.8332bc"]]},{"id":"5ca87b41.8332bc","type":"change","z":"c74669a0.6a34f8","name":"","rules":[{"t":"set","p":"payload","pt":"msg","to":"payload.`Devices-Detail-Response`.owd_DS18S20.{\"ROMId\": ROMId[0],\"Health\": Health[0], \"Temperature\": Temperature[0].*[0]}","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":460,"y":1060,"wires":[["68f1a316.5e352c","633b6cf4.123b84"]]},{"id":"68f1a316.5e352c","type":"debug","z":"c74669a0.6a34f8","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":720,"y":1060,"wires":[]},{"id":"633b6cf4.123b84","type":"change","z":"c74669a0.6a34f8","name":"","rules":[{"t":"set","p":"payload","pt":"msg","to":"payload[ROMId=\"4F000801728D5A10\"].Temperature","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":570,"y":1120,"wires":[["6b5fdace.c11e8c"]]},{"id":"6b5fdace.c11e8c","type":"debug","z":"c74669a0.6a34f8","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":790,"y":1120,"wires":[]}]

[edit] or if you want to have the ROMId as an object property. You can also convert the strings to integer or floats.

[{"id":"81cb466e.5f6f2","type":"inject","z":"c74669a0.6a34f8","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"{\"Devices-Detail-Response\":{\"$\":{\"xmlns\":\"http://www.embeddeddatasystems.com/schema/owserver\",\"xmlns:xsi\":\"http://www.w3.org/2001/XMLSchema-instance\"},\"PollCount\":[\"2038611\"],\"DevicesConnected\":[\"12\"],\"LoopTime\":[\"10.749\"],\"DataErrors\":[\"780\"],\"owd_DS18S20\":[{\"$\":{\"Description\":\"Parasite power thermometer\"},\"Name\":[\"DS18S20\"],\"Family\":[\"10\"],\"ROMId\":[\"BB00080172AD3010\"],\"Health\":[\"7\"],\"RawData\":[\"49004B46FFFF0210ED00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\"],\"PrimaryValue\":[\"36.5 Deg C\"],\"Temperature\":[{\"\":\"36.5\",\"$\":{\"Units\":\"Centigrade\"}}],\"UserByte1\":[{\"\":\"75\",\"$\":{\"Writable\":\"True\"}}],\"UserByte2\":[{\"\":\"70\",\"$\":{\"Writable\":\"True\"}}]},{\"$\":{\"Description\":\"Parasite power thermometer\"},\"Name\":[\"DS18S20\"],\"Family\":[\"10\"],\"ROMId\":[\"1200080172A1D810\"],\"Health\":[\"7\"],\"RawData\":[\"56004B46FFFF0A103500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\"],\"PrimaryValue\":[\"43.0 Deg C\"],\"Temperature\":[{\"\":\"43.0\",\"$\":{\"Units\":\"Centigrade\"}}],\"UserByte1\":[{\"\":\"75\",\"$\":{\"Writable\":\"True\"}}],\"UserByte2\":[{\"\":\"70\",\"$\":{\"Writable\":\"True\"}}]},{\"$\":{\"Description\":\"Parasite power thermometer\"},\"Name\":[\"DS18S20\"],\"Family\":[\"10\"],\"ROMId\":[\"67000801CA106410\"],\"Health\":[\"7\"],\"RawData\":[\"88004B46FFFF0D106D00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\"],\"PrimaryValue\":[\"68.0 Deg C\"],\"Temperature\":[{\"\":\"68.0\",\"$\":{\"Units\":\"Centigrade\"}}],\"UserByte1\":[{\"\":\"75\",\"$\":{\"Writable\":\"True\"}}],\"UserByte2\":[{\"\":\"70\",\"$\":{\"Writable\":\"True\"}}]},{\"$\":{\"Description\":\"Parasite power thermometer\"},\"Name\":[\"DS18S20\"],\"Family\":[\"10\"],\"ROMId\":[\"5E00080172389410\"],\"Health\":[\"7\"],\"RawData\":[\"72004B46FFFF0F107700000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\"],\"PrimaryValue\":[\"57.0 Deg C\"],\"Temperature\":[{\"\":\"57.0\",\"$\":{\"Units\":\"Centigrade\"}}],\"UserByte1\":[{\"\":\"75\",\"$\":{\"Writable\":\"True\"}}],\"UserByte2\":[{\"\":\"70\",\"$\":{\"Writable\":\"True\"}}]},{\"$\":{\"Description\":\"Parasite power thermometer\"},\"Name\":[\"DS18S20\"],\"Family\":[\"10\"],\"ROMId\":[\"23000801729B9410\"],\"Health\":[\"7\"],\"RawData\":[\"70004B46FFFF0C10A400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\"],\"PrimaryValue\":[\"56.0 Deg C\"],\"Temperature\":[{\"\":\"56.0\",\"$\":{\"Units\":\"Centigrade\"}}],\"UserByte1\":[{\"\":\"75\",\"$\":{\"Writable\":\"True\"}}],\"UserByte2\":[{\"\":\"70\",\"$\":{\"Writable\":\"True\"}}]},{\"$\":{\"Description\":\"Parasite power thermometer\"},\"Name\":[\"DS18S20\"],\"Family\":[\"10\"],\"ROMId\":[\"4F000801728D5A10\"],\"Health\":[\"7\"],\"RawData\":[\"84004B46FFFF09106900000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\"],\"PrimaryValue\":[\"66.0 Deg C\"],\"Temperature\":[{\"\":\"66.0\",\"$\":{\"Units\":\"Centigrade\"}}],\"UserByte1\":[{\"\":\"75\",\"$\":{\"Writable\":\"True\"}}],\"UserByte2\":[{\"\":\"70\",\"$\":{\"Writable\":\"True\"}}]},{\"$\":{\"Description\":\"Parasite power thermometer\"},\"Name\":[\"DS18S20\"],\"Family\":[\"10\"],\"ROMId\":[\"0500080172BEFE10\"],\"Health\":[\"7\"],\"RawData\":[\"86004B46FFFF0C101000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\"],\"PrimaryValue\":[\"67.0 Deg C\"],\"Temperature\":[{\"\":\"67.0\",\"$\":{\"Units\":\"Centigrade\"}}],\"UserByte1\":[{\"\":\"75\",\"$\":{\"Writable\":\"True\"}}],\"UserByte2\":[{\"\":\"70\",\"$\":{\"Writable\":\"True\"}}]},{\"$\":{\"Description\":\"Parasite power thermometer\"},\"Name\":[\"DS18S20\"],\"Family\":[\"10\"],\"ROMId\":[\"62000801CA204510\"],\"Health\":[\"7\"],\"RawData\":[\"89004B46FFFF06100D00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\"],\"PrimaryValue\":[\"68.5 Deg C\"],\"Temperature\":[{\"\":\"68.5\",\"$\":{\"Units\":\"Centigrade\"}}],\"UserByte1\":[{\"\":\"75\",\"$\":{\"Writable\":\"True\"}}],\"UserByte2\":[{\"\":\"70\",\"$\":{\"Writable\":\"True\"}}]},{\"$\":{\"Description\":\"Parasite power thermometer\"},\"Name\":[\"DS18S20\"],\"Family\":[\"10\"],\"ROMId\":[\"7A00080172AB1510\"],\"Health\":[\"7\"],\"RawData\":[\"3E004B46FFFF0910AB00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\"],\"PrimaryValue\":[\"31.0 Deg C\"],\"Temperature\":[{\"\":\"31.0\",\"$\":{\"Units\":\"Centigrade\"}}],\"UserByte1\":[{\"\":\"75\",\"$\":{\"Writable\":\"True\"}}],\"UserByte2\":[{\"\":\"70\",\"$\":{\"Writable\":\"True\"}}]},{\"$\":{\"Description\":\"Parasite power thermometer\"},\"Name\":[\"DS18S20\"],\"Family\":[\"10\"],\"ROMId\":[\"0C000801CA3B2D10\"],\"Health\":[\"7\"],\"RawData\":[\"6D004B46FFFF01100500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\"],\"PrimaryValue\":[\"54.5 Deg C\"],\"Temperature\":[{\"\":\"54.5\",\"$\":{\"Units\":\"Centigrade\"}}],\"UserByte1\":[{\"\":\"75\",\"$\":{\"Writable\":\"True\"}}],\"UserByte2\":[{\"\":\"70\",\"$\":{\"Writable\":\"True\"}}]},{\"$\":{\"Description\":\"Parasite power thermometer\"},\"Name\":[\"DS18S20\"],\"Family\":[\"10\"],\"ROMId\":[\"17000801CA011710\"],\"Health\":[\"7\"],\"RawData\":[\"6C004B46FFFF09103000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\"],\"PrimaryValue\":[\"54.0 Deg C\"],\"Temperature\":[{\"\":\"54.0\",\"$\":{\"Units\":\"Centigrade\"}}],\"UserByte1\":[{\"\":\"75\",\"$\":{\"Writable\":\"True\"}}],\"UserByte2\":[{\"\":\"70\",\"$\":{\"Writable\":\"True\"}}]}],\"owd_DS2408\":[{\"$\":{\"Description\":\"8-Channel Addressable Switch\"},\"Name\":[\"DS2408\"],\"Family\":[\"29\"],\"ROMId\":[\"FA0000000C56E529\"],\"Health\":[\"7\"],\"RawData\":[\"8FFFFF00008000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\"],\"PrimaryValue\":[\"143\"],\"PIOLogicState\":[\"143\"],\"PIOOutputLatchState\":[{\"\":\"255\",\"$\":{\"Writable\":\"True\"}}],\"PIOActivityLatchState\":[{\"\":\"255\",\"$\":{\"Writable\":\"True\"}}],\"RSTZconfiguration\":[{\"\":\"0\",\"$\":{\"Writable\":\"True\"}}],\"PowerOnResetLatch\":[{\"_\":\"0\",\"$\":{\"Writable\":\"True\"}}],\"VccPowerStatus\":[\"1\"]}]}}","payloadType":"json","x":230,"y":980,"wires":[["5ca87b41.8332bc"]]},{"id":"5ca87b41.8332bc","type":"change","z":"c74669a0.6a34f8","name":"","rules":[{"t":"set","p":"payload","pt":"msg","to":"payload.`Devices-Detail-Response`.owd_DS18S20.${\tROMId[0]:{\t\"Health\": $number(Health[0]), \t\"Temperature\": $number(Temperature[0].*[0]), \t\"Unit\": Temperature[0].*[1].Units}}","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":460,"y":1060,"wires":[["68f1a316.5e352c","633b6cf4.123b84"]]},{"id":"68f1a316.5e352c","type":"debug","z":"c74669a0.6a34f8","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":720,"y":1060,"wires":[]},{"id":"633b6cf4.123b84","type":"change","z":"c74669a0.6a34f8","name":"","rules":[{"t":"set","p":"payload","pt":"msg","to":"payload.`4F000801728D5A10`.Temperature","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":570,"y":1120,"wires":[["6b5fdace.c11e8c"]]},{"id":"6b5fdace.c11e8c","type":"debug","z":"c74669a0.6a34f8","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":790,"y":1120,"wires":[]}]
3

WAU!
a very big thank you E1cid
My attempts are felt 1000 times as large.
In particular, the second approach is perfect for me to convert. And that without adapting my existing environment much.
I will need some more time to understand the subtleties of JSON.
For this my programming knowledge is still in beginner mode.
THX
Edstobi