none
Maximum result limit using REST search API. RRS feed

  • Question

  • What is the maximum result limit using  REST search API. Could we fetch more than 10000 at a time . In my case it is giving 500 internal server error.

    Ashish Baranwal To know what you know and what you do not know, that is true knowledge

    Tuesday, December 9, 2014 3:12 AM

Answers

All replies

  • 500 is the limit. You can make additional requests for 500 at a time until you get the total results returned. You can keep incrementing the StartRow querystring variable until no more results are returned.


    Blog | SharePoint Field Notes Dev Tools | SPFastDeploy | SPRemoteAPIExplorer

    • Proposed as answer by Nikhil ahuja Tuesday, December 9, 2014 4:03 AM
    • Marked as answer by Ashish Baranwal Wednesday, December 10, 2014 6:41 AM
    Tuesday, December 9, 2014 3:56 AM
  • Hi Steve,

    We can also set max row limit to 10000 using below. So I have another question here whether it would be recommended to do so from microsoft.

    $ssa = Get-SPEnterpriseSearchServiceApplication
    $ssa.MaxRowLimit = 10000
    $ssa.Update()

    Regards


    Ashish Baranwal To know what you know and what you do not know, that is true knowledge

    Tuesday, December 9, 2014 5:23 AM
  • More than setting the row limit, you need to understand that it has got to do with payload limitations of any service

    http://www.strathweb.com/2012/09/dealing-with-large-files-in-asp-net-web-api/

    You can change the limits in IIS, but it is not recommended to change the limits and fetch all the 10,000 in one time. You can go for the incremental approach suggested by Steve Curran MVP.


    Please mark the replies as answers if they help or unmark if not.

    Tuesday, December 9, 2014 5:45 AM
  • It won't work. There are internal limiters to SharePoint that mean that you won't get 10k results back. Stick to paging on large data sets.

    Edit: as Sundar and Steve have said

    Tuesday, December 9, 2014 9:00 AM