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]

thebaldgeek 7 June 2020 19:50 10

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.

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

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