在我的 json 中将值转换为类型"System.Collections.Generic.List"时出错

Question

我在c#中转换JSON到对象时有问题。我想知道json或对象结构出了什么问题?为什么会失败?

我的JSON是:

[ { "added_on" : "10-03-2014",
    "country" : "INDIA",
    "crew" : "{"Actor1": "Kangana", "Actor2":"Lisa Haydon"}rn",
    "fb_link" : "https://www.facebook.com/Queenthefilm",
    "genre" : "DRAMA",
    "id" : 1,
    "image_first_url" : "",
    "image_main_url" : "133avk38CcBfNHsqwr0nzqOa8Db.jpg",
    "image_second_url" : "",
    "name" : "Queen",
    "ratings" : "[{"type": "IMDB", "value": "9.3"}, {"type": "TOI", "value": "4"}, {"type": "NDTV", "value": "3"}]",
    "release_date" : "07-03-2014",
    "release_year" : 2014,
    "storyline" : "A Delhi girl from a traditional family sets out on a solo honeymoon after her marriage gets canceled.",
    "twitter_link" : "https://twitter.com/Queenthefilm",
    "youtube_link" : "http://www.youtube.com/watch?v=KGC6vl3lzf0"
  } ]

对象结构:

public class Movie
{
    public string id { get; set; }
    public string name { get; set; }
    public string storyline { get; set; }
    public string crew { get; set; }
    public string genre { get; set; }
    public string release_year { get; set; }
    public string release_date { get; set; }
    public string country { get; set; }
    public string youtube_link { get; set; }
    public string fb_link { get; set; }
    public string twitter_link { get; set; }
    public string image_main_url { get; set; }
    public string image_first_url { get; set; }
    public string image_second_url { get; set; }
    public string added_on { get; set; }
    public List<Rating> ratings { get; set; }
}
public class Rating
{
    public string type { get; set; }
    public string value { get; set; }
}

错误:

Error converting value "[{"type": "IMDB", "value": "9.3"}, {"type": "TOI", "value": "4"}, {"type": "NDTV", "value": "3"}]" to type 'System.Collections.Generic.List`1[mq.channel.Rating]'. Path '[0].ratings', line 1, position 731.

Answer 1

您的JSON不包含ratings属性的数组，而是字符串。它应该看起来像

[ { "added_on" : "10-03-2014",
    "country" : "INDIA",
    "crew" : "{"Actor1": "Kangana", "Actor2":"Lisa Haydon"}rn",
    "fb_link" : "https://www.facebook.com/Queenthefilm",
    "genre" : "DRAMA",
    "id" : 1,
    "image_first_url" : "",
    "image_main_url" : "133avk38CcBfNHsqwr0nzqOa8Db.jpg",
    "image_second_url" : "",
    "name" : "Queen",
    "ratings" : [{"type": "IMDB", "value": "9.3"}, {"type": "TOI", "value": "4"}, {"type": "NDTV", "value": "3"}],
    "release_date" : "07-03-2014",
    "release_year" : 2014,
    "storyline" : "A Delhi girl from a traditional family sets out on a solo honeymoon after her marriage gets canceled.",
    "twitter_link" : "https://twitter.com/Queenthefilm",
    "youtube_link" : "http://www.youtube.com/watch?v=KGC6vl3lzf0"
  } ]

为了将ratings属性作为一个数组来分析(注意引号和转义反斜杠被删除)

Answer 2

我遇到了同样的问题，我用下面的代码解决了

YourVariable.Replace(""[", "[").Replace("]"", "]").Replace("\", ""); 

Answer 3

你需要从你的ratings数组属性中删除引号，否则它将被视为字符串，即

"ratings": [...]