Questions tagged [bulk-delete]
The bulk-delete tag has no usage guidance.
71
questions
0
votes
0
answers
48
views
Async-safe mass delete of children with Batch
How to write in Apex a mass deletion (over 10 000 records, even up to 150 000) of related records that can be safely called from async context, like Batch?
I have two custom objects, lets call them ...
- 21
0
votes
0
answers
81
views
Delete a row from Quip spreadsheet using Python API
I have a requirement to delete all rows in a Quip spreadsheet and reload the data. However, it seems that this is not possible with the existing API commands. Therefore, I have looked into the [...
- 1
0
votes
1
answer
411
views
Composite API to delete multiple records by an external id
I have been looking for an example of what @sfdcfox suggested for this thread
https://salesforce.stackexchange.com/a/332678/133263
"The first subsequent would be a get, the second the delete call&...
-1
votes
1
answer
226
views
Using Developer Console Query Editor to delete multiple items
I need some assistance with a message I came across while trying to delete multiple items from SF (less than 3K items). I used the query editor to see the items I need to delete but when I select the ...
0
votes
0
answers
835
views
Why is Salesforce inspector faster than data loader or workbench?
I have a use case where I need to delete a few million duplicates from my org. I have explored the following 3 tools to achieve this. Salesforce Inspector, Data Loader and Workbench. The performance ...
- 1
0
votes
1
answer
201
views
Query files from private folders by SOQL to wipe content?
My QA users have overfloaded the Developer Sandbox with 234 MB of files.
I try to wipe all the content, however, looks like SOQL query doesn't return all the files even though I can see them in UI.
I ...
- 16.1k
1
vote
1
answer
438
views
Queries on Large Object (>1 million rows) Fail to Execute
We have an object with approximately 1.5 million records in Salesforce. These records are created in an external system and synced with Salesforce every 24 hours. On a 24 hour basis, we delete all 1.5 ...
- 174
0
votes
3
answers
4k
views
Delete Mass records
I want to delete 10 million records from the custom object. How to delete all records without batch class and within minimum time.
1
vote
2
answers
2k
views
How to mass delete only one particular field value (for all records)?
I have a custom object, one of the field in it is email, all the values saved in this email field got corrupted.
Not all the records are having email value.
Irrespective of that, I have to clear/...
- 29
0
votes
1
answer
346
views
SFDMU - Deleting 30 Millions records
I deleted 30M records with SFDMU.
The only issue I faced was that I have to update the Json file for every 900,000 records and re-trigger the job using sfdx sfdmu:run --targetusername Production.
By ...
0
votes
1
answer
2k
views
Delete records using Bulk API
Can you please tell me how to delete records in Salesforce using Bulk API? The process of deletion itself is known to me. I am interested in how I understand which dependencies should be removed. ...
- 1
0
votes
1
answer
67
views
mass delete names from opp
I have a custom field on an opportunity record called Team Member.
If Team Member contains one of the names below, then I must delete the name.
Is dataloader the best way to do this? or is there ...
- 77
0
votes
1
answer
1k
views
Postman Bulk API 2.0 Delete: Error "The 'delete' batch must contain only ids"
trying to test Bulk API delete functionality in Postman desktop. I created a Job like so
{
"object": "et4ae5__IndividualEmailResult__c",
"operation": "delete&...
- 301
0
votes
1
answer
1k
views
Mass Delete AccountContact Relationship Record
I have activated the AccountContactRelationship object.
One particular contact is related to 800 Accounts. This is causing issues when we Update records from Dataloader or any other ETL tool.
How can ...
- 845
0
votes
2
answers
870
views
How do I mass delete inactive Dashboard Component records?
My org has over 300 reports that have been identified as no longer needed, but that are associated with current dashboards. I need a quick way to delete just the associations between those reports ...
- 25
0
votes
2
answers
975
views
Implications of deleting from All Contacts
Our organization is cleaning up our All Contacts list. I'm wondering - when the contact is deleted form All Contacts, will they also be removed from any auto suppression lists they may be on? I just ...
- 13
1
vote
2
answers
669
views
Is it possible to make a single API request which deletes multiple records using external id without creating a custom rest resource?
Let's say I have an external identifier field Account.External_Id__c.
I have a web application which has the values for this field and needs to delete multiple records, (e.g. "Abc123", "...
- 4,508
0
votes
1
answer
2k
views
apex class to delete records older than 90 days
Calling an apex action to delete records older than 90 days. I'm wondering if the code I have is the best practice or is there a better/ more structured way to write this:
public class ...
1
vote
1
answer
1k
views
Flow to Delete Leads doesn't seem to work as hoped
I'm creating a scheduled daily flow that loops through all Leads each day, and if a formula field I created for a deletion date is hit, then delete said Lead.
I'm including an entrance filter to only ...
- 63
0
votes
1
answer
3k
views
Best way to remove/delete all contacts in Marketing Cloud? [duplicate]
Have a large amount of junk contacts that are not part of any data extensions that need to be deleted (400k) from the marketing cloud instance. What is the easiest way to go about doing this? If there ...
- 65
0
votes
2
answers
679
views
Marketing Cloud FTP --> Automatic Delete Functionality
Is there a way to setup a rule so that your Marketing Cloud FTP will delete a file older than a certain date?
- 134
4
votes
6
answers
3k
views
Mass delete Debug logs using Salesforce DX
In my developer sandbox the Apex logs count has exceeded beyond its limit and there are more than 1 lakh records created in it. I want to mass delete them, but not able to do so.
I am using the ...
- 265
0
votes
2
answers
2k
views
Automate Data Extension Deletion in Salesforce marketing cloud [closed]
We have multiple Data extension which are no longer required for use. I want to delete all the data extension inside a folder in SFMC. is there any way to achieve this using automation or SSJS? I don'...
0
votes
1
answer
1k
views
Mass delete Accounts where related contacts have direct association with other Accounts
My issue is two fold -
I want to delete 350 Accounts. However these are the two blockers I have -
Your attempt to delete 'account record' could not be completed because it is associated with the ...
- 845
1
vote
1
answer
334
views
Create multiple delete functionality for all the attachments related to a particular case
I have created a button on case detail page called "delete attachments" once pressing that, the page directs to below VF page where all related attachments to that particular case are displayed with ...
- 25
0
votes
0
answers
412
views
What are the considerations when deleting the All Subscribers list and only adding contacts when emailing them?
I'm in the process of cleaning up our MC database to save on costs and improve efficiencies.
My question:
Considering our setup below, what would the downsides be if we were to delete our All ...
- 111
4
votes
1
answer
1k
views
Is there a way to delete >1 Million records from a custom Big Object?
First thing that came to my mind was writing a Batch Apex to do this but I get this error.
System.UnexpectedException: The requested operation is not supported by this SObject
Deleting via Bulk API ...
- 1,251
1
vote
1
answer
185
views
How to find easily the correct order of object for records deletion?
I have around 47 objects and need to delete records from these objects but these objects are related by master-detail and lookup relations.
I have to go through relation of each of these objects to ...
- 8,797
1
vote
1
answer
2k
views
Delete all contacts in Marketing Cloud to delete all duplicates
We have duplicates in our all contacts in Marketing Cloud. To solve this, we want to delete all contacts (audience builder).
We use the Marketing Cloud connector, and send emails to synchronized ...
- 27
1
vote
1
answer
199
views
Trigger truncate of an object
Is it possible to trigger a truncate of an object in Salesforce? As a job etc.? Deleting the data from an object needs the Ids to be cached/stored and then deleted from the Salesforce. Even using "...
- 11
0
votes
1
answer
485
views
Estimated time to Delete multiple Contacts via Data Extension
Those that have used the Contact Deletion (https://help.salesforce.com/articleView?id=mc_cab_contact_deletion.htm&type=5) process for bulk deletes...is there any metrics on time to complete
...
- 1,808
0
votes
1
answer
512
views
DELETE Dependencies REST API DELETE_FAILED
When attempting to use REST API to delete multiple object records like so:
h t t p s://org.my.salesforce.com/services/data/v42.0/composite/sobjects?ids=0010x000000000,a1r0x000000001,a1m0x000000002,...
- 1
0
votes
1
answer
122
views
Delete contacts based on an "expiring" field on their record
I have a bunch of contacts whose details have been licensed from other companies. The only caveat to being able to treat them as normal contacts in our Salesforce database is that they must be deleted ...
- 1
9
votes
1
answer
362
views
Bulk Delete operation in trigger does not split the data in chunks of 200
As far I know, while processing bulk operations in Trigger, the data is split in chunks of 200 per batch. I have around 40K accounts in org and I wanted to delete around 1000 of them. To understand ...
- 495
2
votes
1
answer
142
views
Bulk delete records from post uninstall script
I'm writing a post-uninstall script for a managed package that will delete a set of records that are no longer used. This works fine at the moment but I want to make it capable of deleting very large ...
- 21
1
vote
1
answer
227
views
When Managed Package Deletes Records via Bulk Data Load Job, Before/After Delete Apex Doesn't Run
Background: We have a Managed Package that syncs data with our system
via Bulk Data Loads. Occasionally, based on a change in Salesforce,
record(s) are sent to the external system and then ...
- 3,514
2
votes
2
answers
8k
views
Anyway to mass delete Custom Metadata Type records?
I currently have 100+ records I need to delete under my custom metadata type, and I am not keen on having to do it one by one (I will need to reset the records every now and then as our requirements ...
- 354
0
votes
1
answer
561
views
Looking to delete old emails but keep cases & activities
I need to have a rule to cleanse old email messages, but keep the case & activity records. It seems this is possible to do manually (find the case, click into the task, click into the related ...
- 15
1
vote
0
answers
48
views
API return answer is 'queued'. What does this mean?
We are using the API delete contacts. However we cannot se that the delete contacts call have had any impact, actually none. Our return answer for every call is 'queued' but what does this mean? How ...
- 23
1
vote
1
answer
71
views
Returning PRODUCTION Org to Virgin Status Without DEVELOPER Tools [duplicate]
I have a scenario:
Previous consultants and users had initially done some work inside our Production org (we have NEVER DEPLOYED to Production - they simply started to do the setup of this company's ...
- 4,674
2
votes
1
answer
10k
views
How can I bulk delete Prospects in Pardot?
On the Salesforce end of things we've implemented some logic to prevent certain contacts ever syncing to Pardot and in test it seems to work as planned, but we still have 924 prospects in Pardot that ...
- 970
2
votes
3
answers
1k
views
How to automate finding and deleting a person's data in Marketing Cloud?
I would to know what ways are available to find all instances of a person's data and delete it in Marketing Cloud (ExactTarget). I have a list of People that we need to delete out of Marketing Cloud. ...
- 61
3
votes
1
answer
816
views
Why is the mass delete of reports function not removing reports?
Per the Summer 14 release instructions I've found in Stack Exchange I am trying to delete a large quantity of reports using the mass delete function.
I open setup then 'Data management" then 'mass ...
- 43
2
votes
1
answer
239
views
Backup and remove old ActivityHistory entries?
Ok, we are sort of running out of space on one instance, and we noticed that EmailMessage-s and their accompanying Tasks take about 60% of our instance (we use a lot of Email2Case here). So the idea ...
- 161
0
votes
3
answers
6k
views
Remove users from All contacts in marketing cloud
I'm in the process of setting up our Marketing Cloud service and I've ended up with a number of users in All Contacts without the correct subscriber key (email as subscriber key instead of a user_id ...
- 81
0
votes
1
answer
1k
views
Case bulk delete error
I am trying to bulk delete cases where for some case I am getting this error
"UNKNOWN_EXCEPTION:An unknown exception has occurred.:--"
I checked for all dependancies and found only CaseHistory ...
- 350
1
vote
1
answer
252
views
Deleting Cases from org
I want to delete thousands of cases in my org preferably 25k at a time.
I have written a batch class for this. However during testing i found that its taking 30 minutes to delete 500 cases through ...
- 973
3
votes
1
answer
2k
views
I need to delete 7 million records but Data Loader keeps getting stuck
We found that 7 million Task records were created in our org and we need to delete them. We were recommended to delete all tasks, but there are many we want to preserve.
We were able to create a CSV ...
1
vote
1
answer
135
views
Scheduling mass delete of pdf Attachments from Account using Data Loader ClI
I was able to upload pdf attachments to account object using Data Loader CLI. I want to delete these attachments daily and upload newest pdf files.
Can somebody please suggest how can I schedule mass ...
- 541
7
votes
2
answers
4k
views
What is best way to delete all records from any Dev org
We have managed package and to test this we have special Dev & QA org from sales force which higher data limits (one of them is 250 mb org).
To test various scenarios we need to create may ...
- 9,110