Skip to content
background-image background-image

XML to JSON Connector

[ | version 3.1]

Connector

The connector is permitted for use of the platform background agent.

Connector processing type: Row by row!

XML (Extensible Markup Language) is the standardized language similar to HTML in which data can be stored, searched or exchanged with other systems. This connector transforms this format to JSON, another data-interchange format that is preferred by many REST APIs because it is more lightweight but still readable.

Example

Input data Text (ver. 1.0.0)

Text: String
<?xml version="1.0" standalone="no"?>
<root>
   <person id="1">
      <name>Alan</name>
      <url>http://www.google.com</url>
   </person>
   <person id="2">
      <name>Louis</name>
      <url>http://www.yahoo.com</url>
   </person>
</root>

Output data JSON (ver. 1.0.0)

JSON: JSON
{
    "?xml": {
        "@version": "1.0",
        "@standalone": "no"
    },
    "root": {
        "person": [
            {
                "@id": "1",
                "name": "Alan",
                "url": "http://www.google.com"
            },
            {
                "@id": "2",
                "name": "Louis",
                "url": "http://www.yahoo.com"
            }
        ]
    }
}

Input & Output Schema

Input

XML as plain text.

Text (ver. 1.0.0)

Column Data type Allow null Description
Text String No Converted plain text.

Output

JSON (ver. 1.0.0)

Column Data type Allow null Description
JSON JSON No Input/Output in JSON format

Release notes

3.1.4

  • Plugin binaries update as a result of included connector change.

3.1.3

  • Fixed shared nuget package versions.

3.1.2

  • Fixed right processing of nullable properties.