We built the FuseIT SFDC Explorer while developing our S4S and G4S connectors and found it so useful we made it a free download. The FuseIT SFDC Explorer currently runs on Microsoft Windows only. The download link also provides access to an online tool that accepts a WSDL and generates the Apex classes to call the web service.
With S4S and G4S we recommend using it to verify Salesforce access and understand the underlying entity 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.
The tool provides a number of functions built around the Salesforce Partner, Tooling, and Metadata APIs. Some of these are:
To use the FuseIT SFDC Explorer, first login with the credentials of a Salesforce API user. See the help documentation for further details.
The Explorer has many features. To help you focus on the applicable ones go to the Home Tab to select the features you frequently use. You can also use the Tabs menu to toggle the visibility of features.
We regularly add new features so be sure to regularly download the latest version of the Explorer from the Help tab.
Run Salesforce SOQL queries with the query builder. The results can be exported to a CSV (Excel) or JSON file or to the clipboard by clicking the icon at the bottom of the results pane.
This tab lets you find and view the entity fields belonging to any Salesforce ID.
Shows the currently queued tests running asynchronously.
Allows users to view the Salesforce Apex logs for the Salesforce instance. The logs can be filtered by ticking the statement types in the Apex Log box in the bottom-left section.
The log display has a number of controls for filtering and parsing the debug log content.
Salesforce Data Export zip files (see Salesforce > Data Management > Data Export) need to be manually downloaded to a local server. The FuseIT SFDC Data Export tool has two options to copy these files to your local server. The first is the GUI option:
While the GUI option above is a one-time download, many customers prefer to use a Windows Task to schedule automated data export downloads. Automated backups are more reliable but they should be checked regularly to verify they are still working.
The FuseIT.G4S.DataExportConsole.exe application can be executed directly from the command prompt (via cmd window) or the command line can be embedded in a script file that is executed by a scheduled task - see details.
Salesforce acknowledges an issue with some zip files. One customer, downloading 400 files, had been impacted.
Coming soon ...
FuseIT is building a Microsoft Store application dedicated to selecting, scheduling, and downloading Salesforce Data Export files from weekly data exports. The app will make it very easy to automate the downloads without requiring technical expertise to schedule and monitor the download. We've also added a few features not available in the command line version:
We've not yet completed the app so now is a good time to request features you would like to see implemented. Please contact us and let us know.
From this tab, users can run apex statements directly against the Salesforce org. The Apex debug log output of these statements is also displayed.
Use this tab to quickly view the relationships between entities. First, select an entity from the Database Schema section on the left.
On the right, the top panel shows the master-detail relationships (where the master record controls certain behaviors of the detail and sub-detail record). The lookup relations associated with the entity are shown in the bottom panel.
From this tab, users can generate strongly typed C# classes that represent Salesforce entities.
The WSDL to Apex control helps developers deal with many of the problems faced when generating Apex classes from a WSDL using Salesforce’s WSDL2Apex tool.
The parser lets developers point at the required WSDL, select only the web service methods needed, generate the corresponding Apex classes, choose to also generate test classes, and then publish the classes directly into a Salesforce Org via the Tooling API.
WDSL parsing is particularly challenging as the published interfaces greatly vary. Over the last 10 years, the parser has been improved based on user feedback. The WSDL parsing features in the FuseIT SFDC Explorer are:
The FuseIT WSDL to Apex utility resolves a number of error messages described by the "Error parsing WSDL with Salesforce Wsdl2Apex" message.
This tab allows you to view the code coverage of Salesforce classes.
The Percent column is color-coded to indicate if the minimum 75% coverage for the class has been met and the individual percentage shown. On the top row, the org-wide coverage is shown.
Double-clicking a row will open the class and clicking the green double arrow to the right will attempt to find all the test cases that contribute to the coverage of that class. Then it queues those tests up to run.
This tab is similar to the Code Coverage but the Apex Classes tab provides the ability to view, edit, and deploy multiple classes without jumping out of the Explorer and into your preferred IDE.
From this tab, users can access Salesforce metadata. Metadata defines the schema of the Salesforce instance and includes the entities, fields, config, page layouts, etc,
Metadata can be imported, modified, or edited using the Salesforce Metadata API.
The retrieval dataset can be large so users should try to narrow down their retrieval selections.
This tab assists users to build and deploy a Metadata package.
There are granular options to deploy from a file, several files, or a nominated directory.
Once the deployment files have been selected, the Compare File Hash selection initiates a CRC32 diff of the body of Apex classes, triggers, and Visualforce pages between the local file system and the connected Salesforce org. If anything is different it gets added to the current package ready for deployment. If it turns out the local file is the one that should be updated there is a context menu option to update the local file.
This tab allows users to compare schema elements between the current Salesforce org (the Source org) and a second Target org.
After the two orgs have been chosen the metadata is retrieved from both orgs and placed into the nominated folders where they can be compared using third-party tools.
This tab is useful for quickly checking the Salesforce event logs.
The types of events are displayed in the upper panel. Selecting an event type will cause all events of this type to be displayed in the lower panel. The data can then be exported in csv format.
Individual columns are sortable making it easy to find the event you are looking for.
This tab lets users execute a Salesforce report from inside the Explorer.
First use the refresh button to load any reports that have been recently executed. Clicking on the Id link will run the report in the lower panel.
As expected, the report can also be exported as a .csv file and used with the likes of Excel
This tab queries Salesforce for the Metadata dependency records.
There is also the capability of graphing the relationships using tools like Gephi. Start with a single ID against "Where is it used" and then using the context menus to create a small dataset.
Ready to join the integration revolution?
Get started and enjoy the benefits sooner