SAP Knowledge Base Article - Public

2644858 - SFAPI Query parameter 'maxRows'


  • How to ensure a specific number of records is returned by the SFAPI query
  • How to restrict the number of records returned by the API




There is a parameter named: 'maxRows' which can be utilized to ensure only the specified number of records are returned in the API response.

The parameter is used as follows:

<S:Envelope xmlns:S="">
                 <query xmlns="" xmlns:ns2="">
                     <queryString>SELECT .... </queryString>

Now in the query response of above api call, only 200 records or less will be returned.

In order to fetch all the records, the value of the parameter maxRows should be set as -1.


SFAPI query parameter, maxRows, api query to return a fixed number of records, restrict the number of records , KBA , LOD-SF-INT-API , API & Adhoc API Framework , LOD-SF-INT , Integrations , How To


SAP SuccessFactors HCM Core 1802