Executes SOQL query
Use the Executes SOQL query action to execute the specified SOQL query. For more information, refer to the API documentation.
Complete the following steps to use the Executes SOQL query action in your workflow:
1. Drag the Executes SOQL query action under Salesforce to the canvas, place the pointer on the action, and then click or double-click the action. The Executes SOQL query window opens.
2. Edit the Label, if needed. By default, the label name is the same as the action name.
3. To add a Salesforce connector type, refer to Supported Salesforce Connector Types.
If you previously added a connector type, select the appropriate Connector Type, and under Connector Name, select the connector.
4. Click TEST to validate the connector.
5. Click MAP CONNECTOR to execute the action using a connector that is different from the one that you are using to populate the input fields. In the Runtime Connector field, provide a valid Salesforce connector name. For more information about MAP CONNECTOR, see Using Map Connector.
6. In the API Version list, select the API version that you want to use to execute the query. For enhanced performance, it is recommended to use API version 30.0 and later.
7. In the Query operation method list, select the appropriate method to perform on the query:
Select Execute the query, and in the SOQL Query field, provide the query that you want to execute.
Select Retrieving query performance feedback without executing the query, and in the SOQL Query field, provide the query that you want to execute.
Select Retrieving query performance feedback on a report or list view, and in the Report or List view ID field, provide the report or list view ID to retrieve its query performance.
Select Retrieving additional query results if the initial results are too large, and in the Query Identifier field, provide the query identifier to retrieve the next set of results. You will obtain the query identifier only if the result exceeds the maximum result size.
For more information, refer to the API documentation.
8. Click Done.
Output schema
Was this helpful?