Parsing JSON using LINQ

Question

My json data are as below.

{
   "data":{
      "foo":{
         "sfoo":"1",
         "active":1
      },
      "foo":{
         "sfoo":"2",
         "active":0
      },
      "v":"v1"
   }
}

I try to get the value from json with this code:

JObject _JObject = JObject.Parse(_JsonString);

var _JItems = _JObject.SelectToken("data[0].foo")
            .Select(s => new
            {
                _Sfoo = (string)s.SelectToken("sfoo"),
                _WhereClause = (string)s.SelectToken("active")
            })
    .Where(w => w._WhereClause == "1");

foreach (var _JItem in _JItems)
{
    MessageBox.Show(_JItem._Sfoo.ToString());
}

I am getting an error such as "Additional information: Value cannot be null."

Thank you in advance.

data is not an array, and the first foo property of the object data will be overwritten by the second foo property. Maybe you meant to make data an array? — Andrew Whitaker
– Andrew Whitaker, Commented Jun 25, 2014 at 16:04

Andrew Whitaker · Accepted Answer · 2014-06-25 16:21:38Z

1

As I commented, data is an object ({}) and not an array ([]). You're seeing an error because the object data has no property 0 defined.

It seems like you'd want your JSON to look something like this instead:

{
   "data":{
      "foo":[
         {
            "sfoo":"1",
            "active":1
         },
         {
            "sfoo":"2",
            "active":0
         }
      ],
      "v":"v1"
   }
}

Then your parsing code would look like this:

var _JItems = _JObject.SelectToken("data.foo")
        .Select(s => new
        {
            _Sfoo = (string)s.SelectToken("sfoo"),
            _WhereClause = (string)s.SelectToken("active")

        })
        .Where(w => w._WhereClause == "1");

answered Jun 25, 2014 at 16:21

Andrew Whitaker

126k32 gold badges296 silver badges308 bronze badges

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

3 Comments

Kerberos Over a year ago

Thank you but it seems valid when i check on this url jsonformatter.curiousconcept.com

iamkrillin Over a year ago

@Kerberos there is a difference between syntactically correct and correct based on your intent.

Andrew Whitaker Over a year ago

@Kerberos: As iamkrillin says, your JSON is valid, you're just not accessing it correctly.

Collectives™ on Stack Overflow

Parsing JSON using LINQ

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related