#
Pagination
Pagination is supported on every GET endpoint and can be done using 2 parameters combination:
_offset
and_limit
_start
and_end
#
Pagination with _offset
and _limit
The _offset
parameter is the number of items to skip and _limit
is the number of items to return. If you want to get the first 10 items, you would use _offset=0&_limit=10
. If you want to get the next 10 items, you would use _offset=10&_limit=10
.
curl -X GET \
"https://sheetrest.com/api/v1/SHEET_ID?_offset=0&_limit=10"
fetch('https://sheetrest.com/api/v1/SHEET_ID?_offset=0&_limit=10', {
method: 'GET',
headers: {
accept: 'application/json',
},
});
#
Pagination with _start
and _end
The _start
parameter is the index of the first item to return and _end
is the index of the last item to return. If you want to get the first 10 items, you would use _start=0&_end=9
. If you want to get the next 10 items, you would use _start=10&_end=19
.
curl -X GET \
"https://sheetrest.com/api/v1/SHEET_ID?_start=0&_end=9"
fetch('https://sheetrest.com/api/v1/SHEET_ID?_start=10&_end=19', {
method: 'GET',
headers: {
accept: 'application/json',
},
});