Notifications
Announcements
No record found.
Hello Experts,
I am working on Virtual entity and i am retrieving data from Azure SQL database for that I have written OData which retrieves Sql data from Azure SQL Database. I am trying to mapping data to virtual entity fields but data is not showing.
OutPut of ODataservice:
URL: http://sqldb.azurewebsites.net/$metadata
{ "odata.metadata":"http://sqldb.azurewebsites.net/$metadata#Contacts","value":[ { "id":"1","Name":"abc1","Phone":"1111111111","Email":"abs@gmail.com","Address":"India" },{ "id":"2","Name":"abc2","Phone":"2222222222","Email":"afgs@gmail.com","Address":"India" },{ "id":"3","Name":"abc3","Phone":"3333333333","Email":"adfr@gmail.com","Address":"India" },{ "id":"4","Name":"abc4","Phone":"4444444444","Email":"sdy@gmail.com","Address":"India" },{ "id":"5","Name":"abc5","Phone":"5555555555","Email":"xyz@gmail.com","Address":"India" } ] }
But I am enable to get data, I am getting below type of error,
How to resolve that issue?
From References:
1. https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/customize/virtual-entity-walkthrough-using-odata-provider
2. https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/customize/create-edit-virtual-entities
The reason is because there is no property of GUID type for your entity. To create a virtual entity and map it to CRM entity, there must be a GUID property. You can try this OData demo service and it will be fine:
NOTE:contactId will be GUID field which is necessary.
winstonodata4.azurewebsites.net/$metadata
...
"
</Key>
<Property Name="contactId" Type="Edm.Guid" Nullable="false"/>
<Property Name="name" Type="Edm.String"/>
<Property Name="address" Type="Edm.String"/>
<Property Name="email" Type="Edm.String"/>
Thanks for reply winston he,
I have added contactId as a guid and mapped on Primary Key but I am getting same error
URL: dynamisitysqldb.azurewebsites.net/$metadata
URL: dynamisitysqldb.azurewebsites.net/Contacts
for Virtual Entity Data Sources
TimeOut: 120
Pagination Mode: Server-side Paging
Return Inline Count: False
I tried all the possibilities into the url and pagination mode but getting same error,
There could be something wrong when the virtual entity is configured, you can raise a support team for Microsoft support team for further deeper investigation.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Tom_Gioielli 55 Super User 2025 Season 2
Daniyal Khaleel 27 Most Valuable Professional
Scott Jackson UK 22
