SOQL as Test Step

Prerequisites

• Before you begin, ensure the Salesforce app is connected to Testsigma with a valid metadata connection.

---

Steps to Create SOQL as a Test Step

1. From the left navigation bar, navigate to Create Tests > Test Cases.

2. In the Test Case Details page, click on the test step options list and select SOQL.

3. Select a Salesforce connection from the Salesforce Connection dropdown or you can parameterize your connection.

4. Enter your SOQL query in the editor and click Run Query to fetch the results.

   For example,

   SELECT Id, Name, Phone, Industry, BillingCity, BillingState
   FROM Account
   WHERE Industry = 'Technology' AND BillingState = 'CA'
   ORDER BY Name
   LIMIT 50

   

5. View the response in Table, Outline, or JSON format by switching between the tabs.

6. In the Outline tab, store values as variables or add verifications directly from the response.

7. Click Create to save and add the SOQL step to your test case.

---