Questions tagged [bulk-delete]
The bulk-delete tag has no usage guidance.
66
questions
0
votes
1
answer
25
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 ...
- 13.4k
1
vote
1
answer
92
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 ...
- 164
-1
votes
1
answer
68
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
325
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
0
answers
131
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
215
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
24
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 ...
- 89
0
votes
1
answer
317
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&...
- 191
0
votes
1
answer
401
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 ...
- 655
0
votes
1
answer
268
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 ...
- 15
0
votes
2
answers
324
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
1
answer
274
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,418
0
votes
1
answer
924
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 ...
0
votes
1
answer
719
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 ...
- 47
1
vote
1
answer
2k
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
369
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?
- 111
4
votes
4
answers
1k
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 ...
- 255
0
votes
2
answers
1k
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
856
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 ...
- 655
1
vote
1
answer
161
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
206
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 ...
- 99
3
votes
1
answer
878
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,095
1
vote
1
answer
100
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,392
1
vote
1
answer
1k
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
105
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
375
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,788
0
votes
1
answer
391
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
84
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
8
votes
1
answer
293
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 ...
- 445
2
votes
1
answer
118
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
169
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,350
2
votes
2
answers
6k
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 ...
- 344
0
votes
1
answer
255
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
38
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
68
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,584
2
votes
1
answer
7k
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 ...
- 852
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
625
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
167
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
5k
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
712
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
197
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 ...
- 963
3
votes
1
answer
1k
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
111
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 ...
- 531
7
votes
2
answers
3k
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 ...
- 8,970
1
vote
0
answers
143
views
Malform query when try to delete bulk records
I want to delete bulk records from a custom object.
i am reffering below url:
https://developer.salesforce.com/docs/atlas.en-us.api_asynch.meta/api_asynch/asynch_api_code_curl_walkthrough.htm
and my ...
- 11
1
vote
4
answers
2k
views
How can I mass delete records from custom objects?
I would preferably like to use a point-and-click approach or an appexchange app which helps me accomplish that?
Also, if there is an app for recursive delete of data, that would be fantastic.
- 1,074
1
vote
1
answer
671
views
Delete Open tasks of Inactive users
I need to bulk delete open tasks that are assigned to Inactive users. I need to exempt a particular profile(sales profile) from this. Can you guys suggest me the best way to delete the open tasks for ...
- 83
6
votes
3
answers
6k
views
Mass Delete Tens Of Millions Of Records
I have done my due diligence on this and simply cannot find an answer that does not involve Apex, which is what I'm trying to avoid for various reasons.
Does anyone know how to adequately without a ...
- 4,584
0
votes
1
answer
156
views
Mass Delete Documents In Content Libary
I've been asked to delete 80 outdated documents from our content libary is there an easy way to do this?
- 174