Organize values in SQL

Hello

{"payload":{"TT1914.Val":33.463035583496094,"TT25011.Val":27.10765266418457,"FT_Torre":-996},"_msgid":"da09e59a60c864b6"}

The line before is the msg topic and payload i got from a eth node and need to add the 3 values into a table in sql one value for each column, I have the sql node already configured but do not know how to insert the values in separated columns.

Could you please help me?

Regards

Kefre

We will need a lot more info to help you.

What does the SQL node built in help say?

Does the SQL node have demo flows in its readme?

Maybe it has built in example flows in CTRL-I → Examples → SQL Node?


Ok, more importantly...

  • What version of Node-RED and NodeJS are you running?
  • Is it installed on docker/home assistant or regular install?
  • What SQL node are you actually using node-red-contrib-xxxxx?
  • What have you tried so far & where are you stuck?