Converting XML to JSON

This task will automatically convert an XML file to an equivalent JSON format.

Settings

Omit Root Object

Optional
Set to true to ignore the root element of the XML file when converting to JSON.

Input File

Required
An absolute or relative file path on the local computer or network to the file containing the JSON to convert.

See the Zynk Objects if you require more information on how the Zynk Object file value works.

This will be defaulted to the 'Output from the previous task'

Output File

Required
An absolute or relative file path on the local computer or network to save the converted XML file to.

See the Zynk Objects article if you require more information on how the Zynk Object file value works.

This will be defaulted to xml_to_json.json in the current working directory.

Zynk Settings

See Common Task Settings

Examples

You can find an example of how to use this task in the Converting JSON files to XML article.

Sample input file:

<Customers>
  <Customer>
    <firstName>John</firstName>
    <lastName>Smith</lastName>
    <age>25</age>
    <address>
      <streetAddress>21 2nd Street</streetAddress>
      <city>New York</city>
      <state>NY</state>
      <postalCode>10021</postalCode>
    </address>
    <phoneNumber>
      <type>home</type>
      <number>212 555-1234</number>
    </phoneNumber>
    <phoneNumber>
      <type>fax</type>
      <number>646 555-4567</number>
    </phoneNumber>
  </Customer>
  <Customer>
    <firstName>Joe</firstName>
    <lastName>Bloggs</lastName>
    <age>32</age>
    <address>
      <streetAddress>Nelson House</streetAddress>
      <city>Jesmond</city>
      <state>Tyne & Wear</state>
      <postalCode>NE2 3AE</postalCode>
    </address>
    <phoneNumber>
      <type>home</type>
      <number>212 555-1234</number>
    </phoneNumber>
    <phoneNumber>
      <type>fax</type>
      <number>646 555-4567</number>
    </phoneNumber>
  </Customer>
</Customers>

Sample output file (when Omit Root Object is set to true):

{
    "Customer": [
    {
        "firstName": "John",
        "lastName": "Smith",
        "age": "25",
        "address": {
        "streetAddress": "21 2nd Street",
        "city": "New York",
        "state": "NY",
        "postalCode": "10021"
        },
        "phoneNumber": [
        {
            "type": "home",
            "number": "212 555-1234"
        },
        {
            "type": "fax",
            "number": "646 555-4567"
        }
        ]
    },
    {
        "firstName": "Joe",
        "lastName": "Bloggs",
        "age": "32",
        "address": {
        "streetAddress": "Nelson House",
        "city": "Jesmond",
        "state": "Tyne & Wear",
        "postalCode": "NE2 3AE"
        },
        "phoneNumber": [
        {
            "type": "home",
            "number": "212 555-1234"
        },
        {
            "type": "fax",
            "number": "646 555-4567"
        }
        ]
    }
    ]
}