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
choppen5choppen5 

soql from DataLoader

Hi, I am trying to do the most basic SOQL from this documentation in DataLoader 14.0: http://www.salesforce.com/us/developer/docs/api90/Content/sforce_api_calls_soql_relationships.htm

 

In DataLoader, if I execute this from the docs in the SOQL of Data loader:

 

"SELECT Contact.FirstName, Contact.Account.Name from Contact"

 

the columns are returned blank. 

 

If I use the non aliased version:

 

Select LastName, FirstName FROM Contact  it works. So I can't do any relationship Queries with DataLoader, should I be able to?  Is the documentation out of date, or is DataLoader not capable of this?

 

 

 

choppen5choppen5

Hmm, found a solution, farther down it says this is the correct format for a Child To Parent relationship:

 

"SELECT Id, Name, Account.Name FROM Contact"

 

Not sure why they have the first one, it does not work.

 

"SELECT Contact.FirstName, Contact.Account.Name from Contact"