The Xml2Csv add-in writes certain XML nodes to a CSV file. The parameters are used to configure which nodes are adopted and where the new file is saved.
| features | |
| Add-in type | Logic |
| Interfaces | file directory |
| Transactions | 1 per created file |
| Events | Per created file: <instance>.Output (parameter = file) 1x at the end: <instance>.Done |
| parameter | |
| sourceDirectory | The directory of the source files (XML files) |
| sourceFilePattern | The search pattern to restrict the source files (optional, default = *.xml) |
| rowXPath | XPath to select the lines in the CSV file |
| additionalColumnXPath | XPath to include columns outside the row defined with rowXPath. Multiple columns can be specified separated by semicolons. (Optional) |
| stripNamespace | true = namespace prefixes from the XML file are removed from the column names in the created CSV file (optional, default = true) |
| delimiter | Separator of the columns in the CSV file (optional, default = semicolon) |
| destinationDirectory | Directory in which the CSV file is created (optional, default = sourceDirectory) |
| endpoint | Name of the endpoint that is used in the transaction (optional, default = “”) |
If the Xml2Csv add-in is activated via an event that contains a “file” parameter, the file in this parameter is interpreted as an XML file and converted into a CSV file. In this case the configured parameters “sourceDirectory” and “sourceFilePattern” are ignored.
Events with “file” parameters are triggered by the following add-ins: