function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
JesipJesip 

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??

hugo.medradohugo.medrado

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