Please use the form below to provide your feedback. Because your feedback is valuable to us, the information you submit in this form is recorded in our issue tracking system (JIRA), which is publicly available. You can track the status of your feedback using the ticket number displayed in the dialog once you submit the form.

A newer version of this documentation is available.

View Latest

JSON Functions

  • reference
March 9, 2025
+ 12

DECODE_JSON(expression)

Unmarshals the JSON-encoded string into a N1QL value. The empty string is MISSING.

ENCODE_JSON(expression)

Marshals the N1QL value into a JSON-encoded string. MISSING becomes the empty string.

ENCODED_SIZE(expression)

Number of bytes in an uncompressed JSON encoding of the value. The exact size is implementation-dependent. Always returns an integer, and never MISSING or NULL. Returns 0 for MISSING.

POLY_LENGTH(expression)

Returns length of the value after evaluating the expression. The exact meaning of length depends on the type of the value:

  • MISSING: MISSING

  • NULL: NULL

  • String: The length of the string.

  • Array: The number of elements in the array.

  • Object: The number of name/value pairs in the object

  • Any other value: NULL