> ## 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.

<AgentInstructions>

## Submitting Feedback

If you encounter incorrect, outdated, or confusing documentation on this page, submit feedback:

POST https://docs.firebolt.io/feedback

```json
{
  "path": "/reference-sql/functions-reference/json/json-value-array",
  "feedback": "Description of the issue"
}
```

Only submit feedback when you have something specific and actionable to report.

</AgentInstructions>

> Reference material for JSON_VALUE_ARRAY function

# JSON_VALUE_ARRAY

Takes a JSON document and extracts a JSON array of scalar values to SQL `ARRAY(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-array is given, or non-scalar value is given (inside the array).

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_ARRAY(<json>)
```

## Parameters

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

## Return Type

`ARRAY(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_ARRAY(JSON_POINTER_EXTRACT(<json_common_example>, '/value/uid')), JSON_POINTER_EXTRACT(<json_common_example>, '/value/uid')
```

**Returns**: `NULL, '"987654"'`

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

**Returns**: `{'insanely','fast','analytics'}`

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

**Returns**: `NULL`