Seperating multiple values from Message Payload

General
1

Hi,

I have the following message payload:

{"Header":{"Version":5,"Device":"80","Timestamp":1564041835},"Data":{"Inputs":[{"Number":1,"AD":"A","Value":{"Value":32.4,"Unit":"1"}},{"Number":2,"AD":"A","Value":{"Value":27.2,"Unit":"1"}},{"Number":3,"AD":"A","Value":{"Value":68.3,"Unit":"1"}},{"Number":4,"AD":"A","Value":{"Value":29,"Unit":"1"}},{"Number":5,"AD":"A","Value":{"Value":36.6,"Unit":"1"}},{"Number":6,"AD":"A","Value":{"Value":31.2,"Unit":"1"}},{"Number":7,"AD":"D","Value":{"Value":0,"Unit":"43"}},{"Number":8,"AD":"D","Value":{"Value":0,"Unit":"43"}},{"Number":9,"AD":"D","Value":{"Value":0,"Unit":"43"}},{"Number":10,"AD":"D","Value":{"Value":0,"Unit":"43"}},{"Number":11,"AD":"D","Value":{"Value":0,"Unit":"43"}},{"Number":12,"AD":"D","Value":{"Value":0,"Unit":"43"}},{"Number":13,"AD":"D","Value":{"Value":0,"Unit":"43"}},{"Number":14,"AD":"D","Value":{"Value":0,"Unit":"43"}},{"Number":15,"AD":"D","Value":{"Value":0,"Unit":"43"}},{"Number":16,"AD":"A","Value":{"Value":151,"Unit":"3"}}]},"Status":"OK","Status code":0}

How can I parse one part of this message, eg. Value of Input Number 1, and set it as new message body?

Best Regards,
Johannes

2

Please read the documentation.

3

May be something like that if you want to get the Key/Value pair- "Value": 32.4 .

image
image.png627×752 12.9 KB 

[{"id":"b37dd9cc.0bb588","type":"change","z":"b599c8e9.31852","name":"jasonata filter","rules":[{"t":"set","p":"payload","pt":"msg","to":"Data.Inputs[Number=1].Value{\"Value\":Value}","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":300,"y":240,"wires":[["d873e6bb.f7e018"]]}]