Hi everyone, we’ve been using the ODATA API for quite some time, but recently we’ve ran into a bit of a limitation. It seems like the Odata API does not support SKIP & LIMIT, which are necessary if we want to build pagination in the application we’re building. The only option right now is to use TOP as a initial limit, but that does not scale well when working with large & increasing datasets.
Best answer by Mark JongelingView original
What is exactly your question?
Indicium does support the usage of both Top and Skip, f.e.: "&$skip=425&$top=25”. This will skip the first 425 rows and thereafter select the 25 records after. Our Universal GUI does also support pagination once a Page size is set up for a table in the model.
More info on it here: https://docs.thinkwisesoftware.com/docs/indicium/api#supported-odata-operations
I thought skip was not supported as it wasn’t documented. We tried it and it does help our issue.
Thanks for the feedback!