FM
FlowMarket
Database & SQL Intermediate ⚡ 13 n8n Nodes

Create 2 XML files with and without XML attributes

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...

🔌 Nodes & Integrations Used (5)

My Sql Item Lists Xml Move Binary Data Write Binary File

📖 Implementation & Setup Guide

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 node combines all items into an array. This allows an XML node to create a simple XML file.

The lower part of the workflow shows how to create an XML with attributes. It is almost identical except that a $ (dollar sign) JSON key is used to define XML attributes.

Finally, both files are saved locally.

⚡ How to import this workflow into n8n:

  1. Click the Direct Download JSON button above to save Create 2 XML files_ with and without XML attributes.json.
  2. Log in to your n8n Cloud or self-hosted n8n instance.
  3. In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
  4. Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
  5. Click Execute Workflow to test and switch to Active!

Related Database & SQL Workflows

View All in Database & SQL →