Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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