Find the correct object in JSON and edit values of this object C# Json.Linq

Question

I have the following JSON file (list.json):

[
    {
        "groupID": "12345",
        "subID": "71",
        "stock": false,
        "price": "32.21"
    },
    {
        "groupID": "12345",
        "subID": "25",
        "stock": false,
        "price": "12.94"
    }
]

What a I like to do is, that I edit the "stock" value of one specific object. So if the value of stock is false I like to change it to true and if its true I like to change to false.

I tried to start but I have already at the beginning a big problem. I get already while the parsing a Newtonsoft.Json.JsonReaderException : 'Error reading JObject from JsonReader. Current JsonReader item is not an object: StartArray. Path '', line 1, position 1.'. I believe it happens because the JSON starts with an array.

My method:

public void EditJSON (string GroupID, string SubID)
        {
            JObject JSONnew = JObject.Parse(list.json);

            if (*stock is true*)
            {
              *change stock to false*
            } 

            if (*stock is false*)
            {
              *change stock to ture*
            }

        }

How I can find in the JSON the correct object by using the GroupID and the SubID and edit the value of stock from false to true or the opposit?

I mean find the object in an array

bmw_58
– bmw_58

2020-05-22 03:26:55 +00:00
Commented May 22, 2020 at 3:26 — bmw_58
– bmw_58, Commented May 22, 2020 at 3:26

pujangga malam · Accepted Answer · 2020-05-21 18:54:41Z

1

Try this.

        var json = "[{\"groupID\":\"12345\",\"subID\":\"71\",\"stock\":false,\"price\":\"32.21\"},{\"groupID\":\"12345\",\"subID\":\"25\",\"stock\":false,\"price\":\"12.94\"}]";
        var data = JsonConvert.DeserializeObject<List<StockData>>(json);
        foreach (var item in data.Where(d => d.Stock == false))
        {
            item.Stock = true;
        }

Where the StockData class will be:

public class StockData
{
    public string GroupID { get; set; }
    public string SubID { get; set; }
    public bool Stock { get; set; }
    public string Price { get; set; }
}

Good luck!

answered May 21, 2020 at 18:54

pujangga malam

696 bronze badges

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

Comments

Pavel Anikhouski · Accepted Answer · 2020-05-22 21:17:59Z

0

You should parse your JSON to JArray, then filter items by groupID and subID values. Finally enumerate the filtered items one by one and change a stock value, if needed

var items = JArray.Parse(jsonString);
var filtered = items.Where(i => i["groupID"]?.Value<int>() == 12345 && i["subID"]?.Value<int>() == 25);
foreach (var item in filtered)
{
    var stock = item["stock"]?.Value<bool>();
    if (stock == null)
        continue;

    if (stock.Value)
        item["stock"] = false;
    else
        item["stock"] = true;
}

Console.WriteLine(items);

edited May 22, 2020 at 21:17

answered May 21, 2020 at 17:15

Pavel Anikhouski

23.6k12 gold badges66 silver badges81 bronze badges

5 Comments

bmw_58 Over a year ago

Works so far. However, we both have one small fault. As soon as "stock" is changed to false, it will be changed back to true in the next if block. I think with a double if block with break it is better

bmw_58 Over a year ago

There's one more problem. In the end only this array range is changed and not this array range in the whole JSON. The only thing I can think of now is to delete this array in the json and add at the end the edited array again. Is there a more clever solution?

Pavel Anikhouski Over a year ago

You can split json parsing and filtering, source array items will be changed as well after loop run

bmw_58 Over a year ago

Okey will try it later. Thank you for the feedback.

bmw_58 Over a year ago

Nope sorry it change only the stock value in item and dont overwrite the items. Did you try it yourself already?

Collectives™ on Stack Overflow

Find the correct object in JSON and edit values of this object C# Json.Linq

2 Answers 2

Comments

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related