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.
- In Microsoft Entra ID, register an application.
- Copy the Application (client) ID and Directory (tenant) ID.
- Under Certificates & secrets, create a client secret and copy its Value.
- Add the required Microsoft Graph Application permissions.
- 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
- In AI Agent Studio, go to Credentials > Connectors, select Add Connector, and choose Microsoft SharePoint.
- 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
- In AI Agent Studio, go to Resources → Tools.
- Select Add Tool.
- Choose Connector as the tool type.
- Select the saved Microsoft SharePoint connector instance.
- Wait for the available functions to be listed.
- 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.