RestSharp JSON Array deserialization

Question

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.

Reda · Accepted Answer · 2013-11-27 19:24:07Z

23

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.

edited Nov 27, 2013 at 19:24

answered Nov 27, 2013 at 19:12

Reda

2,28918 silver badges19 bronze badges

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

6 Comments

Tim S. Over a year ago

I think he'll also have a problem due to the Elements property. Rows should be a List<string> (unless you can tell JSON.net that's how it is, maybe via attributes).

Reda Over a year ago

Good catch, Rows should be List<List<string>> though

BriocheBro Over a year ago

Using IList<ReportResult> gives my a compilation error: Error CS0310: The type

System.Collections.Generic.IList<ReportResult>' must have a public parameterless constructor in order to use it as parameter

T' in the generic type or method `ExecuteRequest<T>(RestSharp.RestRequest)' (CS0310)

Reda Over a year ago

Change it to List<ReportResult>, I edited the answer accordingly

BriocheBro Over a year ago

Also, trying the List<List<string>> gives my the same error (unable to cast...)

|

thatguy · Accepted Answer · 2020-08-14 09:36:38Z

0

There is another way by creating wrapper class:

public class ThirdPartySuggesters : List<ThirdPartySuggester> {}
var response = client.Execute<ThirdPartySuggesters>(request);

edited Aug 14, 2020 at 9:36

thatguy

22.3k6 gold badges33 silver badges46 bronze badges

answered Aug 14, 2020 at 8:52

binhtruong.it

3372 silver badges4 bronze badges

Collectives™ on Stack Overflow

RestSharp JSON Array deserialization

2 Answers 2

6 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related