Read all dynamic name and value from JSON string

Question

I need to get all dynamic name and values from JSON string. I am going to create one function with JSON string parameter. that parameter JSON string name and values can change, But I need to print all names and values from that JSON string.

Example code :

json : {   "data": 
       [{
         "id": "001",
         "Name": "Somu",
         "Address": "Erode",
        },
        {
         "id": "002",
         "Name": "Ajal",
         "Address": "USA",
        }]
       }

I want to Get all values from this JSON with in loop. Property name may change or increase property count.I need to get all values from passed JSON.

 Expected Result :  1 st loop
            Id = 001
            Name =Somu
            Address =Erode
         2 nd loop
            Id = 002
            Name =Ajal
            Address =USA

what serializer are you using? or do you have flexibility to use any? IIRC this is a lot easier in, say, json.net - than via things like JavaScriptSerializer — Marc Gravell
– Marc Gravell, Commented Sep 6, 2013 at 8:21

I4V · Accepted Answer · 2013-09-06 08:32:01Z

4

Using Json.Net

string json = @"{ ""data"": [ { ""id"": ""001"", ""Name"": ""Somu"", ""Address"": ""Erode"", }, { ""id"": ""002"", ""Name"": ""Ajal"", ""Address"": ""USA"", }] }";

var result  = JObject.Parse(json)
                ["data"]
                .Select(x => new
                {
                    id = (string)x["id"],
                    Name = (string)x["Name"],
                    Address = (string)x["Address"],
                })
                .ToList();

or more dynamic versions

var result  = JObject.Parse(json)
                ["data"]
                .Select(x=> x.Children().Cast<JProperty>()
                             .ToDictionary(p=>p.Name,p=>(string)p.Value))
                .ToList();

.

var result = JObject.Parse(json)["data"]
                    .ToObject<List<Dictionary<string,string>>>();

edited Sep 6, 2013 at 8:32

answered Sep 6, 2013 at 8:23

I4V

35.4k6 gold badges72 silver badges82 bronze badges

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

1 Comment

user2354274 Over a year ago

Second one only i expected. How can read result values through loop

Collectives™ on Stack Overflow

Read all dynamic name and value from JSON string

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related