Data

array_create

Creates an array from individual values, omitting nulls.

Inputs:

• item_1 (Any) — first element (null = skip)
• item_2 (Any) — second element (null = skip)
• item_3 (Any) — third element (null = skip)
• item_4 (Any) — fourth element (null = skip)

Output: result (Json) — array of non-null values

array_flatten

Flattens nested arrays by one level.

Inputs:

• data (Json) — nested array
• depth (Number) — levels to flatten

Output: result (Json) — flattened array

array_get

Gets an element from an array by index.

Inputs:

• data (Json) — source array
• index (Number) — 0-based index (negative = from end)

Output: result (Any) — element at index

array_length

Returns the length of an array.

Inputs:

• data (Json) — array to measure

Output: result (Number) — number of elements

array_push

Appends a value to an array.

Inputs:

• data (Json) — array to append to
• value (Any) — value to add at end

Output: result (Json) — array with new element

array_reverse

Reverses an array.

Inputs:

• data (Json) — array to reverse

Output: result (Json) — reversed array

array_slice

Returns a portion of an array.

Inputs:

• data (Json) — source array
• start (Number) — start index (inclusive)
• end (Number) — end index (exclusive, -1 = all)

Output: result (Json) — sub-array

array_unique

Returns unique values from an array.

Inputs:

• data (Json) — array with possible duplicates

Output: result (Json) — array with duplicates removed

deep_merge

Recursively merges two objects.

Inputs:

• a (Json) — base object
• b (Json) — object to merge in (wins on conflict)

Output: result (Json) — recursively merged object

Example: a = {"x":{"y":1}}, b = {"x":{"z":2}} → {"x":{"y":1,"z":2}}

See also: object_merge, field_set

field_extract

Extracts a field from an object using dot-notation path.

Inputs:

• data (Json) — object to extract from
• path (Text) — dot-separated key path (e.g. a.b.c)

Output: result (Any) — value at the given path

Example: data = {"a":{"b":42}}, path = a.b → 42

See also: field_set, object_keys

field_set

Sets a field in an object using dot-notation path.

Inputs:

• data (Json) — source object
• path (Text) — dot-separated key path (e.g. a.b.c)
• value (Any) — value to set at path

Output: result (Json) — object with updated field

json_parse

Parses a JSON string into a structured value.

Inputs:

• text (Text) — JSON string to parse

Output: result (Json) — parsed object or array

json_query

Queries nested JSON using dot and bracket path notation.

Inputs:

• data (Json) — JSON data to query
• path (Text) — path expression (e.g. users[0].name)

Output: result (Any) — queried value

Example: data = {"users":[{"name":"Alice"}]}, path = users[0].name → Alice

See also: field_extract, object_keys

json_stringify

Converts a value to a formatted JSON string.

Inputs:

• value (Json) — value to serialize
• pretty (Boolean) — indent with 2 spaces if true

Output: result (Text) — JSON string

object_create

Creates a JSON object from key-value pairs.

Inputs:

• key_1 (Text) — first key name
• value_1 (Any) — value for first key
• key_2 (Text) — second key name
• value_2 (Any) — value for second key
• key_3 (Text) — third key name
• value_3 (Any) — value for third key

Output: result (Json) — constructed object

Example: key_1 = name, key_2 = age, value_1 = Alice, value_2 = 30 → {"age":30,"name":"Alice"}

See also: object_merge, field_set

object_delete

Removes a key from an object.

Inputs:

• data (Json) — source object
• key (Text) — key to remove

Output: result (Json) — object without the key

object_has

Returns true if the object has the given key.

Inputs:

• data (Json) — object to check
• key (Text) — key to look for

Output: result (Boolean) — true if key exists

object_keys

Returns the keys of an object as a JSON array.

Inputs:

• data (Json) — object to extract keys from

Output: result (Json) — array of key strings

object_merge

Shallow-merges two objects. Fields in b override a.

Inputs:

• a (Json) — base object
• b (Json) — object with overrides

Output: result (Json) — merged object (b wins on conflict)

object_values

Returns the values of an object as a JSON array.

Inputs:

• data (Json) — object to extract values from

Output: result (Json) — array of values

table_count

Returns the number of rows in a table.

Inputs:

• table (Json) — array of row objects

Output: count (Number) — number of rows

Example: table = [{"a":1},{"a":2},{"a":3}] → 3

See also: array_length, table_filter

table_filter

Filters table rows where a column matches a condition.

Inputs:

• table (Json) — array of row objects
• column (Text) — column name to test
• value (Any) — value to compare against
• operator (Text) — ==, !=, >, <, or contains

Output: result (Json) — filtered table rows

See also: table_sort, csv_parse

table_group

Groups table rows by a column and aggregates values.

Inputs:

• table (Json) — array of row objects
• column (Text) — column to group by
• aggregate (Text) — count, sum, avg, min, or max
• value_column (Text) — column to aggregate (for sum/avg/min/max)

Output: result (Json) — grouped and aggregated table

See also: table_filter, table_count

table_map

Transforms a column in each row using a predefined operation.

Inputs:

• table (Json) — array of row objects
• source (Text) — source column name
• target (Text) — target column name
• operation (Text) — copy, add, subtract, multiply, divide, prepend, append, set
• value (Text) — operand value for math/string operations

Output: result (Json) — table with mapped column

table_select

Picks specific columns from table rows.

Inputs:

• table (Json) — array of row objects
• columns (Text) — comma-separated column names

Output: result (Json) — table with selected columns only

See also: table_filter, table_sort

table_sort

Sorts table rows by a column.

Inputs:

• table (Json) — array of row objects
• column (Text) — column name to sort by
• direction (Text) — ascending or descending

Output: result (Json) — sorted table rows

See also: table_filter, csv_parse