JSON.ARRINSERT

    Insert the values into the array at path before the index (shifts to the right)

    Required arguments

    key

    is key to modify.

    value

    is one or more values to insert in one or more arrays.

    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 .

    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.

    is JSONPath to specify. Default is root $.

    Return value

    JSON.ARRINSERT returns an array of integer replies for each path, the array’s new size, or nil, if the matching JSON value is not an array. For more information about replies, see .

    Create a document for noise-cancelling headphones in black and silver colors.

    1. dragonfly> 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"]}'
    2. OK

    Add color blue to the end of the colors array. returns the array’s new size.

    Return the new length of the colors array.

    1. dragonfly> JSON.GET item:1
    2. "{\"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\"]}"

    Get the list of colors for the product.

    Insert two more colors after the second color. You now have five colors.

    1. dragonfly> JSON.ARRINSERT item:1 $.colors 2 '"yellow"' '"gold"'

    Get the updated list of colors.

    See also