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]

system Closed 21 June 2020 19:50 11

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
How insert msg.payload in Postgrestor node? General	3	1301	5 May 2021
Node-RED Postgres @open-kappa/node-red-contrib-mydb General	10	1073	30 August 2020
Node-red + postgres General	8	2489	8 May 2020
Node Red to Postgres (closed - duplicate) General node-red-dashboard , database , mqtt	2	237	3 March 2023
Create data in postgres General	15	503	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