function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Tanner RussellTanner 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?
VinayVinay (Salesforce Developers) 

Hi Tanner, 

I don't think this is possible however check below reference that might be close related.


ShirishaShirisha (Salesforce Developers) 
Hi Tanner,


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.

Kindly mark it as best answer if it helps so that it can help others in the future.

Warm Regards,
Shirisha Pathuri