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 5 June 2020 00:30 3

Not getting an error message per se...mainly it’s just not inserting anything in the field...it create a new row, which is good....just there is a blank entry in the icao field, not null, just empty. I’ll try populating a varchar(45) datatype and see what happens.

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