I am using Cloud Page to sync Marketing Cloud Data Extension records from SFMC to Salesforce CRM custom Object. I am using CreateSalesforceObject AMPScript method to create salesforce object. Following are the components involved in the Automation:
- SSJS Activity: This Activity Calls Cloud Page.
- Cloud Page: This Page contains AMPScript to query records from Data Extension and create Salesforce object record using CreateSalesforceObject function.
- Salesforce CRM Custom Object : This is the custom object where we sync data from SFMC
Records are syncing perfectly fine except one following issue. Cloud page is unable to sync more than 700 records in single call. So if Data Extension has 1000 records which needs sync, then automation runs, it sync around 700 records and then is fails. The number 700 is not consistent here. It sometime sync 750, sometimes 800.
I have raised case with Salesforce Support to understand is there is any limitation for this method.and they said that CreateSalesforceObject method is not intended to be used as a data dump, but rather process small volumes. But I did not receive any specific information regarding any limitation for CreateSalesforceObject method.
Also, When we added trigger on above custom object, SSJS Activity could only sync 400 records and it started failing when we tried to sync more than 400 records from single cloud page call.
We were able to sync upto 10000 records by calling same cloud page multiple time from SSJS activity using for loop and syncing 400 records per cloud page hit.
Does anyone know any specific limitation of CreateSalesforceObject method which could have caused this issue?