Skip to main content
Accepts a JSON document and pointer expression. If the key exists and holds a JSON object (map), JSON_POINTER_EXTRACT_VALUES returns all the values in that object as SQL ARRAY(TEXT), while the values remain raw as they appeared in the original JSON document. Otherwise, it returns NULL.

​
Syntax

​
Parameters

​
Return Type

ARRAY(TEXT)
  • If any input values are NULL, the function will return NULL.

​
Examples

For the JSON document used in the examples below, see JSON common example. Example The following code example extracts all the values at path /value/events/0/EventProperties from the JSON document, and returns the raw values as SQL ARRAY(TEXT):

Rows: 1Execution time: 6.29ms

Example The following code example attempts to extract the keys at the path /value/no_such_key from the JSON document and returns NULL because the key does not exist:

Rows: 1Execution time: 5.44ms

Example The following code example attempts to extract the value at the path /value/keywords from the JSON document and returns NULL because the value at the specified path is an array, not an object:

Rows: 1Execution time: 5.18ms