3631264 - API GET Call Returns Limited Number of Counts to 10.000

The system holds more than 10000 records. This kind of issue occurs for all objects, not just Visits.

The lack of this functionality prohibits pagination and development of full, initial load processes.

Use Case example: During development of a process for mass-replicating data from Sales Cloud V2 to Datasphere it was found that the '$skip' parameter for the standard REST API services stops working after the value reaches 10000 (works fine until 9999).

SAP Sales Cloud and SAP Service Cloud Version 2 

• Make an API call to Sales Cloud Version 2;
• e.g. Visit Collection API
  • https://"salescloudversion2tenantURL"/sap/c4c/api/v1/visit-service/visits 
  • Make a GET call to this endpoint -
  • https://"salescloudversion2tenantURL"/sap/c4c/api/v1/visit-service/visits?$skip=10000&$top=1000

you would expert to get data, but it does not. If the skip parameter value is less than 10000, it works fine.

The REST API supports a maximum of 10,000 records across all services. As a result, the values for $skip and $top cannot exceed 10,000.

To retrieve more targeted data and stay within this limit, consider applying additional filters such as status, account, date, or other relevant criteria.

Alternatively, if you need to export larger datasets without these constraints, you can use Data Impex, which does not impose the same record limitations.

api;cns;visit;10000;skip;top;sales cloud version 2;get;limit , KBA , CEC-CRM-INT , Integration for SAP Sales/Service Cloud , CEC-CRM-VST , Visit for SAP Sales/Service Cloud , Known Error