Before You Install the Recipe

You must perform the following configuration tasks on your Salesforce and SurveyMonkey instances in order to successfully connect to these external systems using Oracle Integration and email the surveys to Salesforce contacts.

  1. Configure Salesforce
  2. Configure SurveyMonkey

Configure Salesforce

To access Salesforce using Oracle Integration and retrieve contact email addresses from Salesforce cases, you must perform certain configuration tasks on your Salesforce instance.

Create a user account on Salesforce for Oracle Integration. You'll use the credentials of this user account while configuring the Salesforce connection in Oracle Integration.

Also, identify your Salesforce instance type and your current Salesforce API version. In addition, create an outbound message to trigger the recipe in Oracle Integration, and create a workflow rule to send the outbound message when a Salesforce case is closed.

Log in to your Salesforce instance as an Administrator and execute the following tasks.

Note:

The steps provided here apply to the Salesforce Classic UI. If you're using the Lightning Experience UI on your Salesforce instance, switch to the Classic UI. See Toggle or switch between Lightning Experience and Salesforce Classic.
  1. Create an API-enabled custom role. You'll assign this role to the user account you'll subsequently create for Oracle Integration.
    1. On the Salesforce Setup page:
      1. Expand Manage Users under the Administer section in the left navigation pane.
      2. Click Profiles.
    2. On the Profiles page, click New Profile.
    3. On the resulting page:
      1. Select Standard User in the Existing Profile field.
      2. Enter a name for the new profile, for example, API Enabled, and click Save.
      The new profile is now saved, and the Profile Detail page of the new profile is displayed.
    4. Click Edit on the Profile Detail page.
    5. On the Profile Edit page:
      1. Scroll to the Administrative Permissions section and ensure that the API Enabled check box is selected.
      2. Scroll to the Standard Object Permissions section and perform the following actions.
        • In the Accounts row, leave the Read, Create, Edit, and Delete boxes checked. Additionally, select the ViewAll check box.
        • In the Contacts row, leave the Read, Create, Edit, and Delete boxes checked. Additionally, select the ViewAll check box.
        • In the Price Books row, leave the Read box checked. Additionally, select the Create, Edit, and Delete check boxes.
        • In the Products row, leave the Read box checked. Additionally, select the Create, Edit, and Delete check boxes.
      3. Scroll to the end of the page and click Save.
  2. Create a user account for Oracle Integration and assign the custom role created previously to this account.

    Note:

    If you have already created a user account for Oracle Integration, you can assign the API-enabled custom role to the existing account.
    1. On the Profile Detail page of the API Enabled profile, click View Users.
    2. Click New User in the resulting page.
    3. On the New User page:
      1. Enter a first name and last name for the user, for example, Integration User05.
      2. In the Email field, enter a valid email address.

        The email address you enter is automatically populated in the Username field. Note down this user name.

      3. In the User License field, select Salesforce .
      4. In the Profile field, select the profile you created previously, that is, API Enabled.
      5. Scroll to the end of the page, ensure that the Generate new password and notify user immediately check box is selected, and click Save.

        The user account is now created, and a verification email is sent to the email address you provided for the account.

    4. Log in to the corresponding email account and click the Verify Account button in the email message from Salesforce.
      You're redirected to the Salesforce instance to set a password for the new user account.
    5. Set a password and note down the same.
      Subsequently, you're signed in to the Salesforce instance with the new account.

      Note:

      If you're shown the Lighting Experience UI, switch to the Salesforce Classic UI. See Toggle or switch between Lightning Experience and Salesforce Classic.
    6. Generate a security token for the new user account. You'll need this security token along with the password to access Salesforce using Oracle Integration.
      1. Stay signed in as the new user, and click the user name at the top of the page to open a menu.
      2. Click My Settings in the menu.
      3. On the My Settings page, in the Quick Links section, click Edit my personal information.
      4. On the resulting page, click Reset My Security Token in the left navigation pane.
      5. Click the Reset Security Token button.

        A new security token is sent to the email address associated with the account. Note down the security token.

      6. On the Salesforce instance, click the user name again and select Logout from the menu. Log back in as the Administrator.
  3. Identify your current Salesforce API version.
    1. On the Salesforce Setup page:
      1. Scroll to the Build section in the left navigation pane.
      2. Expand Develop, and then click API.
    2. On the API WSDL page, click the Generate Enterprise WSDL link.
      The WSDL is displayed in a new browser tab, and your current API version is present in the second line. For example:
      Salesforce.com Enterprise Web Services API Version 52.0
    3. Note down the API version.
  4. Identify your Salesforce instance type.
    1. If you use the URL https://login.salesforce.com to log in to your Salesforce account, your instance type is Production.
    2. If you use the URL https://test.salesforce.com to log in to your Salesforce account, your instance type is Sandbox.
  5. On your Salesforce instance, create an outbound message to trigger the integration flow of this recipe.
    1. On the Salesforce Setup page:
      1. Scroll to the Build section in the left navigation pane.
      2. Expand Create, then Workflow & Approvals, and then click Outbound Messages.

      If you're shown the Understanding Workflow page, click Continue.

    2. Click New Outbound Message in the resulting page.
    3. On the New Outbound Message page:
      1. Select Case in the Object field, and click Next.
      2. Enter the following details for the new outbound message:
        • Enter SurveyMonkeyCase as the name of the message. Note that the Unique Name field is automatically populated based on the name you enter.
        • Optionally, enter a description for the message.
        • In the Endpoint URL field, enter the following URL:

          https://<OIC_FQDN:OIC_SSL_PORT>/ic/ws/integration/v1/flows/salesforce/ORCL_R_SFDC_SM_CASE_CLOSE/1.0/.

          Where OIC_FQDN and OIC_SSL_PORT are the fully-qualified domain name and port of your Oracle Integration instance (for example, oicinstance.example.com:443).

        • In the User to send as field, select the user account using which you want to send the message.
        • Under Case fields to send, select all the fields.
        • Click Save.
    The new outbound message is created and displayed on your browser.
  6. Now, create a workflow rule to send the outbound message (created previously) when a Salesforce case is closed.
    1. On the Salesforce Setup page:
      1. Scroll to the Build section in the left navigation pane.
      2. Expand Create, then Workflow & Approvals, and then click Workflow Rules.

      If you're shown the Understanding Workflow page, click Continue.

    2. Click New Rule in the resulting page.
    3. On the New Workflow Rule page:
      1. Select Case in the Object field, and click Next.
      2. Enter the following details for the new workflow rule:
        • Enter SurveyMonkeyCase as the rule's name.
        • Optionally, enter a description for the rule.
        • In the Evaluation Criteria section, select the created, and every time it's edited radio button.
        • In the Rule Criteria section, with the criteria are met option selected, select Case: Closed from the Field drop-down list, equals from the Operator field, and enter True in the Value field.
        • Click Save & Next.
      3. On the next page, click the Add Workflow Action button and choose Select Existing Action.
      4. On the Select Existing Actions page:
        • Select Outbound Message in the Search field.
        • In the Available Actions box, select the outbound message you created previously, for example, Outbound Message: SurveyMonkeyCase.
        • Click Add to move your selection to the Selected Actions box.
        • Click Save.
      5. Click Done.
      The new workflow rule is created and displayed on your browser.
    4. Click Activate to activate the rule.

Configure SurveyMonkey

You must perform the following prerequisite tasks in your SurveyMonkey instance.

  1. Create and Configure a SurveyMonkey App
  2. Create a Survey

Create and Configure a SurveyMonkey App

You have to create a SurveyMonkey app and configure it to access SurveyMonkey APIs from Oracle Integration.

  1. Create and configure a SurveyMonkey app.
    1. Log in to the SurveyMonkey Developer console at https://developer.surveymonkey.com/.
    2. Click My Apps on the title bar of the SurveyMonkey Developer home page.
    3. On the My Apps page, click Add a New App.
    4. In the resulting APP CREATION dialog, enter the app's name in the App Nickname field, and select Private App as the App Type option.
    5. Click Create App.
      SurveyMonkey creates an app and displays the client ID and secret details on the resuling page.
    6. Click SETTINGS to open the app's settings, and in the OAuth Redirect URL field, enter the URL of your Oracle Integration instance.
  2. Get the SurveyMonkey API credentials.
    1. Click SETTINGS to open the app's settings.
    2. Scroll down to the Credentials section, and note the values in the Client ID and Secret field.

      Click the eye icon in the Secret field to view the value. You'll need the SurveyMonkey API credentials, that is the client ID and secret values while configuring the SurveyMonkey connection from Oracle Integration.

  3. Select the scopes.
    1. In the Scopes section, select the following scopes:
      • Create/Modify Surveys
      • Create/Modify Collectors
      • Create/Modify Responses
      • View Surveys
      • View Collectors
      • View Responses
      • View Response Details
    2. Click Update Scopes.
      You get a confirmation message that the scopes are successfully updated.

Create a Survey

You have to create a survey in SurveyMonkey for which you want to receive responses.

  1. Log in to your SurveyMonkey account at https://www.surveymonkey.com/user/sign-in/.
  2. On the SurveyMonkey Dashboard, click CREATE SURVEY on the title bar.
  3. Create a survey using one of the following options in the Create a new survey pane on the left:
    • Start from scratch
    • Copy a past survey
    • Buy Targeted Response
    • Import Questions
    • Start from template
    • Build it for me

    Find information related to creating and managing surveys under the Design and Manage topic in the SurveyMonkey Help Center (https://help.surveymonkey.com/).

    Note down the name of the survey that you have created.

  4. Click Next to preview your survey.
  5. Click Next to view the COLLECT RESPONSES section.
  6. Click Send surveys your way.
    The COLLECT RESPONSES section displays the different ways in which you can collect the responses.
  7. Click Share a survey link.
    The COLLECT RESPONSES section displays the details of the web link collector. Note down the name of the collector. For example, Web Link 1.