How to deserialize json data(from URL) and show on label.

Ravi Birla

Hi Everyone,

I want to deserialize json data which is on solr URL after deserialization i wand to show that data on label and use it in if statement. Below is my JSON format:-

{
"responseHeader":{
"status":0,
"QTime":0,
"params":{
"q":"vendor:abc",
"indent":"true",
"wt":"json"}},
"response":{"numFound":1,"start":0,"docs":[
{
"vendor":["abc"],
"value":[1000],
"id":"6257a225-0a35-4d0c-a0e4-dd9336d45641",
"_version_":1592304323677650944}]
}}

I want to show only "value" which is in response object of json.

Thanks,

4 Replies

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

Dharmraj Thakur8y ago
Accepted answer
Simply read like below code...
static void Main(string[] args)
{
    string json = "{" +
        "\"responseHeader\": {" +
            "\"status\": 0," +
            "\"QTime\": 0," +
            "\"params\": {" +
                "\"q\": \"vendor:abc\"," +
                "\"indent\": \"true\"," +
                "\"wt\": \"json\"" +
            "}" +
        "}," +
        "\"response\": {" +
            "\"numFound\": 1," +
            "\"start\": 0," +
            "\"docs\": [" +
                "{" +
                    "\"vendor\": [" +
                        "\"abc\"" +
                    "]," +
                    "\"value\": [" +
                        "1000" +
                    "]," +
                    "\"id\": \"6257a225-0a35-4d0c-a0e4-dd9336d45641\"," +
                    "\"_version_\": 1592304323677650944" +
                "}" +
            "]" +
        "}" +
    "}";
    JToken myDeserializedObjList = (JToken)JsonConvert.DeserializeObject(json);
    foreach (var item in myDeserializedObjList["response"]["docs"])
    {
        Console.WriteLine(item["value"][0]);
    }

    Console.ReadKey();
}
Ravi Birla8y ago
Hi Dharmraj Thakur,

Thanks for your concern!

i already have prepared the code myself and its working fine ..Below is the code details.,.

if (!IsPostBack)
{
string json = new WebClient().DownloadString("http://localhost:8983/solr/wap/select?q=vendor%3AXYZ&wt=json&indent=true");
String joutput = json;
dynamic obj = JObject.Parse(joutput);
JToken token;
if (obj.TryGetValue("response", out token))
{
var values = (JArray)token["docs"];
//string finaloutput;
foreach (JToken child in values)
{
var output = (JArray)child["value"];
foreach (string final in output)
{
string result1 = Convert.ToString(final);
Label1.Text = result1;
}
}
}
//string abc = "1000";
//if( abc == Label1.Text.ToString())
//{
// Label2.Visible = true;
//}
}

Thanks.
Ravi Birla8y ago
in c#( in conditional statements)
Dharmraj Thakur8y ago
Where you want to use values of response? in Javascript code or in c# code?