Deserialize a JSON array in C#

Question

I've a JSON string of this format:

[{
  "record":
          {
             "Name": "Komal",
             "Age": 24,
             "Location": "Siliguri"
          }
 },
 {
  "record":
          {
             "Name": "Koena",
             "Age": 27,
             "Location": "Barasat"
          }
 },
 {
  "record":
          {
             "Name": "Kanan",
             "Age": 35,
             "Location": "Uttarpara"
          }
 }
... ...
]

Fields in "record" can increase or decrease.

So, I've made classes like this:

public class Person
{
    public string Name;
    public string Age;
}

public class PersonList
{
    public Person record;
}

And trying to deserialize like this:

JavaScriptSerializer ser = new JavaScriptSerializer();

var r = ser.Deserialize<PersonList>(jsonData);

I'm doing something wrong. But unable to find. Can you please help?

Update:

Actually I was getting error "Invalid JSON Primitive: ." due to I was getting the string reading a file with this code:

public static bool ReadFromFile(string path, string fileName, out string readContent)
{
   bool status = true;
    
   byte[] readBuffer = null;
   try
   {
      // Combine the new file name with the path
      string filePath = System.IO.Path.Combine(path, fileName);
      readBuffer = System.IO.File.ReadAllBytes(filePath);
   }
   catch (Exception ex)
   {
       status = false;
   }
    
   readContent = (null != readBuffer) ? Utilities.GetString(readBuffer) : string.Empty;
    
   return status;
}

Now I'm reading the file with this:

using (StreamReader r = new StreamReader("E:\\Work\\Data.json"))
{
   string json = r.ReadToEnd();
   result = JsonConvert.DeserializeObject<List<PersonList>>(json);
}

It's working fine.

How is .net supposed to know that you want a Person object for a javascript object named "record"? — Bazzz
– Bazzz, Commented May 31, 2013 at 12:08
If it's an option, I highly recommend using JSON.NET. Then you could just call something like JsonConvert.DeserializeObject<List<Person>>(jsonData) — valverij
– valverij, Commented May 31, 2013 at 12:31
I had a similar issue till @valverij comment above fixed my issue. <List<ListsOfJsons>> — user2025696
– user2025696, Commented Oct 28, 2015 at 19:31

BenKoshy · Accepted Answer · 2019-09-10 01:56:00Z

56

This should work...

JavaScriptSerializer ser = new JavaScriptSerializer();
var records = new ser.Deserialize<List<Record>>(jsonData);

public class Person
{
    public string Name;
    public int Age;
    public string Location;
}
public class Record
{
    public Person record;
}

edited Sep 10, 2019 at 1:56

BenKoshy

36.1k15 gold badges119 silver badges88 bronze badges

answered May 31, 2013 at 12:57

I4V

35.4k6 gold badges71 silver badges82 bronze badges

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

Comments

Litisqe Kumar · Accepted Answer · 2018-07-16 11:19:07Z

15

This code is working fine for me,

var a = serializer.Deserialize<List<Entity>>(json);

edited Jul 16, 2018 at 11:19

Litisqe Kumar

2,5654 gold badges28 silver badges41 bronze badges

answered May 31, 2013 at 12:33

Hitesh

3,9902 gold badges18 silver badges21 bronze badges

Comments

Alejandro · Accepted Answer · 2018-05-15 18:37:38Z

1

[JsonProperty("name")]
public string name { get; set; }
[JsonProperty("Age")]
public int required { get; set; }
[JsonProperty("Location")]
public string type { get; set; }

and Remove a "{"..,

strFieldString = strFieldString.Remove(0, strFieldString.IndexOf('{'));

DeserializeObject..,

   optionsItem objActualField = JsonConvert.DeserializeObject<optionsItem(strFieldString);

edited May 15, 2018 at 18:37

Alejandro

7,9274 gold badges40 silver badges70 bronze badges

answered May 16, 2014 at 3:46

Mohan Kumar

6577 silver badges8 bronze badges

Collectives™ on Stack Overflow

Deserialize a JSON array in C#

3 Answers 3

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Linked

Related