We are doing a POC whether retool can support all our business use cases.
How do we display records on a table from an API that support pagination.
Let say the API returns 100 records but we display only 10 on the single page upon clicking next we display next 10 records from the last API call results only but when we reach 10th Page we’ll have last 10 records displayed from results of the first API call only now when we press next the results are fetched using another API call with offset 100 and limit 100.
Constraint are API always returns 100 rows, we are fine displaying 100 rows in a single page but we still didn’t get any solution do display 100 rows in a single page.
We’d like to prefer the first approach. Can anyone guide us with some examples ?