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]

zenofmud 7 June 2020 16:07 7

What is the exact node you are using? i.e. node-red-contrib-?????

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

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