Create 2 XML files: with and without XML attributes
Needs changesNeeds changes. This template uses 3 thing(s) that n8n 3.0 removes: Item Lists (legacy), Convert to/from binary data, Write Binary File. 3 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 11 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”.
- Show 16 random products (MySQL): run a query
- Define file structure (Edit Fields (Set)): sets or maps fields
- Define file structure (Edit Fields (Set)): sets or maps fields
- Concatenate Items (Item Lists): reshapes item lists (legacy Item Lists node)
- Concatenate Items (Item Lists): reshapes item lists (legacy Item Lists node)
- Convert to XML (XML): converts between XML and JSON
- Convert to XML (XML): converts between XML and JSON
- Move Binary Data (Convert to/from binary data): uses Convert to/from binary data
- Move Binary Data (Convert to/from binary data): uses Convert to/from binary data
- Write Binary File: uses Write Binary File
Services it uses
Before you upgrade to n8n 3.0
3 things in this workflow are removed in n8n 3.0. Fix them before you upgrade:
- Item Lists (legacy) in Concatenate Items, Concatenate Items1: replace with Split Out, Aggregate, Sort, Limit, Remove Duplicates or Summarize (match the operation used).
- Convert to/from binary data in Move Binary Data, Move Binary Data1: replace with Convert to File or Extract from File.
- Write Binary File: replace with Read/Write Files from Disk.
| Removed in 3.0 | Replace with |
|---|---|
| Item Lists (legacy) Concatenate Items, Concatenate Items1 | Split Out, Aggregate, Sort, Limit, Remove Duplicates or Summarize (match the operation used) |
| Convert to/from binary data Move Binary Data, Move Binary Data1 | Convert to File or Extract from File |
| Write Binary File Write Binary File | Read/Write Files from Disk |
Nodes used (7)
- Manual Trigger
n8n-nodes-base.manualTrigger - MySQL
n8n-nodes-base.mySql - Edit Fields (Set)
n8n-nodes-base.set - Item Lists
n8n-nodes-base.itemLists - XML
n8n-nodes-base.xml - Convert to/from binary data
n8n-nodes-base.moveBinaryData - Write Binary File
n8n-nodes-base.writeBinaryFile
From the author
This workflow demonstrates two ways of exporting data from SQL to XML. First, several random records are received from the MySQL database. Then, in the upper part of the workflow, the structure of an XML is defined in the Set node. After that, the ItemLists…