FunctionsJSON

json_extract_keys

Returns the top-level keys of the selected JSON object as a JSON string array.

json_extract_keys(…) → JSON

Kind · scalar

Returns the top-level keys of the selected JSON object as a JSON string array.

Part of the JSON family.

json_extract_int

Extracts the JSON value at the given path and returns it as a signed integer. If the path is missing, the JSON is invalid, or the value is not an integer (or overflows the target type), the result …

json_extract_keys_and_values

Returns top-level object entries as key/value pairs, with each value converted to textual JSON content.