Add XML
Description
Add XML encodes the values of selected fields in each row as an XML string and adds it as a new field to the data stream. Use this step when your workflow needs to produce XML output from row data — for example, building XML payloads for web service calls, generating XML fragments for document assembly, or packaging field values into a structured format for downstream processing.
Configurations
| Field Name | Description |
|---|---|
| Step name | Specify the name of the step as it appears in the workflow workspace. This name has to be unique in a single workflow. |
| Content Tab: | |
| Encoding | Specify the encoding to use. This encoding is specified in the header of the XML file |
| Output Value | Specify the name of the new field that contains the XML |
| Root XML element | Specify the name of the root element in the generated element. |
| Omit XML header | Enable to not include the XML header in the output. |
| Omit null values from the XML result | Do not add or eliminate elements or attributes with null values. This is often used to limit the size of the target XML. |
| Fields Tab: | The Fields tab is where you configure the output fields and their formats. The table below describes each of the available properties for a field: |
| Fieldname | Specify the name of the field |
| Element name | Specify the name of the element in the XML file to use |
| Type | Specify the Type of the field can be either String, Date, or Number |
| Format | Specify the Format mask with which to convert data; see Number Formats for a complete description of format specifiers |
| Length | Output string is padded to this length if it is specified |
| Precision | Specify the precision. |
| Currency | Specify the Symbol used to represent currencies like $10,000.00 or E5.000,00 |
| Decimal | Specify the decimal separator. The Decimal point separator can be a "." (10,000.00) or "," (5.000,00) |
| Grouping | Specify a thousand’s group separator. A group separator can be a "," (10,000.00) or "." (5.000,00) |
| Null | Specify the string to use in case the field value is null. |
| Attribute | Choose Y/N from the dropdown list. Choose Y to make this an attribute (N means: element) |
| Attribute parent name | You can specify the name of the parent element to add the attribute to if previous parameter attribute is set to Y. If no parent name is specified, the attribute is set in the parent element. |