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.

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.

login

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
soql query image

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
sfdc relationships image

 

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
findentity image

 

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.

 

 

apex tests image

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. 
queued tests image

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. 

 

apex logs image

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.

data export image

Run Salesforce Anonymous Apex

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

 

 

 

 

 

 

 

 

anonymous apex image

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_apex_image

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
Time in New Zealand

Our Saturday is Friday in the US

Ready to join the integration revolution?
Get started and enjoy the benefits sooner