JsonPathMatch / String Layer

Extract data from JSON strings using JSONPath expressions. Similar to XPath for XML, but designed for JSON structures. Creates a list column containing all matching values.

Supports JSONPath syntax elements:

$ : Root object reference
@ : Current object reference
. : Child operator (dot notation)
[] : Child operator (bracket notation)
.. : Recursive descent
- : Wildcard for names/indices
[n] : Array index (0-based)
[start:end:step] : Array slice
[,] : Union of values
?() : Filter expression
() : Script expression

Common applications:

Extracting nested JSON values
Processing API responses
Filtering JSON data
Complex data selection
JSON document querying
Hierarchical data navigation

Note: Returns null for invalid JSON or when path doesn't match.

Table

Select

column

The string column containing JSON data. Example JSON structures:

Nested objects: '{"user":{"name":"John","age":30}}'
Arrays: '{"items":[{"id":1},{"id":2}]}'
Mixed data: '{"store":{"book":[{"title":"T1","price":10}]}}'

JsonPath

string

JSONPath expression to evaluate. Example patterns:

$. s t ore . b oo k [*] . a u t h or : A ll b oo ka u t h ors -$ ..price : All prices in structure
$. s t ore . b oo k [0] : F i rs t b oo k -$ ..book[-1:] : Last book
$.. b oo k [? (@. p r i ce < 10)] : B oo k s u n d er$ 10
$. s t ore . * : A ll s t ore i t e m s -$ ..* : All values in structure

Supports both dot notation ( $. s t ore . b oo k) an d b r a c k e t n o t a t i o n ($ ['store']['book'])

Name for the new column. If not provided, the system generates a unique name. If AsColumn matches an existing column, the existing column is replaced. The name should follow valid column naming conventions.