To transform, fetch, or convert data in an extensible markup language (XML) format, add a step in a chain that uses an XML connection command.
To enable these commands, an IT admin first creates an XML connector.
Element list to CSV
To convert an element list to a comma-separated values (CSV) file, given each column's name and the XPath to its desired values, use an Element list to CSV command. If a single column has multiple values, they're separated by the selected delimiter.
Properties
| Property | Detail |
|---|---|
| Input file | Enter the input file to parse as XML. To parse text, leave blank. |
| Input text | Enter the text to parse as XML. To parse a file, leave blank. |
| Path to root | Enter the XPath for the list of elements to convert to CSV. All XPaths defined in the columns are relative to this path. |
| Preview result | To preview the created CSV file, check this box. |
| Columns | Enter the columns to produce and their corresponding XPaths. |
| Multi-value delimiter | Select the delimiter to use to separate multiple values for a single column. |
Outputs
| Output | Output type |
|---|---|
| Converted file | File |
Exit codes
| Code | Type | Detail |
|---|---|---|
| 0 | Success | Success |
| 1 | Error | Error running the command |