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]

So a few things..... Firstly, awsome you are doing ADSB stuff in Node-RED. I do a lot of aircraft tracking 'stuff' in Node-RED. Secondly, whats the error you are getting? Its helpful that you show what you are doing, but you don't show the error you are getting. Looking at your insert statement y…

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.

Put a debug node (set to display the Complete msg object) on the output of the second split node so you can see the complete sql statement.

Thanks zenofmud. Here's what I've got so far. I've tried playing around with the outputs and still not getting data entry into the postgres fields. I've attached the screenshots for the complete message. The "mydb" node allows you to craft the sql inside the node, vs having to pass it to the node. I…

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 mention…

[image] gooroo: The "mydb" node allows you to craft the sql inside the node, vs having to pass it to the node What is the exact node you are using? i.e. node-red-contrib-?????

@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.

Awesome. Thanks for following up and letting us know you got it working and what you did. Great for the community to see the problem and solution.

Node-RED

Node-RED Forum

INSERT msg.payload.object into postgres table

General

Topic		Replies	Views
How insert msg.payload in Postgrestor node? General	2	1473	5 May 2021
Node-RED Postgres @open-kappa/node-red-contrib-mydb General	9	1132	1 July 2020
Node-red + postgres General	7	2538	9 March 2020
Node Red to Postgres (closed - duplicate) General node-red-dashboard , database , mqtt	1	264	3 March 2023
Create data in postgres General	15	578	8 October 2021

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

INSERT msg.payload.object into postgres table

Related topics