Retrieve and Convert Random Products Data to XML

• Generate XML feeds for product listings from a MySQL database.
• Serve dynamic product data to web applications in XML format.
• Integrate random product selection functionality for promotional campaigns.

Webhook triggers the workflow upon receiving a request. MySQL node fetches 16 random products from the database. Data is structured using a set node to define the file format. Items are concatenated into a single XML structure. The XML is converted to a binary format for response delivery. Final response is sent back to the webhook with the XML data.

1. 1
   Import the workflow template into your n8n instance.
2. 2
   Configure the MySQL credentials to connect to your database.
3. 3
   Set the webhook URL to receive incoming requests.
4. 4
   Test the workflow by sending a request to the webhook.