Executing SOQL or SOSL commands on Salesforce org – ACCELQ

ACCELQ supports test logic development to query the backend Salesforce data using SOQL (Salesforce Object Query Language) and SOSL (Salesforce Object Search Language) interface provided by Salesforce. You can either query for data or verify the information and match it against the front-end display on Salesforce screens. The same set of commands works both for SOQL and SOSL, intended for querying Salesforce objects and searching Salesforce objects respectively.

Establishing Connection

Define Salesforce Query connection (SOQL/SOSL)

Defines Salesforce Query (SOQL/SOSL) connection details. Further Salesforce Query/Search commands will be based on this connection.

Instance URL

Authenticate Type

Username

Password

Session ID

Proxy Required?

Proxy information
(host, port, user, password)

Session ref name

Salesforce instance URL

Choose between "Credentials" and "Session ID"

Username (for auth-type = credentials)

Password+Security Token (for auth-type = credentials)

Session id for authentication (for auth-type = session id)

Yes / No (for auth-type = session id)

Applicable if Proxy Required = Yes


Unique name for the session to refer in subsequent commands

About specifying the Password:

Concatenate the security token with the password.

Format (Password+Security Token)

Refer to the article to get the Security token: Get Salesforce Security token

Note about finding the Instance URL:

The instance URL your Salesforce Organization uses is indicated in the URL of your browser's address bar for the Developer Console Window.

For Example https://accelq.salesforce.com/_ui/common/apex/debug/ApexCSIPage

The hostname is your Salesforce Instance URL. In this example, 'accelq.salesforce.com'.

You can open the Developer Console by :

In Salesforce Classic: After login, Your user name dropdown > Developer Console
In Lightning Experience: After login, Gear icon > Developer Console

Running Queries

Execute Salesforce query

Executes the given SOQL/SOSL query. Returns the count of rows matched by the query.

Query

Query Ref Name

Returns

Salesforce Query (SOSL/SOQL) to execute in the format supported by Salesforce

Reference name for this query to be used for retrieving results in subsequent steps

Returns the count of rows matched by the query

Retrieve Field value from Query/Search results

Get Field Value from Salesforce Query Result

Retrieves the value for a field from the results of the recently executed Salesforce query or search. Identify the query with its reference name. The row number and column number used in the field specification start with 1.

Query ref name

Row number

Col Specification type

column

Returns

reference name of the query from which results are retrieved

row number in the executed query results

column specification type (column index, column name)

column number or column name in the executed query results

Returns value of the field from the results of SF query/search

Verify Field value from Query Execution results

Verify Field Value from Salesforce Query Result

Verifies the value in the result of the Salesforce query or search against an expected value. Note that the Salesforce query should have already been executed with the given query reference name.

Query ref name

Row number

Col Specification type

column

expected value

match criteria

failure action

reference name of the query from which results are retrieved

row number in the executed query results

column specification type (column index, column name)

column number or column name in the executed query results

expected value against which the field value is verified

match criteria to evaluate

continue or abort test case in case of verification failure

Log Query Result

Log Salesforce Query Result

Prints given Salesforce query results to the test report.

Query reference name

query reference name from which results must be retrieved

Establishing Connection

Running Queries

Retrieve Field value from Query/Search results

Verify Field value from Query Execution results

Log Query Result

Related articles