Inserting a record in MySQL from a payload: Null values are being inserted in fields

General
1

Hi
I'm new to NodeRed. I am trying to insert a row in mysql table in a nodered function. In the inject node I have specified the values of each field and added to msg.payload. In the function node, I'm creating an Insert query and passing each field in the insert query.
When I run the flow, the row is created in the table without values in the fields. Any tutorial on the right way of doing it?

2

Put a debug (set to display the complete msg object) on the output of the function node and run an insert. Then open add the arrows in the debug output and paste it into a reply.

3

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.