C＃无法在newtonsoft.json.linq.jproperty上访问儿童价值

Question

我希望你们能够帮助我。我想将JSON文件中的每个ID删除，但是我会收到以下异常错误：

无法在newtonsoft.json.linq.jproperty上访问儿童价值。

    private void button1_Click(object sender, EventArgs e)
    {
        string address = "https://api.mysportsfeeds.com/v1.1/pull/nba/2016-2017-regular/cumulative_player_stats.json?team=85";
        var w = new WebClient();
        w.UseDefaultCredentials = true;
        w.Credentials = new NetworkCredential("****", "****");
        var result = w.DownloadString(address);
        var obj = JObject.Parse(result);
        var play = "";

        foreach (JProperty child in obj["cumulativeplayerstats"])
        {
            play = child["player"]["ID"].ToString();
            string latlong = Convert.ToString(play);
            Console.WriteLine("player=" + Convert.ToString(play));
            Console.ReadKey();
        }
    }

这是JSON的样子的片段：

{
  "cumulativeplayerstats": {
    "lastUpdatedOn": "2017-09-11 4:45:30 PM",
    "playerstatsentry": [
      {
        "player": {
          "ID": "10138",
          "LastName": "Abrines",
          "FirstName": "Alex",
          "JerseyNumber": "8",
          "Position": "F"
        },
        "team": {
          "ID": "96",
          "City": "Oklahoma City",
          "Name": "Thunder",
          "Abbreviation": "OKL"
        },
        "stats": {
          "GamesPlayed": {
            "@abbreviation": "GP",
            "#text": "68"
          },
          "Fg2PtAtt": {
            "@category": "Field Goals",
            "@abbreviation": "2PA",
            "#text": "94"
          },
          "Fg2PtMade": {
            "@category": "Field Goals",
            "@abbreviation": "2PM",
            "#text": "40"
          },
          "Fg3PtAtt": {
            "@category": "Field Goals",
            "@abbreviation": "3PA",
            "#text": "247"
          },
          "Fg3PtMade": {
            "@category": "Field Goals",
            "@abbreviation": "3PM",
            "#text": "94"
          },
          "FtAtt": {
            "@category": "Free Throws",
            "@abbreviation": "FTA",
            "#text": "49"
          },
          "FtMade": {
            "@category": "Free Throws",
            "@abbreviation": "FTM",
            "#text": "44"
          }
        }
      },

我尝试在这里挖掘，但我似乎找不到有效的解决方案。如果你们可以借用一些贤哲的智慧，我将非常感谢！

谢谢伙计们！

Answer 1

您可以修改foreach通过playerstatsentry数组迭代：

foreach (JObject child in obj["cumulativeplayerstats"]["playerstatsentry"].OfType<JObject>())

或没有OfType<T>：

foreach (var child in obj["cumulativeplayerstats"]["playerstatsentry"])

Answer 2

以JSON为例，如果您试图找到名为" ID"的所有属性，只要它们处于层次结构的相同级别，您就可以使用"。SelectTokens" 使用路径和通配符达到您的属性级别的方法。这可能会节省几行代码，并且是一种更好的定位方法。

.net小提琴 - https：//dotnetfiddle.net/fq9xeh

foreach (var tokn in obj.SelectTokens("cumulativeplayerstats.playerstatsentry[*].*.ID"))
{               
    Console.WriteLine(tokn);
}