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