Implement paginated responses for REST API requests
Currently the max # of rows from a table via the REST API is limited to 1,000.
Many REST APIs utilize pagination via page tokens or other methods and I think caspio could benefit from implementing this kind of feature.
I've personally resorted to querying by autonumber and using multiple API calls, but a native solution would be cleaner / faster.
Thank you again for this idea. Pagination is now supported in REST API. More information can be found at https://howto.caspio.com/integration/web-services-api/rest-api/criteria/
Andrew Horner commented
For me personally, the best way to handle this would be via an offset parameter specified when querying the API for rows. This way I would not need to make multiple calls to fetch results several pages deep.
The offset should take into account the filter query (WHERE clause), sorting (ORDERBY), grouping (GROUPBY), and LIMIT.
It appears that MS SQL supports offset natively: https://technet.microsoft.com/en-us/library/gg699618(v=sql.110).aspx