Trying to deserialize a json file C#

Question

0.00/5 (No votes)

See more:

Hello, guys. My first time asking here. So, I got a situation trying to get some information from a Json File. I want to reach the information that is inside of the Public Class Valore and Resultados. This is how my code looks like:

C#

public class Valore
        public string fecha { get; set; }
    {
    public string hora { get; set; }
    public string pml { get; set; }
    public string pml_ene { get; set; }
    public string pml_per { get; set; }
    public string pml_cng { get; set; }
}

public class Resultado
{
    public string clv_nodo { get; set; }
    public List<valore> Valores { get; set; }
}

public class RootObject
{
    public string nombre { get; set; }
    public string proceso { get; set; }
    public string sistema { get; set; }
    public string area { get; set; }
    public List<resultado> Resultados { get; set; }
    public string status { get; set; }
}



class Program
{
    static void Main(string[] args)
    {
        RootObject PrecioMarginal;
        HttpWebRequest request = (HttpWebRequest)WebRequest.Create(@"Someplaceoninternet");
        using (HttpWebResponse response = (HttpWebResponse)request.GetResponse())
        using (Stream stream = response.GetResponseStream())
        using (StreamReader reader = new StreamReader(stream))
        {
            string json = reader.ReadToEnd();
            price = JsonConvert.DeserializeObject<rootobject>(json);
           
        }
        Console.WriteLine("El estatus del nodo es: " + Price.status);
        Console.ReadKey();
    }
}

What I have tried:

Not too much, my first time making code with C#

Posted 8-Feb-18 17:42pm

Member 13669173

Updated 8-Feb-18 20:47pm

Graeme_Grant

v2

Add a Solution

Comments

David_Wimbley 9-Feb-18 0:06am

Do you happen to have a sample of the JSON you are attempting to deserialize?

Graeme_Grant 9-Feb-18 0:10am

~~Having problems posting solutions, so will post answer here...~~

Solutions now posting..

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Graeme_Grant · Answer 1 · 2018-02-08T18:11:00

Solution 1

This question gets asked a lot in here, so I published an article that answers yours and other questions: Working with JSON in C# & VB[^]

Posted 8-Feb-18 18:11pm

Graeme_Grant

OriginalGriff · Answer 2 · 2018-02-08T20:46:00

I can strongly recommend using Newtonsoft.JSON for deserialization:

C#

/// <summary>
/// Load all known sheets
/// </summary>
/// <param name="path">
/// Full path to the JSON file containing the sheet data.
/// If not provided, the default will be used.</param>
/// <returns></returns>
public static List<AveryLabelSheet> Load(string path = null)
    {
    if (path == null) path = GetSensiblePathToSheetDataFile();
    if (!File.Exists(path)) throw new FileNotFoundException("Cannot locate the Sheet Data file:\n   \"" + path + "\"\nPlease check the path and try again.");
    try
        {
        all = JsonConvert.DeserializeObject<List<AveryLabelSheet>>(File.ReadAllText(path));
        }
    catch (Exception ex)
        {
        throw new FileLoadException("Unable to load Sheet Data.\nThe file \"" + path + "\" does not load correctly.", ex);
        }
    isLoaded = true;
    return new List<AveryLabelSheet>(all);
    }

One line of code does the whole job:

C#

all = JsonConvert.DeserializeObject<List<AveryLabelSheet>>

You will need to install Newtonsoft.JSON: you can add it to your project via the NuGet Package Manager (Tools ... NuGet Package Manager ... Package Manager Console):

PM> Install-Package Newtonsoft.Json

As an aside, I'm using JSON data for the first time with a recent prioject, and it's remarkably easy with the Newtonsoft stuff: serialize and deserialize a whole list of a custom class in one line of code each! The only hassle I found was it only works if the relevant class properties have both public getter and setter - I originally used private setters, and the data failed to read back, understandably.