Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to delete all records in SalesForce object?

Is there a quick and easy way to delete all records in a SalesForce object? If I use a tSalesForceOutput and set Action to delete, the job runs and I get:
connecting to socket on port 3444
connected
disconnected
I'm guessing because I'm not telling it what to delete. How do i tell it to delete everything?
I tried using a tSalesForceInput with "truncate <table>" and "delete from <table>", as I can do this with MSSQL/MySql, but SalesForce won't let me do this.
Labels (3)
1 Reply
Anonymous
Not applicable
Author

I'm not aware of any easy way to do this. Depending on the number of rows, you could read all the IDs and then delete each one.
I don't even think Salesforce developers find it that easy to mass delete...