Parse Json key/values of a key's value using JObject in C#

Question

I am trying to get the sub key\values of a key's value. What I am trying to accomplish is to remove the elements that are empty or have "-" or have "N/A". I can not seem to figure out out to iterate over the values to search.

{
  "name": {
    "first": "Robert",
    "middle": "",
    "last": "Smith"
  },
  "age": 25,
  "DOB": "-",
  "hobbies": [
    "running",
    "coding",
    "-"
  ],
  "education": {
    "highschool": "N/A",
    "college": "Yale"
  }
}

Code:

JObject jObject = JObject.Parse(response);

foreach (var obj in jObject)
{
    Console.WriteLine(obj.Key);
    Console.WriteLine(obj.Value);
}

I am trying to search "first":"Robert","middle":"","last":"Smith"

Pavel Anikhouski · Accepted Answer · 2020-05-14 16:04:19Z

2

You can use Descendants method to get child tokens of type JProperty, then filter their values and print them or remove one by one

var properties = json.Descendants()
    .OfType<JProperty>()
    .Where(p =>
    {
        if (p.Value.Type != JTokenType.String)
            return false;

        var value = p.Value.Value<string>();
        return string.IsNullOrEmpty(value);
    })
    .ToList();

    foreach (var property in properties) 
        property.Remove();

    Console.WriteLine(json);

Gives you the following result (with "middle": "" property removed)

{
  "name": {
    "first": "Robert",
    "last": "Smith"
  },
  "age": 25,
  "DOB": "-",
  "hobbies": [
    "running",
    "coding",
    "-"
  ],
  "education": {
    "highschool": "N/A",
    "college": "Yale"
  }
}

You can also add more conditions to return statement, like return string.IsNullOrEmpty(value) || value.Equals("-"); to remove "DOB": "-" property as well

edited May 14, 2020 at 16:04

answered May 14, 2020 at 7:30

Pavel Anikhouski

23.6k12 gold badges66 silver badges81 bronze badges

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

2 Comments

FirstElement Over a year ago

The next question is how to loop over the result you have and remove the element that has a value of "" such as "middle"?

Pavel Anikhouski Over a year ago

@FirstElement just call property.Remove(), but materialize the result to list to avoid enumeration was changed exception, I've updated an answer

pakeha_by · Accepted Answer · 2020-05-14 05:20:58Z

1

You can recursively iterate JObject properties:

    private static void IterateProps(JObject o)
    {
        foreach (var prop in o.Properties())
        {
            Console.WriteLine(prop.Name);
            if (prop.Value is JObject)
            {
                IterateProps((JObject)prop.Value);
            }
            else
            {
                Console.WriteLine(prop.Value);
            }
        }
    }

answered May 14, 2020 at 5:20

pakeha_by

2,2841 gold badge16 silver badges8 bronze badges

Collectives™ on Stack Overflow

Parse Json key/values of a key's value using JObject in C#

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related