JSON Data Type | JSONPath Request Syntax | Teradata Vantage - JSONPath Request Syntax - Advanced SQL Engine - Teradata Database

JSON Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
uwa1591040057999.ditamap
dita:ditavalPath
uwa1591040057999.ditaval
dita:id
B035-1150
lifecycle
previous
Product Category
Teradata Vantageā„¢

The following JSONPath syntax reflects the JSONPath specification (http://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.