> ## Documentation Index
> Fetch the complete documentation index at: https://docs.oxla.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Overview

To help you query JSON data, Oxla provides some functions that will be used to operate and manipulate the JSON data. The functions are as follows:

| **Functions**                                                                                     | **Description**                                                                        |
| ------------------------------------------------------------------------------------------------- | -------------------------------------------------------------------------------------- |
| [JSON\_EXTRACT\_PATH()](/sql-reference/sql-functions/json-functions/json-extract-path)           | It extracts JSON sub-object at the specified path.                                     |
| [JSON\_EXTRACT\_PATH\_TEXT()](/sql-reference/sql-functions/json-functions/json-extract-path-text) | It returns text referenced by a series of path elements in a JSON string or JSON body. |
| [JSON\_ARRAY\_LENGTH()](/sql-reference/sql-functions/json-functions/json-array-length)            | It returns the number of elements in the outer array of a JSON string or JSON body.    |
| [JSON\_ARRAY\_EXTRACT()](/sql-reference/sql-functions/json-functions/json-array-extract)          | It returns the JSON array as a set of JSON values.                                     |

Operators are used to specify conditions when using JSON functions. Oxla also supports JSON operators as listed below:

| **Operators** | **Description**                                          | **Example**                                          |
| ------------- | -------------------------------------------------------- | ---------------------------------------------------- |
| ->            | It gets & returns the element of the JSON array.         | `'[{"a":"cab"},{"b":"bac"},{"c":"abc"}]'::json -> 2` |
| ->            | It gets & returns the JSON object field.                 | `'{"a": {"b":"abc"}}'::json -> 'a'`                  |
| ->>           | It gets & returns the element of the JSON array as text. | `'[11,22,33]'::json ->> 2`                           |
| ->>           | It gets & returns the JSON object field as text.         | `'{"a":13,"b":33}'::json ->> 'b'`                    |