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 Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Users online (2,463)