反序列化 JSON 对象和查询

Question

我需要查询并获取匹配的JSON字符串。以下是我的 JSON：

我需要查询我在HTTP RESPONSE中收到的 JSON，匹配code=2的 JSON，然后提取text=Jenny kisworth

杰伦

[
  {
    "code":1234,
    "parentCode":9898,
    "language":{
      "lookup": "IN",
      "code": 1
    },
    "parentType": "Patient",
    "text": "James Berth"
  },
  {
    "code":4567,
    "parentCode":8989,
    "language":{
      "lookup": "IN",
      "code": 1
    },
    "parentType": "Patient",
    "text": "James Bond"
  },
 {
    "code":89101,
    "parentCode":2525,
    "language":{
      "lookup": "OUT",
      "code": 2
    },
    "parentType": "Patient",
    "text": "Jenny kisworth"
  }
]

法典：

public class JSonData
    {
        [Newtonsoft.Json.JsonProperty("code")]
        public string code { get; set; }
        [Newtonsoft.Json.JsonProperty("language")]
        public List<Datum> language { get; set; }
    }
    public class Datum
    {
        public string lookup { get; set; }
        public int code { get; set; }
    }
//only posting code relevant to the subject
HttpResponseMessage responseCode = client.GetAsync(codeParameters).Result;
if (responseCode.IsSuccessStatusCode)
{
  var dataObjects = responseAlternateTitles.Content.ReadAsStringAsync();
            dataObjects.Wait();
            string dataObjectsString = dataObjects.Result.ToString();
            var data = Newtonsoft.Json.JsonConvert.DeserializeObject<List<JSonData>>(dataObjectsString);
}

在上面我得到一个错误：Cannot deserialize the current JSON object (e.g. {"name":"value"}) into type 'System.Collections.Generic.List 1[BCMTest.Datum]'，因为该类型需要一个 JSON 数组'

Answer 1

你的类应该看起来更像这样，我怎么知道？ http://json2csharp.com/

public class Language
{
    public string lookup { get; set; }
    public int code { get; set; }
}
public class JSonData
{
    public int code { get; set; }
    public int parentCode { get; set; }
    public Language language { get; set; }
    public string parentType { get; set; }
    public string text { get; set; }
}
...
var data = Newtonsoft.Json.JsonConvert.DeserializeObject<List<JSonData>>(dataObjectsString);

Answer 2

您收到错误，因为您的 JSON 在类对象中没有您所期望的语言数组对象。

更改JSonData class -> language

public class JSonData
{
    [Newtonsoft.Json.JsonProperty("code")]
    public string code { get; set; }
    [Newtonsoft.Json.JsonProperty("language")]
    public Datum language { get; set; }
}

Answer 3

    public class Language
{
    public string lookup { get; set; }
    public int code { get; set; }
}
public class JSonData
{
     [Newtonsoft.Json.JsonProperty("code")]
    public string code { get; set; }
     [Newtonsoft.Json.JsonProperty("parentCode")]
     public int parentCode { get; set; }
     [Newtonsoft.Json.JsonProperty("language")]
    public Language language { get; set; }
     [Newtonsoft.Json.JsonProperty("parentType")]
    public string parentType { get; set; }
     [Newtonsoft.Json.JsonProperty("text")]
    public string text { get; set; }
}
var data = Newtonsoft.Json.JsonConvert.DeserializeObject<List<JSonData>>(dataObjectsString);
var filtereddata = data.Where(s => s.language.code.Equals(2));