I am trying to do an export of approx 30,000 attachments in our Salesforce Org,
Would anyone have been through a similar exercise and can advise best practice or the best way / tool to do this?
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.Sign up to join this community
The export would follow this pattern (example from the above link):
sfdx force:data:tree:export --query \ "SELECT Id, Name, Title__c, Phone__c, Mobile_Phone__c, \ Email__c, Picture__c, \ (SELECT Name, Address__c, City__c, State__c, Zip__c, \ Price__c, Title__c, Beds__c, Baths__c, Picture__c, \ Thumbnail__c, Description__c \ FROM Properties__r) \ FROM Broker__c" \ --prefix export-demo --outputdir sfdx-out --plan
but with the SOQL querying the
(Not sure about governor limits: may be necessary to use many requests with a
where clause to break the data up into groups.)