Evening all, I hate to do it but I've exhausted my google, forum, and phone-a-friend resources. Flow Description: poll a http endpoint which returns a json string, and push that into a postgres table. [Capture] [Capture1] [Capture2] I just can't get the variable to insert into a text field i…

Got it to work...Using the template node I had to make the sql query, then use the function query to build the full message that has to get passed to the postgres node. Thanks all for your help. [Capture8] [Capture9] [Capture10]

INSERT msg.payload.object into postgres table

General

Steve-Mcl 7 June 2020 15:18 6

I don't know that db node but I doubt the format is correct. (I.e you've written js like syntax but I highly doubt it will evaluate the string concatenation with msg.payload)

Try putting a function node before the SQL node and build the SQL and pass it in.

Alternatively - perhaps that node mentions mustache format in its help info?

Topic		Replies	Views
Msg.payload data writing to Postgres General	16	3009	25 April 2020
Newbie - msg.payload into SQL General	7	2187	13 December 2019
Node-RED Postgres @open-kappa/node-red-contrib-mydb General	10	962	30 August 2020
Using mysql node but no joy with insert query General	7	1718	29 August 2020
Need help - Syntax MSSQL Insert Statement from a msg.payload General	3	492	9 December 2019

INSERT msg.payload.object into postgres table

Related Topics