JSON Date field does not bound to C# datetime field

Question

I have the following DateTime field in business entity c# :

public DateTime BirthDate { get; set; }

I got the following message when I call the API passing the entity object as JSON:

DateTime content '2009-02-15T00:00:00Z' does not start with '\/Date(' and end with ')\/' as required for JSON.

I searched the web tried many formats but does not work with me!

The error message is clear! but I have more than an hour trying to send a request to my API. Please do not vote down my post! I did my best.

This is the JSON object I sent via postman:

{
  "patient": {
"Number": 20012,
"FirstName": "ِAnas",
"LastName": "Tina",
"BirthDate":"1986-12-29",
"Phone": "000000",
"Mobile": "00000",
"Address": "Damas",
"Job": "Developer",
"Note": "This is a note",
"GenderId": 1
  }
}

[DataContract]    
public class Patient
{
    [Description("Patient's Id in ECMS database")]
    [DataMember(Order = 1)]
    public int Id { get; set; }

    [Description("Patient's unique number")]
    [DataMember(Order = 2)]
    public int Number { get; set; }

    [Description("Patient's first name")]
    [DataMember(Order = 3)]
    public string FirstName { get; set; }

    [Description("Patient's last name")]
    [DataMember(Order = 4)]
    public string LastName { get; set; }

    [Description("Patient's birth date")]
    [DataMember(Order = 5)]
    public DateTime BirthDate { get; set; }
}

Looks like on server side you are using JavaScriptSerializer, but you should use JsonSerializer. What kind of application is on server side? ASP.NET, WCF or else? — Fabio
– Fabio, Commented Nov 4, 2019 at 3:35

kkica · Accepted Answer · 2019-11-04 03:32:05Z

1

Use this extension

public class DateTimeConverter : IsoDateTimeConverter
{
    public DateTimeConverter()
    {
        base.DateTimeFormat = "yyyy-MM-dd";
    }
}

And add to your model

[JsonConverter(typeof(DateTimeConverter))]
public DateTime BirthDate { get; set; }

This way you can send the date in "yyyy-MM-dd" format. You can change it to another format if you like.

answered Nov 4, 2019 at 3:32

kkica

4,1041 gold badge22 silver badges41 bronze badges

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

2 Comments

Fabio Over a year ago

Will have no effect if other than JsonSerializer are used for deserialisation request data. For JsonSerializer given data format is standard, so no need for explicit converter.

Anas Tina Over a year ago

I used the code provided but still got the same exception.

Divyang Desai · Accepted Answer · 2019-11-04 05:17:05Z

1

I used the same json and created in a namespace two classes:

public partial class JsonModel
{
    [JsonProperty("patient")]
    public Patient Patient { get; set; }
}

public partial class Patient
{

    [JsonProperty("Number")]
    public string Number;

    [JsonProperty("FirstName")]
    public string FirstName;

    [JsonProperty("LastName")]
    public string LastName;

    [JsonProperty("BirthDate")]
    public DateTime BirthDate;

    [JsonProperty("Phone")]
    public string Phone;

    [JsonProperty("Mobile")]
    public string Mobile;

    [JsonProperty("Address")]
    public string Address;

    [JsonProperty("Job")]
    public string Job;

    [JsonProperty("Note")]
    public string Note;

    [JsonProperty("GenderId")]
    public int GenderId;

    // Return a textual representation of the order.
    public override string ToString()
    {
        return "FirstName: " + FirstName +
        "\nLastName: " + LastName +
         "\nBirthDate: " + BirthDate;
    }
}

Created a console application for testing purpose.

static void Main(string[] args)
{
    string json = @"{
     ""patient"": {
     ""Number"": 20012,
     ""FirstName"":  ""Anas"",
     ""LastName"":  ""Tina"",
     ""BirthDate"": ""1986-12-29"",
     ""Phone"":  ""000000"",
     ""Mobile"":  ""00000"",
     ""Address"":  ""Damas"",
     ""Job"":  ""Developer"",
     ""Note"":  ""This is a note"",
     ""GenderId"": 1
      }
    } ";

    var test = FromJson(json);
    Console.WriteLine(test.Patient);
    Console.ReadKey();
}

public static JsonModel FromJson(string json)
{
    // Return the result.enter code here
    return JsonConvert.DeserializeObject<JsonModel>(json);
}

Finally the result was:

FirstName: Anas
LastName: Tina
BirthDate: 12/29/1986 12:00:00 AM

edited Nov 4, 2019 at 5:17

Divyang Desai

7,90414 gold badges56 silver badges83 bronze badges

answered Nov 4, 2019 at 4:43

Bresly Alexander Arias Baez

111 bronze badge

3 Comments

Anas Tina Over a year ago

Why should I use JsonProperty if I am using DataMember attribute, please?

Anas Tina Over a year ago

I updated the question to include my Entity class, please check.

Bresly Alexander Arias Baez Over a year ago

look a this post stackoverflow.com/questions/44227653/…

Collectives™ on Stack Overflow

JSON Date field does not bound to C# datetime field

2 Answers 2

2 Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related