Tuesday, December 20, 2022

Workbench in Salesforce

In this post, we will talk about what is Workbench in Salesforce and what we can do with this tool. Salesforce Workbench is a powerful, web-based suite of tools designed to interact with Salesforce.com organizations via the Force.com APIs.

What is Salesforce Workbench?

A workbench is a web-based tool designed for Salesforce Admin and Developers which allows them to interact with Salesforce organization to insert, update, delete, search and export data. Using the Workbench tool, they can easily perform SOQL and SOSL, view their organization’s data, perform data loading and testing, deploy and troubleshoot their applications, and modify session settings.

Login to the Salesforce workbench

To log in, go to the workbench website, select the type of environment like sandbox/production, and enter credentials to log in. If you are login to the developer edition, then select production. See the below screen for reference.

login to the Salesforce workbench

Features of Workbench for Salesforce Developers

There are different features of Workbench for Developers. Here is some feature of Workbench:

  1. Metadata Explorer
  2. Data Management Capabilities
  3. REST API Explorer
  4. Metadata Deployment/ Retrieval
  5. Password Management
  6. Anonymous Apex

Different way to use Workbench

Let’s see how we can use Workbench in Salesforce and different ways to use this web base tool.

  1. Standard & Custom Object Metadata
  2. Metadata Types & Components
  3. SOQL using Workbench in Salesforce
  4. Export data with Workbench
  5. Mass Data update
  6. Workbench REST Explorer query
  7. Deployment using workbench

Let’s see all of them in detail.

Metadata Explorer

1. Standard & Custom Object Metadata

Use the workbench Standard & Custom Object Metadata feature if you want to access the metadata details. For that, you need to select the “Standard & Custom Object Metadata” option and then select the SObject that you want to see.

After that click on Select button. Then it will show you all details.

Standard & Custom Object Metadata

2. Metadata Types & Components

You can also access Metadata Types & Components details in the workbench.

Metadata Types & Components using Salesforce workbench

Data Management Capabilities

3. SOQL using Workbench in Salesforce.

Workbench is the best tool for building SOQL for non-developer. follow the below step to run the query from the workbench.

  1. Login on workbench
  2. Select the SOQL Query option
  3. Then select Sobject
  4. Then select the field which you want in your query
  5. You can also add a filter from the “Filter result by” column.
  6. It automatically creates a query for you. Then click on the query button to see the result.
Queries using Salesforce Workbench

4. Export data with Workbench

You can also export the data using the query builder. You just need to click on “Bulk CSV” or “Bulk XML” option to export the data.

Export data with Workbench

Using Deleted and archived records you also also export data from recycle bin.

5. Mass Data update

You can also insert, update, delete and undelete a record and mass data update using the workbench.

  1. Login on workbench
  2. Select Data Option then select the DML option called Update/insert
  3. Then select The Sobject.
  4. Then upload the file.
  5. Then click on Next.
Mass Data update using Salesforce workbench

REST API Explorer

6. Workbench REST Explorer query

Let’s see How to run REST API through Workbench?

  1. Login on workbench
  2. Go to Utilities -> Rest Explorer.
  3. Then select the HTTP Method
  4. You can click on Header button to change header values
  5. Then provide the URL

Metadata Deployment/ Retrieval

7. Deployment using workbench

You can also do the deployment using the workbench Migration option. You need to create on zip folder with metadata and package.xml which you can upload to start the deployment. Please check this post to learn about how to do deployments using the workbench.

FAQ’s

What is a Salesforce workbench?

A workbench is a web-based tool designed for Salesforce Admin and Developers which allows them to interact with Salesforce organization to perform DML, Query, check schema, and deployment in Salesforce.

How to login in to Workbench?

To log in, go to the workbench website, select the type of environment like sandbox/production, and enter credentials to log in

Where is the workbench in Salesforce?

A workbench is a web-based tool. You need to https://workbench.developerforce.com/login.php URL to login and access it.

Workbench is an official Salesforce.com tool.

No. Workbench is free to use but is not an official salesforce.com product

No comments:

Post a Comment

Understanding Wire vs Imperative Apex Method Calls in Salesforce Lightning Web Components (LWC)

Understanding Wire vs Imperative Apex Method Calls in Salesforce Lightning Web Components (LWC) Introduction: Salesforce Lightning Web ...