Find a certain string and replace it in a nested JObject?

Question

I have the following JSON object where I would like to search for the string: "Customer.CustomerAddress.Common" and replace it with "Customer.CustomerAddress.Common.S2" wherever it is present i.e. at all occurrences. How can this be done?

 {
   "$id": "1",
   "$type": "Customer.CustomerAddress, Customer.CustomerAddress.Common, Version=8.0.0.0, Culture=neutral, PublicKeyToken=f291d57f641e84e4",
   "FlatRate": 29.65,
   "AmountFinanced": 12402.2,
   "AmountUsed": 12302.2,
   "TotalPayment": 0,
   "CustomerAddress": {
      "$id": "2",
      "$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[System.Collections.Generic.List`1[[Customer.Customerbject, Customer.CustomerAddress.Common, Version=8.0.0.0, Culture=neutral, PublicKeyToken=f291d57f641e84e4]], mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]], mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089",
      "Items": {
         "$id": "3",
         "$type": "System.Collections.Generic.List`1[[Customer.Customerbject, Customer.CustomerAddress.Common, Version=8.0.0.0, Culture=neutral, PublicKeyToken=f291d57f641e84e4]], mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089",
         "$values": []
      },
      "Added": {
         "$id": "4",
         "$type": "System.Collections.Generic.List`1[[Customer.Customerbject, Customer.CustomerAddress.Common, Version=8.0.0.0, Culture=neutral, PublicKeyToken=f291d57f641e84e4]], mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089",
         "$values": []
      },
      "Removed": {
         "$id": "5",
         "$type": "System.Collections.Generic.List`1[[Customer.Customerbject, Customer.CustomerAddress.Common, Version=8.0.0.0, Culture=neutral, PublicKeyToken=f291d57f641e84e4]], mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089",
         "$values": []
      }
   }
   }

JSON.NET has some of the better documentation out there, with lots of samples. Please show what research you've done, and any attempts you've made to solve the problem yourself. — Heretic Monkey
– Heretic Monkey, Commented Sep 28, 2020 at 19:01

Alexander Petrov · Accepted Answer · 2020-09-28 20:39:22Z

1

We go through all the descendants, find properties with the desired name and value, then replace the value with the desired one.

var text = File.ReadAllText("test.json");
var json = JObject.Parse(text);

var props = json.Descendants()
    .OfType<JProperty>()
    .Where(p => p.Name == "$type" &&
        p.Value.ToString().Contains("Customer.CustomerAddress.Common"));

foreach (var p in props)
{
    p.Value = p.Value.Value<string>()
        .Replace("Customer.CustomerAddress.Common", "Customer.CustomerAddress.Common.S2");
}

File.WriteAllText("result.json", json.ToString());

answered Sep 28, 2020 at 20:39

Alexander Petrov

14.4k2 gold badges23 silver badges56 bronze badges

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

Collectives™ on Stack Overflow

Find a certain string and replace it in a nested JObject?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related