FuseIT SFDC Explorer

The Salesforce developer tool for Microsoft developers and administrators.

About SFDC Explorer?

We built the FuseIT SFDC Explorer for internal use while developing our S4S and G4S connectors and found it so useful we made it a free download. You can also click on the download link to access an online tool for generating Apex from your own WSDLs. The Explorer runs on Microsoft Operating Systems.

For customers using our integrations, we recommend using the Explorer as an easy way to verify their Salesforce access and understand the underlying object model and processes. There is also a code generation tool that uses a T4 template to create strongly typed C#.NET classes (with associated service and data source classes) from custom and standard Salesforce objects.

Get started with FuseIT SFDC Explorer - Download

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

View Salesforce Relationships

This tab allows you to view object relationships. Use the Database Schema section to choose the required object.

Fields

Master Detail Relationships: Shows any related parent-child relationships where a master object controls behaviors of the detail object
Lookup Relationships: Shows any related lookup relationships where another object is optionally connected to selected object

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

Run Salesforce Apex Tests

This tab allows you to run Apex tests. Tests can be run synchronously or asynchronously. The average code coverage for the selected tests is displayed along with what tests have passed and failed. Additionally the test log is can be viewed for the selected tests.

Buttons

Run All Tests: Executes all the test methods in the current Salesforce instance.
Run Sync: Runs the selected tests synchronously.
Run Async: Runs the selected tests asynchronously.

View Salesforce Apex Tests Queued

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

Buttons

Check Status: Checks the status of the tests within the current job and displays results below.
Get Results: Gets the results of all tests run.
Open Log: If a log was found for the tests, the log will be opened. If a log for a test has been found, the ApexLogId column will be populated with the log ID.

Fields

Test Run Job Id: The Apex Job ID of the current job.

View Salesforce Apex Logs

Allows users to view the Apex logs for the Salesforce.com instance.

Note that the logs can be filtered by ticking the statement types in the Apex Log box on the bottom-left.

Buttons

Open Log: Opens the selected log.
Refresh: Gets the latest list of logs from Salesforce.
Clear: Clears the list of logs currently visible.
Reset: Displays all the logs from Salesforce.

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.

Run Salesforce Anonymous Apex

From this tab users can run apex statements anonymously. The output of these statements is also displayed.

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.

WSDL Parsing Features

The WSDL parsing features in SFDC Explorer are:

Import a WSDL from URL or local file.
Supports multiple Port, Binding and PortType in the WSDL (calls SOAP based web service at the moment).
Support for complex types that extend from a base class <xsd:extension base="tns:Sample">
Support for <wsdl:import> which will import the Service Description (e.g. Bindings) from another location.
Support for <xsd:import> and <xsd:include> which will import a WSDL schema from another location.
Support for <xsd:any> schema element, and converted to "List<DOM.XmlNode>" type in Apex.
Support for <xsd:choice> elements.
Support <xsd:attribute> elements.
Support for nested Complex types in a sequence.
Support for nested sequence in a sequence.
Support for <xsd:all> element to generate Apex class members and apex method parameters.
Support for <xs:simpleContent> elements.

User defined class names for each WSDL namespace.
Option to replace already existing Apex classes in Salesforce.
Ability to select the Apex methods that should be generated. The description of input and output parameters is also provided.
Response and Request Apex classes are generated only for the methods included, which reduces the amount of code to written for testing Web Service callouts.
Apex method filter by name or by CSV (Comma Separated Values.)
Warning comments are add in generated Apex code if WSDL elements are skipped.
Syntax highlighter for generated Apex classes.
Option available to generate web service callout test and mock classes for Apex classes providing more than 75% code coverage.
HTTP mock class for testing will also be generated if Apex methods with HTTP calls are generated.
Deploy generated Apex and test classes all at once or one by one.
Resolves typical code generation errors produced by Salesforce.
Option available to generate HTTP calls in addition to SOAP call in Apex methods.

WSDL Parsing Errors

The FuseIT WSDL to Apex utility resolves a number of error messages described by the "Error parsing WSDL with Salesforce Wsdl2Apex" message.

Error: Failed to parse wsdl: Found more than one wsdl:binding. WSDL with multiple binding not supported
Error: Failed to parse wsdl: Found more than one wsdl:portType. WSDL with multiple portType not supported
Failed to parse wsdl: Failed to parse WSDL: Unable to find binding
Error: Failed to parse wsdl: Found schema import. External schema import not supported

Apex Generation Failed Unable to find schema for element
Error: Failed to parse wsdl: type not specified for attribute
Apex Generation Failed: No type specified for element
Error: need to modify WSDL with import tags or include tags
Enterprise wsdl error: Unsupported schema type: {http://www.w3.org/2001/XMLSchema}anyType

Salesforce

Take a closer look?

External web link - http://www.salesforce.com/

Time in Nelson, New Zealand

Our Saturday is Friday in the US