XML to JSON Converter
[ | 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 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.