RestSharp JSON Array deserialization

BriocheBro picture BriocheBro · Nov 27, 2013 · Viewed 20.8k times · Source

I launch this RestSharp query in JSON format:

var response = restClient.Execute<Report>(request);

The response I get contains this data

[
    {
        "Columns":
        [
            {"Name":"CameraGuid","Type":"Guid"},
            {"Name":"ArchiveSourceGuid","Type":"Guid"},
            {"Name":"StartTime","Type":"DateTime"},
            {"Name":"EndTime","Type":"DateTime"},
            {"Name":"TimeZone","Type":"String"},
            {"Name":"Capabilities","Type":"UInt32"}
        ],
        "Rows":
        [
            [
                "00000001-0000-babe-0000-00408c71be50",
                "3782fe37-6748-4d36-b258-49ed6a79cd6d",
                "2013-11-27T17:52:00Z",
                "2013-11-27T18:20:55.063Z",
                "Eastern Standard Time",
                2147483647
            ]
        ]
    }
]

I'm trying to deserialize it into this group of classes:

public class Report
{
    public List<ReportResult> Results { get; set; }
}

public class ReportResult
{
    public List<ColumnField> Columns { get; set; }
    public List<RowResult>   Rows { get; set; }
}

public class ColumnField
{
    public string Name { get; set; }
    public string Type { get; set; }
}

public class RowResult
{
    public List<string> Elements { get; set; }
}

Unfortunately, the result data is null and I get this exception:

Unable to cast object of type 'RestSharp.JsonArray' to type 'System.Collections.Generic.IDictionary`2[System.String,System.Object]'.

I cannot figure out what is wrong here. I little help would be greatly appreciated.

Answer

Reda picture Reda · Nov 27, 2013

Try this:

var response = restClient.Execute<List<ReportResult>>(request);

EDIT

You should also change ReportResult to:

public class ReportResult
{
  public List<ColumnField> Columns { get; set; }
  public List<List<string>>   Rows { get; set; }
}

and you can get rid of Report and RowResult.