Xml to SQL database import
Workflow preview
$20/month : Unlimited workflows
2500 executions/month
THE #1 IN WEB SCRAPING
Scrape any website without limits
HOSTINGER
Early Deal
DISCOUNT 20% Try free
DISCOUNT 20%
Self-hosted n8n
Unlimited workflows - from $4.99/mo
#1 hub for scraping, AI & automation
6000+ actors - $5 credits/mo
Important notice
This workflow is provided as-is. Please review and test before using in production.
Overview
This is an example workflow that imports an XML file into an SQL database.
- The ReadBinaryFiles node loads the XML file from the server.
- Then the Code node extracts the file content from the binary buffer.
- Afterwards, an XML node converts the XML string into a JSON structure.
- Finally, in the MySQL node inserts the data records into the SQL table.
In the upper part of the workflow there is another MySQL node that is disabled. This node creates a new table with all the required variables based on the sample SQL database: https://www.mysqltutorial.org/mysql-sample-database.aspx