Add Paging for Virtual Entities with a custom data provider

(2) Share

Report

Posted on by cd09

We have implemented a solution for our client that archives activities from Dynamics 365 to an Azure Cosmos DB. We are displaying the archived activities from the Azure Cosmos DB using their REST API within a Dynamics 365 plugin and a Virtual Entity. We recently tried to implement paging, but found that the Azure Cosmos DB only supports it using this method: Querying Azure Cosmos DB resources using the REST API | Microsoft Docs

Since that method requires a response token to retrieve the next page and Dynamics 365 plugins cannot receive responses, we're looking to understand what other options are available for us to implement paging with the Azure Cosmos data within Dynamics 365 using supported methods.

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

JessonCoock 26 on at

Like (1)

Report

To handle paging, consider using Azure Functions as a middle layer. The function can query Cosmos DB, handle the continuation token, and return paged data to Dynamics 365.

Was this reply helpful? Yes No
JessonCoock 26 on at

Like (0)

Report

To add paging with Azure Cosmos DB data in Dynamics 365, you can try a custom paging approach. Use the continuation token from the Cosmos DB API to fetch the next set of results in multiple requests, and store the token in a custom field or entity to manage paging in your plugin. This way, you can handle paging without needing direct responses.

Was this reply helpful? Yes No