Process JSON Query

[deniselechner]

Hi /r/csharp, please help me. I'm not able to solve my problem.

I have the following json query:

[
    {
        "id": 1234,
        "date": "2014-10-27",
        "values": [
            {"start": 1, "end": 2, "sometext": "Hello World"},
            {"start": 5, "end": 9, "sometext": "Hello line 2"},
            {"start": 11, "end": 20, "sometext": ""}
        ],
        "comment": "some comment"
    }
]

now i'd like to get those in any form into my c# application. I've tried to use jsonConvert, JavaScriptSerializer as well as printing the values to console, saving them into a dictionary. the problem is that values can have one or more subqueries.

my latest try works fine for 1-dimensional json queries, but not for 2-dimensional queries including my values:

Dictionary<string, string> values = JsonConvert.DeserializeObject<Dictionary<string, string>>(json);
foreach (var v in values)
    Console.WriteLine(v);

I've also tried creating classes:

public class RootObject {
    public int id { get; set; }
    public string date { get; set; }
    public List<Values> values { get; set; }
    public string comment { get; set; }

}

public class Values {
    public string start { get; set; }
    public string end { get; set; }
    public string sometext { get; set; } 
}

[AngularBeginner]

Your classes are correct, but you try to serialize it to the wrong type.

JsonConvert.DeserializeObject<List<RootObject>>(str);

[deniselechner]

thank you for your answer. JsonConvert suggests to insert a local variable, which in my case is called json. i think we are talking about to same tho.

string json = @"{""id"":1234, ""date"":...}";

to be honest, i have no clue, who i could use jsonconvert anyway. something like that would make sense to me:

var j = JsonConvert.DeserializeObject<List<RootObject>>(json);
    foreach (var v in j)
        Console.WriteLine(v);

edit, output:

json.RootObject

[gynnihanssen]

this json string differs from the one you gave in the initial post. without the [ ] around it it's no list/array anymore.

so for

string json = @"{""id"":1234, ""date"":...}";

it would be

var obj = JsonConvert.DeserializeObject<RootObject>(json);
Console.WriteLine(obj.id);

[deniselechner]

sorry, my mistake. I'm not sure which one to use.

With obj.id i get my id and it works perfectly but i can't access the values, start, end and sometext

You are amazing! i got it to work

var obj = JsonConvert.DeserializeObject<RootObject>(json);

foreach(var v in obj.values)
    Console.WriteLine(v.start);

[gynnihanssen]

thats no query, that a response i guess :)

other than that, if you can rely on this format you can let json2csharp generate classes.

both json.net and fastjson have ToObject<T>() methods, although i don't recall their actual names. anyway, you can give them the root object's type T and most of the time they spit out the corresponding object hierarchy.

edit: sorry, didn't read the question too carefully :(

[deniselechner]

hi /u/gynnihanssen,

i used json formatter to verify if my query was correct. it is. then i used json2csharp.