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 through XML

Im working with Dataloader.cli and im trying to dynamically populate the soql query through another xml file such as

<root>
<account>select id from account</account>
<root>
to get the metadata dynamically through a REST call
currently the soql query is hardcoded like this but I do have the file generating all I want is:
THIS 
<entry key="sfdc.extractionSOQL" value="{./SOQL.xml Account}"/>
Not this
<entry key="sfdc.extractionSOQL" value="Select Id, name FROM Account"/>
Is this possible or am I better off loading in the xml file directly through code?
ShirishaShirisha (Salesforce Developers) 
Hi Tanner,

Greetings!

Please find the below blog which will help you in your XML.

https://www.jitendrazaa.com/blog/salesforce/automate-command-line-dataloader-using-ant-with-dynamic-arguments-and-query/

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

Warm Regards,
Shirisha Pathuri