Home / Questions / 177571
Accepted
Ariel Octavio D'Alfeo
Asked: 2020-07-04 07:27:58 +0800 CST 2020-07-04 07:27:58 +0800 CST

Parse Json C# to Object

  • 772

What would be the best way to parse this Json?

https://drive.google.com/file/d/1A9-6o99kcIqRM3CEaXxYwh_Dv-vUkvnM/view?usp=sharing

I tried it like this, but I don't get data

var resultJson2 = Json.deserialize<List<ClimaHour>>(result.Result);
public class ClimaHour {
    public  List<int> couldCover { get; set; }
    public  List<string> dayOfWeek { get; set; }
    public  List<string>dayOrNight { get; set; }
    public  List<int> expirationTimeUtc { get; set; }
    public  List<int> iconCode { get; set; }
    public  List<int> iconCodeExtend { get; set; }
    public  List<int> precipChance { get; set; }
    public  List<string> precipType { get; set; }
    public List<decimal> pressureAltimeter { get; set; }
}
c#

1 Answers

  1. Best Answer

    In theory you should just read the content of the json, store it in a , stringand pass that variable for deserialization .

    string jsonPath = System.IO.File.ReadAllText(json);
var jsonD = JsonConvert.DeserializeObject<ClimaHour>(jsonPath);

    The only weird thing I noticed in your question, was that you're trying to deserialize a list( List<ClimaHour>) from ClimaHourwhen it should just be a Objeto.

    Another thing is that you use Json.deserialize ... I searched for that library and couldn't find it =/ , that's why the answer I gave is using Newtonsoft .

    Now, since you indicate one urlfor said JSON and it is found in Google Drive , we must build a function that returns a valid url for the json deserialization.

    Helpers helper = new Helpers();
using (var web = new WebClient())
{
   string data = string.Empty;
   string url = helper.GetGoogleDriveDownloadLinkFromUrl("https://drive.google.com/file/d/1A9-6o99kcIqRM3CEaXxYwh_Dv-vUkvnM/view");
   data = web.DownloadString(url);
   var json = JsonConvert.DeserializeObject<ClimaHour>(data);
}

    And the implementation of the method GetGoogleDriveDownloadLinkFromUrl, which is inside the classHelpers

    public class Helpers
{
   public string GetGoogleDriveDownloadLinkFromUrl(string url)
   {
      int index = url.IndexOf("id=");
      int closingIndex;

      if (index > 0)
      {
         index += 3;
         closingIndex = url.IndexOf('&', index);

         if (closingIndex < 0)
            closingIndex = url.Length;
      }
      else
      {
         index = url.IndexOf("file/d/");

         if (index < 0)
            return string.Empty;

            index += 7;
            closingIndex = url.IndexOf('/', index);

            if (closingIndex < 0)
            {
               closingIndex = url.IndexOf('?', index);

               if (closingIndex < 0)
                  closingIndex = url.Length;
            }
       }
       return $"https://drive.google.com/uc?id={url.Substring(index, closingIndex - index)}";
     }
  }

    I can't take all the credit and I mention that the function that creates the url was taken from this link ; The way to call said function can be by creating a class (as I did) or within the same class that reads the JSON, I leave that to your discretion, colleague.

    • 0