JSON.SET
Syntax
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
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
dragonfly> JSON.SET doc $ '{"a":2}'
OK
dragonfly> JSON.SET doc $.a '3'
OK
dragonfly> JSON.GET doc $
"[{\"a\":3}]"
Add a new value
dragonfly> JSON.SET doc $ '{"a":2}'
OK
dragonfly> JSON.SET doc $.b '8'
OK
dragonfly> JSON.GET doc $
"[{\"a\":2,\"b\":8}]"
Update multi-paths
dragonfly> JSON.SET doc $ '{"f1": {"a":1}, "f2":{"a":2}}'
OK
dragonfly> JSON.SET doc $..a 3
OK
dragonfly> JSON.GET doc
"{\"f1\":{\"a\":3},\"f2\":{\"a\":3}}"
See also
JSON.GET | JSON.MGET