Server paging is an option, see https://docs.microsoft.com/en-us/aspnet/web-api/overview/odata-support-in-aspnet-web-api/supporting-odata-query-options#server-paging
Mendix version of this is ?$top=100
See https://docs.mendix.com/refguide/odata-query-options