Question 110628 in Json Question posted in
Our archive of expertly curated questions and answers provides insights and solutions to common problems related to this popular data interchange format. From parsing and manipulating JSON data to integrating it with various programming languages and web services, our archive has got you covered. Start exploring today and take your JSON skills to the next level

JSON Deserialization issue with DateTime in MM/dd/yyyy HH:mm:ss

I am having a JSON with a date time in MM/dd/yyyy HH:mm:ss format, for example, 12/20/2000 10:30:00.

The complete JSON will be something similar to this.


[
    {
        "id": 10001,
        "name": "Name 1",
        "date": "10/01/2022 00:00:00"
    },
    {
        "id": 10002,
        "name": "Name 2",
        "date": "10/01/2022 00:00:00"
    },
    {
        "id": 10003,
        "name": "Name 3",
        "date": "10/01/2022 00:00:00"
    }
]

I have a c# class with id, name and date where the date is a DateTime type.
I am trying to convert the JSON object to a list of Objects, but I am getting a conversion error as shown below.

System.AggregateException: One or more errors occurred. (Unable to deserialize response content to the type of List`1)rn ---> System.Exception: Unable to deserialize response content to the type of List`1rn

If I remove the date from the class, everything works fine.

If I convert the date to a string type, it works. But I need to keep it as DateTime.

Tags:

2

Answers


  1. 0

    you can do this, with DateTime properties you need to provide the JsonConverter.

    public class Root
{
    public int id { get; set; }
    public string name { get; set; }
    public DateTime date { get; set; }
}

var ls = JsonConvert.DeserializeObject<List<Root>>(content, new IsoDateTimeConverter { DateTimeFormat = "MM/dd/yyyy HH:mm:ss" });

    DeserializeObject Declaration:

    /// <summary>
/// Deserializes the JSON to the specified .NET type using a collection of <see cref="JsonConverter"/>.
/// </summary>
/// <typeparam name="T">The type of the object to deserialize to.</typeparam>
/// <param name="value">The JSON to deserialize.</param>
/// <param name="converters">Converters to use while deserializing.</param>
/// <returns>The deserialized object from the JSON string.</returns>
[DebuggerStepThrough]
public static T? DeserializeObject<T>(string value, params JsonConverter[] converters)
{
    return (T?)DeserializeObject(value, typeof(T), converters);
}

    Reference: https://www.newtonsoft.com/json/help/html/P_Newtonsoft_Json_Converters_IsoDateTimeConverter_DateTimeFormat.htm

    Login or Signup to reply.
  2. 0

    this works for me

    var jsonSettings = new JsonSerializerSettings { DateFormatString = "dd/MM/yyyy hh:mm:ss" };
    
List<Data> data = JsonConvert.DeserializeObject<List<Data>>(json, jsonSettings);

public class Data
{
    public int id { get; set; }
    public string name { get; set; }
    public DateTime date { get; set; }
}
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search