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…

INSERT msg.payload.object into postgres table

gooroo 7 June 2020 19:40 9

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.

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