iRobo.Activity.Execute.SQL.Query

Execute SOQL command in salesforce.


                                                                                                               

Properties

Input

  • Query -  Enter SOQL query as String within "", for example: "select id, name from contact limit 2". (Mandatory)


Misc

  • DisplayName - Activity header name.


Output

  • Result - returns List of String of the query result.  


Steps of Using Execute SQL Query Activity

  1. Open iRobo Studio, and then open a new Workflow.
  2. Drag SalesForce Application Scope Activity to the Sequence.
  3. Enter your Salesforce account password in the Password field in Properties Panel.
  4. Enter your Salesforce account username in the username field in Properties Panel.
  5. Enter the Consumer Key field in Input in Properties Panel.
  6. Enter the Consumer Secret field in Input in Properties Panel.
  7. Drag Execute SQL Query into SalesForce Application Scope Activity Sequence.
  8. Enter SOQL command in the Query field in Input in Properties Panel.
  9. Create List Variable of ListString Type and add it Result in Output in Execute SOQL Activity.
  10. Drag For Each Activity into SalesForce Application Scope Activity Sequence.
  11. Add List Variable to For Each Activity; to loop on it as shown in the image below.

  1. Drag Message Box Activity into SalesForce Application Scope Activity Sequence; as shown in the above image.
  2. Click the Save button from the iRobo Studio Menu to save Workflow.
  3. Click the Play button to start the automated process, a message box appears displaying data for each ListString in the SOQL command.

Created with the Personal Edition of HelpNDoc: Single source CHM, PDF, DOC and HTML Help creation