无效的JSON原语:.尝试用c#对JSON进行反序列化

本文关键字：JSON 反序列化 原语 无效 | 更新日期: 2023-09-27 18:11:09

我需要从第三方服务器端反序列化一些数据(出于可访问性的原因，这是服务器端完成的，而不是出于选择)。然而，我得到

我调用以下代码行:

var data = new JavaScriptSerializer().Deserialize<TPOData>(responseFromServer);

responseFromServer如下:

{
  "name": "TPO",
  "columns": [
    "ogc_fid",
    "orderref",
    "status",
    "entityref",
    "treetype",
    "comments",
    "orderyear",
    "label",
    "dist"
 ],
 "data": [
   [
      360,
      "07/1970/WR ",
      "Tree       ",
      "T6   ",
      "Chestnut",
      "Position checked against Scanned Order 13/11/2008",
      1970,
      "479055.705,204698.514",
      33
   ],
   [
      361,
      "07/1970/WR ",
      "Tree       ",
      "T7   ",
      "May",
      "Position checked against Scanned Order 13/11/2008",
      1970,
      "479061.747,204685.09",
      35
   ]
 ]
}

我试图反序列化成一个对象TPOData:

public class TPOData
{
    public string name;
    public List<string> columns;
    public List<List<object>> data;
}

我已经尝试使属性数据是不同的。除此之外，我还尝试了List<object>, List<object[]>, object[][], object[], object。我甚至尝试了List<List<string>>，希望它可以转换int值。但都无济于事。我怀疑问题在于第二层对象数组中的数据是int和字符串值的混合。我做了一个非常类似的任务，其中第二级完全是字符串，所以我可以使用List<List<string>>没有问题。

无效的JSON原语:.尝试用c#对JSON进行反序列化

我试过你的例子，它工作得很好，我使用JavaScriptSerializer与List<List<object>>内的TPOData类。我使用的测试程序复制如下。注意，我使用的是。net Framework v4.5，以防万一。JSON或代码中是否有其他东西可能导致问题?

class Program
{
    static void Main(string[] args)
    {
        string json = @"
        {
            ""name"": ""TPO"",
            ""columns"": [
                ""ogc_fid"",
                ""orderref"",
                ""status"",
                ""entityref"",
                ""treetype"",
                ""comments"",
                ""orderyear"",
                ""label"",
                ""dist""
            ],
            ""data"": [
                [
                    360,
                    ""07/1970/WR "",
                    ""Tree       "",
                    ""T6   "",
                    ""Chestnut"",
                    ""Position checked against Scanned Order 13/11/2008"",
                    1970,
                    ""479055.705,204698.514"",
                    33
                ],
                [
                    361,
                    ""07/1970/WR "",
                    ""Tree       "",
                    ""T7   "",
                    ""May"",
                    ""Position checked against Scanned Order 13/11/2008"",
                    1970,
                    ""479061.747,204685.09"",
                    35
                ]
            ]
        }";
        var data = new JavaScriptSerializer().Deserialize<TPOData>(json);
        Console.WriteLine("name: " + data.name);
        Console.WriteLine();
        foreach (var row in data.data)
        {
            for (int i = 0; i < data.columns.Count; i++)
            {
                Console.WriteLine(data.columns[i] + ": " + row[i]);
            }
            Console.WriteLine();
        }
    }
    public class TPOData
    {
        public string name;
        public List<string> columns;
        public List<List<object>> data;
    }
}
输出:

name: TPO
ogc_fid: 360
orderref: 07/1970/WR
status: Tree
entityref: T6
treetype: Chestnut
comments: Position checked against Scanned Order 13/11/2008
orderyear: 1970
label: 479055.705,204698.514
dist: 33
ogc_fid: 361
orderref: 07/1970/WR
status: Tree
entityref: T7
treetype: May
comments: Position checked against Scanned Order 13/11/2008
orderyear: 1970
label: 479061.747,204685.09
dist: 35
相关文章：