Question 109010 in Json Question posted in
Our archive of expertly curated questions and answers provides insights and solutions to common problems related to this popular data interchange format. From parsing and manipulating JSON data to integrating it with various programming languages and web services, our archive has got you covered. Start exploring today and take your JSON skills to the next level

Filtering Json response updating mongodb database

I’m trying to filter a json response and use the filtered response to update several documents in my mongodb collection. The Json response looks like this:

{"88996940":{"charge":"5","start_count":"10","status":"Completed","remains":"90","currency":"USD"},
"88996961":{"charge":"8","start_count":"50","status":"Completed","remains":"50","currency":"USD"},
"88999796":{"charge":"7","start_count":"80","status":"Completed","remains":"20","currency":"USD"}}

"88996940","88996961" and "88999796" are the order id’s.

I want to filter the values of "start_count", "status" and "remains".

I tried parsing them but it only works if there is only one order id, otherwise the response is "null":

JObject responseObject = JObject.Parse(responseContent);
orderStartCount = responseObject1["start_count"].ToString();
orderStatus = responseObject1["status"].ToString();
orderRemains = responseObject1["remains"].ToString();

I also used the following code to update a single mongodb document but I don’t know how to do it with multiple documents and different values.

var filterSingle = Builders<BsonDocument>.Filter.Eq("orderID", orderID);
var update = Builders<BsonDocument>.Update.Set("status", orderStatus)
                                   .Update.Set("start_count", orderStartCount)
                                   .Update.Set("remains", orderRemains);
MyCollection.UpdateOne(filterSingle, update);
Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    Fixed the issue myself, I just had to create a loop through the response and extract the single values, here is the code:

    JObject responseObject = JObject.Parse(responseContent);

foreach (var order in responseObject)
{
    string orderID = order.Key;
    string orderStartCount = order.Value["start_count"].ToString();
    string orderStatus = order.Value["status"].ToString();
    string orderRemains = order.Value["remains"].ToString();

    
    var filter = Builders<BsonDocument>.Filter.Eq("orderID", orderID);
    var update = Builders<BsonDocument>.Update.Set("status", orderStatus)
                                             .Set("start_count", orderStartCount)
                                             .Set("remains", orderRemains);
    MyCollection.UpdateOne(filter, update);
}

  2. 0

    Your JSON object is not a collection; it’s a dictionary.

    A collection would be:

    [{"charge":"5","start_count":"10","status":"Completed","remains":"90","currency":"USD"},{"charge":"8","start_count":"50","status":"Completed","remains":"50","currency":"USD"},{"charge":"7","start_count":"80","status":"Completed","remains":"20","currency":"USD"}]

    The differences are:

    • A collection is enclosed in [] brackets, whereas dictionary is an object {}.
    • A collection has keyless objects: [{},{},{}], a dictionary requires key-value pair for every object: {"": {}, "": {}, "": {}}

    TL:DR; Deserialise your JSON into Dictionary<int, Entity>, where Entity is an item of your mongoDB collection.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search