Deserialize JSON to relative Class

Question

I am new to JSON and Web API. I have gone through helping books to make a simple console app that gets a URL response i.e. JSON and parse it using NewtonSoft. I cannot access the VoiceIAQStats portion data from the JSON. I need assistance in parsing:

My code is:

async static void GetRequest(string url)
{
    using (HttpClient client = new HttpClient())
    {
        using (HttpResponseMessage response = await client.GetAsync(url))//  .GetAsync(url))
        {
            using (HttpContent content = response.Content)
            {
                string mycontent = await content.ReadAsStringAsync();
                //Console.WriteLine(mycontent);
                JArray a = JArray.Parse(mycontent);
                Console.WriteLine("Total Count is " + a.Count());
                Console.WriteLine("Data is " + a.ToString());
            }
        }
    }
}

The JSON Result is as follows:

[{"id":"faisal","operation":"UPDATE","VoiceIAQStats":{"id":9,"esdId":9,"esdName":"faisal"}}]

score 1 · Accepted Answer · answered Mar 01 '18 at 09:33

You are parsing to an array adn thus all your data is held in the first element of the array. You should access the first item of the array and then access the property, like this:

var firstElement = a[0];
var voiceIaqStats = firstElement["VoiceIAQStats"];

//Or in 1 line:
var voiceIaqStats = a[0]["VoiceIAQStats"];

M. Abouzeid · Answer 2 · 2018-03-01T09:55:53.393

Having the result as an object would make your life much easier. I'd say try something like this. (haven't tested it myself)

 private struct ResponseData
    {
        public List<Data> results { get; set; }
    }
    private struct Data
    {
        public string id { get; set; }
        public string operation { get; set; }
        public VoiceIA VoiceIAQStats { get; set; }
    }

    private struct VoiceIA
    {
        [JsonProperty("id")]
        public long id { get; set; }
        [JsonProperty("esdId")]
        public long esdId { get; set; }
        [JsonProperty("esdName")]
        public string esdName { get; set; }
    }

    async static void GetRequest(string url)
    {
        using (HttpClient client = new HttpClient())
        {
            using (HttpResponseMessage response = await client.GetAsync(url))//  .GetAsync(url))
            {
                using (HttpContent content = response.Content)
                {
                    var mycontent = content.ReadAsStringAsync();

                    ResponseData queryResponse = JsonConvert.DeserializeObject<ResponseData>(mycontent.Result);
                    string id = queryResponse.results[0].id;
                    int count = queryResponse.results.Count;
                    string operation = queryResponse.results[0].operation;

                    VoiceIA voiceObj = queryResponse.results[0].VoiceIAQStats;
                    long idOfVoice = voiceObj.id;
                    long esdId = voiceObj.esdId;
                    string esdName = voiceObj.esdName;


                    ////                            Console.WriteLine(mycontent);

                    //JArray a = JArray.Parse(mycontent);
                    //Console.WriteLine("Total Count is " + a.Count());
                    //Console.WriteLine("Data is " + a.ToString());
                }
            }
        }
    }

Deserialize JSON to relative Class

2 Answers2