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
Node-red + postgres General	8	2492	8 May 2020
Node-RED Postgres @open-kappa/node-red-contrib-mydb General	10	1075	30 August 2020
How insert msg.payload in Postgrestor node? General	3	1340	5 May 2021
Msg.payload data writing to Postgres General	16	3223	25 April 2020
Insert into PostgreSQL database General	44	11559	26 August 2020

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