Is it possible to remove limit of 10,000 while using GET REST API in ONE single call ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-23-2018 12:13 PM
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.
- Labels:
-
Integrations
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-23-2018 12:28 PM
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