c# how to count the amount of json values

Question

So, I am trying to count the amount of values in JSON using c#. The Json is:

{
  "Someid": 657442,
  "roles": [
    {
      "id": 3892751,
      "name": "Guest",
      "rank": 0,
      "memberCount": 0
    },
    {
      "id": 3892750,
      "name": "Fanz!<3",
      "rank": 1,
      "memberCount": 0
    },
    {
      "id": 3892749,
      "name": "Lead-Singer",
      "rank": 254,
      "memberCount": 0
    },
    {
      "id": 3892748,
      "name": "Drums",
      "rank": 255,
      "memberCount": 0
    }
  ]
}

I want to count the amount "roles". The JSON is just in a string variable. Help?

Deserialize it to the appropriate data structure, and read obj.Roles.Length? — CodeCaster
– CodeCaster, Commented Sep 10, 2019 at 12:38
I'd suggest starting with app.quicktype.io?share=IEs9emLGOZgseqkyggdt . — mjwills
– mjwills, Commented Sep 10, 2019 at 12:45

andyb952 · Accepted Answer · 2019-09-10 12:53:10Z

6

You can either use like this:

var token = JToken.Parse(input);
var roles= token.Value<JArray>("roles");
var count = roles.Count;

Or you can also use JsonPath:

var token = JToken.Parse(input);
var count = token.SelectTokens("$.roles[*]").Count();

But ideally, you should be serilizing into an object and then using the properties to get the Count:

public class Role
{
    public int id { get; set; }
    public string name { get; set; }
    public int rank { get; set; }
    public int memberCount { get; set; }
}

public class MyObject
{
    public int Someid { get; set; }
    public List<Role> roles { get; set; }
}

var item = JsonConvert.DeserializeObject<MyObject>(input);
var count = item.roles.Count;

edited Sep 10, 2019 at 12:53

answered Sep 10, 2019 at 12:42

andyb952

2,00913 silver badges29 bronze badges

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

2 Comments

Aaron Jonk Over a year ago

I get the following error: Object reference not set to an instance of an object.

andyb952 Over a year ago

With which example? And which line?

Collectives™ on Stack Overflow

c# how to count the amount of json values

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related