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