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

> Reference material for JSON_VALUE function

# JSON_VALUE

Takes a JSON document and extracts a JSON scalar value to SQL `TEXT` value.
For JSON strings, removes the outermost quotes and unescapes the values.
Other JSON scalars are not changed.
Returns a SQL `NULL` if a non-scalar value is given.

For `TEXT` input, this function pairs with the [JSON\_EXTRACT](/reference-sql/functions-reference/json/json-extract) function, which doesn't convert the JSON values to SQL values.

## Syntax

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
JSON_VALUE(<json>)
```

## Parameters

| Parameter | Description        | Supported input types |
| :-------- | :----------------- | :-------------------- |
| `<json>`  | The JSON document. | `JSON` or `TEXT`      |

## Return Type

`TEXT`

* If any of the input is `NULL` the output is `NULL` (propagates nulls).

## Example

For the JSON document indicated by `<json_common_example>` below,
see [JSON common example](/reference-sql/functions-reference/json#json-common-example). The **returned result** is based on this example.

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SELECT JSON_VALUE(JSON_POINTER_EXTRACT(<json_common_example>, '/value/uid')), JSON_POINTER_EXTRACT(<json_common_example>, '/value/uid')
```

**Returns**

`'987654', '"987654"'`

**Example**

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SELECT JSON_VALUE(JSON_POINTER_EXTRACT(<json_common_example>, '/key'))::INT
```

**Returns**

`123`

**Example**

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SELECT JSON_VALUE(JSON_POINTER_EXTRACT(<json_common_example>,'/value/keywords'))
```

**Returns**

`NULL`

**Example**

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SELECT JSON_VALUE(NULL)
```

**Returns**

`NULL`