Transform data formats or structures with the Data Conversion Step.

When to Use #

• Convert formats: JSON, XML, CSV, YAML, Excel, etc.
• Transform data structures
• Create variables from complex data
• Parse uploaded files
• Extract data with JSONPath

Settings #

Basic

• Description: Describe the transformation
• Response Tag: Output data wrapper name

Format

• From/To Format: Choose formats (JSON, XML, CSV, Text, YAML, Excel, Variables)

XML Specific

• Encoding: Set output encoding
• Indent: Toggle XML indentation
• Exclude declaration: Remove XML header
• Array Nodes: Nodes to treat as arrays

Output

• Output mode: Append, Replace, or Wrapper (obsolete)
• Exclude Wrapper: Remove wrapper
• Output path: JSONPath for result destination

Advanced

• Evaluate: Enable formulas in mapped data
• File Upload Start: Trigger integration on file upload

Mappings Tab

• Edit source data or define variables
• Preview source/converted/output data

File Upload

• Import data from files (.xlsx auto-converted)

Tips #

• Use variables mode to create multiple variables
• Enable “File Upload Start” for file-driven flows
• Use JSONPath to extract specific data
• Use preview refresh after mapping changes
• For XML, define array nodes to maintain structure