extract_json_values(text: text|category, {
    "param": value,
    ...
}) -> (value_extracted: column)

A JsonPath is a string that uses a syntax similar to XPath to extract values from JSON objects. The syntax is described in the JsonPath Online Evaluator.

extract_json_values(text: text|category, {
    "param": value,
    ...
}) -> (value_extracted: column)
​
path
string
required

JsonPath string used to extract the values from the JSON values of the columns.

​
type
string
required

Output column type. Select the desired type using a shortened yet fully specified name.

Values must be one of the following:

boolean category date number text url list[number] list[category] list[url]

Was this page helpful?

Suggest edits