Install and Configure the Recipe

On your Oracle Integration instance, install the recipe to deploy and configure the integration and associated resources.

Install the recipe on your Oracle Integration instance. See Install a Recipe or Accelerator.

After you've installed the recipe, configure the following resources.

Configure the SharePoint REST Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the Connection URL. For example: https://<sharepoint_domain>.sharepoint.comm.
  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Select OAuth Custom Two Legged Flow.
    Access Token Request

    -X POST -H "Content-Type: application/x-www-form-urlencoded" -d 'grant_type=client_credentials&client_id=<client_id>@<tenant_id>&client_secret=<client_secret>&resource=<resource_id>/<sharepoint_domain>.sharepoint.com@<tenant_id>' https://accounts.accesscontrol.windows.net/<tenant_id>/tokens/OAuth/2

    Replace client_id, client_secret, tenant_id and resource_id in the above with respective values for the same that you obtained while configuring SharePoint. See Configure SharePoint.

  4. Click Save. If prompted, click Save again.
  5. Click Test to ensure that your connection is successfully configured. In the resulting dialog, click Test again.

    A message confirms if your test is successful.

  6. To return to the project workspace, click Go back Back icon.

Configure the Lookup Table

Edit the lookup table Utility_Lookup and set up appropriate values for the lookup keys as per your requirement.

  1. In the Lookups section, click the lookup name.
  2. Enter appropriate values for the lookup keys.
    Key Value
    SP_Site_Name Specify the SharePoint site name.
    SP_Folder_Name Specify the SharePoint folder name under which objects are to be uploaded.
    OCI_Object_Storage_Bucket_Name Specify the OCI Object Storage bucket name from which objects are to be imported to SharePoint.
  3. Click Save. If prompted, click Save again.
  4. To return to the project workspace, click Go back Back icon.