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.
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.
8. Click Done.
Output schema