Transform

Convert data between formats like XML, JSON, CSV, HTML, and XLS to enable compatibility across systems and services. This connector supports predefined actions only.

Actions

XML to JSON: XML to JSON converter
JSON to CSV: JSON to CSV converter
CSV to JSON: CSV to JSON converter
JSON to HTML: JSON to HTML converter
JSON to XML: JSON to XML converter
XLS to JSON: XLS to JSON converter

Note: JSON consists of 6 data types, string, number, boolean, null, object, and array. As JSON does not have a Date type, it encodes dates as ISO 8601 strings. Hence, for the XLS to JSON action to interpret dates correctly, the 'Date' or 'Time' data-type field should always have a value in DateTime format or the column should be converted into a 'String' data-type.