Microsoft SharePoint

Microsoft SharePoint connects Oracle Fusion AI Agent Studio agents and workflows to SharePoint through Microsoft Graph. It can find permitted SharePoint sites, browse document libraries and folders, search for files, retrieve file content and metadata, work with SharePoint lists and pages, and perform limited write operations.

If you need a connector configured for one specific site with File Store browsing, delegated-user access, and security propagation, use Microsoft SharePoint Site.

Supported Operations

Capability What you can do
Find sites Retrieve the root site, find permitted sites, and list subsites.
Browse files List document libraries, root items, and folder contents, or search within a document library.
Retrieve content Retrieve item metadata and download permitted file content.
Work with lists and pages List SharePoint lists, list items, and site pages, and retrieve existing page content.
Upload or update files Upload a file to a selected document library. Uploading to an existing destination path replaces that file.
Create a basic page Create a page with a name, title, and optional layout. Arbitrary page-body content is not supported by the current operation.

Microsoft Graph documents the SharePoint content model, site resources, site search, site pages, and Microsoft Graph permissions.

Authentication and Prerequisites

Microsoft SharePoint uses OAuth 2.0 Client Credentials authentication.

  1. In Microsoft Entra ID, register an application.
  2. Copy the Application (client) ID and Directory (tenant) ID.
  3. Under Certificates & secrets, create a client secret and copy its Value.
  4. Add the required Microsoft Graph Application permissions.
  5. Select Grant admin consent for the configured permissions.
Permission Use
Sites.Read.All Read SharePoint sites, files, lists, and pages.
Sites.ReadWrite.All Upload or replace files and create pages.

Configure and use in AI Agent Studio

  1. In AI Agent Studio, go to Credentials > Connectors, select Add Connector, and choose Microsoft SharePoint.
  2. Enter the following values:
Setting Value
Graph Base URL https://graph.microsoft.com/v1.0
Authentication type Client Credentials
Tenant ID Directory tenant ID from Microsoft Entra
Client ID Application client ID from Microsoft Entra
Client Secret Client-secret value
Proxy Optional; configure only when required

A SharePoint host or site path is not required during connector configuration. The required site, drive, list, folder, or item identifiers are supplied when the connector operations run.

Add the Connector as a Tool

  1. In AI Agent Studio, go to Resources → Tools.
  2. Select Add Tool.
  3. Choose Connector as the tool type.
  4. Select the saved Microsoft SharePoint connector instance.
  5. Wait for the available functions to be listed.
  6. Select only the functions required by the agent or workflow.

Validate the Connection

Start with these read-only functions:

  • get_root_site
  • sharepoint_list_site_drives
  • sharepoint_list_root_items

Use the site ID returned by the first operation and the drive ID returned by the second operation.

If validation fails, verify the tenant ID, client ID, client-secret value, Microsoft Graph permissions, and administrator consent.

Safe Write Operations

Start with read operations and add only the functions required by the business workflow.

Before uploading or replacing a file or creating a page, show the proposed destination and content and obtain approval. After the operation completes, confirm the returned item or page identifier and URL.

Available writes are limited to uploading a file, replacing a file at an existing destination path, and creating a basic page using its name, title, and layout.

Configure with the AI Studio Skill

If you use Codex or Claude Code, ask it to use the installed aistudio skill to configure the Microsoft SharePoint connector.

Use a prompt such as:

Use the installed aistudio skill to configure a Microsoft SharePoint connector instance in this AI Studio project.

Reuse the existing Microsoft SharePoint connector definition. Guide me through the staged configuration, including family, product, prefix, user groups, and all required and optional connector settings. Use every valid default value returned by the connector definition instead of asking me to enter it again. For optional settings with defaults, accept the default and mark the setting as reviewed. Ask only for values that have no default or choices that require my decision, and do not display secrets after I provide them.

Create the connector instance as a local draft first. Show me the draft path and a redacted configuration summary that identifies the defaults used, and do not save it to AI Agent Studio until I explicitly approve the save.

After the connector instance is saved, verify the connection with a safe operation before selecting its functions for an agent or workflow. Keep only the capabilities required for the intended Fusion use case.

Sample Use Cases

  • Speed up business approvals: Find the latest policy, contract, implementation document, or supporting evidence in SharePoint and provide the relevant details with a link to the source.
  • Prepare audit and compliance evidence: Search approved SharePoint locations, retrieve the required documents, and prepare a source-linked evidence summary for auditors or compliance teams.
  • Track project risks and actions: Retrieve items from a SharePoint project or risk list and summarize open risks, owners, and actions for project managers.
  • Publish approved deliverables: After approval, upload reports, implementation checklists, or project documents to the designated SharePoint document library. Uploading to the same destination path replaces the existing file.

Works Well With

Microsoft SharePoint can serve as the trusted content source and publishing destination for enterprise workflows in AI Agent Studio. The following examples show how SharePoint content can support business processes across other applications. Available actions depend on the configured connector permissions and approval controls.

  • Microsoft SharePoint + Jira

    Turn governed business evidence into actionable work.

    Retrieve relevant policies, implementation documents, or project evidence from SharePoint, check Jira for related or duplicate issues, and, with approval, create a new Jira issue or update an existing one while retaining links to the SharePoint source.

  • Microsoft SharePoint + Microsoft OneDrive

    Move approved working documents into a controlled team repository.

    Retrieve an approved file from OneDrive, review its destination and classification, and—with approval—publish it to the appropriate SharePoint document library for broader team access and controlled collaboration.

  • Microsoft SharePoint + Gmail

    Notify stakeholders without distributing uncontrolled document copies.

    Retrieve the relevant SharePoint document or page link, prepare a concise notification containing the approved business context, and, with approval, send it through Gmail so recipients can access the governed SharePoint source.