Symptom
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).
Environment
SAP Sales Cloud and SAP Service Cloud Version 2
Reproducing the Issue
- Make an API call to Sales Cloud Version 2;
- e.g. Visit Collection API
you would expert to get data, but it does not. If the skip parameter value is less than 10000, it works fine.
Cause
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.
Resolution
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.
Keywords
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
SAP Knowledge Base Article - Public