Before You Install the Recipe

To successfully connect to OCI Object Storage and SharePoint using Oracle Integration and copy OCI Object Storage objects into SharePoint, you must perform certain configuration tasks on your OCI Object Storage and SharePoint instances.

Configure OCI Object Storage

To successfully connect to OCI Object Storage using a native action, create a dynamic group and required policy.

See Prerequisites in Invoke Oracle Cloud Infrastructure Object Storage from an Integration with an OCI Object Storage Action.

Additionally, create an OCI Object Storage bucket and upload objects into it. See Creating an Object Storage Bucket and Uploading an Object Storage Object to a Bucket.

Configure SharePoint

To successfully connect to SharePoint and upload OCI Object Storage objects, you must perform certain configurations on SharePoint.

  1. Register the SharePoint add-in and get the client Id and secret.
    1. Go to: https://<sharepoint domain>.sharePoint.com/sites/<sharepoint Site Name>/_layouts/15/appregnew.aspx by using a web browser.
    2. In the AppRegNew page, enter the following details:
      Field Information to Enter
      Title Enter a title of your choice. For example: OICAPP
      App Domain Enter the local hostname.
      Redirect URL Enter the endpoint URL. For example, https:://localhost.com
    3. Click Create.
      You get the client Id and client secret in the resulting window. Note down the client Id and secret. You'll need these while creating a connection to SharePoint from Oracle Integration.
    4. Provide permission to the add-in that you created.
      1. Go to: https://<sharepoint_domain>.sharepoint.com/sites/<sharepointSiteName>/_layouts/15/appinv.aspx
      2. Enter the client Id in the App Id field and click the Lookup button. The Title, App Domain, and Redirect URL fields will be populated automatically.
      3. Enter the following in the App’s permission Request XML text area.
        <AppPermissionRequests AllowAppOnlyPolicy="true">
    <AppPermissionRequest Scope="http://sharepoint/content/sitecollection/web" Right="FullControl" />
</AppPermissionRequests>
      4. Click Create.
      5. In the resulting window, click Trust It.
  2. Get the SharePoint tenant Id.
    1. Go to: https://<sharepoint_domain>.sharepoint.com/_layouts/15/appprincipals.aspx.
    2. In the Site Settings>Site Collection App Permissions page, copy the alphanumeric string after @ in the App Identifier value.
      This is the SharePoint tenant Id.
  3. Get the SharePoint resource Id.
    1. Enter the following POST endpoint in Postman.
      https://<sharepoint_domain>.sharePoint.com/_vti_bin/client.svc/
    2. Add the Bearer type Authorization header without entering any bearer token and click Send.
    3. In Postman, go to the WWW-Authenticate response header and copy the value of the client id.
      This is the SharePoint resource Id.