Apex Code Development You need to sign in to do that
Don't have an account?
Tanner Russell Dataloader CLI Dynamic Query
I have the task of setting up automated scheduled backups for my organizaiton the issue I am running into is I originally manually put each field into the select statement but down the road we deleted and added new fields resulting in the backups failing or missing important information (see example of config)
<entry key="sfdc.extractionSOQL" value="Select Id, CaseNumber, customfield__c, deleted_custom__c FROM Case"/>
Since these values are hardcoded into the config if the "deleted_custom__c" is deleted in the production org than this backup will fail.
Is there a solution for dynamic soql in dataloader cli such as select * from case or another solution?
<entry key="sfdc.extractionSOQL" value="Select Id, CaseNumber, customfield__c, deleted_custom__c FROM Case"/>
Since these values are hardcoded into the config if the "deleted_custom__c" is deleted in the production org than this backup will fail.
Is there a solution for dynamic soql in dataloader cli such as select * from case or another solution?
Hi Tanner,
I don't think this is possible however check below reference that might be close related.
https://salesforce.stackexchange.com/questions/126771/exporting-salesforce-record-dynamically-using-data-loader
Thanks,
Greetings!
I don't think we can control the fields to retrieve in the SOQL query.However,I would like to check the blelow thread to see,if it helps you to achieve your requirement.
https://stackoverflow.com/questions/12071190/key-extractionsoql-value-in-apex-data-loader-with-command-line
https://developer.salesforce.com/forums/?id=906F00000008ou3IAA
Kindly mark it as best answer if it helps so that it can help others in the future.
Warm Regards,
Shirisha Pathuri