c# - JToken 获取特定值

Question

我有以下 JToken 输出。我如何从 TenantID 中检索此处的“值”，在这种情况下应为 1？

{[
 {
  "value": 1,
  "metadata": {
   "userType": 0,
   "flags": 8,
   "type": {
    "type": "INT4",
    "name": "Int",
    "id": 56
   },
   "colName": "TenantID"
  }
 }
]}

这是我当前的代码:

        JToken value;
        if (usr.Profile.TryGetValue("tenantid", out value))
        {
            JObject inner = value["value"].Value<JObject>(); //not working with null error
            User.TenantID = (string)value;
        }
        User.obj = usr.Profile;

编辑 - 请在下面找到完整的 JToken 输出:

    {[
    {
    "value": 1,
    "metadata": {
      "userType": 0,
      "flags": 8,
      "type": {
        "type": "INT4",
        "name": "Int",
        "id": 56
      },
      "colName": "TenantID"
    }
    }
    ]}
    Count: 1
    First (Newtonsoft.Json.Linq.JContainer): {{
  "value": 1,
  "metadata": {
    "userType": 0,
    "flags": 8,
    "type": {
      "type": "INT4",
      "name": "Int",
      "id": 56
    },
    "colName": "TenantID"
  }
}}
    First (Newtonsoft.Json.Linq.JToken): {{
  "value": 1,
  "metadata": {
    "userType": 0,
    "flags": 8,
    "type": {
      "type": "INT4",
      "name": "Int",
      "id": 56
    },
    "colName": "TenantID"
  }
}}
    HasValues: true
    IsReadOnly: false
    Last (Newtonsoft.Json.Linq.JContainer): {{
`"value": 1,
  "metadata": {
    "userType": 0,
    "flags": 8,
    "type": {
      "type": "INT4",
      "name": "Int",
      "id": 56
    },
    "colName": "TenantID"
  }
}}
    Last (Newtonsoft.Json.Linq.JToken): {{
  "value": 1,
  "metadata": {
    "userType": 0,
    "flags": 8,
    "type": {
      "type": "INT4",
      "name": "Int",
      "id": 56
    },
    "colName": "TenantID"
  }
}}
    Next: (null)
    Parent: {"tenantid": [
  {
    "value": 1,
    "metadata": {
      "userType": 0,
      "flags": 8,
      "type": {
        "type": "INT4",
        "name": "Int",
        "id": 56
      },
      "colName": "TenantID"
    }
  }
]}
    Path: "tenantid"
    Previous: (null)
    Static members: 
    Non-public members: 
    IEnumerator: 
    Root: {{
  "name": "Rx Sidhu",
  "given_name": "Rx",
  "family_name": "Sidhu",
  "locale": "en_US",
  "emails": [
    "ranxdeep@xxx.com",
    "ranxdeep@xxx.com",
    "ranxdeep@hx.com"
  ],
  "nickname": "ranxdeep@xxx.com",
  "email": "ranxdeep@xxx.com",
  "picture": "https://apis.live.net/v5.0/f1xxxxxx/picture",
  "roles": [
    "Account Admin",
    "Admin"
  ],
  "tenantid": [
    {
      "value": 1,
      "metadata": {
        "userType": 0,
        "flags": 8,
        "type": {
          "type": "INT4",
          "name": "Int",
          "id": 56
        },
        "colName": "TenantID"
      }
    }
  ],
  "email_verified": true,
  "clientID": "wxxxvC8",
  "updated_at": "2015-07-15T16:26:30.526Z",
  "user_id": "windowslive|f1axxxac",
  "identities": [
    {
      "access_token": "EwBwAq1",
      "provider": "windowslive",
      "user_id": "f1aexxxxxac",
      "connection": "windowslive",
      "isSocial": true
    }
  ],
  "created_at": "2015-07-01T06:08:21.358Z"
}}
    Type: 2

我需要检查 tenantID 是否实际存在然后获取值，否则返回 null 或 0。

Answer 1

你应该能够做到:

JObject jObject = JObject.Parse(...);
JToken value = jObject.SelectToken("value");

您解析您的对象，然后应该公开内部内容，您可以在其中利用SelectToken 方法找到该特定值。

要进一步构建它，您可以这样做:

public static JToken FindToken<T>(string key, T value)
{
     string serialized = NewtonsoftJsonSerializer.Instance.Serialize(value);
     var jObject = JObject.Parse(serialized);
     var jToken = jObject.SelectToken(key);

     if(jToken != null)
          return jToken;

     return null;
}