Reference material for JSON_POINTER_EXTRACT_TEXT function
JSON_POINTER_EXTRACT_TEXT
returns it as SQL TEXT
, removing outer quotes and decoding characters. Otherwise, it returns NULL
.
Parameter | Description | Supported input types |
---|---|---|
<json> | The JSON document. | TEXT |
<json_pointer_expression> | A JSON pointer expression to the location of the desired sub-document in the JSON. For more information, see JSON pointer expression syntax. | TEXT |
TEXT
NULL
, the function will return NULL
.<json_common_example>
below,
see JSON common example. The returned result is based on the following example.
Example
The following code example extracts the value at path /value/uid
from the JSON document, removes the outermost quotes, and returns the result as SQL TEXT
, labeled as res
:
res (TEXT) |
---|
987654 |
/value/no_such_key
from the JSON document:
NULL
with the result labeled as res
, because the key does not exist:
res (TEXT) |
---|
NULL |
/value/code
from the JSON document:
NULL
, labeled as res
because the value at the specified path is an integer, not a string:
res (TEXT) |
---|
NULL |
2
of the array at /value/keywords
in the JSON document, removes the outermost quotes, and returns it as SQL TEXT
, labeled as res
:
"analytics"
, which is the third element in the JSON array, which uses zero-based indexing:
res (TEXT) |
---|
analytics |