Hello I am new with node red. Currently, I am working with node-red and mysql database for my final year project. I would like to send temperature data to the database but i have error stated that the array is undefined. [node-red] this is my node red flow.. and this is the function in mysql fun…

Hi, welcome to the forum. Unless you name your debug nodes it is difficult to tell from a picture. At a guess, msg.payload is a number BUT here... var test = msg.payload; var temp = test.temperature; msg.payload = [temp]; you are affectively saying "Set msg.payload to a new array [ ] and put ms…

if i want to add another column such as id from the node red together with the temperature data .. how should i write it? [form] [id]

if the data comes from different nodes, then you need to join the 2 bits of data together into 1 message/payload so that you can use them together in your insert query. See this article in the cookbook for an example of how to join messages into one object.

i have tried using join, but i still got an error [join] [edit join] this is the debug message: {"INSERT INTO temperature(temperature) VALUES (?)":[36.75],"INSERT INTO temperature(id) VALUES (?)":[{"id":1729336}]} how ever, the id is not updated in mysql. can you please help me.

dont put the object in the payload array - only put the value. e.g. msg.payload = [ msg.payload.id ]; or if you have 2 params then update your query and add the 2 params (use debug window as instructed below) const data = msg.payload; msg.payload = [data.id, data.temperature]; msg.topic = "INSE…

Node-RED

Node-RED Forum

How to pass payload data from node red to mysql

General

asyrahshah 30 December 2021 12:03 3

thank you.. i got it

Topic		Replies	Views
Post to sql from array General	16	2448	7 October 2019
MySQL NODE-RED table General	33	11713	8 February 2019
Node red value to mysql General	9	1956	19 July 2020
Mysql data logging General function-node	4	171	25 May 2023
How to access msg.payload array in mssql? General	10	2564	10 June 2020

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

How to pass payload data from node red to mysql

Related topics