CODEWITHSUNDEEP
marklogicmarklogic-8
Avinash Shukla
Avinash Shukla

Reputation: 201

Add new key-value pair to JSON created using object-node constructor

I want to add a new key-value pair to JSON created using object-node constructor.

Object node:

object-node {
     "status": "success",
     "categories": "cat"
  }

XQuery code to insert new pair:

let $outputJson :=
      object-node {
        "status": "success",
        "categories": "cat"
      }
return ( map:put($outputJson, "str", "xyz"), $outputJson )

The above expression fails. Is there a way to insert a new pair?

Upvotes: 3

Views: 284

Answers (2)

grtjn
grtjn

Reputation: 20414

It probably makes more sense to start off with json:object when constructing json docs dynamically, but in case you need to pull json from the database, and manipulate that, this might be a useful trick:

let $outputJson :=
      object-node {
        "status": "success",
        "categories": "cat"
      }
return xdmp:to-json(map:with(xdmp:from-json($outputJson), "str", "xyz"))

HTH!

Upvotes: 2

Mads Hansen
Mads Hansen

Reputation: 66783

It is annoying that the object-node() can't be manipulated as you might expect, but the object-node() is not mutable.

Instead use json:object(), which will provide a specialized mutable map:

let $outputJson :=
      json:object() 
      => map:with("status", "success") 
      => map:with("categories", "cat")
      
return ( map:put($outputJson, 'str', 'xyz'), $outputJson )

Upvotes: 2

Related Questions