Parsing Json string using Json.NET

Question

I am using Json.NET in order to parse a json string but when i try to use SelectToken it returns null. Also it seems that Json.NET read the json string as 1 node

here is the JSON

[
   [{
      "input_index":0,
      "candidate_index":0,
      "delivery_line_1":"124 Main St",
      "last_line":"Cambridge MA 02138-5813",
      "delivery_point_barcode":"021385813991",
      "components":{
         "primary_number":"125",
         "street_name":"Main",
         "street_suffix":"St",
         "city_name":"Cambridge",
         "state_abbreviation":"MA",
         "zipcode":"02138",
         "plus4_code":"5813",
         "delivery_point":"99",
         "delivery_point_check_digit":"1"
      },
      "metadata":{
         "record_type":"H",
         "county_fips":"25017",
         "county_name":"New York",
         "carrier_route":"C025",
         "congressional_district":"08",
         "building_default_indicator":"Y"
      },
      "analysis":{
         "dpv_match_code":"D",
         "dpv_footnotes":"AAN1",
         "dpv_cmra":"N",
         "dpv_vacant":"N",
         "ews_match":false,
         "footnotes":"A#H#N#"
      }
   }]
]

and here is the code

JArray o = JArray.Parse(page);
string something = (string)o.SelectToken("county_name");

However it just returns me null and i am totally confused as there is something wrong with JSON.NET parsing this Json string

It's an array... an array doesn't have a county_name...

Jeff Mercado
– Jeff Mercado

2013-07-07 19:40:49 +00:00
Commented Jul 7, 2013 at 19:40 — Jeff Mercado
– Jeff Mercado, Commented Jul 7, 2013 at 19:40
So how could i retrieve it...

Roman Ratskey
– Roman Ratskey

2013-07-07 19:43:36 +00:00
Commented Jul 7, 2013 at 19:43 — Roman Ratskey
– Roman Ratskey, Commented Jul 7, 2013 at 19:43
Also they are double arrays. outer and inner one.

Roman Ratskey
– Roman Ratskey

2013-07-07 19:44:54 +00:00
Commented Jul 7, 2013 at 19:44 — Roman Ratskey
– Roman Ratskey, Commented Jul 7, 2013 at 19:44

Community · Accepted Answer · 2017-05-23 10:25:33Z

2

See: What is the JSON.NET equivalent of XML's XPath, SelectNodes, SelectSingleNode?

var data = GetJson();

//You can use the SelectToken to get the value similar to XPath.
var value = JArray.Parse(data)
                  .SelectToken("[0][0].metadata.county_name")
                  .Value<string>();

This can be extended to support multiple elements:

var jArray = JArray.Parse(data);
var countyNames = new List<string>();

foreach(var element in jArray.SelectToken("[0]"))
{
    var value = element.SelectToken("metadata.county_name").Value<string>();

    countyNames.Add(value);
}

edited May 23, 2017 at 10:25

CommunityBot

11 silver badge

answered Jul 7, 2013 at 20:00

Dustin Kingen

21.4k7 gold badges55 silver badges94 bronze badges

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

8 Comments

Roman Ratskey Over a year ago

what is the use of [0][0]

Dustin Kingen Over a year ago

First element of the unnamed outer array and first element of the unnamed inner array.

Roman Ratskey Over a year ago

But i still get null using this code idk why!. i am sorry but could you have a little patience with me to solve this

Dustin Kingen Over a year ago

Is you are getting null then either the JSON that you are receiving is different, it does not contain the same property, or there is a typo in your code.

Dustin Kingen Over a year ago

Is that the complete JSON?

|

Nate Diamond · Accepted Answer · 2013-07-07 19:49:11Z

0

So, the issue is that you basically have a wrapper around your actual object. You basically have:

Array of objects
  Object
    Metadata
    etc

So basically, get the first JToken out of the JArray and access the metadata from there.

answered Jul 7, 2013 at 19:49

Nate Diamond

5,5652 gold badges33 silver badges59 bronze badges

1 Comment

Roman Ratskey Over a year ago

Please make you answer richer with a code so another people after me could find it useful

Collectives™ on Stack Overflow

Parsing Json string using Json.NET

2 Answers 2

8 Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

8 Comments

1 Comment

Linked

Related