Delete Salesforce Data
Last updated
Last updated
The following articles describe using Single Dataloader to delete data from Salesforce. To delete data, all you need is a CSV file that contains the IDs of the objects you want to delete in one of the columns. Once you have this, proceed with the instructions below.
Log in to your ARM account.
Hover your mouse over the Dataloader module and choose the Dataloader option.
Click Delete on the right side of the screen.
Choose your Salesforce Org and your org environment (Production or Development Edition, Sandbox, or Pre-Release).
The corresponding URL and your Username are automatically generated based on the above selection.
Click Login and Fetch Objects to fetch all the objects from your Salesforce Org.
Select the object you wish to delete the data. For example, Account, Contact, Lead, etc. You can use the search function to search through your objects and the filter button to filter your standard/custom objects quickly.
Click Next.
Import your file from your local directory on the next screen. Upload the CSV file you wish to import by clicking the Upload button.
A notification pop-up will display the number of records that will be impacted. Click OK.
The next step is to prepare your field mappings. Field mappings match columns in your CSV to fields in your Salesforce Org.
You can automatically map the members and the fields using Automap. It compares the destination fields with the fields available in uploaded CSV files, and if both match, the value is selected automatically.
The number of fields mapped out of the total number of fields is displayed below the Automap checkbox.
Use the search option to look up a field by name from the long list to map it.
Use the Filter dropdown to choose which fields to display:
All: Displays all fields, whether they have been mapped or not.
Mapped: Displays only the fields which have been mapped yet.
Unmapped: Displays only the fields which haven't been mapped yet.
After selecting the filter, the list updates automatically as you map or unmap each field.
Make sure you have mapped all the required fields. Otherwise, you can't move forward. Click Next.
On the Process Summary screen, you can:
Give the process/job a Name.
Select the Category. Categories are used to classify and group similar processes having similar functionality. In simple terms, you are assigning similar processes to a category. You can either select an existing category or create a new category by clicking the + icon.
View the main Object.
View the operation Type (Delete).
View the number of impacted Records.
Use Bulk API.About Bulk APIThe Bulk API is based on REST principles and is optimized for inserting, updating, and deleting large data sets. You can use the Bulk API to process jobs in serial or parallel mode. Processing batches serially means running them one after another, while processing batches in parallel means running multiple batches simultaneously. When you run a Bulk API job, processing more batches in parallel means giving that job a higher degree of parallelism, providing better data throughput overall.
You can schedule your tasks so they start running regularly. You can choose between Daily, Weekly, or On-demand schedules.
Finally, click Save to save your task and run it later.
Your task is listed at the top in the Dataloader Summary screen.
Click Run to run the Dataloader immediately before the scheduled time.
Select the criteria for the dataloader process to continue:
Use Bulk API (Batch API will be used if the option is not enabled)
The Bulk API is based on REST principles and is optimized for inserting, updating, and deleting large data sets.
You can use the Bulk API to process jobs in serial or parallel mode. Processing batches serially means running them one after another, while processing batches in parallel means running multiple batches simultaneously.
When you run a Bulk API job, processing more batches in parallel means giving that job a higher degree of parallelism, giving your overall run better data throughput. When you run a Bulk API job, processing more batches in parallel means giving that job a higher degree of parallelism, giving your overall run better data throughput.
Note: When performing multiple delete operations into the same destination org while the ongoing jobs are still running, choosing the Serial Mode is recommended.
Batch Size
Whenever the Bulk API checkbox is left unchecked, the Batch API is used. Salesforce Batch API is based on SOAP principles and is optimized for real-time client applications that update small numbers of records at a time. Although SOAP API can also process large numbers of records, it becomes less practical when the data sets contain hundreds of thousands of records. In those cases, Bulk API is the best option. Batch API processes data in smaller batches than Bulk API, resulting in a higher API call usage per operation on large volumes of data. Note: When you run a Bulk API job, processing more batches in parallel means giving that job a higher degree of parallelism, giving your overall run better data throughput.
Use UTF-8 file encoding for file read and write operations
Use UTF-8 as the internal representation of strings. Text is transcoded from the local encoding to UTF-8 when data is written to or read from a file. UTF-8 must be enabled in your data exclusively containing English alphabets. UTF-8 must be disabled if your data contains non-English alphabets. UTF-8 should be enabled by default as per Salesforce.
Click Run.
The Results of Last Run section shows the number of successful or failed records deleted. The values in this field are updated dynamically while the job is still running. You can view the records or download them to your local system. The records are generated in CSV format.
The number of impacted records can be seen in the Records section. The value in this field is updated dynamically while the job is still running.
Edit: Modifies or updates the process details.
Abort: Aborts the process while it is still running.
Schedule: Sets the schedule at which the process must run.
Delete: Deletes the delete process.
Log: Provides information about the execution of the deleted task.
VR/WFR: ARM lists all the validations/workflow rules that were set. The UI lists all the validation rules, and users must enable them for the disabled validation rules (if required). For more info, refer to the article: Validation/ Workflow Rules. Sample VR/WFR attached:
Clone: Creates a copy (clone) of the insert process. Operation type and object name are displayed. Enter the Process Name in the field. The default Salesforce Org is automatically selected. To choose a different org, use the dropdown list. Select the Choose Different Data CSV File check box to upload a different CSV file. Finally, click Clone.
