How can I use the Explorer?

The Explorer uses the Salesforce Partner API to provide the following:

• Login to Salesforce using credentials from a Partner API enabled user
• Create SOQL queries that can be run against Salesforce objects
• Expose the Salesforce database schema
• Identify each object's lookup and master-detail relationships
• Find Salesforce entities
• Quickly run Apex tests
• Select and generate Apex methods and test methods from any WSDL
• Download data exports to your server directly or via a scheduled task using a command line executable
• Use the WSDL Parser to generate Apex classes and test classes with code coverage for a WSDL from a local file or directly from a URL
• More features every week

You need to login using Salesforce credentials to use the FuseIT SFDC Explorer. See the help documentation for further details.

Run Salesforce SOQL Queries

This tab allows you to run SOQL queries against the Salesforce.com instance. The results of the SOQL query may be exported to an Excel CSV file by clicking the  icon.

Fields

• Entry field: Canvas for writing the SOQL query. You can also create a new query by dragging the object from the Database Schema section to the query window

Buttons

• Query: Executes the query against Salesforce.com
• Clear: Clears the SOQL query and any results. 
• Save: Asks you to name the query then saves it for future use
• View All: Shows a screen with a list of saved queries and presents an opportunity to open one

Find Salesforce Entities

 This tab lets you find the object associated with a Salesforce ID.

Fields

• Entity ID: The Salesforce entity sought. This is typically the 15 digit unique URL extension seen when viewing the object within Salesforce.com
• Case Safe ID: The 15 digit Salesforce ID converted to the 18 digit lower case equivalent  
• Output Field: Details of the field type discovered

View Salesforce Apex Tests Queued

Apex Tests Queued shows the currently queued tests when the test are running asynchronously.

Data Exports

There are two ways to use the data export functionality, GUI or command line. Both are able to iterate through a completed export (see Salesforce > Data Management > Data Export) and copy the selections to your local server hard drive.

Fields

• Output field: Area for viewing the results
• File Name Format: How the system will save the export files. The merged field ({}) is a placeholder for the export ID text
• Save Directory: Where the exports will be saved on the file system

Buttons

• Get ID's: Shows a collection of export ID's and offers the opportunity to select individual exports
• Stop: Halts the current download process
• Download: Initiates the download to the nominated file location

Data Export by Command Line

The FuseIT.G4S.DataExportConsole.exe application can be executed directly from the command prompt (via cmd window) or you can embed the command line in a script file - see details.

Known Issue

Salesforce acknowledges an issue with some zip files. We know one customer, who was downloading 400 files, that was impacted.

WSDL Parser and Apex Generator

The WSDL to Apex control in the FuseIT SFDC Explorer helps developers deal with many of the problems faced when generating Apex classes from a WSDL using Salesforce’s WSDL2Apex tool.

The FuseIT tool allows developers to select only the Apex methods needed, generate these Apex classes, then publish the classes directly into a Salesforce Org via the Tooling API.

See the example beside of Apex classes generated for the Salesforce Partner WSDL in FuseIT SFDC Explorer.