Getting Json Data C#

Question

I have a function where I can get all JSON data from but I do not understand how to pick out specific data.

I am using dynamic variable to loop thought all JSON information.

How can I for example pick out all "names:" from the given JSON URL and display it in the console.

Fetching data with url:

    public string FetchData(string url)
    {
        string String_jsonData;

        using (WebClient client = new WebClient())
        {
            Uri SourceUri = new Uri(url);

            String_jsonData = client.DownloadString(SourceUri);
        }
        return String_jsonData;
    }

Main and run methode,

    static void Main(string[] args)
    {
        Program p = new Program();
        p.run();
        Console.ReadKey();

    }

    public void run()
    {
        string url = "JSON URL;

        dynamic pers = JsonConvert.DeserializeObject(FetchData(url));

        // fetching all data. Here I want to select specific data and save it.
        foreach (var item in pers)
        {
            Console.WriteLine(item);
        }

    }

Model Class:

class Person
{
    public string name { get; set; }

    public string ci_list { get; set; }
}

Here is an example of the data I want to fetch

{
"items": [
{
"ci_type": "xxx",
"exists_in_equipman": false,
"exists_in_hydra": false,
"exists_in_taxen": true,
"hns_name": false,
"id": xxx,
"latest_sync_info": {
  "HYDRA": "xxx",
  "TAXEN": "xxx"
},
"modified_url": "xxx",
"name": "xxx",
"params": {
  "Band (4G)": {
    "id": xxx,
    "source": "script",
    "source_name": "xxx",
    "value": {}
  },
  "Hardware Specification": {
    "id": xxx,
    "source": "script",
    "source_name": "taxen_import",
    "value": {
      "0": {
        "3GPP release": {
          "value": ""
        },
        "Accessories": {
          "value": ""
        },
        "Category": {
          "value": ""
        },
        "Hw rev": {
          "value": "xxx"
        },
        "Locked": {
          "value": ""
        },
        "Model family name": {
          "value": "xxxx"
        },
        "Physical state": {
          "value": "xxxx"
        },
        "Serial No": {
          "value": "xxxx"
        },
        "Software": {
          "value": ""
        },
        "Software version": {
          "value": ""
        }
      }
    }
  },

Can you hint as to what the json structure looks like? Is name a top level property? — Phil Cooper
– Phil Cooper, Commented Mar 4, 2019 at 9:55
Do not use WebClient, it is very old. Use HttpClient instead, it is much more modern. — Fred
– Fred, Commented Mar 4, 2019 at 10:47

Saif · Accepted Answer · 2019-03-04 15:03:47Z

1

First get data from url

var json = string.Empty;

string url = "http://";

using (var httpClient = new HttpClient())
{
    json = httpClient.GetStringAsync(url).Result;

}

Then Deserialize object (assume is lest of objects)

 List<dynamic> list = JsonConvert.DeserializeObject<List<dynamic>>(json);

foreach (var ar in list)
{
   Console.WriteLine(ar["name"]); //assume object look like {"name":"saa", "age":"23"} and want to access name 
}

Example in how to extract ci_type value based on json object in your question

string json = "{\r\n\"items\": [\r\n{\r\n\"ci_type\": \"xxx\",\r\n\"exists_in_equipman\": false,\r\n\"exists_in_hydra\": false\r\n}\r\n]\r\n}";
var result = JsonConvert.DeserializeObject<dynamic>(json);
var data  = result["items"];

foreach (var cityType in data)
{
    Console.WriteLine(cityType["ci_type"]);
}

result : xxx

edited Mar 4, 2019 at 15:03

answered Mar 4, 2019 at 10:10

Saif

2,8093 gold badges22 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Marcus Wilen Over a year ago

Hello. I am getting this error when implementing your solution. Newtonsoft.Json.JsonSerializationException HResult=0x80131500 Message=Cannot deserialize the current JSON object (e.g. {"name":"value"}) into type 'System.Collections.Generic.List`1[System.Object]' because the type requires a JSON array (e.g. [1,2,3]) to deserialize correctly.

Saif Over a year ago

Please show me the json data you suppose to deserialize

Marcus Wilen Over a year ago

Hello. I have posted the beginning part that I want to deserialize in the topic.

ADyson · Accepted Answer · 2019-03-04 14:11:54Z

0

Your issue is that pers is not directly an array, it's an object.

You need to loop over the "items" property which is held within it. This array is what contains the objects which have the "name" properties.

Change your loop code to

foreach (var item in pers.items)

answered Mar 4, 2019 at 14:11

ADyson

62.9k16 gold badges84 silver badges98 bronze badges

Collectives™ on Stack Overflow

Getting Json Data C#

2 Answers 2

3 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Related