Our external system(DWH) would like to load large number of records from Creatio, no matter how big the data upload limit is, it will end.
We want to use pageing functional to divide data.
If there is such functionality in creatio, if so, how to enable it
Like
Hello,
Please note that we do not have such an integration in the system and we advise using the basic export functionaliy, as it does not have any limits.
As an alternative option, you can use Integrations & API, Odata web service for this.
Anna,
In this case I recommend you contacting our Support team directly at support@creatio.com so we could check this issue on your site.
You can use OData 4 $top and $skip parameters to load all records.
Example to load 3000 records:
https://demo.creatio.com/0/odata/contacts?$top=1000&$skip=0
https://demo.creatio.com/0/odata/contacts?$top=1000&$skip=1000
https://demo.creatio.com/0/odata/contacts?$top=1000&$skip=2000
Can you be more specific as to what you are trying to do? Are you trying to load data from your DWH to a Cloud instance? Is this a one time thing? Are the inserts or updates? How are trying to load? Odata DataService? Are you using an app or self coded?