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
Msg.payload data writing to Postgres General	16	3202	25 April 2020
Newbie - msg.payload into SQL General	7	2304	13 December 2019
Node-RED Postgres @open-kappa/node-red-contrib-mydb General	10	1064	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