Pagination in API response

[maliklalani]

Hi,

I am using Table API to fetch records from table. Maximum limit of records per response is 10,000 but I find no provision for pagination (URL to next page if maximum allowed records is exhausted).

Thanks in Advance,

- Malik

[tony_barratt]

Hi Malik,

I checked the documentation - below - and it seems that you are correct that there is no provision for pagination when the sysparm_limit is exceeded.

Best Regards

Tony

Table API - ServiceNow Wiki

sysparm_limit

Limit to be applied on pagination. The default is 10000. Unusually large sysparm_limit values can impact system performance.

sysparm_offset

A number of records to skip before returning records. Use this parameter with sysparm_limit for paging results. A number of records, specified by sysparm_offset are skipped before starting to count the sysparm_limit value. For example, if sysparm_limit is set to 500, but there are additional records you want to query, you can specifysysparm_offset=500 to skip the first 500 records and get the second set of records. Specifying sysparm_offset=0 is equivalent to omitting the sysparm_offsetparameter.

[tony_barratt · Accepted solution]

Also there is a description by Jose Valle here

Re: Using REST API with Servicenow

which may give a bit more insight...

[Steve Arnold2]

Here is an updated link to that answer:

https://www.servicenow.com/community/developer-forum/using-rest-api-with-servicenow/m-p/1648726