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
Copy link

Link copied!

For more clarity:

With NULL values are actually meant 0D values

Was this reply helpful? Yes No
Suggested answer

Andy Sather Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Join the conversation

Community site session details

How do you handle null date values via API ?

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2025 Community Spotlights

Congratulations to the January Top 10 Community Leaders

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

How do you handle null date values via API ?

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2025 Community Spotlights

Congratulations to the January Top 10 Community Leaders

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates