{
  "name": "Xml to SQL database import",
  "nodes": [
    {
      "id": "19a81ae3-6ef6-46b0-aaa7-2ddcad1c86cb",
      "name": "When clicking \"Execute Workflow\"",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        700,
        360
      ]
    },
    {
      "id": "495356fb-8132-40c2-bfd8-559cd1a03bf8",
      "name": "Read Binary Files",
      "type": "n8n-nodes-base.readBinaryFiles",
      "position": [
        900,
        360
      ]
    },
    {
      "id": "9c88e06c-66be-4f62-a30e-811171fec34b",
      "name": "Item Lists",
      "type": "n8n-nodes-base.itemLists",
      "position": [
        1500,
        360
      ]
    },
    {
      "id": "a8aeb5c8-bb7a-4990-8a07-565c2d9e2760",
      "name": "Extract binary data",
      "type": "n8n-nodes-base.code",
      "position": [
        1100,
        360
      ]
    },
    {
      "id": "7a37802d-e0b7-4520-8832-8d43fa5815a0",
      "name": "XML to JSON",
      "type": "n8n-nodes-base.xml",
      "position": [
        1300,
        360
      ]
    },
    {
      "id": "e5bca22c-7941-46d0-ba2d-d375cb4735c9",
      "name": "Add new records",
      "type": "n8n-nodes-base.mySql",
      "position": [
        1700,
        360
      ]
    },
    {
      "id": "b787244f-aebf-4ec7-ba84-4b9409e30817",
      "name": "Create new table",
      "type": "n8n-nodes-base.mySql",
      "position": [
        900,
        80
      ]
    },
    {
      "id": "49b8214d-bc98-441c-847d-158a35c6fefa",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        720,
        -40
      ],
      "parameters": {
        "width": 503,
        "height": 317,
        "content": "### Activate and execute this node only when needed.\nCREATE TABLE IF NOT EXISTS new_table AS SELECT * FROM products;\nTRUNCATE new_table;"
      }
    },
    {
      "id": "28533467-5e12-4f7c-9310-8c88708bcff9",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        680,
        560
      ],
      "parameters": {
        "width": 553.5746606334839,
        "height": 268.9366515837105,
        "content": "## This is a content of the example XML file.\n### Please use it if the file was not already created\n\n<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"yes\"?>\n<Products>\n  <Product Price=\"69.26\" Code=\"S"
      }
    }
  ],
  "connections": {
    "Item Lists": {
      "main": [
        [
          {
            "node": "Add new records",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "XML to JSON": {
      "main": [
        [
          {
            "node": "Item Lists",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Read Binary Files": {
      "main": [
        [
          {
            "node": "Extract binary data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract binary data": {
      "main": [
        [
          {
            "node": "XML to JSON",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking \"Execute Workflow\"": {
      "main": [
        [
          {
            "node": "Read Binary Files",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}