Apex Code Development You need to sign in to do that
Don't have an account?
Tanner 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?
<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?
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