Getting cannot access child key error from the Web API

prasanna p

6y11.9k.NET

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.

4 Replies

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

Shantanu Pandey6y ago
Accepted 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;}
}
prasanna p6y ago
I removed all special characters and spaces from the json string after the values are coming in the class properties.

Thank you all
prasanna p6y ago
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?
Jaimin Shethiya6y ago
Hello prasanna,

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

Thanks

Getting cannot access child key error from the Web API

Hi Jaimin Shethiya,