Parse JSON data with JSON.NET

Question

There are a lot of questions about this out there, but I couldn't find a solution to my problem.

I have JSON that looks like this:

{
"index":[
  {
     "Color":"Blue",
     "URL":"SomeURL",

     "Persons":[
        {
           "name":"Charlie",
           "Country":"Denmark",
           "Security number":"25663456"
        }
     ],

     "Color":"Green",
     "URL":"SomeURL",

     "Persons":[
        {
           "name":"Putin",
           "Country":"Russia",
           "Security number":"78495832"
         }
       ],
    ],
  } 
 "total":"2"
}

The only JSON data I can access is index and total.

How do I access and print out ONLY name, Country or Color?

index is an array. index[0].Color will give you "Blue" etc... — Peter
– Peter, Commented Jan 9, 2015 at 16:08
FYI, this isn't valid JSON; you're closing a block before an array at the very end — Drew McGowen
– Drew McGowen, Commented Jan 9, 2015 at 16:09
@DrewMcGowen im sorry, since I wrote it down by looking at it, there could be some mistakes — Rickard B.
– Rickard B., Commented Jan 9, 2015 at 16:15
"since I wrote it down by looking at it" You wrote it out by hand? Why didn't you copy and paste? — weston
– weston, Commented Jan 9, 2015 at 16:27
@weston yeah, well the index array is several pages long, so I can't really copy and paste all that in here. therefore I made a few changes and shortened it a bit. — Rickard B.
– Rickard B., Commented Jan 9, 2015 at 16:32

Peter · Accepted Answer · 2015-01-09 16:21:58Z

2

index is an array. index[0].Color will give you "Blue" etc...

answered Jan 9, 2015 at 16:21

Peter

28k8 gold badges69 silver badges85 bronze badges

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

Comments

Ryan · Accepted Answer · 2015-01-09 17:38:19Z

1

The index is an array of objects. To access it, you'll have to loop over it, or access each element by its index in the array. Then, you'll have access to the properties you have set on it in the feed.

You can do something like this if you're using the JSON.Net lib:

dynamic jsonObj = JsonConvert.DeserializeObject<dynamic>(target)
foreach(var item in jsonObj.index)
{
    string color = item.Color;
}

answered Jan 9, 2015 at 17:38

Ryan

1,3682 gold badges10 silver badges15 bronze badges

Collectives™ on Stack Overflow

Parse JSON data with JSON.NET

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related