JSON Data Type | JSONPath Request Syntax | VantageCloud Lake - JSONPath Request Syntax - Teradata Vantage

The following JSONPath syntax reflects the JSONPath specification (https://goessner.net/articles/JsonPath/).

. [ $ [children [...]] ] .

Syntax Elements

$

The root object or element.

children

{.|..} { child_specification | options }

child_specification

{ * | name_string [ options ] }

options

[ { index | expression | filter } ]

You must type the colored or bold brackets.

index

{ * |
  integer [ : | , integer | : integer : integer ] |
  : integer
}

expression

( @.LENGTH [ {+|-|*|/} integer ] )

In this context, LENGTH is the length of the current JSON array, equal to the number of elements in the array.

filter

?(@.element_string [ number_comparison | =~string ] )

Applies a filter (script) expression.

number_comparison

{ <= | < | > | >= | == | != } integer

@

The current object or element.

integer

A signed integer.

element_string

A string specifying the name of an element.

=~ string

String comparison expression.