MySQL NODE-RED table

General
23

Hi @smalhao

as you have changed the Join node to generate a key/value object, the msg.payload[0] way of accessing its properties is no longer the right way to do it.

This page in the docs explains how you can use the Debug sidebar to identify how to access different parts of a message: https://nodered.org/docs/user-guide/messages

If you look at the Debug message, you can see msg.payload is no longer an array, but an Object. It has three properties:

{
   "ns=2;s=LM35": 23.0550....,
   "ns=2;s=SensorIndutivo": 7514.689.....,
   "ns=2;s=LM335": 22.2104...
}

So you would access those properties as:

msg.payload["ns=2;s=LM35"]
msg.payload["ns=2;s=SensorIndutivo"]
msg.payload["ns=2;s=LM335"]

in your Function node, in place of msg.payload[0], msg.payload[1] and msg.payload[2].