XML to SQL database import

Nodes

fc075733-bb58-455a-b659-2f01823422732e3e39e3-0e17-4fae-9ac5-9ee31f9711edc26ee7ea-e01b-42ad-8f48-355916f8914c

Created by

n8n8n Team

Last edited 38 days ago

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

New to n8n?

Need help building new n8n workflows? Process automation for you or your company will save you time and money, and it's completely free!