Remove specific properties from JSON object

Question

I have a JSON:

{
    "scbs_currentstatus": "",
      "scbs_primaryissue": "",
      "_umb_id": "Test",
      "_umb_creator": "Admin",
      "_umb_createdate": "0001-01-01 00:00:00",
      "_umb_updatedate": "0001-01-01 00:00:00",
      "_umb_doctype": "Test",
      "_umb_login": "Test",
      "_umb_email": "Test",
      "_umb_password": {
        "newPassword": "Test",
        "oldPassword": null,
        "reset": null,
        "answer": null
      },
      "_umb_membergroup": {
        " User": false,
        "Line User": true,
        "Callback User": false,
        "Su User": false,
        },
      "umbracoMemberComments": "Test",
      "umbracoMemberFailedPasswordAttempts": ""

    }

Iam trying to remove all the properties start with "umb_" .is this possible in json.net?

and output will be like:

{
        "scbs_currentstatus": "",
          "scbs_primaryissue": "",
           "umbracoMemberComments": "Test",
          "umbracoMemberFailedPasswordAttempts": ""
}

using remove i am able to to do it however not all at a time.

   result.Property("_umb_id").Remove();

any suggestion please?

amiry jd · Accepted Answer · 2016-03-29 08:47:28Z

29

You can parse the string first:

var temp =  JArray.Parse(json);
temp.Descendants()
    .OfType<JProperty>()
    .Where(attr => attr.Name.StartsWith("_umb_"))
    .ToList() // you should call ToList because you're about to changing the result, which is not possible if it is IEnumerable
    .ForEach(attr => attr.Remove()); // removing unwanted attributes
json = temp.ToString(); // backing result to json

UPDATE OR:

result.Properties()
    .Where(attr => attr.Name.StartsWith("_umb_"))
    .ToList()
    .ForEach(attr => attr.Remove());

UPDATE #2

You can specify more conditions in where clause:

.Where(attr => attr.Name.StartsWith("_umb_") && some_other_condition)

OR

.Where(attr => attr.Name.StartsWith("_umb_") || some_other_condition)

Or whatever you need.

edited Mar 29, 2016 at 8:47

answered Mar 29, 2016 at 7:14

amiry jd

27.7k31 gold badges121 silver badges222 bronze badges

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

1 Comment

Harshit Over a year ago

@javed. can we specify more than one condition in it?suppose we dont the fields contains "umbracoMember" in the property.

शेखर · Accepted Answer · 2022-01-23 04:47:33Z

0

In case JArray.Parse is not working, you can strongly type your object as follows:

var temp = (Newtonsoft.Json.Linq.JObject)JsonConvert.DeserializeObject(json);
temp.Descendants()
 .OfType<JProperty>()
 .Where(attr => attr.Name.StartsWith("_umb_"))
 .ToList() // you should call ToList because you're about to changing the result, which is not possible if it is IEnumerable
 .ForEach(attr => attr.Remove()); // removing unwanted attributes

edited Jan 23, 2022 at 4:47

शेखर

17.6k14 gold badges64 silver badges123 bronze badges

answered Dec 19, 2021 at 14:23

Joginder Tanikella

1361 silver badge9 bronze badges

Comments

Alfa Dhaval Thakkar · Accepted Answer · 2016-03-29 08:33:16Z

-3

I just ended up deserializing to JObject and recursively looping through that to remove unwanted fields. Here's the function for those interested.

private void removeFields(JToken token, string[] fields)
{
JContainer container = token as JContainer;
if (container == null) return;

List<JToken> removeList = new List<JToken>();
foreach (JToken el in container.Children())
{
    JProperty p = el as JProperty;
    string propertyName = p.hasOwnProperty(key);

    if (p != null && fields.Contains(p.propertyName) && p.propertyName.substring(0,4) == "_umb" )
    {
        removeList.Add(el);
    }
    removeFields(el, fields);
}

foreach (JToken el in removeList)
{
    el.Remove();
}
}

answered Mar 29, 2016 at 8:33

Alfa Dhaval Thakkar

14 bronze badges

Collectives™ on Stack Overflow

Remove specific properties from JSON object

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related