Small and medium business | Business Central, N...

How do you handle null date values via API ?

(1) Share

Report

Posted on by Hinnack

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 ?

Kind Regards

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (2)

Answers (0)

Hinnack 69 on at

Like (1)

Report

For more clarity:

With NULL values are actually meant 0D values

Was this reply helpful? Yes No
Suggested answer

Andy Sather on at

Like (0)

Report

Hello - I found a similar message on a different Microsoft Community (power automate). Not sure if you can apply the same workaround: powerusers.microsoft.com/.../420710

You can also reach out to our Developer Support on our Yammer for assistance as well:

www.yammer.com/dynamicsnavdev

Was this reply helpful? Yes No