Handling The SharePoint REST API Search Threshold Limit In SPFx

Jayakumar Balasubramaniam

SPFx SharePoint FrameworkSearch REST APISearch Threshold

9 Comments

Join the conversation! Your thoughts help the community grow.

Deepak Upadhya8y ago
No I am executing the script on html website you can call it as https://abc.com. So i need to Call share point online from that. in simple words, in c sharp corner site. how to display Sharepoint online list [ announcements] items
- Jayakumar Balasubramaniam8y ago
  There is only one solution to achieve this. Without tokens you couldn't access SharePoint online. To do so write a Provided Hosted app which will work based on ClientId and ClientSecret and it will be resgistered in the site where your list exists. In your website say https://abc.com you need to use SharePoint helper classes for .net to generate the token from the client id and client secret.
- Rabia Williams7y ago
  Deepak Upadhya You need to pass the access token in your API call since you are calling it from outside SharePoint. I suggest you use apps like Postman to work out communicating with SharePoint. Check out this blog for setting up Postman to communicate with SharePoint. https://medium.com/@anoopt/accessing-sharepoint-data-using-postman-sharepoint-rest-api-76b70630bcbf
Deepak Upadhya8y ago
<html> <head> <script src="/jquery.min.js"></script> <script> $(document).ready(function() { function executesearch(){ var siteurl = "https://abc.com/sites/space2/xyz/_api/lists/getbytitle('Pages')/Items"; $.ajax({ url: siteurl, method: "GET", headers: { "Accept": "application/json; odata=verbose" }, success: function (data) { if (data.d.results.length > 0 ) { alert(data); } }, error: function (data) { alert("Error: "+ siteurl); } }); } $("#search-button").off().click(function(e) { executesearch(); }); }); </script> </head> <body> <div class="test"> <button class="btnsearch" id="search-button"> FIND CONTENT</button> </div></body> </html>
Deepak Upadhya8y ago
How to Display SharePoint Online 365 List Items on non - share point site , you can say a site built using html. how we can connect? I have tried using simple html page and REST API. its giving error as "Access Denied". Looks like I am missing something or i am using wrong methods. Please help
- Deepak Upadhya8y ago
  I am new to Sharepoint Online. Can you please help me regarding that.
- Deepak Upadhya8y ago
  My current code is this. please help : <html> <head> <script src="/jquery.min.js"></script> <script> $(document).ready(function() { function executesearch(){ var siteurl = "https://abc.com/sites/space2/xyz/_api/lists/getbytitle('Pages')/Items"; $.ajax({ url: siteurl, method: "GET", headers: { "Accept": "application/json; odata=verbose" }, success: function (data) { if (data.d.results.length > 0 ) { alert(data); } }, error: function (data) { alert("Error: "+ siteurl); } }); } $("#search-button").off().click(function(e) { executesearch(); }); }); </script> </head> <body> <div class="test"> <button class="btnsearch" id="search-button"> FIND CONTENT</button> </div></body> </html>
- Jayakumar Balasubramaniam8y ago
  You are executing this script in a SharePoint page right ?

SharePoint REST APIs restrict results and return a limited amount of data to improve performance. One of the restrictions is the threshold limit to read data from a list which means we cannot read more than 5000 items from a list for an API call. The same rule applies to Search APIs also; it returns only 500 rows at a time.

Since we are searching across the tenant/site, there are more chances for us ending up with more than 500 rows per search.

How to get the total number of rows expected to be returned through the Search API call?

The total number of rows expected to be returned from your search query will be available in the below object mapping of the response.

PrimaryQueryResult.RelevantResults.TotalRows

Get the total number of rows returned in the current search request?

The total number of rows returned in the current search will be available in the below object mapping of the response.

PrimaryQueryResult.RelevantResults.Rowcount

The traditional pagination is the core concept to handle the search results in more than 500 rows. This approach will fit any type of technologies you use to contact SharePoint Search through Rest API with some slight changes in the headers. Let me explain this for SPFx now.

Check out our article about reading more than 5000 items using rest API in SharePoint Framework applications. Now, handling the threshold limit in search API is not so complicated like handling threshold limit for list items, just add the below parameter in the ODATA query,

startrow=501

Let me explain with an example. Below is a sample url to get the contents from the tenant with the Sharepoint text,

https://tenantName.sharepoint.com/search/_api/search/query?querytext='sharepoint’

We can also restrict the number of results to be returned from the Search API result with the parameter rowlimit like below,

https://tenantName.sharepoint.com/search/_api/search/query?querytext='sharepoint&rowlimit=500’

The startrow parameter specifies from which row it has to start the search, for example, if you specify the start row as 501, the search will be performed from row 501 and it will return the results from row 501 to row 1000.

Get the total rows expected to return from the search and put in the below logic. Then, make the second call to the same Search API with the same refiners and parameters.

URL

https://tenantName.sharepoint.com/search/_api/search/query?querytext='sharepoint&rowlimit=500&startrow=501’

Code Snippet

let totalRows: number = searchResult.PrimaryQueryResult.RelevantResults.TotalRows;
let pageSize = 500; //maximum rows that search api can return
if (totalRows > pageSize) {
let totalPages = parseInt((totalRows / pageSize).toString());
for (let page = 1; page <= totalPages; page++) {
let startRow = page * pageSize;
this.searchWithPaging(startRow);
}
}

How to build SharePoint Framework Applications

The following blog posts will help you in detail about building SPFx applications,

If you have any questions/issues about this article, please let me know in the comments.