I have a document in Document DB , I want to add a new item in array , how to do this?

Question

My Collection is having this type of document.

{
        "id": "65f7a7e9-dc99-4c3a-b9ed-6291a8986343",
        "Username": "[email protected]",
        "Password": "somepassword",
        "FullName": "Abhishek Gupta",
        "DateCreated": "2018-02-18T02:20:50.36367Z",
        "Type": "User",
        "WishList": [
            "18a67f77-5b1b-42f9-8361-bf481fe3a341",
            "3baf9376-1e7f-43af-bd15-0fb317edd95f",
            " << Add New Item HEre  >>"

        ]
    }

I simply want to add one more guid in WishList Array of id .

What is the efficient way to do this rather then updating whole document.

Jason · Accepted Answer · 2018-02-26 18:02:10Z

2

With the DocumentDB API, you could use a stored procedure to accomplish atomically adding a single item to the array. Stored procedures run within a transaction on the server. Here's a sample that implements something similar to the MongoDB 'update' command:

https://github.com/Azure/azure-documentdb-js-server/blob/master/samples/stored-procedures/update.js

Indeed, there are lots of fun samples here: https://github.com/Azure/azure-documentdb-js-server

answered Feb 26, 2018 at 18:02

Jason

3691 silver badge4 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

David Makogon · Accepted Answer · 2018-02-26 11:34:28Z

1

I'm assuming you're using the DocumentDB (SQL) API. That being the case: there is no "update" command or query syntax. Rather, you have to read your document, update it yourself (e.g. modifying your JSON array), and replace the document.

The only way to avoid this type of modification would be to move your array elements to separate documents that you would need to link somehow (like with an id in the separate wishlist document, referencing your primary document's id, 65f7a7e9-dc99-4c3a-b9ed-6291a8986343 in your example).

Note: If you're using the MongoDB API, then you can use the native MongoDB update() command, such as:

db.coll.update( {username:"[email protected]"},
 { $push: { WishList: "NewWishListId" } })

edited Feb 26, 2018 at 11:34

answered Feb 26, 2018 at 11:23

David Makogon

71k22 gold badges145 silver badges204 bronze badges

Collectives™ on Stack Overflow

I have a document in Document DB , I want to add a new item in array , how to do this?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related