Extracting information from multiple JSON arrays in C#

Question

Extracting information from multiple JSON arrays in C#

Searching for statistics in this Json Code is my goal:

{
    "summonerId": 32033681,
    "modifyDate": 1403658807000,
    "champions": [{
        "id": 40,
        "stats": {
            "totalSessionsPlayed": 1,
            "totalSessionsLost": 0,
            "totalSessionsWon": 1,
            "totalChampionKills": 1,
            "totalDamageDealt": 27006,
            "totalDamageTaken": 9924,
            "mostChampionKillsPerSession": 1,
            "totalMinionKills": 17,
            "totalDoubleKills": 0,
            "totalTripleKills": 0,
            "totalQuadraKills": 0,
            "totalPentaKills": 0,
            "totalUnrealKills": 0,
            "totalDeathsPerSession": 2,
            "totalGoldEarned": 8383,
            "mostSpellsCast": 0,
            "totalTurretsKilled": 2,
            "totalPhysicalDamageDealt": 8957,
            "totalMagicDamageDealt": 18049,
            "totalFirstBlood": 0,
            "totalAssists": 13,
            "maxChampionsKilled": 1,
            "maxNumDeaths": 2
        }
    },
    {
        "id": 36,
        "stats": {
            "totalSessionsPlayed": 1,
            "totalSessionsLost": 1,
            "totalSessionsWon": 0,
            "totalChampionKills": 0,
            "totalDamageDealt": 14267,
            "totalDamageTaken": 7649,
            "mostChampionKillsPerSession": 0,
            "totalMinionKills": 33,
            "totalDoubleKills": 0,
            "totalTripleKills": 0,
            "totalQuadraKills": 0,
            "totalPentaKills": 0,
            "totalUnrealKills": 0,
            "totalDeathsPerSession": 5,
            "totalGoldEarned": 3258,
            "mostSpellsCast": 0,
            "totalTurretsKilled": 0,
            "totalPhysicalDamageDealt": 4992,
            "totalMagicDamageDealt": 9165,
            "totalFirstBlood": 0,
            "totalAssists": 0,
            "maxChampionsKilled": 0,
            "maxNumDeaths": 5
        }
    }]
}

In this particular example, my objective is to find the total number of sessions won for Champion ID 36. However, I am unable to access this specific data as I typically would with other JSON files because it doesn't allow me to specify the champion's ID:

string jsonInput = new WebClient().DownloadString(@usableurl); // Retrieves the JSON from the API
string usableJson = @"JObject.Parse(jsonInput)"; // Converts the JSON into a usable format
var usableJson["champions"]["stats"]["totalSessionWon"];

Is there any way for me to choose a specific statistic based on its preceding ID?

I'm relatively new to working with both JSON and C#, so your assistance is greatly appreciated!

c#json json.net

Answer 1

Answer №1

If you're unfamiliar with the library Newtonsoft.Json;, here's a step-by-step guide on how to install Newtonsoft. Once installation is complete, I'll let you in on a little secret: XML and JSON are formats that utilize human-readable text to transmit data objects which consist of attribute–value pairs. Retrieving data from these string formats is as easy as working with a database.

In order to efficiently retrieve data from a JSON string, we first need to create an object representation that reflects its hierarchy. Take a look at what your data or JSON string looks like. At the topmost level, you'll find attributes such as summonerId, modifyDate, and champions. Within champions, there could be an indefinite number of champion details, so we've created a list called champions.

Moving down one level in the hierarchy, you'll see the champion ID and their stats. So, we need to create another class to represent the stats of each champion. Your classes will therefore look something like this:

public class Rootobject
{
    public int summonerId { get; set; }
    public long modifyDate { get; set; }
    public List<Champion> champions { get; set; }
}

public class Champion
{
    public int id { get; set; }
    public Stats stats { get; set; }
}

public class Stats
{
    public int totalSessionsPlayed { get; set; }
    public int totalSessionsLost { get; set; }
    public int totalSessionsWon { get; set; }
    public int totalChampionKills { get; set; }
    public int totalDamageDealt { get; set; }
    public int totalDamageTaken { get; set; }
    public int mostChampionKillsPerSession { get; set; }
    public int totalMinionKills { get; set; }
    public int totalDoubleKills { get; set; }
    public int totalTripleKills { get; set; }
    public int totalQuadraKills { get; set; }
    public int totalPentaKills { get; set; }
    public int totalUnrealKills { get; set; }
    public int totalDeathsPerSession { get; set; }
    public int totalGoldEarned { get; set; }
    public int mostSpellsCast { get; set; }
    public int totalTurretsKilled { get; set; }
    public int totalPhysicalDamageDealt { get; set; }
    public int totalMagicDamageDealt { get; set; }
    public int totalFirstBlood { get; set; }
    public int totalAssists { get; set; }
    public int maxChampionsKilled { get; set; }
    public int maxNumDeaths { get; set; }
}

Now that we've established the structure, we need to Deserialize the string into an object of our created type, Rootobject. This will convert the plain JSON string into individual objects. From there, fetching details is as effortless as eating a piece of cake.

using Newtonsoft.Json;

Rootobject rt = JsonConvert.DeserializeObject<Rootobject>(jsonstr);
if(rt.champions[1].id == 36)
{
    Console.WriteLine(rt.champions[1].stats.totalSessionsWon);
}

Answer 2

If you're unfamiliar with the library Newtonsoft.Json;, here's a step-by-step guide on how to install Newtonsoft. Once installation is complete, I'll let you in on a little secret: XML and JSON are formats that utilize human-readable text to transmit data objects which consist of attribute–value pairs. Retrieving data from these string formats is as easy as working with a database.

In order to efficiently retrieve data from a JSON string, we first need to create an object representation that reflects its hierarchy. Take a look at what your data or JSON string looks like. At the topmost level, you'll find attributes such as summonerId, modifyDate, and champions. Within champions, there could be an indefinite number of champion details, so we've created a list called champions.

Moving down one level in the hierarchy, you'll see the champion ID and their stats. So, we need to create another class to represent the stats of each champion. Your classes will therefore look something like this:

public class Rootobject
{
    public int summonerId { get; set; }
    public long modifyDate { get; set; }
    public List<Champion> champions { get; set; }
}

public class Champion
{
    public int id { get; set; }
    public Stats stats { get; set; }
}

public class Stats
{
    public int totalSessionsPlayed { get; set; }
    public int totalSessionsLost { get; set; }
    public int totalSessionsWon { get; set; }
    public int totalChampionKills { get; set; }
    public int totalDamageDealt { get; set; }
    public int totalDamageTaken { get; set; }
    public int mostChampionKillsPerSession { get; set; }
    public int totalMinionKills { get; set; }
    public int totalDoubleKills { get; set; }
    public int totalTripleKills { get; set; }
    public int totalQuadraKills { get; set; }
    public int totalPentaKills { get; set; }
    public int totalUnrealKills { get; set; }
    public int totalDeathsPerSession { get; set; }
    public int totalGoldEarned { get; set; }
    public int mostSpellsCast { get; set; }
    public int totalTurretsKilled { get; set; }
    public int totalPhysicalDamageDealt { get; set; }
    public int totalMagicDamageDealt { get; set; }
    public int totalFirstBlood { get; set; }
    public int totalAssists { get; set; }
    public int maxChampionsKilled { get; set; }
    public int maxNumDeaths { get; set; }
}

Now that we've established the structure, we need to Deserialize the string into an object of our created type, Rootobject. This will convert the plain JSON string into individual objects. From there, fetching details is as effortless as eating a piece of cake.

using Newtonsoft.Json;

Rootobject rt = JsonConvert.DeserializeObject<Rootobject>(jsonstr);
if(rt.champions[1].id == 36)
{
    Console.WriteLine(rt.champions[1].stats.totalSessionsWon);
}

Answer 3

Answer №2

While assisting the author of the question in utilizing the JObject library to query their JSON object, it dawned upon me to provide a solution using the same approach.

The essence of querying JSON with JObject lies in its integration with Linq, which serves as a specialized query language for extracting data from various sources. However, I acknowledge that Linq can be quite challenging for new C# programmers to comprehend. In light of this, Mohit Shrivastrava's answer presents a simpler alternative for newcomers to grasp.

// Parses the API's JSON into an accessible format
JObject usableJson = JObject.Parse(json); 

// Retrieves champion objects
JToken champions = usableJson["champions"];

// Finds the desired champion object using Linq's FirstOrDefault method.
// This method returns the first matching object based on the provided query,
// otherwise, null if no match is found.
JToken champion = champions.FirstOrDefault(c=> (int)c["id"] == 36);

if (champion != null)
{
    // Retrieves the stats object
    JToken stats = champion["stats"];

    // Extracts the value of totalSessionsWon field from the object.
    int totalSessionsWon = (int) stats["totalSessionsWon"];
}

Answer 4

While assisting the author of the question in utilizing the JObject library to query their JSON object, it dawned upon me to provide a solution using the same approach.

The essence of querying JSON with JObject lies in its integration with Linq, which serves as a specialized query language for extracting data from various sources. However, I acknowledge that Linq can be quite challenging for new C# programmers to comprehend. In light of this, Mohit Shrivastrava's answer presents a simpler alternative for newcomers to grasp.

// Parses the API's JSON into an accessible format
JObject usableJson = JObject.Parse(json); 

// Retrieves champion objects
JToken champions = usableJson["champions"];

// Finds the desired champion object using Linq's FirstOrDefault method.
// This method returns the first matching object based on the provided query,
// otherwise, null if no match is found.
JToken champion = champions.FirstOrDefault(c=> (int)c["id"] == 36);

if (champion != null)
{
    // Retrieves the stats object
    JToken stats = champion["stats"];

    // Extracts the value of totalSessionsWon field from the object.
    int totalSessionsWon = (int) stats["totalSessionsWon"];
}

Extracting information from multiple JSON arrays in C#

Answer №1

Answer №2

Similar questions

Using Node to parse XLSX files and generate JSON data

Convert C# webapi date formats to Java using Gson

The error `Uncaught TypeError: array_unique(): Argument #1 ($array) must be of type array, string given` suggests that the

extract several fields from a json object

Using opening and closing curly braces within a PHP foreach loop

Transforming the MySQL result array into JSON format

Exploring the Depths of Multidimensional JSON Arrays in PHP

Organize Selenium Elements in C# without Using Tables

Leveraging the get_account_funds function within the betfair.py library

Exploring the Interplay of JSON Objects in SQL Server and C#

Combining a JSON file and a CSV file into a pandas dataframe for analysis

Assessing the string to define the structure of the object

Using JSON to pass a function with parameters

Sending user input from search component to main App.js in React

Adding information to an HTML table using JQuery

What is causing the difficulty in accessing the 'query' feature within the API, and why is the question bank failing to display?

What is the best way to eliminate the additional square bracket from a JSON file containing multiple arrays?

Navigating and extracting nested JSON properties using JavaScript (React)

Tips for building a versatile fetch function that can be reused for various JSON formats within a React application

Flexigrid, link to fill the grid