deserialize part of json string (array) in c#

Question

I have a json string like this:

{  
"Results":[  
  {  
   "attr1": "value1",
   "attr2": "value2",
   "A": "value_a",
   "B": "value_b",
   "C": "value_c", 
   "GuestValues":[  
        {  
            "A": "value_a",
            "B": "value_b",
            "C": "value_c"
        },
        {  
            "A": "value_a",
            "B": "value_b",
            "C": "value_c"
        },
        {  
            "A": "value_a",
            "B": "value_b",
            "C": "value_c"
        }
}
],
"TotalResults":1,
"MilliSeconds":11
}

I want to deserialize only the GuestValues array. I created a class like this:

public class GuestValue
{
    public string A;
    public string B;
    public string C;
}

public class GuestValueResult
{
    public List<GuestValue> GuestValues { get; set; }
    public in TotalResults { get; set; }
}

And call it like this:

GuestValueResult guestValues = JsonConvert.DeserializeObject<GuestValueResult>(jsongString);

But it doesn't work. I tried a lot, once somehow, it only gives me back the first "A", "B", "C" in the jsonString, the one above the "GuestValues", I don't want that group of data. I only want those inside "GuestValues". Please help.

What exact JSON string do you pass in? It would be easier to write the JSON class for the complete JSON string, I don't think the deserializer is nice enough to check what part of the string it can serialize and give that back to you. — Maximilian Gerhardt
– Maximilian Gerhardt, Commented May 19, 2016 at 22:31
Also see: newtonsoft.com/json/help/html/SerializingJSONFragments.htm — Evan Trimboli
– Evan Trimboli, Commented May 19, 2016 at 22:42
Your JSON is invalid. You're missing a ] before the ending } ], "TotalResults":1, "MilliSeconds":11 }. I assume this is a typo? — dbc
– dbc, Commented May 19, 2016 at 22:51

Thomas Levesque · Accepted Answer · 2016-05-22 20:08:58Z

18

You can use Linq to JSON (part of JSON.NET) to access the relevant node, then deserialize it:

var root = JObject.Parse(jsonString);
var guestValues = root["Results"][0]["GuestValues"].ToObject<GuestValue[]>();

edited May 22, 2016 at 20:08

answered May 19, 2016 at 22:57

Thomas Levesque

294k73 gold badges639 silver badges769 bronze badges

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

3 Comments

Brian Rogers Over a year ago

Actually it should be ToObject<List<GuestValue>> shouldn't it? (As opposed to GuestValueResult)

Thomas Levesque Over a year ago

@BrianRogers, ah, yes, I got them mixed up... thanks

Thomas Levesque Over a year ago

Ah, yes, I missed the array in the JSON... fixed

Bogdan Beda · Accepted Answer · 2016-05-19 22:49:20Z

6

I don't know how the code you posted returns any useful value at all given that you have an Results array which is not mapped.

You need to create another class like this

 public class ResultsResult
 {
    public GuestValueResult[] Results { get; set; }
 }

And then deserialize using the class

 ResultsResult guestValues = JsonConvert.DeserializeObject<ResultsResult>(jsongString);

You'll then get what you expect.

answered May 19, 2016 at 22:49

Bogdan Beda

7886 silver badges12 bronze badges

2 Comments

Carrie Over a year ago

this works, but it makes me having 3 classes which is not so cool. I'll upvote your answer. Thanks!

Bogdan Beda Over a year ago

I thought that was the direction you wanted to take, given your existing code. Use what's best for your scenario. Thanks!

Collectives™ on Stack Overflow

deserialize part of json string (array) in c#

2 Answers 2

3 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related