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?

Getting cannot access child key error from the Web API

Answers (4)