我如何使用JSON.Net解析这个

本文关键字：Net 何使用 JSON | 更新日期: 2023-09-27 18:02:44

我正在尝试使用JSON。. Net解析从第三方API返回的结果。

可以看到，第一个块似乎是对后面的行块列的描述。我认为这不是标准的做法，因为我找不到任何关于这种风格的参考。因为它不是通常的名称:值对格式，我有点难住了。

{ cols: [{label: "name", type: 'string'},
    {label: "caller_id_number", type: 'string'},
    {label: "destination_number", type: 'string'},
    {label: "call_start", type: 'datetime'},
    {label: "duration", type: 'number'},
    {label: "bill_seconds", type: 'number'},
    {label: "uuid", type: 'string'},
    {label: "call_bill_total", type: 'number'},
    {label: "recorded", type: 'boolean'}],
    rows: [
 {c:[{v: "mydomain.com"},
     {v: "1650"},
     {v: "01902321654"},
     {v: new Date(2011, 6, 19, 14, 12, 25)},
     {v: 3},
     {v: 0},
     {v: "07752f6c-b203-11e0-92e6-495a2db86d6d"},
     {v: 0},
     {v: true}]}
 ,{c:[{v: "mydomain.com"},{v: "1652"},{v: "034534514"},{v: new Date(2011, 6, 19, 14, 11, 34)},{v: 53},{v: 27},{v: "e8fe3a06-b202-11e0-92dd-495a2db86d6d"},{v: 0.05},{v: true}]},
 {c:[{v: "mydomain.com"},{v: "1650"},{v: "034534580"},{v: new Date(2011, 6, 19, 14, 11, 34)},{v: 11},{v: 9},{v: "e8dfb9dc-b202-11e0-92dc-495a2db86d6d"},{v: 0.02},{v: true}]},
 {c:[{v: "mydomain.com"},{v: "1650"},{v: "03453453600"},{v: new Date(2011, 6, 19, 14, 11, 11)},{v: 14},{v: 9},{v: "db7efd52-b202-11e0-92d6-495a2db86d6d"},{v: 0.02},{v: true}]},
 {c:[{v: "mydomain.com"},{v: "1650"},{v: "0345345947"},{v: new Date(2011, 6, 19, 14, 9, 41)},{v: 42},{v: 21},{v: "a59314bc-b202-11e0-92c7-495a2db86d6d"},{v: 0.04},{v: true}]},
 {c:[{v: "mydomain.com"},{v: "1653"},{v: "345345420"},{v: new Date(2011, 6, 19, 14, 9, 41)},{v: 28},{v: 0},{v: "a5a953f8-b202-11e0-92c8-495a2db86d6d"},{v: 0},{v: true}]},
 {c:[{v: "mydomain.com"},{v: "1650"},{v: "353453120"},{v: new Date(2011, 6, 19, 14, 8, 52)},{v: 28},{v: 5},{v: "885515bc-b202-11e0-92bd-495a2db86d6d"},{v: 0.02},{v: true}]},
 {c:[{v: "mydomain.com"},{v: "1653"},{v: "34534567"},{v: new Date(2011, 6, 19, 14, 8, 36)},{v: 10},{v: 3},{v: "7efc86d0-b202-11e0-92b8-495a2db86d6d"},{v: 0.02},{v: true}]},
 {c:[{v: "mydomain.com"},{v: "1650"},{v: "34534584"},{v: new Date(2011, 6, 19, 14, 7, 43)},{v: 34},{v: 13},{v: "5f1cfb60-b202-11e0-92b2-495a2db86d6d"},{v: 0.02},{v: true}]},
 {c:[{v: "mydomain.com"},{v: "1653"},{v: "34534534561"},{v: new Date(2011, 6, 19, 14, 6, 52)},{v: 52},{v: 0},{v: "411b3faa-b202-11e0-92ab-495a2db86d6d"},{v: 0},{v: true}]}]}

我只能做到var o = JObject.Parse(results); var records = o.SelectToken("rows").Select(s => s).ToList();

理想情况下，我想把记录拉回一个类，如

public class CallDetailRecord
{
    public String Name { get; set; }
    public String CallerIdNumber { get; set; }
    public String DestinationNumber { get; set; }
    public DateTime CallStart { get; set; }
    public int Duration { get; set; }
    public String Uuid { get; set; }
    public Decimal CallBillTotal { get; set; }
    public bool Recorded { get; set; }
}

非常感谢您的帮助

我如何使用JSON.Net解析这个

我不知道那是什么，但它不是JSON。它看起来像javascript，很可能用javascript引擎解析。

JSON规范:http://json.org/

验证器:http://jsonlint.com/

虽然您的示例数据不是严格有效的JSON，但您尝试解析它非常接近。

您所看到的布局有时被一些人使用，他们认为可以通过别名字段名来改进(减少)结果集的大小。不幸的是，这不是那么简单的工作，但您可以将项目转回对象。

在这些情况下，我倾向于使用dynamic关键字和ExpandoObject s。如果愿意，您可以使用类，因为创建对象的大部分工作发生在下面最后的Select()中，您可以重写它以将v元素集映射到类的字段而不是ExpandoObject。访问字段的语法是相同的，正如您可以在最后的代码片段中看到的那样，它将所有值写入控制台。

注意，我已经编写了一个helper lambda来处理将Date()映射到DateTime()的情况。我只是指出这一点，因为你可能有一个更好的地方把这个方法(一个扩展方法在DateTime上，也许);但是按原样复制并粘贴到代码的合适位置是没有害处的。

using System.Dynamic;
using Newtonsoft.Json;
using Newtonsoft.Json.Converters;
using Newtonsoft.Json.Linq;
// ... other code removed
// You already have a means that loads your pseudo-json into results
// I used a file for the sake of this example
string results = File.ReadAllText(@"C:'temp'sample.json");
var o = JObject.Parse(results);
var headers = o.SelectToken("cols")
    .Select(x => { return new { label = x.SelectToken("label").Value<string>(), type = x.SelectToken("type").Value<string>()}; }).ToArray();
var rows = o.SelectToken("rows").Select(s => { return s.SelectToken("c");}).ToList();
Func<JConstructor, DateTime> MapAsDateTime = (s) =>
{
    // This is sloppy on my part, you should improve this as you like.
    List<int> v = new List<int>();
    foreach (JToken t in s)
    {
        v.Add(t.Value<int>());
    }
    return new DateTime(v[0], v[1], v[2], v[3], v[4], v[5]);
};
IEnumerable<dynamic> finalValues = rows.Select(s =>
    {
        var innerValues = s.ToList().Select(x => { return x.SelectToken("v"); }).ToArray();
        int i = 0;
        dynamic val = new ExpandoObject();
        IDictionary<string, object> valueMap = (IDictionary<string, object>)val;
        foreach (var innerValue in innerValues)
        {
            switch (headers[i].type)
            {
                case "string":
                    // NOTE: This can be improved, you could try to match and convert GUIDs with a regex or something else.
                    valueMap[headers[i].label] = innerValue.Value<string>();
                    break;
                case "datetime":
                    valueMap[headers[i].label] = MapAsDateTime((JConstructor)innerValue);
                    break;
                case "number":
                    // NOTE: This can be improved, your specific case needs decimal to handle things like 0.25, but many others could get by with just int
                    valueMap[headers[i].label] = innerValue.Value<decimal>();
                    break;
                case "boolean":
                    valueMap[headers[i].label] = innerValue.Value<bool>();
                    break;
                default:
                    // NOTE: You will need to add more cases if they 'define' more types.
                    throw new ArgumentException(string.Format("unhandled type '"{0}'" found in schema headers.", headers[i].type));
            }
            i++;
        }
        return val;
    });
foreach (dynamic d in finalValues)
{
    Console.WriteLine("name: {0}", d.name);
    Console.WriteLine("caller_id_number: {0}", d.caller_id_number);
    Console.WriteLine("destination_number: {0}", d.destination_number);
    Console.WriteLine("call_start: {0}", d.call_start);
    Console.WriteLine("duration: {0}", d.duration);
    Console.WriteLine("bill_seconds: {0}", d.bill_seconds);
    Console.WriteLine("uuid: {0}", d.uuid);
    Console.WriteLine("call_bill_total: {0}", d.call_bill_total);
    Console.WriteLine("recorded: {0}", d.recorded);
    Console.WriteLine("--");
}

最后是样本中第一个数据单元的样本输出。

name: mydomain.com
caller_id_number: 1650
destination_number: 01902321654
call_start: 6/19/2011 2:12:25 PM
duration: 3
bill_seconds: 0
uuid: 07752f6c-b203-11e0-92e6-495a2db86d6d
call_bill_total: 0
recorded: True
--
相关文章：