oData endpoint does not support $skip or $count

(1) Share

Report

Posted on by NingZhu

Experts,

We are using oData endpoints for Dynamics 365 to talk with other systems.

There are some noticeable compliant issues and we need a solution to work around.

In particular, $skip is not supported, so how to conduct pagination? BTW, fetchxml is not an option here, since it is NOT oData standard. In addition, $count only returns 5,000 even you can have millions of hits for the query, more practical, we need count about 100K to 250K records for a query hit.

What are solutions here using oData protocol standard? Or we have to standup our own middle-tier, which we are trying to avoid, unless that is the last resort.

Thanks a million!

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Kristian_Cole 195 on at

Like (0)

Report

You are better off filtering down the search to the most relevant results.
Query options overview - OData | Microsoft Learn

100k to 250k what will the user do with that data to screen?

If you are after counts of records then try Count in expression language:
Count, CountA, CountIf, and CountRows functions - Power Platform | Microsoft Learn
there is a 50k limit on that though.

Was this reply helpful? Yes No
Guido Preite 1,488 Super User 2024 Season 1 on at

Like (0)

Report

when the existing records are more than the specified count, a property called@odata.nextLink will be in the results and it will contain the full url to the next records and so on until the last page (max 5000 records per page)

Was this reply helpful? Yes No