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)
<?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)
{
"?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"
}
]
}
}
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.
July 29, 2024
Alena Toev, Boris Matejka, Radek Bednarik, Róbert Blažek