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.

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]