Arrays & Objects in Node-RED

[Ram]

Hi,

I've an output from one of my flow as shown below. I'm trying to get the objects Level, UnitNumber, Schools & Comfort as a single CSV file. How can I convert this array into a merged single output?

msg.payload : array[1]

array[1]

0: object

Level: array[1]

0: "Level 6"

UnitNumber: array[1]

0: "10"

Schools: array[1]

0: "Office A"

Comfort: array[1]

0: "Freezing"

[Mark Setrem]

As i suggested on the 23rd to one of your other "how do I reformat this" questions.  Some time reading a Javascript Arrays and Objects tutorial would be time well spend.

My personal favourite is https://www.w3schools.com/js/js_arrays.asp   

If you get stuck, post what you've managed to do here and I'm sure someone will help you correct it.

[Dj Jastrzębowski]

Could anyone help me and tell me how to put a variable instead of expressing the "sensor" in the code to accept the variable var

var sensor = msg.topic

var data = msg.payload;

msg.measurement = global.get ("temp");

msg.payload = [{

sensor: parseFloat(data),

}];

return msg;

 

[Dave C-J]

If it's always going to be an array you want then something like this

...

msg.payload = [];  // create an empty array

msg.payload[0][msg.topic] = parseFloat(data);

...

[Dave C-J]

ooops

missed a line

...

msg.payload = []; // create an empty array

msg.payload[0] = {};  // create an empty object as first item

msg.payload[0][session] = parseFloat(data);

...

[Colin Law]

What are you seeing in the payload for the first case?  It is no good saying it is not working unless you tell us what you are seeing and what you want it to be.

Colin

On 1 January 2018 at 16:47, Dj Jastrzębowski <dariuszjas...@gmail.com> wrote:

Thanks Dave,

I dont know not working :-(

var data = msg.payload;

var data1 = global.get ("variable1");

msg.measurement = global.get ("variable2");

msg.payload = []; // create an empty array

msg.payload[0] = {};  // create an empty object as first item

msg.payload[0][global.get ("casevariable")] = parseFloat(data);

return msg;

and try 

var data = msg.payload;

var data1 = global.get ("casevariable");

msg.measurement = global.get ("prodvariable1");

msg.payload = []; // create an empty array

msg.payload[0] = {};  // create an empty object as first item

msg.payload[0][(data1)] = parseFloat(data);

return msg;

Array return 

--
http://nodered.org
 
Join us on Slack to continue the conversation: http://nodered.org/slack
---
You received this message because you are subscribed to the Google Groups "Node-RED" group.
To unsubscribe from this group and stop receiving emails from it, send an email to node-red+unsubscribe@googlegroups.com.
To post to this group, send email to node...@googlegroups.com.
Visit this group at https://groups.google.com/group/node-red.
To view this discussion on the web, visit https://groups.google.com/d/msgid/node-red/c5453089-322f-47f9-8c26-472cc1dc3938%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

[Colin Law]

The second one doesn't work because you need a string, so msg.payload[0]["data1"].

Colin

On 1 January 2018 at 16:52, Colin Law <cla...@gmail.com> wrote:

What are you seeing in the payload for the first case?  It is no good saying it is not working unless you tell us what you are seeing and what you want it to be.

Colin

[Colin Law]

On 1 January 2018 at 16:54, Colin Law <cla...@gmail.com> wrote:

The second one doesn't work because you need a string, so msg.payload[0]["data1"].

Sorry, that is wrong for the second one, it should be msg.payload[0][data1] as data1 is already a string (presumably).

Colin

 

Colin

On 1 January 2018 at 16:52, Colin Law <cla...@gmail.com> wrote:

What are you seeing in the payload for the first case?  It is no good saying it is not working unless you tell us what you are seeing and what you want it to be.

Colin

[Dj Jastrzębowski]

I have global variables declared as text (to all Node-red) and payload input in to node function as value

variable1 - text with space (debug its is ok) the variable is well declared

variable2 - text need to send influxdatabase

msg.payload - numeric value 

var data = msg.payload;

var data1 = global.get ("variable1");

msg.measurement = global.get ("variable2");

msg.payload = []; // create an empty array

msg.payload[0] = {};  // create an empty object as first item

msg.payload[0][(data1)] = parseFloat(data);

return msg;

Output debug say 

 

[Colin Law]

You should not have the parentheses round data1, though I would not expect it to matter, but it should be, as I said earlier
msg.payload[0][data1] = parseFloat(data);


Put a line in above that with


node.warn("data1 is " + data1 + " type is " + typeof data1);


It will print that in the debug window so you can see what it says



Colin


--

http://nodered.org
 
Join us on Slack to continue the conversation: http://nodered.org/slack
---
You received this message because you are subscribed to the Google Groups "Node-RED" group.
To unsubscribe from this group and stop receiving emails from it, send an email to node-red+unsubscribe@googlegroups.com.
To post to this group, send email to node...@googlegroups.com.
Visit this group at https://groups.google.com/group/node-red.

To view this discussion on the web, visit https://groups.google.com/d/msgid/node-red/7858dedb-23e9-40b4-87f7-7697970b048e%40googlegroups.com.

[Dj Jastrzębowski]

Thank you for professional help

 

[Colin Law]

Glad to be of help, but it is certainly not professional. I retired 11 years ago.

Please tell us what the issue was so that others finding this (and us) may learn something.

Colin

On 1 January 2018 at 18:17, Dj Jastrzębowski <dariuszjas...@gmail.com> wrote:

Thank you for professional help

 

--

http://nodered.org
 
Join us on Slack to continue the conversation: http://nodered.org/slack
---
You received this message because you are subscribed to the Google Groups "Node-RED" group.
To unsubscribe from this group and stop receiving emails from it, send an email to node-red+unsubscribe@googlegroups.com.
To post to this group, send email to node...@googlegroups.com.
Visit this group at https://groups.google.com/group/node-red.

To view this discussion on the web, visit https://groups.google.com/d/msgid/node-red/f9d98674-8b0a-4d3a-a683-f68186ef0b7c%40googlegroups.com.

[Dj Jastrzębowski]

I have to admit there was something wrong with my variable declaration :-(

but it's ok with

[Colin Law]

Take the parentheses out round data1, in the future they will just confuse you, or someone else. You will wonder what subtle reason there was for including them.

Colin

--

http://nodered.org
 
Join us on Slack to continue the conversation: http://nodered.org/slack
---
You received this message because you are subscribed to the Google Groups "Node-RED" group.
To unsubscribe from this group and stop receiving emails from it, send an email to node-red+unsubscribe@googlegroups.com.
To post to this group, send email to node...@googlegroups.com.
Visit this group at https://groups.google.com/group/node-red.

To view this discussion on the web, visit https://groups.google.com/d/msgid/node-red/50b6eec6-3284-4add-936a-28a52aefecf3%40googlegroups.com.