How to extract data from mysql node response?

Node-Red version : 1.0.6
I want to extract some data from DataBase MySQL response to do some other operation !

[{"id":"b3dfdc6d.e7775","type":"function","z":"ccdfe680.e48b48","name":"Get data","func":"msg.topic = msg.payload.Press\nreturn msg;","outputs":1,"noerr":0,"x":980,"y":280,"wires":[["6a5c8fa2.8bd9d"]]}]

Extract it to where?

There’s a great page in the docs that will explain how to use the debug panel to find the right path to any data item.

Thanks Steve-Mcl,

When I ask it here is because I already read this link and made a hundred attempts without success, the idea is to be able to access directly the data like 'Press'.


What do you see when you use Copy Path from the debug pane as explained in that link?

Hover your mouse pointer over "press" in the debug panel. Do you see some buttons appear?

It is clearly documented and demonstrated in that link.

I tried but didn't work!

Yes I tried it 'copy path' but nothing!
Maybe the object does not have a name that's why it did not work

what happens if you copy path then open a text editor (notepad) and paste.

The item most certainly does have a name.

edit - its becoming clear you are quite unfamiliar with many of the very basic parts of node-red.

do yourself a favour (and us :wink: ) watch this playlist: Node-RED Essentials. The videos are done by the developers of node-red. They're nice & short and to the point. You will understand a whole lot more in about 1 hour. A small investment for a lot of gain.

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.