# HELP extract data from object/json

**URL:** <https://discourse.nodered.org/t/help-extract-data-from-object-json/86168>\
**Category:** General\
**Tags:** node-red-dashboard, function-node\
**Created:** [5 March 2024 18:44 UTC](https://discourse.nodered.org/t/help-extract-data-from-object-json/86168 "2024-03-05T18:44:31Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![maury77](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/maury77/32/48205_2.png) [@maury77](https://discourse.nodered.org/u/maury77)\
**Post date:** [5 March 2024 18:44 UTC](https://discourse.nodered.org/t/help-extract-data-from-object-json/86168/1 "2024-03-05T18:44:31Z")

</div>

Sorry but I have need to parse this object

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/2/9/2914f5cf806d832eca8b3f6bb19df6454342c4b8.png)

I want extra VolV for each element of array

{"topic":"energy\_measurs","payload":{"serial":"A07766","measurs":[{"phaseId":0,"voltV":223,"currentA":2.038,"powerW":364,"powerFactor":0.8009999990463257},{"phaseId":1,"voltV":225.3000030517578,"currentA":2.102,"powerW":412,"powerFactor":0.8690000176429749},{"phaseId":2,"voltV":231.1999969482422,"currentA":0.624,"powerW":80,"powerFactor":0.5569999814033508}],"totPowerW":856,"errorSensor":0}}

---

<div class="post-metadata">

**Author:** ![TotallyInformation](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/totallyinformation/32/31_2.png) [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Post date:** [5 March 2024 19:19 UTC](https://discourse.nodered.org/t/help-extract-data-from-object-json/86168/2 "2024-03-05T19:19:32Z")

</div>

Do you really want to create a custom node to do this? If not, could we please ask you to change the category to "general".

---

<div class="post-metadata">

**Author:** ![christopher-lambe](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/christopher-lambe/32/69369_2.png) [@christopher-lambe](https://discourse.nodered.org/u/christopher-lambe)\
**Post date:** [5 March 2024 19:42 UTC](https://discourse.nodered.org/t/help-extract-data-from-object-json/86168/3 "2024-03-05T19:42:55Z")

</div>

"An extra VolV" I assume you mean an extra VoltV.  
A Change Node with a jsonata expression will do the job.

`$$ ~> |payload.measurs|{"VoltV2": voltV}|`  
You can play with it here. As the test on the JSONata expression editor does not allow

> **[JSONata Playground - Get familiar with the JSONata language](https://www.stedi.com/jsonata/playground?statev2=eJylkztrwzAQgP%2BKERmNOb3tDoUshW6FQjrEGUQqSCC1jOT0QZT%2B9kqOwXGrJpTeYk73yedP1i2XyJm9XWuUI%2F3eWu3c1jQhUR48Ds9DjVr1sTPquUY32aFusiFq5LTdql1crtEcpBSiRvk58KKV21sXieW4HuMwTU94u1FO3%2Fd9IE8Br2bXLWKZEJoE1ntrddPNe6YAWiap1rxp%2BxQZKtjvxJ1ad8b2X1OUAFUfwAQlXE43HfO%2F2eFrdrygEIICx5LLtMXUFQO54srwBWLiKqrYHEvBSCVZ9T%2FXdNPRleICx4MVFSsJI2n83BUKQS78td61TN%2BfH6qci9i7xAwo5VB%2BUx3T1eRed6Z7GHtxMSlqa4191I0bmpxq4V3HME2zWfZ5m%2FlhoophQHwYskU8ERJ39Gdz9IE2nnjqGVrliKPVFx8o3dY%3D)**
>
> Get familiar with JSONata syntax in Stedi's playground where you can quickly edit, share, and embed examples.

```auto
[{"id":"1c99cc328f943a7f","type":"function","z":"66277e057a573726","name":"function 12","func":"msg = {\"topic\":\"energy_measurs\",\"payload\":{\"serial\":\"A07766\",\"measurs\":[{\"phaseId\":0,\"voltV\":223,\"currentA\":2.038,\"powerW\":364,\"powerFactor\":0.8009999990463257},{\"phaseId\":1,\"voltV\":225.3000030517578,\"currentA\":2.102,\"powerW\":412,\"powerFactor\":0.8690000176429749},{\"phaseId\":2,\"voltV\":231.1999969482422,\"currentA\":0.624,\"powerW\":80,\"powerFactor\":0.5569999814033508}],\"totPowerW\":856,\"errorSensor\":0}}\nreturn msg;","outputs":1,"timeout":0,"noerr":0,"initialize":"","finalize":"","libs":[],"x":370,"y":760,"wires":[["b970d4c17e6a7fc7"]]},{"id":"f3804042146bfa36","type":"inject","z":"66277e057a573726","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":160,"y":760,"wires":[["1c99cc328f943a7f"]]},{"id":"223c3c71312ca5da","type":"debug","z":"66277e057a573726","name":"debug 92","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":760,"y":760,"wires":[]},{"id":"b970d4c17e6a7fc7","type":"change","z":"66277e057a573726","name":"","rules":[{"t":"set","p":"payload","pt":"msg","to":"$$ ~> |payload.measurs|{\"VoltV2\": voltV}|","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":580,"y":760,"wires":[["223c3c71312ca5da"]]}]

```

---

<div class="post-metadata">

**Author:** ![maury77](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/maury77/32/48205_2.png) [@maury77](https://discourse.nodered.org/u/maury77)\
**Post date:** [5 March 2024 20:38 UTC](https://discourse.nodered.org/t/help-extract-data-from-object-json/86168/4 "2024-03-05T20:38:19Z")

</div>

Sorry for my English.

I need to extract the tree value of Volts to create 3 sensor from array of json message

---

<div class="post-metadata">

**Author:** ![christopher-lambe](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/christopher-lambe/32/69369_2.png) [@christopher-lambe](https://discourse.nodered.org/u/christopher-lambe)\
**Post date:** [5 March 2024 20:47 UTC](https://discourse.nodered.org/t/help-extract-data-from-object-json/86168/5 "2024-03-05T20:47:10Z")

</div>

Change Node \> Set msg.voltV0 = payload.measurs[0].voltV

Same for the rest  
payload.measurs[1].voltV  
payload.measurs[2].voltV

The "Copy path" button in the debug window is your friend

---

<div class="post-metadata">

**Author:** ![maury77](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/maury77/32/48205_2.png) [@maury77](https://discourse.nodered.org/u/maury77)\
**Post date:** [6 March 2024 16:09 UTC](https://discourse.nodered.org/t/help-extract-data-from-object-json/86168/6 "2024-03-06T16:09:44Z")

</div>

Thanks perfect!!!!

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [5 May 2024 16:10 UTC](https://discourse.nodered.org/t/help-extract-data-from-object-json/86168/7 "2024-05-05T16:10:23Z")

</div>

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