`OBJECTTOARRAY` (NoSQL query)

The OBJECTTOARRAY function converts field/value pairs in a JSON object to a JSON array.

Syntax

OBJECTTOARRAY(<object_expr> [, <string_expr_1>, <string_expr_2>])

	Description
`object_expr`	An object expression with properties in field/value pairs.
`string_expr_1`	A string expression with a name for the field representing the field portion of the original field/value pair.
`string_expr_2`	A string expression with a name for the field representing the value portion of the original field/value pair.

Returns an array of elements with two fields, either k and v or custom-named fields.

This section contains examples of how to use this query language construct.

In this example, the OBJECTTOARRAY function is used to convert a JSON object to an array.

SELECT VALUE
  OBJECTTOARRAY({
    "a": "12345",
    "b": "67890"
  })

[
  [
    {
      "k": "a",
      "v": "12345"
    },
    {
      "k": "b",
      "v": "67890"
    }
  ]
]