Getting cannot access child key error from the Web API

Question

Hi friends, I am getting response content from the Web API using Jobject Jobject obj=JObject.Parse(responsecontent); but always I am getting the following error. cannot access child key value on newtonsoft.json.linq.jvalue My Json Sample : { "jsonrpc": "2.0", "id": null, "result": "{\"status\": \"success\", \"res\": [{\"Rollnumber\": \"1581\", \"Receipt Time\": \"13:38:32\"},{\"Rollnumber\": \"1582\", \"Receipt Time\": \"15:10:32\"}]}} I tried with Jobjects and Jtokens I am getting the result in the object but I am unable get the child object res\ token object values to insert this data into the sql server datatable. I tried with res keyword and using stringbuilder I am concatinating \ to res i.e res\ keyword. I tried different ways but always getting the cannot access child key value on newtonsoft.json.linq.jvalue error. Please tell me how to get the res object and using loop I need to insert res object values in the sql server datatable.

Shantanu Pandey · Answer

try using below class and json convert. var result=JsonConvert.DeserializeObject (responsecontent); public class response { public string jsonrpc{ get ; set ;} public string id { get ; set ;} public result result{ get ; set ;} } public class result{ public string status{ get ; set ;} public List res{ get ; set ;} } public class res{ public string Rollnumber{ get ; set ;} public DateTime ReceiptTim{ get ; set ;} }

Jaimin Shethiya · Answer

Hello prasanna, var result = JsonConvert.DeserializeObject (responsecontent); var status = result.success; var data = result.res; can you please check the above code. Thanks

prasanna p · Answer

I removed all special characters and spaces from the json string after the values are coming in the class properties. Thank you all

prasanna p · Answer

Hi Jaimin Shethiya, I checked with your code but status and data variables showing null because result json contains backslashes in the json like this "result": "{\"status\": \"success\", \"res\": [{\"Rollnumber\": \"1581\", \"Receipt Time\": \"13:38:32\"},{\"Rollnumber\": \"1582\", \"Receipt Time\": \"15:10:32\"}]} I checked with the following code JObject obj = JObject.Parse(responseContent); JToken token = obj["result"]; Rootobject result = JsonConvert.DeserializeObject ((token.ToString()).Replace(@"\", "")); Cannot convert from Newtonsoft.Json.Linq.JToken to string error came.So I added Tostring() to token. Here my problem is res json parameters contains spaces such as Receipt Time,Receipt Date,CGST@9% Inc,Card..etc. result object is showing all parameters with null data.Where as Card parameter don't have spaces so the value is showing in the Card parameter I created like this public class Rootobject { public string status { get; set; } public List res { get; set; } } public class Re { public string Rollnumber { get; set; } public string ReceiptTime { get; set; } public float CGST9Inc { get; set; } public string TransactionStatus { get; set; } public string ReceiptDate { get; set; } public float Card { get; set; } } I tried to create Roll number,Receipt Time in the class object not allowing showing error. how to create class object with spaces exact with json parameters?