I am trying to store the output of a node-red-node-mysql mysql node into a flow Context variable to aid verification and debuging (I keep missing output in debug pane as they only occur every 10 minutes or so). But all it writes to the flow context is a string "[object Object]". [FlowCOntext resu…

I have seen this behaviour before (with another node) - and I believe it has to do with the way it returns the object (not sure what the exact issue was), could you try to enable 'deep copy value' ? edit found my own topic

[image] IanH: I keep missing output in debug pane as they only occur every 10 minutes or so You could use node-red-contrib-flogger so that you can go back and look at what happened, or just set the debug node to also output to the console, then you can look back through the node-red log to se…

[image] Colin: You could use node-red-contrib-flogger so that you can go back and look at what happened, or just set the debug node to also output to the console, then you can look back through the node-red log to see what happened. Thanks Colin, but I would still like to know why this behavi…

I don't see how those comments relate to my post.

Thanks for quick response, I have now tried 'deep Copy' and result is unchanged. I also resorted to a function node with this short code var DBResponse = {} DBResponse = msg.payload DBResponse.topic = msg.topic flow.set("LastDBRequest1", DBResponse); msg.payload = DBResponse return msg; The outpu…

hit wrong reply button. corrected now

Could you try: DBResponse = JSON.parse(JSON.stringify(msg.payload))

There is an open issue against it. This might also work: DBResponse = {...msg.payload}

thanks, good to hear it is a known issue

In Change Node, setting output of mySQL node to Flow.Context gives "[object Object]"

General

IanH 29 April 2024 10:36 9

Thanks BakMan, that appears to work in the function node. So for the mySQL node developers, they have a bug that impacts the output of the mySQL node very subtly they might want to look at.

Topic		Replies	Views
Change node not working as expected! General	30	1508	6 December 2021
Why debug node can only show 'msg' message? General	27	4913	5 July 2020
Pass S7 variable to Mysql query General	4	571	23 February 2021
Read from mysql db Dashboard	54	17580	23 December 2018
Get value from mysql in debug General database	8	265	5 December 2022

In Change Node, setting output of mySQL node to Flow.Context gives "[object Object]"

Related topics