+ Start a Discussion

sForce Data Loader command line

I am successfully using the command line interface of the sForce Data Loader to extract data.  However, I am having problems using SOQL statements with a WHERE clause like:

The statement below generates a "Error in Query: missing Select" message. The statement directly out of the config.properties file after running successfully using the GUI interface.

java -jar sforcedataloader.jar entity=Account operation=extract extractionSOQL="Select Id, Name FROM Account WHERE RecordTypeId \!= '0123000000004lXAAQ'" extractionTarget=C:\\Projects\\Salesforce\\Data\\accounts.csv

I have tried every combination of escape characters I can think of to get this syntax to work.  Can anybody help me out??


Did you solve this problem? I´m with the same error...