JSON.SET

Syntax

  1. JSON.SET key path value [NX | XX]

Time complexity: O(M+N) when path is evaluated to a single value where M is the size of the original value (if it exists) and N is the size of the new value, O(M+N) when path is evaluated to multiple values where M is the size of the key and N is the size of the new value

ACL categories: @json

Set the JSON value at path in key

Examples

Required arguments

key

is key to modify.

value

is value to set at the specified path

Optional arguments

path

is JSONPath to specify. Default is root $. For new Redis keys the path must be the root. For existing keys, when the entire path exists, the value that it contains is replaced with the json value. For existing keys, when the path exists, except for the last element, a new child is added with the json value.

Adds a key (with its respective value) to a JSON Object (in a RedisJSON data type key) only if it is the last child in the path, or it is the parent of a new child being added in the path. Optional arguments NX and XX modify this behavior for both new RedisJSON data type keys as well as the JSON Object keys in them.

NX

sets the key only if it does not already exist.

XX

sets the key only if it already exists.

Return value

JSET.SET returns a simple string reply: OK if executed correctly or nil if the specified NX or XX conditions were not met. For more information about replies, see Redis serialization protocol specification.

Examples

Replace an existing value

  1. dragonfly> JSON.SET doc $ '{"a":2}'
  2. OK
  3. dragonfly> JSON.SET doc $.a '3'
  4. OK
  5. dragonfly> JSON.GET doc $
  6. "[{\"a\":3}]"

Add a new value

  1. dragonfly> JSON.SET doc $ '{"a":2}'
  2. OK
  3. dragonfly> JSON.SET doc $.b '8'
  4. OK
  5. dragonfly> JSON.GET doc $
  6. "[{\"a\":2,\"b\":8}]"

Update multi-paths

  1. dragonfly> JSON.SET doc $ '{"f1": {"a":1}, "f2":{"a":2}}'
  2. OK
  3. dragonfly> JSON.SET doc $..a 3
  4. OK
  5. dragonfly> JSON.GET doc
  6. "{\"f1\":{\"a\":3},\"f2\":{\"a\":3}}"

See also

JSON.GET | JSON.MGET