--- acl_categories: - '@json' - '@write' - '@slow' arguments: - name: key type: key - name: path type: string - name: index type: integer - multiple: true name: value type: string categories: - docs - develop - stack - oss - rs - rc - oss - kubernetes - clients complexity: O(N) when path is evaluated to a single value where N is the size of the array, O(N) when path is evaluated to multiple values, where N is the size of the key description: Inserts the JSON scalar(s) value at the specified index in the array at path group: json hidden: false linkTitle: JSON.ARRINSERT module: JSON railroad_diagram: /images/railroad/json.arrinsert.svg since: 1.0.0 stack_path: docs/data-types/json summary: Inserts the JSON scalar(s) value at the specified index in the array at path syntax_fmt: JSON.ARRINSERT key path index value [value ...] title: JSON.ARRINSERT --- Insert the `json` values into the array at `path` before the `index` (shifts to the right) [Examples](#examples) ## Required arguments
key is key to modify.
value is one or more values to insert in one or more arrays. {{% alert title="About using strings with JSON commands" color="warning" %}} To specify a string as an array value to insert, wrap the quoted string with an additional set of single quotes. Example: `'"silver"'`. For more detailed use, see [Examples](#examples). {{% /alert %}}
index is position in the array where you want to insert a value. The index must be in the array's range. Inserting at `index` 0 prepends to the array. Negative index values start from the end of the array.
## Optional arguments
path is JSONPath to specify. Default is root `$`.
## Examples
Add new colors to a specific place in a list of product colors Create a document for noise-cancelling headphones in black and silver colors. {{< highlight bash >}} redis> JSON.SET item:1 $ '{"name":"Noise-cancelling Bluetooth headphones","description":"Wireless Bluetooth headphones with noise-cancelling technology","connection":{"wireless":true,"type":"Bluetooth"},"price":99.98,"stock":25,"colors":["black","silver"]}' OK {{< / highlight >}} Add color `blue` to the end of the `colors` array. `JSON.ARRAPEND` returns the array's new size. {{< highlight bash >}} redis> JSON.ARRAPPEND item:1 $.colors '"blue"' 1) (integer) 3 {{< / highlight >}} Return the new length of the `colors` array. {{< highlight bash >}} redis> JSON.GET item:1 "{\"name\":\"Noise-cancelling Bluetooth headphones\",\"description\":\"Wireless Bluetooth headphones with noise-cancelling technology\",\"connection\":{\"wireless\":true,\"type\":\"Bluetooth\"},\"price\":99.98,\"stock\":25,\"colors\":[\"black\",\"silver\",\"blue\"]}" {{< / highlight >}} Get the list of colors for the product. {{< highlight bash >}} redis> JSON.GET item:1 '$.colors[*]' "[\"black\",\"silver\",\"blue\"]" {{< / highlight >}} Insert two more colors after the second color. You now have five colors. {{< highlight bash >}} redis> JSON.ARRINSERT item:1 $.colors 2 '"yellow"' '"gold"' 1) (integer) 5 {{< / highlight >}} Get the updated list of colors. {{< highlight bash >}} redis> JSON.GET item:1 $.colors "[[\"black\",\"silver\",\"yellow\",\"gold\",\"blue\"]]" {{< / highlight >}}
## Redis Software and Redis Cloud compatibility | Redis
Software | Redis
Cloud | Notes | |:----------------------|:-----------------|:------| | ✅ Supported
| ✅ Flexible & Annual
✅ Free & Fixed | | ## Return information {{< multitabs id="json-arrinsert-return-info" tab1="RESP2" tab2="RESP3" >}} With `$`-based path argument: [Array reply]({{< relref "/develop/reference/protocol-spec#arrays" >}}) of [integer replies]({{< relref "/develop/reference/protocol-spec#integers" >}}) or [null replies]({{< relref "/develop/reference/protocol-spec#nulls" >}}), where each element is the array's new size, or `null` if the matching value is not an array. With `.`-based path argument: [Integer reply]({{< relref "/develop/reference/protocol-spec#integers" >}}) representing the array's new size, or [null reply]({{< relref "/develop/reference/protocol-spec#nulls" >}}) if the matching value is not an array. -tab-sep- With `$`-based path argument (default): [Array reply]({{< relref "/develop/reference/protocol-spec#arrays" >}}) of [integer replies]({{< relref "/develop/reference/protocol-spec#integers" >}}) or [null replies]({{< relref "/develop/reference/protocol-spec#nulls" >}}), where each element is the array's new size, or `null` if the matching value is not an array. With `.`-based path argument: [Integer reply]({{< relref "/develop/reference/protocol-spec#integers" >}}) representing the array's new size, or [null reply]({{< relref "/develop/reference/protocol-spec#nulls" >}}) if the matching value is not an array. {{< /multitabs >}} ## See also [`JSON.ARRAPPEND`]({{< relref "commands/json.arrappend/" >}}) | [`JSON.ARRINDEX`]({{< relref "commands/json.arrindex/" >}}) ## Related topics * [RedisJSON]({{< relref "/develop/data-types/json/" >}}) * [Index and search JSON documents]({{< relref "/develop/ai/search-and-query/indexing/" >}})