How to access inner stringified JSON data using JavaScriptSerializer

Question

JSON:

{  
    "o-data":[  
        {  
            "entry 1":"test1",
            "entry 2":"test2",
            "entry 3":"test3",
            "entry 4":"118"
        }
    ]
}

C#:

dynamic dn = dyndata(json);
foreach (KeyValuePair<string, object> kvp in dn)
{
    //I would like to be able to get all the inner data for `o-data` like below...
    string entry1 = "";// test1
    string entry2 = "";// test2
    string entry3 = "";// test3

    //but instead I get `{[o-data, System.Object[]]}`
    string second = kvp.Value.ToString(); // gives my 'System.Object[]'
}

public dynamic dyndata(string json)
{
    dynamic dyn1 = new System.Dynamic.ExpandoObject();
    try
    {
        var serializer = new JavaScriptSerializer();
        var result = serializer.DeserializeObject(json);
        return result);
    }
    catch { return Tuple.Create(dDummy, false); }
}

How can I the KVP of the inner list for 'o-data'.

Currently it only loop once because of o-data. I would like to get the inner list of o-data and loop through that.

Michael · Accepted Answer · 2017-10-17 18:25:35Z

2

Some castings are required:
1) cast the kvp.Value to object[] because "o-data" contains an array
2) cast the first item of this array to IDictionary<string, object>

dynamic dn = dyndata(json);
foreach (KeyValuePair<string, object> kvp in dn)
{
    var array = ((object[])kvp.Value);
    var dictionary = (IDictionary<string, object>) array[0];
    var entry1 = dictionary["entry 1"];
}

answered Oct 17, 2017 at 18:25

Michael

2,1432 gold badges13 silver badges27 bronze badges

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

1 Comment

Si8 Over a year ago

Thank you... it's weird, locally your code works but i had to revert back to my code to work correctly when the site is hosted in IIS... weird weird weird! Thanks for the help. +1 and accepted.

Collectives™ on Stack Overflow

How to access inner stringified JSON data using JavaScriptSerializer

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