Null date values via API ?

(0) Share

Report

Posted on by iSteve

Hello,

we provide data via API interface. In our case some date fields are NULL. These NULL values are represented as 0001-01-01 in the API. When trying to write the data to a SQL database, we get an error because the min. date is 1753-01-01.

How do you handle such problems ?

With NULL values are actually meant 0D values

Categories:

Dynamics 365 Business Central

All responses (1)

Answers (0)

Suggested answer

Tech-Lucky 844 on at

Like (0)

Report

RE: Null date values via API ?

You need to manage this issue at the code level only the Null values stored in our SQL Database as 1900-01-01 or 1753-01-01 etc what I do is Extract the Year from the Date and compare it with IF Year>2000 then only assigned the Date to my Table Field else I skip the API value to be modified in my Date type Field to ignore this kind of default values.

mark my answer as verified if this was helpful