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":[["6a5c…

[image] RMILIOussama: I want to extract some data from DataBase MySQL 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. https://nodered.org/docs/user-guide/messages

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'. Regards

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

[image] RMILIOussama: the idea is to be able to access directly the data like 'Press'. 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.

[image] RMILIOussama: Yes I tried it 'copy path' but nothing! what happens if you copy path then open a text editor (notepad) and paste. [image] RMILIOussama: Maybe the object does not have a name that's why it did not work The item most certainly does have a name. edit - its becomin…

Node-RED

Node-RED Forum

How to extract data from mysql node response?

General

RMILIOussama 26 March 2021 12:56 7

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

Topic		Replies	Views
Get value from mysql in debug General database	8	265	5 December 2022
How to extract a value General node-red-dashboard	13	419	26 January 2024
How to split msg.payload array data General	3	8438	16 June 2019
How to read specific value from Array General	11	7115	30 August 2022
Extracting a value from an MS-SQL database General database	9	968	2 May 2022

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.

How to extract data from mysql node response?

Related topics