FunctionsJSON

json_length

Returns the number of top-level elements for arrays and top-level keys for objects. For scalar JSON values, returns 0.

json_length(…) → UInt64

Kind · scalar

Returns the number of top-level elements for arrays and top-level keys for objects. For scalar JSON values, returns 0.

Part of the JSON family.

json_key

Returns the key at the requested zero-based position among top-level object members.

json_merge_patch

Applies a JSON Merge Patch (RFC 7396) document to a target JSON value and returns the patched result. Use this for partial updates of JSON objects.