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
Related Articles
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 ...How do I retrieve my license.dat file after it has been deleted?
When Licensing COZYROC to a server, the License.dat file is placed in the C:\Program Files (x86)\CozyRoc\SSIS folder for a typical installation. Occasionally customers will want to move a license to a new server, but some event has taken place where ...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 ...