[SalesForce] Not able to export query results to Bulk Csv

I have a SOQL query that I am able to run in eclipse, developer console and the workbench (as a list).

Here is my query. The query is based on two standard objects – User and UserRole.

Select u.Name, u.Id, 
(Select Username, LastName, FirstName, Name, 
IsActive From Users) 
From UserRole u WHERE u.name like 'Inside%'

When I select the "Bulk Csv" option in the workbench, I get this error.

Invalid Job: Unable to find object: users

How can I download the results to a csv file?

The workaround I have is:

  1. Select the List Option.
  2. Save the results page as an HTML page on my laptop.
  3. Copy the contents of an HTML page to Excel.
  4. Edit the excel spreadsheet and save.

Is there a better (free) alternative to do this?
Error on Workbench

Best Answer

I am a big fan of the Salesforce Inspector chrome extension. Once installed, it has an option of data export (helps you write SOQL lightning fast!) which you can use to export data as Excel/CSV/Json etc. Give it a try, it would save lot of time (copying results as HTML and HTML to excel must be painful!)

Related Topic