How can I change the value of a JSON property using Json.NET?

Question

I would like to modify the values AREA1 & AREA2 from the parsed JObject of the below JSON string.

How can I retrieve the elements with jObject.SelectTokens() and edit it them?

{
   "summary":{
      "summaryDataTable":{
         "id":"summaryDataTable",
         "type":"dataTable",
         "source":"/SmartScreen/SummaryFw",
         "columns":[
            {
               "name":"CreateDate",
               "title":"AREA1",
               "filterable":false
            },
            {
               "name":"CreateUser",
               "title":"AREA2",
               "filterable":false
            }
         ],
         "options":{
            "showFilter":false
         }
      }
   }
}

Answer 1

If you just need to modify it for the above JSON model, use JObject.SelectToken to get the parent objects using the JSON path & then set the value like below:

var data = JObject.Parse(json);

var firstColumn = data.SelectToken("summary.summaryDataTable.columns[0]");
var secondColumn = data.SelectToken("summary.summaryDataTable.columns[1]");
firstColumn["title"] = "replacedTitle1";
secondColumn["title"] = "replacedTitle2";

Output:

{
  "summary": {
    "summaryDataTable": {
      "id": "summaryDataTable",
      "type": "dataTable",
      "source": "/SmartScreen/SummaryFw",
      "columns": [
        {
          "name": "CreateDate",
          "title": "replacedTitle1",
          "filterable": false
        },
        {
          "name": "CreateUser",
          "title": "replacedTitle2",
          "filterable": false
        }
      ],
      "options": {
        "showFilter": false
      }
    }
  }
}

Answer 2

You can try this

var json= ...your json;

var o= JObject.Parse(json);
var columns=o.SelectToken("summary.summaryDataTable.columns");

columns[0]["title"]="newTitle1";
columns[1]["title"]="newTitle2";

json = o.ToString(Newtonsoft.Json.Formatting.Indented);