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
Root Selector (jsonpath) (selector) string Pre-select a collection of items with jsonpath
Output Format (format) select, possible values: JSON (JsonBody) (json),
CSV (RawBody) (csv),
XLSX (RawBody) (xlsx)
json Format for saving after transformation
Column Name (name) string Column Name
**** () legend [XLSX Only] Sheet and Formulas
Sheet Name (sheet) string Data Excel Sheet Name
Column Letter and $.Current or $.Next for row (formula_column) string Cell Position
**** () legend [CSV Only] Formatting
CSV separator (csv-separator) string , Separator character for CSV input / output

Expected Input

JSON, Raw or CSV Body

Expected Input

JSON, XLSX or CSV Body

Back to top