GRAB

Returns a result of applying jsonpath expression to the input frame. If multiple expressions will be specified - their results will be merged.

Syntax

GRAB(inputFrame, [grabexpr1], [grabexpr2], ...)

• inputFrame - The data to run jsonpath on.

• [grabexpr1], [grabexpr2] - Grabexpr is jsonpaths with optional match renaming "as name".

Sample Usage

GRAB(C1, "$..nickname")
GRAB(C1, C2)

{
 "name": "Sasha",
 "age": 16,
 "gender":"female",
    "pets": [
        {
            "nickname": "Alice",
            "kind": "cat",
            "age": 3
        },
        {
            "nickname": "Tina",
            "kind": "dog",
            "age": 2
        },
        {
            "nickname": "Goldy",
            "kind": "fish",
            "age": 1
        }
        ]
}

Return Value

• Returns value or frame, that is the result of jsonpath search.

Notes

In order for GRAB to work, the first argument inputFrame must be a FROM_JSON formula which returns a json frame.

See also