How can I retrieve updated and deleted Salesforce records?
You can use the following reusable script with the JavaScript component to retrieve records that were deleted from Salesforce between specified dates: https://www.cozyroc.com/ssis/script-salesforce-get-deleted-source
To retrieve records that have been updated in Salesforce between specified dates, use the following reusable script with the JavaScript component: https://www.cozyroc.com/ssis/script-salesforce-get-updated-source
Both scripts allow you to enter the object and the start date and end date of the records you want to pull data from. The dates may be specified in variables.
Book a Presales Call
Are you new to COZYROC and evaluating our solutions?
Book a Presales Call with us now and get 5% off SSIS+.
Book a Presales Call with us now and get 5% off SSIS+.
Related Articles
Setting up Salesforce Bulk Mode with COZYROC Script Salesforce Bulk Result Transformation
When using COZYROC Salesforce components in Bulk Mode the operations are asynchronous, meaning the results are not immediately available. If needed, the status, identifiers of newly created records, and any error information can be retrieved in an ...NetSuite Source: How to retrieve transaction records like Sales Orders
Sales order records are found under the general transactions record. To retrieve them, specify a SearchXml statement. For sales order records, specifically, you can use the following statement: 1 2 3 4 5 <TransactionSearchBasic> <type ...Why is the batch size in my Salesforce bulk data load different than the batch size I set?
Scenario: We are doing bulk data load to Salesforce and the default size which we have set is 10000 but when i look at the Salesforce the number of records are processing per batch is 112 records Here is the Salesforce destination configuration Can ...How to find which records contain errors in Salesforce destination component.
The component's Error Output is used for providing both error information and the processed record identifier. Check the ErrorCode column: ErrorCode Description -1 Not an error record. >0 Error record. Check the ErrorDescription column for more ...Missing objects or columns when using Salesforce Destination Component
Most likely the reason for object or column to be missing is that you are using older version of Salesforce API. To verify which version of Salesforce API you are using please check what is showing in the Server URL field on the Salesforce Connection ...