Extracting JsonObject from JsonArray

Question

I have a problem to extract a JasonObject from a Arry, that contains some objects without a name. Ive got the Array by a batch request form graph.facebook.

[
    {
    "code":200,
    "headers":[{...}],
    "body":"{
        \"id\":\"255572697884115_1\",
        \"from\":{
            \"name\":\"xyzk\",
            \"id\":\"59788447049\"},
        \"message\":\"Hey\",
        \"created_time\":\"2011-11-04T21:32:50+0000\"}"},
    {
    "code":200,
    "headers":[{...}],
    "body":"{
        \"id\":\"255572697884115_2\",
        \"from\":{
             \"name\":\"xyzk\",
             \"id\":\"59788447049\"},
        \"message\":\":P\",
        \"created_time\":\"2012-01-03T21:05:59+0000\"}"}
]

Now I have to read the vaules "message" of the containing objects, but i dont know how i can access the objects in the array. Can anybody give me a helping hand?

I want to use System.Json, additional Newtonsoft.Json.

In Java it is easy to use by GetJsonObject(), but how can i succeed with VSC#? There is an method JsonValueLinqExtensions.ToJsonObject but i dont know, how to use. Could sb give me an example?

Thank you so far,

Dominic

check following links they might help you. stackoverflow.com/questions/2859753/… stackoverflow.com/questions/4611031/… — Geethanga
– Geethanga, Commented Sep 6, 2012 at 14:36

James · Accepted Answer · 2012-09-07 07:51:52Z

3

You could parse the JSON into a dynamic using JavaScriptSerializer object e.g.

var serializer = new JavaScriptSerializer();   
var result = serializer.Deserialize<dynamic>(json);
foreach (var item in result)
{
    Console.WriteLine(item["body"]["message"]);
}

edited Sep 7, 2012 at 7:51

answered Sep 6, 2012 at 14:33

James

82.4k19 gold badges172 silver badges245 bronze badges

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

4 Comments

Findus Over a year ago

Thank you for your answer. Your suggest is great but it doesnt work. Converting to dynamic is ok, but i can access body. Compiler says ok, but i get the exception "Object reference not set to an object instance" in line foreach... Do you have any idea?

Findus Over a year ago

Sry, the exception is System.Collectios.Generic.Dictionary<string,object> doesnt consist definitions for body

Findus Over a year ago

Hey James, thank you for response. The problem is that body is opended by quotes: <"body":"{>. These quotes have to be deletet, i do in following way: dynamic result=JsonArray.Load(s);string st = item.body; dynamic result2 = JsonObject.Parse(st);

James Over a year ago

@DominicFrank the code provided will work. I was assuming that when you parsed into a dynamic object you could access it like a property. However, if you access it via name it works just fine. The other solution is to actually create a class which represents each "Item" and parse it straight to that which would give you type safety e.g. Item.Body.Message. However, it's whatever you feel is the better solution for you.

Collectives™ on Stack Overflow

Extracting JsonObject from JsonArray

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related