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
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Users online (1,855)