Convert XML to MySQL using an API

After signing up and verifying your email, you will be able to create an API Token in your account settings.

Headers

• Authorization (required) Bearer <<YOUR_API_TOKEN_HERE>>

Request Body — (multipart/form-data)

• file (required) string <binary>

• uploadSettings

  object

  {
    "treeNodes" : [ {
      "name" : "book",
      "fieldName" : "book",
      "xpathExpression" : "/bookstore/book",
      "recordBreak" : true,
      "field" : false
    }, {
      "name" : "title",
      "fieldName" : "title",
      "xpathExpression" : "/bookstore/book/title",
      "recordBreak" : false,
      "field" : true
    }, {
      "name" : "@lang",
      "fieldName" : "lang",
      "xpathExpression" : "/bookstore/book/title/@lang",
      "recordBreak" : false,
      "field" : true
    }, {
      "name" : "price",
      "fieldName" : "price",
      "xpathExpression" : "/bookstore/book/price",
      "recordBreak" : false,
      "field" : true
    } ]
  }

• downloadSettings

  object

  {
    "tableName" : "bookstore",
    "pretty" : true,
    "dropTable" : true,
    "checkIfDropTableExists" : true,
    "checkIfTableNotExists" : true,
    "defaultBigIntegerPrecision" : 20,
    "defaultBigDecimalPrecision" : 20,
    "defaultBigDecimalScale" : 5,
    "useInferredType" : true,
    "sqlScriptType" : "DDL_AND_DML",
    "sqlInsertType" : "INSERT"
  }