遍历JSON响应Newtonsoft.Json.Linq.JObject C＃

sys73r 发表于 Dev

sys73r

我不想创建一个类来反序列化响应，因为将来它可能会有所不同。

我尝试了几种尝试访问所需数据的方法，但我真的不知道如何访问json响应中的项目。

obj {{
  "type": "regular",
  "response": {
    "usable": [
      {
        "id": "897",
        "name": "John Doe",
        "owner": {
          "id": "2",
          "username": "jdoe",
          "firstname": "john",
          "lastname": "doe"
        }
      },
      {
        "id": "657",
        "name": "Karen Whiner",
        "owner": {
          "id": "3",
          "username": "kwhiner",
          "firstname": "karen",
          "lastname": "whiner"
        }
      },
  },
  "error_code": 0,
  "error_msg": "",
  "warnings": [],
  "timestamp": 74772822
}}

我需要的：

Console.WriteLine：

ID：
897-名称：john doe-用户名：jdoe ID：657-名称：Karen Whiner-用户名：kwhiner

。等等

我尝试过的

var jsonString = await result.Content.ReadAsStringAsync();
var obj = JsonConvert.DeserializeObject<object>(jsonString);


DataSet dataSet = JsonConvert.DeserializeObject<DataSet>(jsonString);
DataTable dataTable = dataSet.Tables["response"];

foreach (DataRow row in dataTable.Rows)
{
    Console.WriteLine(row["id"] + " - " + row["name"]);
}

---


JObject stuff = JObject.Parse(jsonString);

foreach (JProperty rate in stuff)
{
    Console.WriteLine(rate.Name + ": " + rate.Value);
}

有什么建议？

谢谢

贾瓦德

首先，您发布的json是不正确的..但是我假设它与复制/粘贴和berevity有关。

您有不同的选择，但是如果要进行动态/对象反序列化，则可以执行此操作以打印其中一行。

var obj = JsonConvert.DeserializeObject<dynamic>(text);
var usableList = obj["response"]["usable"];
Console.WriteLine($"id: {usableList[0]["id"]} - name: {usableList[0]["name"]} - username: {usableList[0]["owner"]["username"]}");

//prints
id: 897 - name: John Doe - username: jdoe

我建议创建一个类来反序列化json。这样，您可以使用Linq和for循环遍历所有可用列表。

public class Rootobject
{
    public string type { get; set; }
    public Response response { get; set; }
    public int error_code { get; set; }
    public string error_msg { get; set; }
    public object[] warnings { get; set; }
    public int timestamp { get; set; }
}

public class Response
{
    public Usable[] usable { get; set; }
}

public class Usable
{
    public string id { get; set; }
    public string name { get; set; }
    public Owner owner { get; set; }
}

public class Owner
{
    public string id { get; set; }
    public string username { get; set; }
    public string firstname { get; set; }
    public string lastname { get; set; }
}

// and deserialization and printing would be like this,

var obj = JsonConvert.DeserializeObject<Rootobject>(text);
foreach (var item in obj.response.usable)
{
    Console.WriteLine($"id: {item.id} - name: {item.name} - userid: {item.owner.username}");
}

// prints:
id: 897 - name: John Doe - userid: jdoe
id: 657 - name: Karen Whiner - userid: kwhiner

本文收集自互联网，转载请注明来源。

如有侵权，请联系 [email protected] 删除。