Proper way to deserialize multidimensional JSON using JSON.NET in C#

Question

I was researching during a lot of time about how deserialize this json file:

{  
"clients":[  
  {  
     "id":"a0ece5db-cd14-4f21-812f-966633e7be86",
     "name":"Britney",
     "email":"[email protected]",
     "role":"admin"
  },
  {  
     "id":"e8fd159b-57c4-4d36-9bd7-a59ca13057bb",
     "name":"Manning",
     "email":"[email protected]",
     "role":"admin"
  },
  {  
     "id":"a3b8d425-2b60-4ad7-becc-bedf2ef860bd",
     "name":"Barnett",
     "email":"[email protected]",
     "role":"user"

     [ ... ]

This is my controller code:

 using (var sr = new StreamReader(response.GetResponseStream()))
{
    receivedData = sr.ReadToEnd();
}

var userList = JsonConvert.DeserializeObject<List<User>>(receivedData);

foreach (User us in userList)
{
   //this method just print the user Id
   MsgBox(u.Id);
}

So, I am absolutely stuck because the Json

JsonConvert.DeserializeObject>(receivedData); launch the following exception:

Newtonsoft.Json.JsonSerializationException: 'Cannot deserialize the current JSON object (e.g. {"name":"value"}) into type 'System.Collections.Generic.List`1[InsuranceWebAPI.Models.User]' because the type requires a JSON array (e.g. [1,2,3]) to deserialize correctly.

I try to set the json data into an array and a list, but doesn't works. I know that maybe is a very beginner question but I am not used to work with Json and Json.net

Can any body help me to get the data into an array or List.

Thanks in advance to everybody and sorry if I don't understand properly the other questions about Json.net

Gilad Green · Accepted Answer · 2017-04-29 20:04:00Z

1

That is because your JSON format is not of a collection of users. It is of an object containing a property named clients which is a collection of users. See this model:

public class RootObject
{
    public IEnumerable<User> clients { get; set; }
}
public class User
{
    public string id { get; set; }
    public string name { get; set; }
    public string email { get; set; }
    public string role { get; set; }
}

And by executing this:

var data = JsonConvert.DeserializeObject<RootObject>(File.ReadAllText(receivedData));

edited Apr 29, 2017 at 20:04

answered Apr 29, 2017 at 16:23

Gilad Green

37.3k7 gold badges67 silver badges99 bronze badges

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

9 Comments

MadDev Over a year ago

Works! Buy I can't acces to the data as an array, maybe I asked a different thing excuseme, how can I manipulate the client data inside the data variable, to store it into a class?

Gilad Green Over a year ago

@MadDev - didn't understand current problem

Brian Rogers Over a year ago

@MadDev - if you need clients to be an array or list, you can change it from IEnumerable<User> to List<User> or User[] and it will still work.

MadDev Over a year ago

Forget get it @Gilad Green, Too much hours studying and working today :( you really help me man. A lot of thanks!

MadDev Over a year ago

Thats true @Gilad Green, seems that is more convenient to use the IEnumerable, finally the code works fine, now I have problems to populate with the data a TextArea hehehe... but this is another issue... ;-) If you can check it this is the link: stackoverflow.com/questions/43698982/…

|

Marcius Bezerra · Accepted Answer · 2017-04-29 17:09:28Z

0

Or..

        dynamic userList = JsonConvert.DeserializeObject(File.ReadAllText("file.js"));

        foreach (var user in userList.clients)
        {
            ///MessageBox.Show(user.id);
            Console.WriteLine(user.id);
        }

answered Apr 29, 2017 at 17:09

Marcius Bezerra

1491 gold badge2 silver badges11 bronze badges

Collectives™ on Stack Overflow

Proper way to deserialize multidimensional JSON using JSON.NET in C#

2 Answers 2

9 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

9 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related