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 this workflow does
This workflow has 7 nodes and runs manually, when you click “Execute workflow”. Along the way it connects MySQL.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Read Binary Files: uses Read Binary Files
- Extract binary data (Code): runs custom JavaScript code
- XML: converts between XML and JSON
- Item Lists: reshapes item lists (legacy Item Lists node)
- Add new records (MySQL): uses MySQL
- Create new table (MySQL): run a query
Services it uses
Before you upgrade to n8n 3.0
2 things in this workflow are removed in n8n 3.0. Fix them before you upgrade:
- Read Binary Files: replace with Read/Write Files from Disk.
- Item Lists (legacy) in Item Lists: replace with Split Out, Aggregate, Sort, Limit, Remove Duplicates or Summarize (match the operation used).
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| 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
From the author
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…