Extract with JSONPath

Extract data from a column containing JSON using the JSONPath syntax, and create a new column containing the extracted data.

Example

JSON object from input column: {"person":"John","age":24}

JSONPath expression: $.age

Extracted data: 24

Options

Input column

Column containing the JSON to extract.

Output column

Create a new column for output.

JSONPath expression

Expression following the syntax in the JSONPath documentation.

Single value

Check if the path represents a single value and not an array.