# Convert some JSON

**URL:** <https://discourse.nodered.org/t/convert-some-json/634>\
**Category:** General\
**Created:** [6 June 2018 09:39 UTC](https://discourse.nodered.org/t/convert-some-json/634 "2018-06-06T09:39:32Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![grawsom](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/grawsom/32/53070_2.png) [@grawsom](https://discourse.nodered.org/u/grawsom)\
**Post date:** [6 June 2018 09:39 UTC](https://discourse.nodered.org/t/convert-some-json/634/1 "2018-06-06T09:39:32Z")

</div>

Are trying to change the output of a JSON code, but are stuck in how to do a loop for it.  
I can do this with value directly - “se my ex.”

Change from

```auto
[{"Name":"name1","Number":1},{"Name":"name2","Number":2},{"Name":"name3","Number":3}]

```

to.

```auto
[{"name1":1},{"name2":2},{"name3":3}]

```

`[{"id":"7efc616b.54223","type":"debug","z":"fdf95545.a593b8","name":"Output","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","x":790,"y":360,"wires":[]},{"id":"c97aa65f.22c208","type":"function","z":"fdf95545.a593b8","name":"","func":"var value = msg.payload[0].Name;\nvar type = msg.payload[0].Number;\n\nmsg.payload = \"{\"+value+\":\"+type+\"}\";\n\nreturn msg;\n","outputs":1,"noerr":0,"x":470,"y":360,"wires":[["7efc616b.54223"]]},{"id":"beeae646.c3bed","type":"inject","z":"fdf95545.a593b8","name":"","topic":"","payload":"[{\"Name\":\"name1\",\"Number\":1},{\"Name\":\"name2\",\"Number\":2},{\"Name\":\"name3\",\"Number\":3}]","payloadType":"json","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":150,"y":360,"wires":[["c97aa65f.22c208"]]}]`

---

<div class="post-metadata">

**Author:** ![knolleary](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/knolleary/32/3_2.png) [@knolleary](https://discourse.nodered.org/u/knolleary)\
**Post date:** [6 June 2018 09:51 UTC](https://discourse.nodered.org/t/convert-some-json/634/2 "2018-06-06T09:51:23Z")

</div>

You can use a JSONata expression in a Change - very similar to the one I gave you yesterday:

 ![Local_Node-RED](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/e67bee261b72ad9f09f0900af2b9e3e23456383d.png)

```
$.payload.{$.Name:$.Number}
```

---

<div class="post-metadata">

**Author:** ![grawsom](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/grawsom/32/53070_2.png) [@grawsom](https://discourse.nodered.org/u/grawsom)\
**Post date:** [6 June 2018 10:11 UTC](https://discourse.nodered.org/t/convert-some-json/634/3 "2018-06-06T10:11:57Z")

</div>

Your the man - oh my … how easy it is when the right person shows it…