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

gooroo 7 June 2020 16:17 8

@open-kappa/node-red-contrib-mydb but I'm about to switch....just was able to get the template node to craft the INSERT message appropriately, but working through the "DB" nodes syntax at the moment.

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

INSERT msg.payload.object into postgres table

Related Topics