JSON Array deserialization

Ankit Shukla

Hello All,

My JSON array is this:

{"reqData":[{"cctns_ps_cd":2044028,"fir_srno":371,"reg_year":2018},{"cctns_ps_cd":2044048,"fir_srno":309,"reg_year":2018},{"cctns_ps_cd":2044001,"fir_srno":165,"reg_year":2018},{"cctns_ps_cd":2044069,"fir_srno":547,"reg_year":2018},{"cctns_ps_cd":2044040,"fir_srno":326,"reg_year":2018},{"cctns_ps_cd":2044071,"fir_srno":213,"reg_year":2018}]}

I am trying to deserialize it like this:

var empObj = JsonConvert.DeserializeObject>(json1);

But fails.

This code works when json format is like this:

string json1 = @"[

{'cctns_ps_cd':2044071,'fir_srno':207,'reg_year':2018},

{'cctns_ps_cd':2044033,'fir_srno':187,'reg_year':2018},

{'cctns_ps_cd':2044044,'fir_srno':174,'reg_year':2018},

{'cctns_ps_cd':2044022,'fir_srno':201,'reg_year':2018}]";

Please help.

12 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mageshwaran R6y ago
Hi,
Try this Code:
JavaScriptSerializer ser = new JavaScriptSerializer();
var records = new ser.Deserialize>(jsonData);

public class Person
{
    public string Name;
    public int Age;
    public string Location;
}
public class Record
{
    public Person record;
}
0
Madan Shekar7y ago
for you json this will be the class

public class ReqData
{
public int cctns_ps_cd { get; set; }
public int fir_srno { get; set; }
public int reg_year { get; set; }
}
public class RootObject
{
public List reqData { get; set; }
}

List converteddata= arrayname.ToObject>();

//arrayname means your json array variable name

in case of any doubt pls ping me
0
Munesh Sharma7y ago
https://stackoverflow.com/questions/5502245/deserializing-a-json-file-with-javascriptserializer
0
Rajeesh Menoth7y ago
Hi,

As per the given reference what I understood the given json exactly to match with C# class. So please try that way.

Reference :

https://stackoverflow.com/questions/5502245/deserializing-a-json-file-with-javascriptserializer

https://www.codeproject.com/Tips/79435/Deserialize-JSON-with-Csharp.aspx
0
Ankit Shukla7y ago
Hello Sir,

What is the purpose of this
public List<Employee> reqData { get; set; }
instead of
public List<Employee> data { get; set; }

where we are using "reqData " or "data" in our code?
0
Sreekanth Reddy7y ago
Change the below property :

public List<Employee> data { get; set; }

Change to below wise :

public List<Employee> reqData { get; set; }

Mark as answer, If it helps.
Thank you.
0
Ankit Shukla7y ago
Sorry Sir.
Employees lstempobj = new JavaScriptSerializer().Deserialize(json1);

it returns null
0
Sreekanth Reddy7y ago
Change the following line :
Employees lstempobj = new JavaScriptSerializer().Deserialize(json1);
Chage to below :
We needs to give type.
Employees lstempobj = new JavaScriptSerializer().Deserialize(json1);

Mark as answer, If it helps.
Thank you.
0
Ankit Shukla7y ago
Hello Sir,

My complete code is this:

public class Employees
{
public List<Employee> data { get; set; }
}
public class Employee
{
public int cctns_ps_cd { get; set; }
public int fir_srno { get; set; }
public int reg_year { get; set; }
}
protected void Page_Load(object sender, EventArgs e)
{
// string json = @"{ 'cctns_ps_cd':2044028,'fir_srno':371,'reg_year':2018}";
string json1 = @"{'reqData':[
{'cctns_ps_cd':2044071,'fir_srno':207,'reg_year':2018},
{'cctns_ps_cd':2044033,'fir_srno':187,'reg_year':2018},
{'cctns_ps_cd':2044044,'fir_srno':174,'reg_year':2018},
{'cctns_ps_cd':2044022,'fir_srno':201,'reg_year':2018}]}";
Employees lstempobj = new JavaScriptSerializer().Deserialize(json1);
}

But get error till now. "Error 2 The type arguments for method 'System.Web.Script.Serialization.JavaScriptSerializer.Deserialize(string)' cannot be inferred from the usage. Try specifying the type arguments explicitly. "

0
Sreekanth Reddy7y ago
I had updated my answer, Please try again. In the place of facebookfriend place your class employee.

Thank you.
0
Ankit Shukla7y ago
Thank you Sir.

I am trying your code like this:

string json1 = @"{'reqData':[
{'cctns_ps_cd':2044071,'fir_srno':207,'reg_year':2018},
{'cctns_ps_cd':2044033,'fir_srno':187,'reg_year':2018},
{'cctns_ps_cd':2044044,'fir_srno':174,'reg_year':2018},
{'cctns_ps_cd':2044022,'fir_srno':201,'reg_year':2018}]}";
Employees lstempobj = new JavaScriptSerializer().Deserialize(json1);

But highlighted line gives error "
Error 2 Cannot implicitly convert type 'WCFJSON.WebForm1.FacebookFriend' to 'WCFJSON.WebForm1.Employees'"

Please clear.

0
Sreekanth Reddy7y ago
HI Ankit,

public class Employeess
{
public List data {get;set;}
}
public class Employee
{
public string cctns_ps_cd {get;set;}
public string fir_srno {get;set;}
public string reg_year{get;set;}
}
Now deserialize as like below :
Employeess lstempobj = new JavaScriptSerializer().Deserialize(result);
Now access them by foreac loop as like below :
foreach(var item in lstempobj.data)
{
var x = item.cctns_ps_cd
var y = item.fir_srno
var z = item.reg_year
}
Accept the answer, If it helps.
Thank you.
Accept the answer, If it helps.
Thank you.

0