Structural Functions

FROM_KEY_VALUE

Maps a list of key values to a record with fields for each key.

Inputs

key
value

Properties

Keys

Example

Input

{
  "data": [
    { "key": "a", "value": 1 },
    { "key": "b", "value": 2 }
  ]
}

SQL

SET result = FROM_KEY_VALUE('a,b', data[].key, data[].value)

Result

{
  "result": {
    "a": 1,
    "b": 2
  }
}

GET_RANGE

Returns range of numbers between start and end (inclusive).

Inputs

first
last

ITEM_INDEX

Gets the index of the item.

Properties

Global Index - Use the global index in the event instead of the index in the containing array
Count Nulls

JSON_PATH

Extracts data from JSON objects.

Inputs

JSON - A String that contains JSON Document

Properties

Path - JSON Path Expression
JSON Path result
"[{
"name": "The Great Gatsby",
"author": {
"name": "F. Scott Fitzgerald"
}
},
{
"name": "Nineteen Eighty-Four",
"author": {
"name": "George Orwell"
}
}]"
"$[*].author.name" "F. Scott Fitzgerald", "George Orwell"
"{ "net_id": 41 }" "net_id" "41"
"{ "net_id": [41, 42] }" "net_id" "[41, 42]"
"{ "net_id": [41, 42] }" "net_id[*]" "41", "42"
"{ "net_id": [41, 42] }" "net_id.parent" null
"[1,2,3]" "$[*]" "1", "2", "3"

"[{
"name": "The Great Gatsby",
"author": {
"name": "F. Scott Fitzgerald"
}
},
{
"name": "Nineteen Eighty-Four",
"author": {
"name": "George Orwell"
}
}]"

"$[*].author.name"

"{"name":"F. Scott Fitzgerald"}",

"{"name":"George Orwell"}"

JSON_TO_RECORD

Extracts data from JSON objects.

Properties

Mappings - JSON to field mappings
Output Array - If the string contains multiple JSON records use this to allow outputing all of them
value Mappings Output Array result

"{ "a": "Hello" }"

"a,a,string"

true

{"a": "Hello"}

"{ "a": { "value": "Hello" }, "b" : { "value": "World" } }"

"a.value,a.value,string
b.value,b.value,string"

true

{"a.value": "Hello", "b.value": "World"}

MAP_WITH_INDEX

Outputs an index and a value field. Index contains a zero based index, and value contains the value in the input field.

Inputs

value - The value to convert to a record
value result
"a", "b", "c" {"index": 0, "value": "a"}, {"index": 1, "value": "b"}, {"index": 2, "value": "c"}

QUERY_STRING_TO_RECORD

Extracts data from query string.

Properties

Mappings - Field names

TO_ARRAY

Outputs the values from the inputs as an array.

inputs result
["a", "c"], ["b"] "a", "c", "b"

ZIP

Combines multiple arrays by index into records.