Executing SOQL or SOSL commands on Salesforce org

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 information and match against front-end display on Salesforce screens. Same set of commands work both for SOQL and SOSL, intended for querying Salesforce objects and searching Salesforce objects respectively.

Establishing Connection

Define Salesforce Query connection (SOQL/SOSL)

Instance URL

Username

Password

Session ref name

Salesforce instance URL

Username

Password+Security Token

Unique name for the session to refer in subsequent commands

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

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 Salesforce Query Result

Verifies the value in the result of 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

Query reference name

query reference name from which results must be retrieved