Home > Software engineering >  Unhandled exception. Newtonsoft.Json.JsonReaderException: Unexpected character encountered while par
Unhandled exception. Newtonsoft.Json.JsonReaderException: Unexpected character encountered while par

Time:03-23

I am working on a weather application for that I need to get the weather data from the server. the received data is stored in response variable, while printing the response I got the correct Json data, but got some error while converting it into dictionary and printing the values please help to solve it. Thanks In Advance

C# CODE:

using System;
using System.Net;
using Newtonsoft.Json;
class Program
{
static void Main(){
    var request = WebRequest.Create("website link");
    request.Credentials = CredentialCache.DefaultCredentials;
    var response = request.GetResponse();
    using (Stream dataStream = response.GetResponseStream())
        {
            StreamReader reader = new StreamReader(dataStream);
            string responseFromServer = reader.ReadToEnd();
            var myDictionary = JsonConvert.DeserializeObject<Dictionary<string, string>>(responseFromServer);
            if (myDictionary != null)
            {
                foreach (var key in myDictionary.Keys) //Error is here at myDictionary.Keys
                { 
                    Console.WriteLine(myDictionary[key]); 
                } 
            }
        }
    }
}

ERROR:

    Unhandled exception. Newtonsoft.Json.JsonReaderException: Unexpected character 
    encountered while parsing value: [. Path 'data', line 1, position 19.
        at Newtonsoft.Json.JsonTextReader.ReadStringValue(ReadType readType)
        at Newtonsoft.Json.JsonTextReader.ReadAsString()
        at Newtonsoft.Json.JsonReader.ReadForType(JsonContract contract, Boolean hasConverter)
        at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.PopulateDictionary(IDictionary dictionary, JsonReader reader, JsonDictionaryContract contract, JsonProperty containerProperty, String id)
        at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateObject(JsonReader reader, Type objectType, JsonContract contract, JsonProperty member, JsonContainerContract containerContract, JsonProperty containerMember, Object existingValue)
        at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateValueInternal(JsonReader reader, Type objectType, JsonContract contract, JsonProperty member, JsonContainerContract containerContract, JsonProperty containerMember, Object existingValue)
        at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.Deserialize(JsonReader reader, Type objectType, Boolean checkAdditionalContent)
        at Newtonsoft.Json.JsonSerializer.DeserializeInternal(JsonReader reader, Type objectType)
        at Newtonsoft.Json.JsonSerializer.Deserialize(JsonReader reader, Type objectType)
        at Newtonsoft.Json.JsonConvert.DeserializeObject(String value, Type type, JsonSerializerSettings settings)
        at Newtonsoft.Json.JsonConvert.DeserializeObject[T](String value, JsonSerializerSettings settings)
        at Newtonsoft.Json.JsonConvert.DeserializeObject[T](String value)
        at Program.Main() in F:\Lenovo\Documents\web\C#\Program.cs:line 16

    

RESPONSE FROM SERVER AS STRING:

VALIDATED JSON FILE

    {
    "count": 1,
    "data": [{
        "rh": 70,
        "pod": "n",
        "lon": 80.27847,
        "pres": 1002.9,
        "timezone": "Asia\/Kolkata",
        "ob_time": "2022-03-22 12:30",
        "country_code": "IN",
        "clouds": 25,
        "ts": 1647952200,
        "solar_rad": 149.9,
        "state_code": "25",
        "city_name": "Chennai",
        "wind_spd": 4.1,
        "wind_cdir_full": "southeast",
        "wind_cdir": "SE",
        "slp": 1004,
        "vis": 5,
        "h_angle": 90,
        "sunset": "12:50",
        "dni": 515.54,
        "dewpt": 25.8,
        "snow": 0,
        "uv": 1.77082,
        "precip": 0,
        "wind_dir": 130,
        "sunrise": "00:41",
        "ghi": 151.03,
        "dhi": 57.44,
        "aqi": 156,
        "lat": 13.08784,
        "weather": {
            "icon": "c02n",
            "code": 801,
            "description": "Few clouds"
        },
        "datetime": "2022-03-22:12",
        "temp": 32,
        "station": "VOMM",
        "elev_angle": 11.39,
        "app_temp": 40.5
    }],
    "minutely": [{
        "timestamp_utc": "2022-03-22T12:57:00",
        "snow": 0,
        "temp": 29.1,
        "timestamp_local": "2022-03-22T18:27:00",
        "ts": 1647953820,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T12:58:00",
        "snow": 0,
        "temp": 29.1,
        "timestamp_local": "2022-03-22T18:28:00",
        "ts": 1647953880,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T12:59:00",
        "snow": 0,
        "temp": 29.1,
        "timestamp_local": "2022-03-22T18:29:00",
        "ts": 1647953940,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:00:00",
        "snow": 0,
        "temp": 29.1,
        "timestamp_local": "2022-03-22T18:30:00",
        "ts": 1647954000,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:01:00",
        "snow": 0,
        "temp": 29.1,
        "timestamp_local": "2022-03-22T18:31:00",
        "ts": 1647954060,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:02:00",
        "snow": 0,
        "temp": 29.1,
        "timestamp_local": "2022-03-22T18:32:00",
        "ts": 1647954120,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:03:00",
        "snow": 0,
        "temp": 29.1,
        "timestamp_local": "2022-03-22T18:33:00",
        "ts": 1647954180,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:04:00",
        "snow": 0,
        "temp": 29.1,
        "timestamp_local": "2022-03-22T18:34:00",
        "ts": 1647954240,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:05:00",
        "snow": 0,
        "temp": 29.1,
        "timestamp_local": "2022-03-22T18:35:00",
        "ts": 1647954300,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:06:00",
        "snow": 0,
        "temp": 29.1,
        "timestamp_local": "2022-03-22T18:36:00",
        "ts": 1647954360,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:07:00",
        "snow": 0,
        "temp": 29.1,
        "timestamp_local": "2022-03-22T18:37:00",
        "ts": 1647954420,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:08:00",
        "snow": 0,
        "temp": 29.1,
        "timestamp_local": "2022-03-22T18:38:00",
        "ts": 1647954480,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:09:00",
        "snow": 0,
        "temp": 29,
        "timestamp_local": "2022-03-22T18:39:00",
        "ts": 1647954540,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:10:00",
        "snow": 0,
        "temp": 29,
        "timestamp_local": "2022-03-22T18:40:00",
        "ts": 1647954600,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:11:00",
        "snow": 0,
        "temp": 29,
        "timestamp_local": "2022-03-22T18:41:00",
        "ts": 1647954660,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:12:00",
        "snow": 0,
        "temp": 29,
        "timestamp_local": "2022-03-22T18:42:00",
        "ts": 1647954720,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:13:00",
        "snow": 0,
        "temp": 29,
        "timestamp_local": "2022-03-22T18:43:00",
        "ts": 1647954780,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:14:00",
        "snow": 0,
        "temp": 29,
        "timestamp_local": "2022-03-22T18:44:00",
        "ts": 1647954840,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:15:00",
        "snow": 0,
        "temp": 29,
        "timestamp_local": "2022-03-22T18:45:00",
        "ts": 1647954900,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:16:00",
        "snow": 0,
        "temp": 29,
        "timestamp_local": "2022-03-22T18:46:00",
        "ts": 1647954960,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:17:00",
        "snow": 0,
        "temp": 29,
        "timestamp_local": "2022-03-22T18:47:00",
        "ts": 1647955020,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:18:00",
        "snow": 0,
        "temp": 29,
        "timestamp_local": "2022-03-22T18:48:00",
        "ts": 1647955080,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:19:00",
        "snow": 0,
        "temp": 29,
        "timestamp_local": "2022-03-22T18:49:00",
        "ts": 1647955140,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:20:00",
        "snow": 0,
        "temp": 29,
        "timestamp_local": "2022-03-22T18:50:00",
        "ts": 1647955200,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:21:00",
        "snow": 0,
        "temp": 29,
        "timestamp_local": "2022-03-22T18:51:00",
        "ts": 1647955260,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:22:00",
        "snow": 0,
        "temp": 29,
        "timestamp_local": "2022-03-22T18:52:00",
        "ts": 1647955320,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:23:00",
        "snow": 0,
        "temp": 29,
        "timestamp_local": "2022-03-22T18:53:00",
        "ts": 1647955380,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:24:00",
        "snow": 0,
        "temp": 29,
        "timestamp_local": "2022-03-22T18:54:00",
        "ts": 1647955440,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:25:00",
        "snow": 0,
        "temp": 29,
        "timestamp_local": "2022-03-22T18:55:00",
        "ts": 1647955500,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:26:00",
        "snow": 0,
        "temp": 29,
        "timestamp_local": "2022-03-22T18:56:00",
        "ts": 1647955560,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:27:00",
        "snow": 0,
        "temp": 29,
        "timestamp_local": "2022-03-22T18:57:00",
        "ts": 1647955620,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:28:00",
        "snow": 0,
        "temp": 28.9,
        "timestamp_local": "2022-03-22T18:58:00",
        "ts": 1647955680,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:29:00",
        "snow": 0,
        "temp": 28.9,
        "timestamp_local": "2022-03-22T18:59:00",
        "ts": 1647955740,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:30:00",
        "snow": 0,
        "temp": 28.9,
        "timestamp_local": "2022-03-22T19:00:00",
        "ts": 1647955800,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:31:00",
        "snow": 0,
        "temp": 28.9,
        "timestamp_local": "2022-03-22T19:01:00",
        "ts": 1647955860,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:32:00",
        "snow": 0,
        "temp": 28.9,
        "timestamp_local": "2022-03-22T19:02:00",
        "ts": 1647955920,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:33:00",
        "snow": 0,
        "temp": 28.9,
        "timestamp_local": "2022-03-22T19:03:00",
        "ts": 1647955980,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:34:00",
        "snow": 0,
        "temp": 28.9,
        "timestamp_local": "2022-03-22T19:04:00",
        "ts": 1647956040,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:35:00",
        "snow": 0,
        "temp": 28.9,
        "timestamp_local": "2022-03-22T19:05:00",
        "ts": 1647956100,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:36:00",
        "snow": 0,
        "temp": 28.9,
        "timestamp_local": "2022-03-22T19:06:00",
        "ts": 1647956160,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:37:00",
        "snow": 0,
        "temp": 28.9,
        "timestamp_local": "2022-03-22T19:07:00",
        "ts": 1647956220,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:38:00",
        "snow": 0,
        "temp": 28.9,
        "timestamp_local": "2022-03-22T19:08:00",
        "ts": 1647956280,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:39:00",
        "snow": 0,
        "temp": 28.9,
        "timestamp_local": "2022-03-22T19:09:00",
        "ts": 1647956340,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:40:00",
        "snow": 0,
        "temp": 28.9,
        "timestamp_local": "2022-03-22T19:10:00",
        "ts": 1647956400,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:41:00",
        "snow": 0,
        "temp": 28.9,
        "timestamp_local": "2022-03-22T19:11:00",
        "ts": 1647956460,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:42:00",
        "snow": 0,
        "temp": 28.9,
        "timestamp_local": "2022-03-22T19:12:00",
        "ts": 1647956520,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:43:00",
        "snow": 0,
        "temp": 28.9,
        "timestamp_local": "2022-03-22T19:13:00",
        "ts": 1647956580,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:44:00",
        "snow": 0,
        "temp": 28.9,
        "timestamp_local": "2022-03-22T19:14:00",
        "ts": 1647956640,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:45:00",
        "snow": 0,
        "temp": 28.9,
        "timestamp_local": "2022-03-22T19:15:00",
        "ts": 1647956700,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:46:00",
        "snow": 0,
        "temp": 28.9,
        "timestamp_local": "2022-03-22T19:16:00",
        "ts": 1647956760,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:47:00",
        "snow": 0,
        "temp": 28.8,
        "timestamp_local": "2022-03-22T19:17:00",
        "ts": 1647956820,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:48:00",
        "snow": 0,
        "temp": 28.8,
        "timestamp_local": "2022-03-22T19:18:00",
        "ts": 1647956880,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:49:00",
        "snow": 0,
        "temp": 28.8,
        "timestamp_local": "2022-03-22T19:19:00",
        "ts": 1647956940,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:50:00",
        "snow": 0,
        "temp": 28.8,
        "timestamp_local": "2022-03-22T19:20:00",
        "ts": 1647957000,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:51:00",
        "snow": 0,
        "temp": 28.8,
        "timestamp_local": "2022-03-22T19:21:00",
        "ts": 1647957060,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:52:00",
        "snow": 0,
        "temp": 28.8,
        "timestamp_local": "2022-03-22T19:22:00",
        "ts": 1647957120,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:53:00",
        "snow": 0,
        "temp": 28.8,
        "timestamp_local": "2022-03-22T19:23:00",
        "ts": 1647957180,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:54:00",
        "snow": 0,
        "temp": 28.8,
        "timestamp_local": "2022-03-22T19:24:00",
        "ts": 1647957240,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:55:00",
        "snow": 0,
        "temp": 28.8,
        "timestamp_local": "2022-03-22T19:25:00",
        "ts": 1647957300,
        "precip": 0
    }, {
        "timestamp_utc": "2022-03-22T13:56:00",
        "snow": 0,
        "temp": 28.8,
        "timestamp_local": "2022-03-22T19:26:00",
        "ts": 1647957360,
        "precip": 0
    }]
}

CodePudding user response:

You can't use Dictionary<string,string> with this data. Dictionary<string,string> would look like this:

{"field1": "value1", "field2": "value2"}

I used the Paste JSON As Classes feature in VS2019 and got the following:

    public class Rootobject
    {
        public int count { get; set; }
        public Datum[] data { get; set; }
        public Minutely[] minutely { get; set; }
    }

    public class Datum
    {
        public int rh { get; set; }
        public string pod { get; set; }
        public float lon { get; set; }
        public float pres { get; set; }
        public string timezone { get; set; }
        public string ob_time { get; set; }
        public string country_code { get; set; }
        public int clouds { get; set; }
        public int ts { get; set; }
        public float solar_rad { get; set; }
        public string state_code { get; set; }
        public string city_name { get; set; }
        public float wind_spd { get; set; }
        public string wind_cdir_full { get; set; }
        public string wind_cdir { get; set; }
        public int slp { get; set; }
        public int vis { get; set; }
        public int h_angle { get; set; }
        public string sunset { get; set; }
        public float dni { get; set; }
        public float dewpt { get; set; }
        public int snow { get; set; }
        public float uv { get; set; }
        public int precip { get; set; }
        public int wind_dir { get; set; }
        public string sunrise { get; set; }
        public float ghi { get; set; }
        public float dhi { get; set; }
        public int aqi { get; set; }
        public float lat { get; set; }
        public Weather weather { get; set; }
        public string datetime { get; set; }
        public int temp { get; set; }
        public string station { get; set; }
        public float elev_angle { get; set; }
        public float app_temp { get; set; }
    }

    public class Weather
    {
        public string icon { get; set; }
        public int code { get; set; }
        public string description { get; set; }
    }

    public class Minutely
    {
        public DateTime timestamp_utc { get; set; }
        public int snow { get; set; }
        public float temp { get; set; }
        public DateTime timestamp_local { get; set; }
        public int ts { get; set; }
        public int precip { get; set; }
    }

Try inserting these classes and then change code to JsonConvert.DeserializeObject<RootObject>

CodePudding user response:

I don't know how do you need to use data, but you can convert it to dictionary< string, object >

 var weather = JsonConvert.DeserializeObject<Dictionary<string,object>>(json);

  // or just
var weather = JObject.Parse(json);

how to use

    foreach (var prop in  ((JObject) ((JArray) weather["data"])[0]).Properties())
    {
        Console.WriteLine($"Name: {prop.Name}      Value:  {prop.Value} ");
    }
    
    //or minutely data
    
    foreach (var item in   ((JArray) weather["minutely"]))
    foreach (var prop in  ((JObject) item).Properties())
    {
        Console.WriteLine($"Name:   {prop.Name}         Value:    {prop.Value} ");
    }
  • Related