Scalar Functions
JSON functions
Scalar functions for manipulating JSON
Arroyo provides two set of JSON functions.
Json path functions
JSON functions provide basic json parsing functions using JsonPath, an evolving standard for querying JSON objects.
extract_json
Returns the JSON elements in the first argument that match the JsonPath in the second argument. The returned value is an array of json strings.
SELECT extract_json('{"a": 1, "b": 2, "c": 3}', '$.a') FROM source;
['1']
extract_json_string
Returns an unescaped String for the first item matching the JsonPath, if it is a string.
SELECT extract_json_string('{"a": "a", "b": 2, "c": 3}', '$.a') FROM source;
'a'