Search code examples
node.jsjsonmongodbejsmlab

Add key-value pair to collection in mLab

I have a collection in mLab and need to add a JSON key-value pair.
What are some ways to do this for all documents in the collection,
without editing each document manually. 

    {
        "_id": {
            "$oid": "5b76acb78e7ea90016b46e6p"
        },
        "title": "document foo",
        "new key": "new value",

    }
Solution

  • You need to use the option m=true which updates all the documents matching criteria. And if you don't pass the criteria basically it updates every document in the collection.

    $.ajax( { url: 'https://api.mlab.com/api/1/databases/your-db/collections/your-collection?apiKey=yourAPIKey&m=true',
          data: JSON.stringify( { "$set" : { "new key" : "new value" } } ),
          type: "PUT",
          contentType: "application/json" } );

    Documentation