XML to JSON Transformer
Discover more about the XML to JSON Transformer component and how to use it on the Digibee Integration Platform.
XML to JSON Transformer transforms an XML string into a JSON object.
Parameters
Take a look at the configuration options for the component. Parameters supported by Double Braces expressions are marked with (DB).
XML Field Path
Field path of the XML string to be transformed. This path representation must be made in dotted notation. If the field is a matrix, all the elements of this matrix will be run. You can specify multiple fields, separating them by comma.
body
String
Preserve Original
If the option is enabled, the original fields are preserved in the transformation result and, to differ the name of the transformed fields, the “_” character will be added in the beginning of the name of the original fields.
True
Boolean
With Namespace
If the option is enabled, the XML namespaces will be kept in the transformation result.
True
Boolean
Remove XML Attributes
If the option is enabled, the XML attributes will be hidden in the transformation result.
False
Boolean
All Values As String
If the option is enabled, all XML tag values will be transformed to string type.
False
Boolean
Messages flow
Input
The component doesn’t expect a specific input message, just the XML Field Path configuration parameter to be filled with a reference to the path of the field to be transformed. This field must exist in the message of the step prior to the XML to JSON Transformer execution.
Output
The structure will be the same as the one received in the previous step of the flow, but the fields informed in the XML Field Path parameter will be transformed in the JSON object representation. In case of error, the “error” property will be created at the same level as the original property.
When the Preserve Original parameter is enabled, for each field informed in the XML Field Path parameter, a new property will be informed just by adding the “_” character at the beginning of its name and containing the original XML string.
The JSON dotted notation will look for the root element that is being processed by the pipeline and cross it according to the specification provided in the XML Field Path property.
Example:
In an XML Field Path representation with a.b.c.d, "a" will be searched in the root element. Afterwards, it will be “b”, then "c" and finally "d". If an array is found during the cross-process, the algorithm will create a cross path for each array element. The algorithm replaces all the path occurrences defined in XML Field Path.
XML to JSON Transformer in action
For all the scenarios below, the following payload will be considered with the XML String field:
{
"xmlField": "<?xml version=\"1.0\" ?><inf:ProductInformation xmlns:inf=\"urn:product:Info\" xmlns:stk=\"urn:product:Stock\"><inf:ProductName Code=\"C00001\">Computer</inf:ProductName><inf:Price Units=\"$\">2500</inf:Price><stk:Volume Units=\"Units\">200</stk:Volume></inf:ProductInformation>"
}XML Transformation
Input
Parameters
XML Field Path: xmlField
Preserve Original: false
With Namespace: false
Remove XML Attributes: false
All Values As String: false
Output
{
"xmlField": {
"ProductInformation": {
"ProductName": {
"Code": "C00001",
"content": "Computer"
},
"Price": {
"Units": "$",
"content": 2500
},
"Volume": {
"Units": "Units",
"content": 200
},
"xmlns:stk": "urn:product:Stock",
"xmlns:inf": "urn:product:Info"
}
}
}XML Transformation with the Preserve Original parameter enabled
Input
Parameters
XML Field Path: xmlField
Preserve Original: true
With Namespace: false
Remove XML Attributes: false
All Values As String: false
Output
{
"xmlField": {
"ProductInformation": {
"ProductName": {
"Code": "C00001",
"content": "Computer"
},
"Price": {
"Units": "$",
"content": 2500
},
"Volume": {
"Units": "Units",
"content": 200
},
"xmlns:stk": "urn:product:Stock",
"xmlns:inf": "urn:product:Info"
}
},
"_xmlField": "<?xml version=\"1.0\" ?><inf:ProductInformation xmlns:inf=\"urn:product:Info\" xmlns:stk=\"urn:product:Stock\"><inf:ProductName Code=\"C00001\">Computer</inf:ProductName><inf:Price Units=\"$\">2500</inf:Price><stk:Volume Units=\"Units\">200</stk:Volume></inf:ProductInformation>"
}XML Transformation with the With Namespace parameter enabled
Input
Parameters
XML Field Path: xmlField
Preserve Original: false
With Namespace: true
Remove XML Attributes: false
All Values As String: false
Output
{
"xmlField": {
"inf:ProductInformation": {
"inf:Price": {
"Units": "$",
"content": 2500
},
"xmlns:stk": "urn:product:Stock",
"xmlns:inf": "urn:product:Info",
"inf:ProductName": {
"Code": "C00001",
"content": "Computer"
},
"stk:Volume": {
"Units": "Units",
"content": 200
}
}
}
}XML Transformation with the Remove XML Attributes parameter enabled
Input
Parameters
XML Field Path: xmlField
Preserve Original: false
With Namespace: false
Remove XML Attributes: true
All Values As String: false
Output
{
"xmlField": {
"ProductInformation": {
"ProductName": "Computer",
"Price": 2500,
"Volume": 200
}
}
}XML Transformation with the All Values As String parameter enabled
Input
Parameters
XML Field Path: xmlField
Preserve Original: false
With Namespace: false
Remove XML Attributes: true
All Values As String: true
Output
{
"xmlField": {
"ProductInformation": {
"ProductName": "Computer",
"Price": "2500",
"Volume": "200"
}
}
}Was this helpful?