Today's Offer - Salesforce Certification Training - Enroll at Flat 10% Off.

- Salesforce Blogs -

What is Salesforce Workbench? Salesforce Workbench Tutorial Guide

Salesforce is a company who has been striving hard to eliminate all kinds of problems that its clientele witnesses and informs them about. They come up with different tools, features, frameworks etc. One such amazing tool is Salesforce Workbench. It is a web-based suite of tools designed for Salesforce professionals to interact with Salesforce.com org via force.com APIs. Today we shall have a brief discussion about Salesforce Workbench, for better understanding the blog has been divided into the following parts-

What is Salesforce Workbench?

Salesforce Workbench is a versatile, cloud-hosted toolkit designed for Salesforce administrators and developers to administrate and work with Salesforce.com organization via Force.com APIs. Using Salesforce Workbench suite of tools, administrators and developers can rapidly and easily perform SOQL Query and SOSL searches, view their organization’s data, modify session settings, perform Data Loading, and conduct testing, deployment and troubleshooting of their applications.

How to login to Workbench Salesforce?

Salesforce Workbench supports multiple login methods. The standard username and password combo, session IDs and OAuth 2.0 remote access login methods are all supported. Users can also make use of our Firefox browser extension to access Salesforce Workbench suite.

Read: How can Learning Salesforce Developer Skills Lead you to your Dream Job?
  • To access the Workbench Salesforce web suite use the URL (https://workbench.developerforce.com/login.php) and perform the following steps to access your account:
  • Login to the Workbench Salesforce using your account credentials from Salesforce.com
  • Select your desired working environment [Production or Sandbox]
  • Agree to the Terms and Conditions by selecting I Agree to the terms of service.
  • Click on Login with Salesforce
  • Once you have successfully logged in to Workbench Salesforce, you can use the Jump To menu to easily access and switch to different options like Metadata Types & Components, Standard and Custom Objects, SOQL Query, SOSL Search, Insert, Update, Upsert, Delete, Insert, Undelete, Purge, Deploy, Retrieve, Apex Execute and many other tasks
  • Choose the desired option or task from those given in the list. For example, lets select Standard and Custom Objects. This will then allow you to select the specific Object to jump to.

This particular tutorial on Salesforce Workbench will focus on getting session information, building SOQL queries in Salesforce Workbench, Creating records and manipulating (updating & deleting) them using Apex Execute. We will also see how to reset your password using Workbench Salesforce. salesforce Curriculum

Few Nuances of Salesforce Workbench

Session Information

Users with system administrator permissions can end or cancel other user sessions in Workbench Salesforce. The session Information tab in Workbench Salesforce can display details about the current user session like Connection and Accessibility mode, the profile Id, Session seconds valid and user information such as Email, Full Name, Type, Role ID, Time Zone etc.

Performing SOSL searches in Salesforce Workbench

Salesforce Object Search language (SOSL) allows users to perform and execute text-based search queries against the search index. To perform SOSL searches navigate to Queries and select SOSL searches.

Read: Salesforce Consultant Salary Trends you Need to Know

Executing Apex code in Salesforce Workbench

New objects can also be created from SOQL queries on existing objects using SOQL code. All such newly created objects contain null values for its fields and need to be set after automated creation is complete.

Resetting password in Salesforce Workbench

The Workbench Salesforce passwords of users can be set and reset from the utility tab in the Workbench Salesforce Interface. The steps to do so are as follows:

  • Select the Utilities Tab and click on Password Management
  • Select the desired action ( Set or Reset )
  • Fill in the UserId and desired passwords
  • Click on change password.

Advantages of Salesforce Workbench

Data Management

One of Workbench's best functionalities is called Smart lookup, which aids you in supplanting the VLOOKUP choice in excel. Smart Lookup is utilized if there should be an occurrence of Insert, Update, Upsert or Delete function only and it isn't compulsory, it will assist you with providing Standard id query field and an incentive with Salesforce Id consequently. salesforce quiz For instance, in the event that you have a CSV type file for Case object refresh existing records with various Case Owners, as the general practice it would extricate the current Case records including Case Owner field and afterward it refreshes the Case Owner field with new Users according to the prerequisites mentioned. However, using Workbench we can update Case Owners information directly when API does it by looking up the Case Owner ids by using Smart lookup function. To get these benefits, first, we have enabled Smart Lookup feature in settings Anyway, by utilizing Workbench, you can refresh Case Owners data specifically when API does it by looking into the Case Owner ids by utilizing Smart query work. To get these advantages, first, you have to enable the Smart Lookup feature in the settings

Read: How To Use Custom Labels In Apex Class In Salesforce?

Easy Data Extraction

Workbench is such a delightful web device which will make Salesforce administrator's life easy and simple by supplanting the Data Loader device. In Salesforce, to remove information identified with Users with their Roles, Profiles and the Permission sets is simple. Any way to separate information for the Users who are doled out to Permission sets isn't conceivable with Data Loader. However, this necessity can be satisfied utilizing Workbench. Follow the steps here to see how to do that

  • You are required to log in to Workbench with Production or Sandbox environment
  • Then you can go to the 'Inquiries' menu at the top
  • Select SOQL Query alternative, and after that select object name in the options list and Jump to with "PermissionSetAssignment"
  • Select the required field for the recorded things and view as an alternative should be selected to "Mass CSV" rather than "Rundown" with the goal that you can trade the information in CSV design. Tap on "Question" link that appears. There will be a yield of the PermissionSets appointed to Users in the Salesforce.

free salesforce demo

 Conclusion

Well, all your doubts about Salesforce Workbench should be clear now. I hope the blog was useful to you. You can very well see that in Salesforce ecosystem, all you have to do is to look for a way to do things in an easier manner and you would always get away.

Read: What is Salesforce CRM and What does Salesforce do?

Salesforce Tutorial Overview


    Janbask Training

    JanBask Training is a leading Global Online Training Provider through Live Sessions. The Live classes provide a blended approach of hands on experience along with theoretical knowledge which is driven by certified professionals.


Trending Courses

AWS

  • AWS & Fundamentals of Linux
  • Amazon Simple Storage Service
  • Elastic Compute Cloud
  • Databases Overview & Amazon Route 53

Upcoming Class

4 days 24 Nov 2019

DevOps

  • Intro to DevOps
  • GIT and Maven
  • Jenkins & Ansible
  • Docker and Cloud Computing

Upcoming Class

5 days 25 Nov 2019

Data Science

  • Data Science Introduction
  • Hadoop and Spark Overview
  • Python & Intro to R Programming
  • Machine Learning

Upcoming Class

5 days 25 Nov 2019

Hadoop

  • Architecture, HDFS & MapReduce
  • Unix Shell & Apache Pig Installation
  • HIVE Installation & User-Defined Functions
  • SQOOP & Hbase Installation

Upcoming Class

6 days 26 Nov 2019

Salesforce

  • Salesforce Configuration Introduction
  • Security & Automation Process
  • Sales & Service Cloud
  • Apex Programming, SOQL & SOSL

Upcoming Class

-1 day 19 Nov 2019

Course for testing

  • Salesforce Configuration Introduction
  • Security & Automation Process
  • Sales & Service Cloud
  • Apex Programming, SOQL & SOSL

Upcoming Class

34 days 24 Dec 2019

QA

  • Introduction and Software Testing
  • Software Test Life Cycle
  • Automation Testing and API Testing
  • Selenium framework development using Testing

Upcoming Class

13 days 03 Dec 2019

Business Analyst

  • BA & Stakeholders Overview
  • BPMN, Requirement Elicitation
  • BA Tools & Design Documents
  • Enterprise Analysis, Agile & Scrum

Upcoming Class

5 days 25 Nov 2019

SQL Server

  • Introduction & Database Query
  • Programming, Indexes & System Functions
  • SSIS Package Development Procedures
  • SSRS Report Design

Upcoming Class

-1 day 19 Nov 2019

Comments

Search Posts

Reset

Receive Latest Materials and Offers on Salesforce Course

Interviews