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

JSON Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
gzn1554761068186.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1150
lifecycle
previous
Product Category
Teradata Vantage™

JSONPath notation lets you specify a portion of a JSON document. You can use a JSONPath string to identify any portion of the document, such as an object (including all nested objects and arrays), a single name/value pair, an array, a specific element of an array, or a value. Several JSON functions and methods accept a JSONPath string as input.

The principles of JSONPath are analogous to those of XPath for XML.
Vantage does not provide complete validation of the syntax, so malformed query strings can produce undesirable results. Vantage only provides the following validations:
  • Validate the presence of the '$' root character.
  • Validate the omission of the following characters:
    • Any ';' characters
    • Three or more consecutive '.' characters. For example: '…'