C＃从JSON对象内的数组中获取索引

Question

我正在尝试找出锻炼对象中数组中字符串的索引。例如，您可以给予FRC610，它将返回0。

// Get rankings JSON file from thebluealliance.com 
        string TBArankings = @"https://www.thebluealliance.com/api/v2/district/ont/2017/rankings?X-TBA-App-Id=frc2706:ONT-ranking-system:v01";
        var rankings = new WebClient().DownloadString(TBArankings);
        string usableTeamNumber = "frc" + teamNumberString;
        string team_key = "";
        int rank = 0;
        dynamic arr = JsonConvert.DeserializeObject(rankings);
        foreach (dynamic obj in arr)
        {
            team_key = obj.team_key;
            rank = obj.rank;
        }
        int index = Array.IndexOf(arr, (string)usableTeamNumber);  // <-- This is where the exception is thrown.
        Console.WriteLine(index);
        // Wait 20 seconds
        System.Threading.Thread.Sleep(20000);

这是我正在使用的JSON文件。

我尝试了多种不同的解决方案，而这些解决方案都没有。

Answer 1

您可以将索引保持在变量中。

    string usableTeamNumber = $"frc{teamNumberString}";
    string team_key = "";
    int rank = 0;
    int index = 0;
    int count = 0;
    dynamic arr = JsonConvert.DeserializeObject(rankings);
    foreach (dynamic obj in arr)
    {
        team_key = obj.team_key;
        rank = obj.rank;
        if (usableTeamNumber.Equals(team_key) {
             index = count;
        }
        count++;
    }
    Console.WriteLine(index);

Answer 2

创建一个模拟您的数据结构的类(只有3个根字段(：

public class EventPoints
{
    public int point_total { get; set; }
    public int rank { get; set; }
    public string team_key { get; set; }
}

然后，您可以将对象列为这些对象的列表，并且可以使用LINQ或其他工具来查询列表：

        string teamNumberString = "frc2056";
        string TBArankings = @"https://www.thebluealliance.com/api/v2/district/ont/2017/rankings?X-TBA-App-Id=frc2706:ONT-ranking-system:v01";
        var rankings = new WebClient().DownloadString(TBArankings);
        List<EventPoints> eps = JsonConvert.DeserializeObject<List<EventPoints>>(rankings);
        EventPoints sp = eps.Where(x => x.team_key.Equals(teamNumberString)).FirstOrDefault();
        Console.WriteLine(eps.IndexOf(sp));
        Console.ReadLine();