FunctionsJSON

json_extract_uint

Extracts the JSON value at the given path and returns it as an unsigned integer. If the path is missing, the JSON is invalid, or the value is negative/not an integer/overflows, the result is NULL.

json_extract_uint(…) → UInt64

Kind · scalar

Extracts the JSON value at the given path and returns it as an unsigned integer. If the path is missing, the JSON is invalid, or the value is negative/not an integer/overflows, the result is NULL.

Part of the JSON family.

json_extract_string

Extracts the JSON value at the given path and returns it as a string. If the path is missing, the JSON is invalid, or the value is not a JSON string, the result is NULL.

json_has

Checks object keys, JSON paths, or array element membership depending on the input document shape.