Deserializing nested JSON Object and foreaching it throught

Question

What I'am attempt to do is deserialize json and foreach through that object and get Name, Lastname, Id values from it. I think deserializing works but how can I foreach throught thoes values of that object and write out?

ResponseFromServer =

responseFromServer"{\"ReportName\":\"TestReport\",\"Results\":[
{
   \"Name\":\"Test1\",
   \"Lastname\":\"Test2\",
   \"ID\":\"1111111111\",
},{
   \"Name\":\"Test\",
   \"Lastname\":\"Test\",
   \"Id\":\"222222222\"
}
]}" string

Code so far:

object jsonObj = new System.Web.Script.Serialization.JavaScriptSerializer().DeserializeObject(responseFromServer);

var myObject = jsonObj.GetType().GetProperties();

foreach (var obj in myObject)
{
    Console.WriteLine(obj);
}

I suggest you use either strong typing to describe the expected object structure and dynamic feature. I haven't worked with MS serialiser, but JSON.NET is perfectly capable of supporting both options I've mentioned. — Vlad Stryapko
– Vlad Stryapko, Commented Apr 20, 2017 at 22:18

Sean Stayns · Accepted Answer · 2017-04-20 22:33:35Z

2

I recommend, that you create a class for your JSON, like this:

public class Result
{
    public string Name { get; set; }
    public string Lastname { get; set; }
    public string Id { get; set; }
}

public class ResponseClass
{
    public string ReportName { get; set; }
    public List<Result> Results { get; set; }
}

And with this class, you can convert your object and get the properties in a foreach, like the Lastname.

var yourObjectWithStructure = JsonConvert.DeserializeObject<ResponseClass>(responseFromServer,
            new JsonSerializerSettings
                {
                    NullValueHandling = NullValueHandling.Ignore
                });

 foreach (var result in objec.Results)
 {
     var id = result.Id;
     var lastName = result.Lastname;
     var name = result.Name;
 }

Update: You have "ID" and "Id" in your JSON response. I suggest, that "ID" should be "Id". Is that right?

edited Apr 20, 2017 at 22:33

answered Apr 20, 2017 at 22:27

Sean Stayns

4,2646 gold badges27 silver badges38 bronze badges

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

1 Comment

Sean Stayns Over a year ago

@user2809327 Could I answer your question? If, can you mark this as accepted, with the hook under the down vote button. It's helpful for the users of stack overflow, to see that your question is answered. And perhaps you can make this: stackoverflow.com/tour

Dakota Kincer · Accepted Answer · 2017-04-20 22:22:35Z

0

I would use newtonsoft and create a concrete object with a List Property

answered Apr 20, 2017 at 22:22

Dakota Kincer

4483 silver badges16 bronze badges

Comments

Alex · Accepted Answer · 2017-04-20 22:38:37Z

0

If you download the NewtonSoft framework:

Then you can create a class for your response...

public class Report
{
   public string ReportName {get; set;};
   public string TestReport {get; set;};
   public List<Person> Results {get; set;}
}
public class Person
{
   public string Name {get; set};
   public string LastName {get; set};
   public int ID {get; set;}
}

and you can deserialise directly into a list of that object class like this:

using System.Web.Script.Serialization;
===============

List<Person> persons = JavaScriptSerializer().Deserialize<List<Report>>(responseFromServer);

Foreach(Person p in persons)
{
   //stuff
}

edited Apr 20, 2017 at 22:38

answered Apr 20, 2017 at 22:33

Alex

2762 silver badges8 bronze badges

4 Comments

Sean Stayns Over a year ago

The ReportName is missing in your answer.

Alex Over a year ago

Thanks, spotted that just as I hit post...fixing it now :)

Sean Stayns Over a year ago

I think then it's similar with my answer, but it's okay. ;)

Brian Rogers Over a year ago

JavaScriptSerializer is not part of Json.Net; it is built into the .NET framework (that is why the namespace starts with System.Web). If you want to use Json.Net, then you should call JsonConvert.DeserializeObject<T> instead. It is in the Newtonsoft.Json namespace.

Collectives™ on Stack Overflow

Deserializing nested JSON Object and foreaching it throught

3 Answers 3

1 Comment

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related