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:21 PM
What is the business reason for wanting more than 10,000 records? I'm not sure if this is possible, but increasing this limit could cause unwanted performance issues to your instance.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-23-2018 12:23 PM
Hi, we need to make report on incident table in Power BI, our table has more than 10,000 records and we only can use REST to GET data.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-23-2018 12:25 PM
I would recommend that you retrieve a few thousand records at a time through different queries. You can get subsets of records in different calls. First, get record from #1-10000 in one call, then get #10001-20000 in the next call, and so on.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-23-2018 12:31 PM
Thanks that looks good but let's say if i have 200,000 Incidents, I may have to create 20 Calls and write a logic in BI to merge them and wait for sometime I don't know in future to create 21, this may lead to data issues and someone to keep on monitoring the count
