Customer experience | Sales, Customer Insights,...

Virtual entity in UCI

(0) Share

Report

Posted on by Community Member

Developing 365 on premise Unified Interface app, Implemented Virtual entity which is connected to oracle database. In ordinary form (non UCI), showing all the results like more than 250 records without considering the page size given for the subgrid on the form. Showing all the records is the actual requirement of project.

But in UCI its giving only 'n' number of records ('n' - the page size which is specified on the form). The pagination also not working. So not at all able to see records other than first 'n' number of records .

I have the same question (0)

All responses (5)

Answers (0)

Susana Carneiro on at

Like (0)

Report

Hello Rathika,

Can you please share more details how are you getting the date from Oracle and putting them on Dynamics? What processs is being used?

Thank you.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi, You can take the formatted date from oracle DB like "TO_CHAR(datefieldName,'DD/MM/YYYY HH:MI:SS AM')" and convert before submitting it to output context as below,

var _dtValue = Convert.ToDateTime(DateTime.ParseExact(date, "dd/MM/yyyy hh:mm:ss tt", CultureInfo.InvariantCulture)); . Remember the CRM field must be "Timezone independent".

But my question is different I can see all the records in non-UCI form but not in UCI. Can Anybody help in this please?

Was this reply helpful? Yes No
Susana Carneiro on at

Like (0)

Report

Hello,

Our main goal is trying to understand how the integration is being done.

For example, we have some customer using plugins to push the data from their data sources to Dynamics and we have a sample code to do the paging on the data source side.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Susana Carneiro, Could you able to provide that.

Was this reply helpful? Yes No
Suggested answer

Susana Carneiro on at

Like (0)

Report
Hello Rathika,

Please note that the sample that we have applies when a retrive multiple plugin is being used to fetch data from your data provider to a Virtual Entity in Dynamics.

Below is a set of Api calls - as an example - that the provider needs to support. You also need to ensure that your odata endpoint supports equivalent API's. Test the odata endpoint through Postman and web browser:

Retrieve Multiple:

Multiple Records

Retrieve all records from Product entity

https://services.odata.org/V4/OData/OData.svc/Products?$top=50&$select=ID,Name&$count=true

Retrieve all records from Product entity which has the name 'Lemonade'

https://services.odata.org/V4/OData/OData.svc/Products?$filter=contains(Name,'Lemonade')&$top=50&$select=ID,Name&$count=true

Retrieve all the records which has Name = Lemonade

https://services.odata.org/V4/OData/OData.svc/Products?$filter=Name eq 'Lemonade'&$top=50&$select=ID,Name&$count=true

Paging on Grid

Should work when click the paging navigation button on Grid

http://veodataservicev9.azurewebsites.net/odata/Tickets?$skip=50&$top=50&$select=TicketID,Title&$count=true

Retrieve:

Single Record: It's always works on:

https://services.odata.org/V4/OData/OData.svc/Products(5)

The same concept for a for a custom data provide is explained here:

The fetchxml has the pagination information inside it (refer https://community.dynamics.com/crm/b/exploringdynamics365/posts/paging-in-fetchxml as an example)

The retrieve multiple code needs to make sure that it reads the pagination information and honors it. Fetch the nth page if asked etc.

It needs to set the "morerecords" and other pagination property on the entitycollection result that it sends back (refer stackoverflow.com/.../dynamics-crm-how-to-get-the-second-page-of-a-fetchxml-query-beyond-the-5000-el as an example).

Hope this helps.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Virtual entity in UCI

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

Virtual entity in UCI

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