What is the limit for results on REST Table API?

[Mike278]

The default for Table API results per page is 10,000 (sysparm_limit). Is there any way to change this default number to something else? Also, is there any way to set a limit for a specific table within ServiceNow with Table API?
Finally, it seems like the Table API fails when a client requests approximately 40000 records or more? Is this a limitation within ServiceNow? And is there any way to increase this? Trying to test what the limit is.
I know you can limit the number of results with scripted REST API, but wanted to know if this is possible with Table API.

Thanks. 

[Milind Gharte]

Hi,

Increasing the maximum returned record (10000 by default) may have performance implications. What I suggest to retrieve large amounts of records is to use pagination. That is, get sub-sets of records in different calls, for example, first you get records from 1 to 10000 in a call, then you get from 10001 to 20000, then from 20001 to 30000, etc.

To do so, you can make use of the parameters

- sysparm_limit: to define how many records you get in one call (10000 by default)

- sysparm_offset: to define the records to exclude from the query

In this case, the first call would be something like

/api/now/table/incident?sysparm_limit=10000&sysparm_offset=0

the next one

/api/now/table/incident?sysparm_limit=10000&sysparm_offset=10000

the next one

/api/now/table/incident?sysparm_limit=10000&sysparm_offset=20000

...

You can put that in a loop to get all the records using pagination.

For more info you can take a look to Table API - GET /now/table/{tableName}

If it helps,Please mark ✅ Correct and 👍 Helpful.

Warm Regards,

Milind

[Max Contreras]

Where can I change this by default limit?

[Kuldeep Sahu]

I Know this is an old thread, but I had to comment on this for the sake of others, looking here for answer.

https://hi.service-now.com/kb_view.do?sysparm_article=KB0727636

Sincerely,

Kuldeep