+ Start a Discussion
frelepfrelep 

Dynamic SOQL extraction from Salesforce.com with dataloader

Hi,

 

I use the Apex dataloder in CLI mode for an extract operation and I would like to specify one or more criteria in my SOQL query stored in my process-conf.xml file as below:

 

<entry key="sfdc.extractionSOQL" value="Select Id, Name, fle__Field1__c, fle__Field2__c FROM fle__DLObject1__c where fle__OtherExtId__c = 1"/>

How to do to pass a parameter ? Here to replace dynamically the '1' ?

 

Thanks in advance for your help.

 

Keerthi P 5Keerthi P 5
Hi ,

You got any help here.. please let me know

Thanks
Kirthy
Juan AcostaJuan Acosta
Hi,
I recommend to you to follow this.
https://stackoverflow.com/questions/12071190/key-extractionsoql-value-in-apex-data-loader-with-command-line
It works.
However, also check this
https://developer.salesforce.com/forums/?id=906F00000008ou3IAA

The escape characters will give you problems for sure.
Cheers,
J