Before You Install the Recipe

You must perform the following configuration tasks on your ServiceNow instance and Box instance in order to connect to these external systems using Oracle Integration and successfully create folders in Box for ServiceNow incidents.

Configure ServiceNow

To access ServiceNow using Oracle Integration and create corresponding Box folders for ServiceNow incidents, you must perform certain configurations on your ServiceNow instance.

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

  1. Create a custom user (for example, Integration user) and assign a custom role that has access to ServiceNow tables. See Satisfy User and Role Requirements under Prerequisites for Creating a Connection in Using the ServiceNow Adapter with Oracle Integration 3.
  2. Enable web services and assign permissions to required tables.
    1. On the ServiceNow home page, search for tables in the search box in the left pane, and click the Tables link under System Definition in the search results.
    2. Search for each of the following ServiceNow tables using the Search box or locate a table using the show/hide filter.
      • sys_soap_message
      • sys_soap_message_function
      • sys_script
    3. Click the table name in the search results.
    4. Locate and click the Application Access tab.
    5. Select the respective permission (refer to the following table for required permissions), and select the Allow access to this table via web services check box if it is not selected already.
      Table Name Permission
      sys_soap_message Read, Create, Update, Delete
      sys_soap_message_function Read, Create, Update, Delete
      sys_script Read, Create, Update, Delete
  3. Enable multiple insert plugin to support insertMultiple in SOAP.
    1. On the ServiceNow home page, search for System Definition.
    2. Select Plugins.
    3. Locate and click Insert Multiple Web Service.
    4. If the status is inactive, click Activate/Repair.
  4. Get the ServiceNow Caller ID.
    1. On the ServiceNow home page, search for User Administration and then click Users.
    2. On the Users page, select the custom user that you configured earlier in step 1.
    3. Locate the value of the sys_id in the URL that appears when you select the user.
    4. Note the sys_id value as you would need to provide it while configuring lookup table in Oracle Integration.

In addition, you must also create a custom field to store the Id of the Box folder that gets created for new ServiceNow incident. See Create a Custom Field for Box Folder IDs.

Create a Custom Field for Box Folder IDs

This recipe uses unique IDs associated with folders in Box to create Box folders for ServiceNow incidents. Create a custom field for ServiceNow incidents to hold the Box folder IDs.

  1. Log in to your ServiceNow | Developer instance.
  2. On the left navigation pane, enter Incident in the Filter navigator field.
    The Self Service menu displays all modules related to Incident.
  3. In the Self Service menu, click Incidents.
  4. In the Incidents window, click New.
  5. From the available options in the Incident menu, click Configure and then click Table.
  6. Fill in the required fields, such as Name and Label.
  7. Click the Columns tab, and then click New to create a new table column.
  8. In the Type field, search for String, and select String from the search results.
  9. Enter the following details:
    1. In the Column label field, enter the column label. For example, box_Id.
    2. In the Column name field, enter the column name. For example, u_box_id.
    3. In the Max length field, enter a value. For example, 255.
  10. Click Submit.

Configure Box

You must complete the following prerequisite tasks to connect to Box from Oracle Integration, and to create folders for new ServiceNow incidents under the right parent folder in Box.

  1. Create and configure a Box app.
    1. Log in to the Box Developer console at https://developer.box.com.
    2. Create a custom app.
      1. Click Create New App.
      2. In the resulting page to choose the application type, select Custom App.
      3. In the Custom App dialog, select the option User Authentication (OAuth 2.0).
      4. Enter a unique name for your app in the App Name field.

      5. Click Create App.

        The Box app's configuration page appears.

    3. Get the OAuth 2.0 credentials.
      1. In the Box app's configuration page, scroll to the OAuth 2.0 Credentials section.
      2. Copy the client ID from the Client ID field, and the client secret from the Client Secret field.
      3. Note the Client ID and Secret. You'll need these later while configuring the Box connection from Oracle Integration.
    4. Specify the redirect URL.
      1. In the Box app's configuration page, scroll to the OAuth 2.0 Redirect URI section.

      2. In the Redirect URI field, enter the OAuth callback URL of your Oracle Integration instance. Your redirect URI should have the following syntax: 

        https://Oracle-Integration-instance's-FQDN:443/icsapis/agent/oauth/callback

        where, Oracle-Integration-instance's-FQDN is the fully qualified domain name of your Oracle Integration instance, for example, oicinstance.example.com.

    5. Get the Signature Keys.
      1. Click the Webhooks tab on the top of the page.
      2. Click Generate Key to generate the primary and the secondary keys.
      3. Copy the primary and the secondary keys.

      4. Note the values of the primary and secondary keys. You'll need these later while configuring the Box connection from Oracle Integration.

        For more information about signature keys, see Get Your Signature Keys in Using the Box Adapter with Oracle Integration 3.

  2. Create a parent folder in Box.
    You must create a parent folder in Box. All folders for new ServiceNow incidents will be created under this parent folder.
    1. Log in to your Box account at https://account.box.com/login.
    2. Click New on the top right side of the All Files page.
    3. From the menu that displays, click Folder.
    4. In the Create a New Folder dialog, enter a suitable name in the Folder Name field.
    5. Optionally, if you want other people to access the folder, enter their email addresses in the Invite Additional People field. Use a comma between each email address.
      To control other people's level of access, select the appropriate role (co-owner, editor, viewer, and so on) from the drop-down list in the Permission field. Click Learn More next to the field to know about the roles and their capabilities.
    6. Click Create.
      The folder gets created and is displayed on the All Files page.
  3. Get the parent folder ID.
    You have to get the ID of the parent folder in Box, and pass it to the integration properties in Oracle Integration, so that folders for new ServiceNow incidents are created under the right parent folder.
    1. On the All Files page of your Box instance, search and locate the parent folder that you created.
    2. Hover your mouse on the parent folder.
    3. Note the link that appears below on the left side of the page. For example, https://app.box.com/folder/135666632045.
    4. The number after the last forward slash (/) in the link is the folder ID. Note the folder ID. You’ll use this later while updating the integration properties in Oracle Integration.