Data Transformation
Transform data (input, JSON, or CSV) into JSON, XLSX or CSV
Parameters
| Label (internal name) | Type | Default | Description |
|---|---|---|---|
| Data input (input) | select, possible values: Main Input (use selector for e.g $.Users...) (input), JsonBody (jsonbody), Raw Data / json-encoded (raw/json), Raw Data / csv-encoded (raw/csv), StringBody / json-encoded (stringbody) |
jsonbody | Source used to compute input data. Must be directly a slice, or you can use a Selector to point to a slice. Use Main Input and Root Selector $.Vars.VarName to access a runtime variable. |
| Root Selector (jsonpath) (selector) | string | If the input is not already a list (slice), use this selector to point to a list inside the input object. | |
| **** () | legend | [XLSX Only] Sheet and Formulas | |
| Sheet Name (sheet) | string | Data | Excel Sheet Name |
| **** () | legend | [CSV Only] Formatting | |
| CSV separator (csv-separator) | string | , | Separator character for CSV input / output |
| Output Format (format) | Possible Values Below | json | Format for saving after transformation |
| • JSON (JsonBody) (json) | format | ||
| • Object (Variable) (jsonvar) | format | ||
| - Variable Name (varName) | string | Name of the output variable | |
| • CSV (RawBody) (csv) | format | ||
| • XLSX (RawBody) (xlsx) | format | ||
| Column Name (columns.name) | string | Column Name | |
| Selector (jsonpath or template) (columns.jsonpath) | string | Jsonpath Selector (applied to input) | |
| Data Format (columns.dataformat) | select, possible values: String (string), Integer (int64) (number), Float (float64) (float), Date (string) (date), Date (timestamp) (stamp), Boolean (true/false) (bool) |
Make sure output is in the correct format | |
| Expander (columns.expand) | string | Apply this selector on the expanded values | |
| [XSLX] Cell Width (columns.cellwidth) | integer | Specify cell width | |
| Column Letter and $.Current or $.Next for row (formulas.formula_column) | string | Cell Position | |
| Formula (use $.First, $.Last, $.Length) (formulas.formula) | string | Formula | |
| Compute In-Place and Export As... (formulas.compute) | string | Compute |
Expected Input
JSON, Raw or CSV Body
Expected Input
JSON, XLSX or CSV Body
Back to top