Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / In Dynamics 365, getti...
Customer experience | Sales, Customer Insights,...
Answered

In Dynamics 365, getting error in Virtual Entity :- code 0x80050263 ,An OData error occurred

(0) ShareShare
ReportReport
Posted on by Dynamics 365 Sumit ... 110

Hi ,

I want to fetch data from external azure sql database into dynamics 365 . So i used concept of virtual entity .

For fetching data into virtual entity  , i will need OData v4 service provider . So i created one logic app in Azure which will return data as shown below

Logic app url is somewhat like this :- https://*****************.logic.azure.com/workflows/19**************a05d7ffffeaca/triggers/manual/paths/invoke/TestData?api-version=2016-10-01&sp=%2Ftriggers%2Fmanual%2Frun&sv=1.0&sig=_Bed***************JmJm7PMqM-1644wk

Below is data fetched by above odata service

3113.pastedimage1582857009613v1.png

So Id is primary key of Guid type and StudentName is of text type , i want to map these two fields in D365 virtual entity

Below is virtual odata service provider configured in D365. please let me know if i have configured anything wrong

6114.pastedimage1582857164741v2.png

i have to add parameters as Azure url was having parameters as shown below

4377.pastedimage1582857216737v3.png

Below is my virtual entity with configuration :-

2185.pastedimage1582857261483v4.png

Below two are fields mapped with odata data

0358.pastedimage1582857310720v5.png

5518.pastedimage1582857340821v6.png

When i check Data in virtual entity from UI , this is error coming.

3051.pastedimage1582857381066v7.png

  • Dynamics 365 Sumit Thakran Profile Picture
    Dynamics 365 Sumit ... 110 on at
    RE: In Dynamics 365, getting error in Virtual Entity :- code 0x80050263 ,An OData error occurred

    Hi ,

    I was able to resolve the issue. You have to match External Collection name and External field name also should match.

    Also verify these fields name in your OData V4 API.

    Thanks

  • PaulinaStefanczyk Profile Picture
    PaulinaStefanczyk 5 on at
    RE: In Dynamics 365, getting error in Virtual Entity :- code 0x80050263 ,An OData error occurred

    Hello,

    I face the same problem. Could you tell me if you resolved it and if yes then how did you do this?

  • Dynamics 365 Sumit Thakran Profile Picture
    Dynamics 365 Sumit ... 110 on at
    RE: In Dynamics 365, getting error in Virtual Entity :- code 0x80050263 ,An OData error occurred

    hi,

    yes , i have followed all steps carefully given in documention.

    Also i have checked in both Classic and UCI interface. Same error coming.

    I have shared all screenshots of setting i have done , if i m doing wrong somewhere . can you help on that.

    Thanks

    Sumit

  • Verified answer
    mobeenmohsin Profile Picture
    mobeenmohsin on at
    RE: In Dynamics 365, getting error in Virtual Entity :- code 0x80050263 ,An OData error occurred

    Hi Sumit,

    Please help to find official documentation for virtual entity as below:

    https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/customize/create-edit-virtual-entities

    https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/customize/virtual-entity-odata-provider-requirements

    Please confirm if you are following the process as above documentation and once confirmed you can try to see the data in legacy web client or both legacy web client and UCI have this issue. Thank you. 

    Best Regards,

    Mobeen Mohsin  

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

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