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":[]}]
1 Like
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

1 Like
4

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.