paginate list results recipie

[derekeder]

To get around the 500 row response limit, we could implement paging for list views.

Follow the pattern from this thread:

Basically, you would want to send a request to retrieve 500 rows at a time, using the LIMIT clause. For example:

SELECT FROM LIMIT 500

To control the pagination, add an offset. For example, the following query would show the second page of results:

SELECT FROM LIMIT 500 OFFSET 500