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.


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


SAP SuccessFactors HCM Core 1802