JSON_EXTRACT_VALUES
Returns an array of string values from a JSON document using the key location specified by the <json_pointer_expression>.
If no such key exists, returns NULL.
Syntax
JSON_EXTRACT_VALUES(<json>, '<json_pointer_expression>')
Parameter | Type | Description |
---|---|---|
<json> | TEXT | The JSON document from which the values are to be extracted. |
<json_pointer_expression> | Literal string | A JSON pointer to the location of the array in the JSON. For more information, see JSON pointer expression syntax. |
Example
For the JSON document indicated by <json_common_example>
below, see JSON common example. The Returns result is based on this common example.
SELECT
JSON_EXTRACT_VALUES(<json_common_example>, 'value')
FROM
RAW_JSON
Returns:
["987","\"987654\"","[\"insanely\",\"fast\",\"analytics\"]","{\"map\":{\"1737729\":32,\"1775582\":35}}","[{\"EventId\":547,\"EventProperties\":{\"UserName\":\"John Doe\",\"Successful\":true}},{\"EventId\":548,\"EventProperties\":{\"ProductID\":\"xy123\",\"items\":2}}]"]