Reference
No results for 'undefined'
    Powered by Algolia

    GRAB_LIST

    Returns a result of applying jsonpath expression to the input frame.If multiple expressions will be spesified - their results will be merged.Allways wraps result in a array - even if it's a single value - usefull in some cases, where the data is inconsistent

    Syntax

    =GRAB_LIST(inputFrame, grabexprs, grabexprs, ...)

    Parameters

    1. inputFrame
      • Type: Frame
      • Description: The data to run jsonpath on.
    2. grabexprs [repeatable]
      • Type: Any
      • Description: grabexprs is jsonpaths with optional match renaming "as name"

    Returns

    • Type: Frame
    • Description: Returns frame, that is the result of jsonpath search

    Example

    =GRAB_LIST(A1, "$.book[*].author", "$.book[*].isbn")
    Contents