Skip to main content

Notifications

Announcements

Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
Dynamics 365 Community / Forums / Dynamics 365 general forum / CRM Virtual Entities c...
Dynamics 365 general forum

CRM Virtual Entities connect to Business Central

(0) ShareShare
ReportReport
Posted on by Eccountable 613
Has anyone used CRM's Virtual Entity to connect to Business Central? I created an OData endpoint in BC and tested it with Postman. Then I followed the steps on Getting Started (docs.microsoft.com/.../create-edit-virtual-entities) and I did include the authentication user and key that worked in Postman as a Header parameter, and then tried to access the new entity with Advanced Find and got an error. I checked the Plugin Trace Log and the error is a generic error:
Unhandled Exception: Microsoft.Xrm.Sdk.Data.Exceptions.GenericDataAccessException: An OData error occurred.
at Microsoft.Xrm.DataProvider.Odata.V4.Plugins.Client.ExceptionTranslationEdmModelLoader.GetModel(ODataDataSource info, IDictionary`2 httpHeaders)
at Microsoft.Xrm.DataProvider.Odata.V4.Plugins.Metadata.ODataMetadataContextFactory.CreateCachedData(ODataDataSource dataSourceInfo, Guid organizationId, IDictionary`2 httpHeaders)
at …..blah blah....
Any suggestions would be appreciated. 
Categories:
Business Central
Customization / Solutions / SDK and API
  • Suggested answer
    Eccountable Profile Picture
    Eccountable 613 on at
    RE: CRM Virtual Entities connect to Business Central

    After reading this awesome blog post from Jesper Osgaard, it seems that connecting CRM to BC with virtual entities is not possible because virtual entities require a GUID primary key from the publishing source, and BC does not have them.  

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join us in the Community for an AMA: December 12th Register Today

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans