Customer experience | Sales, Customer Insights,...

Answered

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

(0) Share

Report

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

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

mobeenmohsin on at

Like (0)

Report

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

Was this reply helpful? Yes No
Dynamics 365 Sumit ... 110 on at

Like (0)

Report

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

Was this reply helpful? Yes No
PaulinaStefanczyk 5 on at

Like (0)

Report

Hello,

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

Was this reply helpful? Yes No
Dynamics 365 Sumit ... 110 on at

Like (0)

Report

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

Was this reply helpful? Yes No

Join the conversation

Community site session details

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

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates

Community site session details

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

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates