Salesforce Destination "hardDelete" Operation

[Vincent LC]

Hi,

We are currently facing an issue with records deletion using http://www.cozyroc.com/ssis/salesforce-destination component.

It is mandatory to be able to perform what salesforce describes as "hardDelete" operation, instead of a simple "delete" to avoid "Salesforce Recycle Bin" congestion.

• https://help.salesforce.com/articleView?id=000336818&type=1&mode=1
  

If hard delete is not performed for large volumes, it is necessary to empty the Salesforce recycle bin, then to request a physical delete from Salesforce support which is not reasonable on a daily basis.

 The hardDelete operation should work as described: Either in a xml or json body, set the top level operation property to "hardDelete".

• https://developer.salesforce.com/docs/atlas.en-us.api_asynch.meta/api_asynch/asynch_api_reference_jobinfo.htm#operationenum_codeph
  
• https://help.salesforce.com/articleView?id=000314271&language=en_US&type=1&mode=1
  
• https://developer.salesforce.com/docs/atlas.en-us.api_asynch.meta/api_asynch/asynch_api_jobs_create.htm

• Is it possible to add the hardDelete operation in the Salesforce Destination component? (Parameters > Configuration > Action > ...)
• Alternatively, is there any way in SSIS to alter the body before the http request is actually sent?

Thank you!

Regards,

Vincent LC

[Ivan Peev]

Hi Vincent,

I believe you are using the Salesforce bulk-load mode. In this case, you can provide configuration for the BulkJobInfo parameter where you can specify the settings for the "hard-delete".

[Elton Rabello]

Hi Vicent, I facing the same problem, did you realize how to add this BulkJobInfo? I couldnt find it.

Thanks

[Ivan Peev]

Hi Elton,

Did you review the documentation page here ?