# Node red convert string to fields

**URL:** <https://discourse.nodered.org/t/node-red-convert-string-to-fields/5485>\
**Category:** General\
**Created:** [4 December 2018 22:56 UTC](https://discourse.nodered.org/t/node-red-convert-string-to-fields/5485 "2018-12-04T22:56:15Z")\
**Posts on this page:** 15\
**Page:** 1

<div class="post-metadata">

**Author:** ![yoyo89](https://avatars.discourse-cdn.com/v4/letter/y/f04885/32.png) [@yoyo89](https://discourse.nodered.org/u/yoyo89)\
**Post date:** [4 December 2018 22:56 UTC](https://discourse.nodered.org/t/node-red-convert-string-to-fields/5485/1 "2018-12-04T22:56:15Z")

</div>

Hello i want a way to convert my string data into Json fields where they can be read by things speak

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/7/745f7d6f18916d7f453302ef2e714545b6baa580.png)

---

<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:** [4 December 2018 23:20 UTC](https://discourse.nodered.org/t/node-red-convert-string-to-fields/5485/2 "2018-12-04T23:20:40Z")

</div>

maybe the json node 😉

---

<div class="post-metadata">

**Author:** ![yoyo89](https://avatars.discourse-cdn.com/v4/letter/y/f04885/32.png) [@yoyo89](https://discourse.nodered.org/u/yoyo89)\
**Post date:** [4 December 2018 23:22 UTC](https://discourse.nodered.org/t/node-red-convert-string-to-fields/5485/3 "2018-12-04T23:22:34Z")

</div>

when i do that i get this error

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

---

<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:** [4 December 2018 23:25 UTC](https://discourse.nodered.org/t/node-red-convert-string-to-fields/5485/4 "2018-12-04T23:25:08Z")

</div>

before the split ?

---

<div class="post-metadata">

**Author:** ![yoyo89](https://avatars.discourse-cdn.com/v4/letter/y/f04885/32.png) [@yoyo89](https://discourse.nodered.org/u/yoyo89)\
**Post date:** [4 December 2018 23:27 UTC](https://discourse.nodered.org/t/node-red-convert-string-to-fields/5485/5 "2018-12-04T23:27:54Z")

</div>

same things

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/f/fa54e48cf009cc01097019bd1da09bdcc57b2440.png)

---

<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:** [4 December 2018 23:30 UTC](https://discourse.nodered.org/t/node-red-convert-string-to-fields/5485/6 "2018-12-04T23:30:05Z")

</div>

so what is going into the split ? What is the split actually splitting up ? is that a string ? can you just paste that string ?

---

<div class="post-metadata">

**Author:** ![yoyo89](https://avatars.discourse-cdn.com/v4/letter/y/f04885/32.png) [@yoyo89](https://discourse.nodered.org/u/yoyo89)\
**Post date:** [4 December 2018 23:32 UTC](https://discourse.nodered.org/t/node-red-convert-string-to-fields/5485/7 "2018-12-04T23:32:28Z")

</div>

before splitting is this ,the decrypt payload is just to decrypt the binary array

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/5/56b78b7b7707451370cf393e4e8c1cac87fb6937.png)

---

<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:** [4 December 2018 23:32 UTC](https://discourse.nodered.org/t/node-red-convert-string-to-fields/5485/8 "2018-12-04T23:32:42Z")

</div>

But no matter - a function after the split like this - should do it (instead of the json node)

```auto
var m = msg.payload.split(':');
msg.payload = {};
msg.payload[m[0]] = m[1];
return msg;

```

---

<div class="post-metadata">

**Author:** ![yoyo89](https://avatars.discourse-cdn.com/v4/letter/y/f04885/32.png) [@yoyo89](https://discourse.nodered.org/u/yoyo89)\
**Post date:** [4 December 2018 23:37 UTC](https://discourse.nodered.org/t/node-red-convert-string-to-fields/5485/9 "2018-12-04T23:37:04Z")

</div>

thank you i appreciate it now i have like that but i cant get any entries in the thingspeak using thingspeak42

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/c/cf4c1300273f95ff51e794d4b5799d6eaa5117f7.png)

---

<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:** [4 December 2018 23:39 UTC](https://discourse.nodered.org/t/node-red-convert-string-to-fields/5485/10 "2018-12-04T23:39:21Z")

</div>

No idea - never used that node - - looks like it is actually asking for topics with values not an object ... so I'd guess maybe this instead...

```auto
var m = msg.payload.split(':');
msg.topic = m[0];
msg.payload = m[1];
return msg;

```

but I've never used it - so you'll have to read their docs.

---

<div class="post-metadata">

**Author:** ![yoyo89](https://avatars.discourse-cdn.com/v4/letter/y/f04885/32.png) [@yoyo89](https://discourse.nodered.org/u/yoyo89)\
**Post date:** [4 December 2018 23:48 UTC](https://discourse.nodered.org/t/node-red-convert-string-to-fields/5485/11 "2018-12-04T23:48:27Z")

</div>

thank you very much

---

<div class="post-metadata">

**Author:** ![yoyo89](https://avatars.discourse-cdn.com/v4/letter/y/f04885/32.png) [@yoyo89](https://discourse.nodered.org/u/yoyo89)\
**Post date:** [4 December 2018 23:49 UTC](https://discourse.nodered.org/t/node-red-convert-string-to-fields/5485/12 "2018-12-04T23:49:42Z")

</div>

now at least has data queuing but am getting this error

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

---

<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:** [4 December 2018 23:51 UTC](https://discourse.nodered.org/t/node-red-convert-string-to-fields/5485/13 "2018-12-04T23:51:49Z")

</div>

Lookup http error 400. I think it means not allowed (is bad credentials)

---

<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:** [4 December 2018 23:52 UTC](https://discourse.nodered.org/t/node-red-convert-string-to-fields/5485/14 "2018-12-04T23:52:27Z")

</div>

400 (Bad request) The server didn't understand the syntax of the request.

---

<div class="post-metadata">

**Author:** ![yoyo89](https://avatars.discourse-cdn.com/v4/letter/y/f04885/32.png) [@yoyo89](https://discourse.nodered.org/u/yoyo89)\
**Post date:** [4 December 2018 23:55 UTC](https://discourse.nodered.org/t/node-red-convert-string-to-fields/5485/15 "2018-12-04T23:55:39Z")

</div>

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/4/4854c4504c2c8ec01e603ce9bde8d3cfbb568e84.png) i put all credential right i looked it up there is no solution