+ Start a Discussion

DataLoader - Command Line Interface

We have a report that I am trying to extract automatically to a csv file.  I typically use the Command Line Interface (using DataLoader) to do this.  However, this particular report uses a Report Type of "Opportunities w/ Products".  I dont think DataLoader can do a nested SOQL query.  Any suggestions how i can automate extraction of data if the information is pulling from 2 objects.  

SELECT CloseDate, Name, Generics_Analyst__c,(SELECT Site__c,Quantity,Approved_QTY__c,Disposition__c,Product_Name__c,Status__c FROM OpportunityLineItems) FROM Opportunity
WHERE RecordTypeId = '012G00000015ChQ' AND StageName != 'FSE Created' AND CloseDate = TODAY

Try running this query on workbench. In data loader you can work on only one object at a time.

In workbench you can export the query results in csv.