Is it possible to remove limit of 10,000 while using GET REST API in ONE single call ?

Naresh27
Tera Guru

we need to query incident table using REST GET method which usually yields more than 10,000 records. but i can only get 10,000 max records.

How could I get all records from my table ? I have to do it in 1 query. Firstly, is this Possible ? if so please help.

5 REPLIES 5

johnnyd54
Giga Expert

I would try to do this in separate requests so you don't need change any system defaults or cause performance issues like ndt13 mentioned . Request 1 could grab the first 10 k and Request 2 could grab the 2nd 10k and so on. You should be able to set the page in the rest call to grab more than 10k.

 

Take a look at sysparm_suppress_pagination_header here: https://developer.servicenow.com/app.do#!/rest_api_doc?v=jakarta&id=r_TableAPI-GET