Exception occurs while deserialize json containing date with different format C#

Question

Having json string containing date field

{
  "totalSize": 2,
  "records": [
    {
      "Id": "5006C000008ZhEDQA0",
      "CreatedDate": "2021-12-01T15:14:20.000+0000",
      "CaseNumber": "01378682",
      "Status": "Open"
    },
    {
      "Id": "5006C000008ZhE00A0",
      "CreatedDate": "2021-12-05T08:00:00.000+0000",
      "CaseNumber": "01378692",
      "Status": "Open"
    }
  ]
}

I'm trying to do normal Deserialization where CreatedDate datatype is DateTime.

JsonSerializer.Deserialize<SFHistoryResponse>(stringResponse);

I'm getting

The JSON value could not be converted to System.DateTime. Path: $.records[0].CreatedDate

is there any way to format JSON's date part before Deserialization

Kip Morgan · Accepted Answer · 2022-01-21 14:35:28Z

1

The Newtonsoft JSON library can deserialize the string properly without throwing an exception:

using Newtonsoft.Json;

var response =  JsonConvert.DeserializeObject<SFHistoryResponse>(stringResponse);

answered Jan 21, 2022 at 14:35

Kip Morgan

7383 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Dark S Over a year ago

same thing i did.. and its throwing error as date format in json is "2021-12-05T08:00:00.000+0000" and it wont work

Dark S Over a year ago

i did trick by replacing ".000+0000" with "" before deserialization but its marked as in appropriate

Kip Morgan Over a year ago

You're using the deserializer out of System.Text.Json. It isn't the same.

Dark S Over a year ago

ohh my bad, i will try this right away

Aviv Halevy · Accepted Answer · 2022-01-21 14:40:05Z

In your case your classes need to be:

  public class Record
{
    public string Id { get; set; }
    public DateTime CreatedDate { get; set; }
    public string CaseNumber { get; set; }
    public string Status { get; set; }
}

public class SFHistoryResponse
{
    public int totalSize { get; set; }
    public List<Record> records { get; set; }
}

and when you try to deserialize the json

SFHistoryResponse l = JsonConvert.DeserializeObject<SFHistoryResponse>(jsonString);

tested my self

tbResult.Text = "l.records[0].CreatedDate.ToString() - " + l.records[0].CreatedDate.ToString();

Collectives™ on Stack Overflow

Exception occurs while deserialize json containing date with different format C#

2 Answers 2

4 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Related