The XML Writer step is used to create an XML file.
Illustrated in the image below is an example of a flow where records from an Excel file (using the Excel reader step) is being used to create an XML file. The Run File destination step is used to download the XML file.
The records from the Excel file is shown in the below.
The page below shows the XML Writer step.
The XML Root field is the parent name tag but it is not required. If left blank, there will be no parent tag. In this example, the XML Root is 'ParentTag'.
The XML Record Root field is the child tag name that will be used to wrap the XML in. This field is required. In this example, the XML record Root is 'ChildTag'.
The Special Characters section defines the action to take when special characters are detected in the record. For more information on these options, please click the following link:
The Special Names section defines the action to take when special characters in the name are detected. The description for each action is below:
Error - errors out special characters.
Replace – automatically replaces special characters.
The Attribute Identifier field is the character that identifies an attribute.
The Value identifier is the character that identifies that the value should be written as a string.
The image below is the output of how the data looks when testing the XML writer step
