Xml to SQL database import
Needs changesNeeds changes. This template uses 2 thing(s) that n8n 3.0 removes: Read Binary Files, Item Lists (legacy). 2 breaking item(s) found. Static check, last run 2026-10-19.
What to replace before upgrading
| Removed in 3.0 | Replace with |
|---|---|
| Read Binary Files Read Binary Files | Read/Write Files from Disk |
| Item Lists (legacy) Item Lists | Split Out, Aggregate, Sort, Limit, Remove Duplicates or Summarize (match the operation used) |
Nodes used (6)
- Manual Trigger
n8n-nodes-base.manualTrigger - Read Binary Files
n8n-nodes-base.readBinaryFiles - Item Lists
n8n-nodes-base.itemLists - Code
n8n-nodes-base.code - XML
n8n-nodes-base.xml - MySQL
n8n-nodes-base.mySql
What it does
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