cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
accorti
Helper I
Helper I

Error with ODATA connector to create entity in CDS.

I am trying to create connections to MS Business Central (BC) using the web service URLs provided in BC. These are ODATA V4 end points and I am using the ODATA connector in CDS. When I use this method to create a new entity it errors out saying

Load to Common Data Service failed. Details: Bad Request {"error":{"code":"0x80040239","message":"DateTime is less than minumum value supported by CrmDateTime.  I believe this is occurring because some of the date records are null in BC. Despite the error, the entity is still created. 

 

The resulting entity consists of 2 columns in the data tab, my primary key (Job Number) and the date on which the entity was created (i.e. today). When I select the entity and look at the fields tab, all of the field names, data types and CDS type (custom or standard) are populated. The issue is when I look at the data tab which is where I am only seeing the two columns listed above. My ask is:

1) Can I correct the date error without having to backfill the dates in BC (aka. allow null values) 

2) Will that correct the issue with my fields not pulling in or is there something else going on here? 

 

See attached for a screenshot of my resulting data tab and fields tab for this entity. 

1 REPLY 1
v-monli-msft
Community Support
Community Support

Hi @accorti ,

 

Check if below blog could help:

https://msdynamicsworld.com/story/working-microsoft-dynamics-365-business-central-customizations-pow...

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (2,970)