1. Copy Objects from OCI Object Storage to Microsoft SharePoint
  2. Install and Configure the Recipe

3 Install and Configure the Recipe

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

  1. On the Oracle Integration Home page, in the Get started section, click Browse store.
  2. Find the recipe you want to install, then click Get.

    A message confirms that the recipe was successfully installed, and the recipe card shows In use.

  3. Click Configure Configure icon on the recipe to configure its resources.

    The project workspace opens, displaying all the resources of the recipe. Configure the following resources before you activate and run the recipe.

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.