Converter Component
The Converter component transforms data from one format to another. Use it when a source system returns data in a format that a downstream component cannot consume directly.
The default conversion is XML → JSON.
Supported conversions
| From | To |
|---|---|
| XML | JSON |
| JSON | CSV |
| JSON | XML |
| CSV | JSON |
| CSV | XML |
| XML | CSV |
CSV configuration options
| Option | Description |
|---|---|
| Delimiter | The character used to separate values (e.g. , or ;) |
| Delimiter wrap | The character used to wrap values that contain the delimiter (e.g. ") |
| Trim values | Remove leading and trailing whitespace from each value |
| Trim headers | Remove leading and trailing whitespace from column headers |
| Prepend header | Add a header row to the output CSV |
XML configuration options
| Option | Description |
|---|---|
| Root element | The name of the top-level XML element wrapping the output |
| Attribute name prefix | The prefix used to distinguish XML attributes from elements |
| Ignore namespace | Strip XML namespace prefixes from element names |
| Ignore attributes | Exclude XML attributes from the conversion output |
For a worked example of receiving XML, changing it and sending it back as XML, see Receive, Transform and Send XML.
Common use cases
- Parse XML responses from legacy systems into JSON for downstream components
- Generate a CSV from a REST API response before attaching it to an email
- Convert JSON workflow output into XML for a target system that only accepts XML
Further reading
- Receive, Transform and Send XML — step-by-step XML → JSON → XML round trip
- Transform — reshape JSON using JSONata expressions without changing the format
- REST API — commonly the source of data that needs format conversion
- Email — attach a converted file to an outgoing email