Search results

    Edit on GitHub

    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 }
      ]
    }
    

    UpSQL

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

    Result

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

    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"

    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 all the values from all the inputs as an array

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

    ZIP

    Combines multiple arrays by index into records