How to set Odata Server Side Pagination

[hnguyen_kinaxis]

Hello,

We are trying to override the default server page size for some odata2 endpoint with pretty large dataset. 

• https://help.sap.com/docs/SAP_SUCCESSFACTORS_PLATFORM/d599f15995d348a1b45ba5603e2aba9b/a9bbbd1bb3bf4...

https://community.sap.com/t5/integration-blog-posts/handling-large-data-with-sap-cloud-platform-inte...

But is there is something similar for other odata other than SuccessFactors?

• We have tried to do this in IGM without success.
  SPRO
  -> ABAP Platform
  -> Application Server
  -> System Administration
  -> Maintain V2 Odata Customizing
  Set Paging size = 1000

What did we miss?

Regards,

[junwu]

what's the issue?

[hnguyen_kinaxis]

The issue is that in our SAP instance default $skiptoken is 100, which causes perfomance issues for large dataset. We are trying to find a way to bump it up to at least 50000 without success.

[junwu]

don't know what you are talking, if you want to have more data, just ask for more, why it is related to server page size?

[hnguyen_kinaxis]

I can always have a complete data in chunks of 100 records each; which results in too many iterations. It would be nice to bump up the server page size in order to reduce the number of iterations.

[junwu]

then you just ask $top=500 to get 500 records, if it is properly implemented odata.

[litox]

As long as I understand, if you are relying on $skiptoken (server-side pagination) then you cannot use the $top parameter (client-side pagination) just like that. Apparently the implementation applies first the $top and then the token, which is contrary to the standard..