Extract data from xml file and send data to mysql database with Node-RED
Budget: $30 – $250 USD
The project consists of making a program with Node-RED that can listen through a tcp port and receive a POST event. The received message is in xml format, the Tags of the xml file represent data that must be extracted, debugged and then sent to a database. Within the xml file, 2 images are also sent in encoded text format that must be extracted from the file, separated and sent to the db. The database should not be created, only the connector for sending.
Note: I already have a flow where I can receive the file and separate the values sent in the TAGs, I filter them and forward them to a mysql database, but I need to improve the program and extract the images that must also be saved in the database.
Attached I send an example of the content of the xml message that is received and from which the data must be extracted.
Note: I already have a flow where I can receive the file and separate the values sent in the TAGs, I filter them and forward them to a mysql database, but I need to improve the program and extract the images that must also be saved in the database.
Attached I send an example of the content of the xml message that is received and from which the data must be extracted.