+ Start a Discussion
Deepu BDeepu B 

Pass the values dynamically in where clause in data loader CLI(sfdc.extractionSOQL)

My requirement is i need to pass the IDs dynamically in WHERE clause of SOQL query. I tried in below different ways but didn't work.

Ways i worked...

1.  <entry key="sfdc.extractionSOQL" value="Select Id, Name, Phone FROM Account WHERE Name IN     
     (DCRwhereextract.csv) "/>

2.   <entry key="sfdc.extractionSOQL" value="Select Id, Name, Phone FROM Account WHERE Name IN     
     ('DCRwhereextract.csv') "/>

3.  <entry key="sfdc.extractionSOQL" value="Select Id, Name, Phone FROM Account WHERE Name IN     
     '(DCRwhereextract.csv)' "/>

4.   <entry key="sfdc.extractionSOQL" value="Select Id, Name, Phone FROM Account WHERE Name IN     
     (C:\DataLoader\DCRwhereextract.csv) "/>

Show me the way how i can read the ID values after Where clause from the CSV file.