For legacy applications which are using rest services to retrieve the data from existing system and showing the data in Mendix, we need to have a server side pagination
(server here refer to Legacy system). Like, onclick of page number, Mendix calls a rest service with offset number and displays it instead of loading all the data from Legacy system and provide the pagination in the Mendix layer.
Hello Veeraiah,
I think this is something the legacy (in this case) system should do.
If the REST API doesn't provide limit & offset. Then Mendix can't do it for you.
https://www.moesif.com/blog/technical/api-design/REST-API-Design-Filtering-Sorting-and-Pagination/#
On the other hand you can make buttons to kick off microflows to collect next (x amount) rows and previous and set your REST API offset and Limit in the microflow.