# JSON string to CSV - string

**URL:** <https://discourse.nodered.org/t/json-string-to-csv-string/1907>\
**Category:** General\
**Created:** [30 July 2018 19:50 UTC](https://discourse.nodered.org/t/json-string-to-csv-string/1907 "2018-07-30T19:50:28Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![rbauwens3263](https://avatars.discourse-cdn.com/v4/letter/r/d07c76/32.png) [@rbauwens3263](https://discourse.nodered.org/u/rbauwens3263)\
**Post date:** [30 July 2018 19:50 UTC](https://discourse.nodered.org/t/json-string-to-csv-string/1907/1 "2018-07-30T19:50:28Z")

</div>

Hello All ,

I am new to Node-red - i am having a issue to get json to csv , tried the node json2csv but don't get it to work.

Main goal is to get via insert Node a json string and then translate it into a csv string,

Can anybody give help ?

Roland

---

<div class="post-metadata">

**Author:** ![dceejay](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dceejay/32/38_2.png) [@dceejay](https://discourse.nodered.org/u/dceejay)\
**Post date:** [30 July 2018 20:08 UTC](https://discourse.nodered.org/t/json-string-to-csv-string/1907/2 "2018-07-30T20:08:16Z")

</div>

Did you try the built in csv node. It converts csv to a json object and from an object to csv. So if you start with a json string use a json node to convert from string to an object then the csv node to go from an object to csv.

---

<div class="post-metadata">

**Author:** ![rbauwens3263](https://avatars.discourse-cdn.com/v4/letter/r/d07c76/32.png) [@rbauwens3263](https://discourse.nodered.org/u/rbauwens3263)\
**Post date:** [31 July 2018 18:36 UTC](https://discourse.nodered.org/t/json-string-to-csv-string/1907/3 "2018-07-31T18:36:04Z")

</div>

Hi dceejay , i tried your suggestion and got this working , thanks !

---

<div class="post-metadata">

**Author:** ![rbauwens3263](https://avatars.discourse-cdn.com/v4/letter/r/d07c76/32.png) [@rbauwens3263](https://discourse.nodered.org/u/rbauwens3263)\
**Post date:** [31 July 2018 18:37 UTC](https://discourse.nodered.org/t/json-string-to-csv-string/1907/4 "2018-07-31T18:37:38Z")

</div>

I am trying to get a timestamp in the injection node with de following example json payload : {"abc":12345678,"defc":453478} - any suggestion ?

---

<div class="post-metadata">

**Author:** ![zenofmud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zenofmud/32/316_2.png) [@zenofmud](https://discourse.nodered.org/u/zenofmud)\
**Post date:** [31 July 2018 18:55 UTC](https://discourse.nodered.org/t/json-string-to-csv-string/1907/5 "2018-07-31T18:55:26Z")

</div>

Can you explain your issue differently? I don’t understand what mean. Where is that data coming from?

Maybe showing your flow

---

<div class="post-metadata">

**Author:** ![ukmoose](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ukmoose/32/13_2.png) [@ukmoose](https://discourse.nodered.org/u/ukmoose)\
**Post date:** [31 July 2018 18:57 UTC](https://discourse.nodered.org/t/json-string-to-csv-string/1907/6 "2018-07-31T18:57:56Z")

</div>

If you are trying to INJECT a message with that then you can do it with a change node.

BUT check what the CSV node will convert. My guess is that it will convert the msg.payload to CSV so you would need to make msg.payload = {"abc":12345678,"defc":453478};