Questions tagged [bulk-delete]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
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 ...
zanstaszek9's user avatar
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 [...
Rajendra's user avatar
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&...
Lena Razov's user avatar
-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 ...
Krsna Barquero's user avatar
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 ...
Nikhil's user avatar
  • 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 ...
Patlatus's user avatar
  • 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 ...
Isaac L's user avatar
  • 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.
Shekhar Dethe's user avatar
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/...
ramesh's user avatar
  • 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 ...
Sandra Zuluaga's user avatar
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. ...
vgusakov's user avatar
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 ...
h3110's user avatar
  • 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&...
Art S's user avatar
  • 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 ...
GroundToCloud's user avatar
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 ...
Bob Mount's user avatar
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 ...
Maria's user avatar
  • 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", "...
Brian Kessler's user avatar
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 ...
Robert Wynter's user avatar
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 ...
Dan Watkoski's user avatar
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 ...
4kAudio's user avatar
  • 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?
chorlesbarkley7's user avatar
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 ...
Akshay Vasu's user avatar
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'...
RKNauhwar's user avatar
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 ...
GroundToCloud's user avatar
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 ...
spiker k's user avatar
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 ...
Greg Beazley's user avatar
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 ...
compski's user avatar
  • 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 ...
javanoob's user avatar
  • 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 ...
Anne's user avatar
  • 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 "...
user70782's user avatar
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 ...
victorcorey's user avatar
  • 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,...
Josh's user avatar
  • 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 ...
J. Stott's user avatar
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 ...
Dev Arya's user avatar
  • 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 ...
Ben's user avatar
  • 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 ...
Morgan Marchese's user avatar
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 ...
unhinged's user avatar
  • 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 ...
user47837's user avatar
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 ...
BLEIKster's user avatar
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 ...
AMM's user avatar
  • 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 ...
Rob Cowell's user avatar
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. ...
KerryT's user avatar
  • 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 ...
Joe Stevens's user avatar
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 ...
mmix's user avatar
  • 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 ...
Hew Ingram's user avatar
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 ...
Fayyaz A Mian's user avatar
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 ...
maniac coder's user avatar
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 ...
Christopher Large's user avatar
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 ...
force007's user avatar
  • 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 ...
AtulRajguru9's user avatar
  • 9,110