Data transform

Inputs

• data json · required — The object or list to read from.
• path string · required — For example order.lines[0].sku or order.lines[*].sku ($. prefix optional).

Outputs

• value json — The value at the path (a list when the path has a wildcard; empty when not found).
• values list of jsons — Every value found, as a list.
• found boolean
• count integer — How many values were found.

Inputs

• items list of objects · required — A list of objects (rows), e.g. a data table query result or a JSON array.
• fields list · required — One per field: source path, optionally "as" a new name (a dotted name creates nested objects), or objects { from, to, default }.
• keep_other_fields boolean — Keep fields not listed (renamed ones move).

Outputs

• items list of objects — The mapped items.
• count integer — How many items were returned.

Inputs

• items list of objects · required — A list of objects (rows), e.g. a data table query result or a JSON array.
• conditions list of objects · required — List of { "field": "status", "operator": "eq", "value": "paid" }; in / not_in take a list or comma-separated text.each: field (string), operator (string), value (json)
• combine choice · all / any — Whether every condition or any condition must match.
• case_sensitive boolean — Compare text exactly (off: ignore case).

Outputs

• items list of objects — The matching items, in their original order.
• count integer — How many items matched.
• removed integer — How many items did not match.

Inputs

• items list of objects · required — A list of objects (rows), e.g. a data table query result or a JSON array.
• keys list · required — In priority order: "amount desc", "-amount", "name asc text", or { "field", "direction": "asc" | "desc", "type": "auto" | "number" | "text" | "date" }.

Outputs

• items list of objects — The sorted items.
• count integer — How many items were returned.

Inputs

• items list of objects · required — A list of objects (rows), e.g. a data table query result or a JSON array.
• group_by list of strings · required — The field(s) to group by.
• aggregates list — "sum:amount", "avg(amount) as average", "count_distinct:product" or { "op": "sum", "field": "amount", "as": "total" }. The default name is op_field (sum_amount).

Outputs

• groups list of objects — One row per group, in order of first appearance: the group fields, count and each aggregate.
• count integer

Inputs

• items list of objects · required — A list of objects (rows), e.g. a data table query result or a JSON array.
• rows list of strings · required — Field(s) that identify an output row.
• column string · required — Field whose values become columns.
• value string — Field to aggregate in each cell (not needed for count).
• aggregate choice · sum / count / avg / min / max / first / … — How to combine several values in one cell.
• fill json — Value for a row/column with no items (default empty; e.g. 0).

Outputs

• items list of objects — One row per Rows key with a property per column.
• columns list of strings — The column values, in order of first appearance.
• count integer — How many items were returned.

Inputs

• items list of objects · required — A list of objects with one column per measure.
• keep_fields list of strings — Identifier fields copied to every row.
• columns list of strings — The fields to turn into rows (default: every field not kept).
• name_field string — Field that receives the column name.
• value_field string — Field that receives the value.
• skip_empty boolean — Leave out rows whose value is empty.

Outputs

• items list of objects — One row per item and column.
• count integer — How many items were returned.

Inputs

• items list · required — A list of objects or plain values.
• fields list of strings — Fields that make an item unique (default: the whole item).
• keep choice · first / last — Which duplicate to keep (the order of the list is kept).
• case_sensitive boolean — Off: "A@x.io" and "a@x.io" are duplicates.

Outputs

• items list of jsons — The unique items.
• count integer — How many items were returned.
• removed integer — How many duplicates were removed.

Inputs

• left list of objects · required — The main list of objects.
• right list of objects · required — The list to look up.
• left_key list of strings · required — Key field(s) in the left list.
• right_key list of strings — Key field(s) in the right list, in the same order (default: the left key names).
• type choice · inner / left / right / full — Which unmatched rows to keep.
• right_prefix string — Optional prefix for every field from the right list.
• case_sensitive boolean — Off: keys match ignoring case.

Outputs

• items list of objects — The joined rows (one per match).
• count integer — How many items were returned.
• unmatched_left integer — Left rows with no match.
• unmatched_right integer — Right rows with no match.

Inputs

• csv text · required — The CSV text.
• delimiter string — auto (detect), comma, semicolon, tab, pipe or the character(s).
• header boolean — The first row holds the field names (off: column_1, column_2, …).
• infer_types boolean — Turn numbers and true/false into numbers and booleans, empty cells into empty values (numbers with leading zeros stay text).
• trim boolean — Trim spaces around values.

Outputs

• items list of objects — One object per data row.
• columns list of strings — The field names.
• count integer — How many data rows.

Inputs

• items list of objects · required — A list of objects (rows), e.g. a data table query result or a JSON array.
• columns list of strings — Fields to write, optionally "field as Header" (default: every field, in order of appearance).
• delimiter string — Field separator (tab for tab-separated).
• header boolean — Write the column names first.
• line_ending choice · crlf / lf — CRLF (RFC 4180, Excel) or LF.
• escape_formulas boolean — Prefix text starting with = + - @ with ' so spreadsheets do not run it (CSV injection).

Outputs

• csv text
• columns list of strings — The header names.
• count integer — How many data rows.