Extract JSON array names C#

Question

I'm trying to deserialize this piece of json here with JSON.NET through an API, and I just want to extract the names that represent each array, which are John, Marie and Bob. Is it possible to extract just the names of each array with a foreach or any kind of method?

Here is how I currently have it:

WebRequest request = WebRequest.Create("...API URL...");
WebResponse response = request.GetResponse();
Stream dataStream = response.GetResponseStream();
StreamReader reader = new StreamReader(dataStream);

string responseFromServer = reader.ReadToEnd();

reader.Close();
response.Close();
var jss = new JavaScriptSerializer();
var dict = jss.Deserialize<Dictionary<string, dynamic>>(responseFromServer);


foreach (var item in dict["data"])
{
   string arrayName= Convert.ToString(item["data"]["?array_names?"]);
   Console.WriteLine(arrayName);
}

Data from JSON (responseFromServer)

 {"data": {
      "John": {
         "id": 266,
         "title": "Good old john",
         "name": "John Shepard",
         "key": "JS"
      },
      "Marie": {
         "id": 412,
         "title": "Helper Marie",
         "name": "Marie Godfather",
         "key": "MG"
      },
      "Bob": {
         "id": 23,
         "title": "Uncle Bob",
         "name": "Bob Plane",
         "key": "BP"
      }
}}

[EDIT: Added missing {} at start and end, sorry]

Thanks in advance

Json you show here does not have a array. Post the exact json. You cannot deserialize to Deserialize<Dictionary<string, dynamic>> you should have a repective object type in your code — Vasanthan
– Vasanthan, Commented Nov 22, 2016 at 11:28
Amit Kumar Ghosh and Anand Systematix -> Can not apply indexing with [] to an expression of type 'System.Collections.Generic.KeyValuePair <string, object>' — Bruno
– Bruno, Commented Nov 22, 2016 at 11:29

Amit Kumar Ghosh · Accepted Answer · 2016-11-22 11:34:09Z

3

Assuming the valid json format - the follwing produces the result -

var json = "{'data':{'John':{'id':266,'title':'Good old john','name':'John Shepard','key':'JS'},'Marie':{'id':412,'title':'Helper Marie','name':'Marie Godfather','key':'MG'},'Bob':{'id':23,'title':'Uncle Bob','name':'Bob Plane','key':'BP'}}}";
var t = JObject.Parse(json)["data"];
foreach(JProperty j in t){
   Console.WriteLine(j.Name);
} /*John
    Marie
    Bob*/

It is recommended to use JSON.Net for working with json data types.

answered Nov 22, 2016 at 11:34

Amit Kumar Ghosh

3,7761 gold badge22 silver badges24 bronze badges

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

1 Comment

Bruno Over a year ago

This is exactly it. Thank you very much!

Yanga · Accepted Answer · 2016-11-22 11:41:26Z

-1

var json = "{'data':{'John':{'id':266,'title':'Good old john','name':'John Shepard','key':'JS'},'Marie':{'id':412,'title':'Helper Marie','name':'Marie Godfather','key':'MG'},'Bob':{'id':23,'title':'Uncle Bob','name':'Bob Plane','key':'BP'}}}";

var jss = new JavaScriptSerializer();
var dict = jss.Deserialize<Dictionary<string, dynamic>>(json);

foreach (var item in dict["data"])
    {
        string arrayName = Convert.ToString(item.Key);
        Console.WriteLine(arrayName);
    }

// John
// Marie
// Bob

answered Nov 22, 2016 at 11:41

Yanga

3,0121 gold badge33 silver badges32 bronze badges

2 Comments

Camilo Terevinto Over a year ago

This is not what the OP asked for. And this will not print "John, Marie, Bob"

Yanga Over a year ago

You can try the code, it's printing "John, Marie, Bob"

Collectives™ on Stack Overflow

Extract JSON array names C#

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related