Solved

Odata Pagination

  • 8 December 2022
  • 2 replies
  • 111 views

Userlevel 1
Badge

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.

icon

Best answer by Mark Jongeling 8 December 2022, 13:07

View original

This topic has been closed for comments

2 replies

Userlevel 1
Badge

Hi Mark,

I thought skip was not supported as it wasn’t documented. We tried it and it does help our issue.

 

Thanks for the feedback!

Userlevel 7
Badge +23

Hi @ssital,

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