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

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-04-03
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

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. There are JSON functions and methods that 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: '…'