Skip to main content

Microsoft SharePoint Connector

Microsoft SharePoint Manage sites, drives, files, and lists in Microsoft SharePoint.

Connections

Certificate Credentials

Authenticates actions in all Microsoft's Graph API services.

App Registration Requirements

First, create an app registration in Microsoft Entra by following the steps in the OAuth connection guide. Then configure the following Microsoft Graph Application permissions:

Site Operations:

  • Sites.Read.All - Read items in all site collections
  • Sites.ReadWrite.All - Read and write items in all site collections
  • Sites.Manage.All - Create, edit, and delete items and lists in all site collections
  • Sites.FullControl.All - Full control of all site collections

File Operations:

  • Files.Read.All - Read files in all site collections
  • Files.ReadWrite.All - Read and write files in all site collections

List Operations:

  • Sites.ReadWrite.All - Required for list operations
  • Sites.Manage.All - For creating and managing lists

User and Group Access:

  • User.Read.All - Read all users' profiles
  • Group.Read.All - Read all groups

Certificate Requirements

Before configuring certificate credentials, ensure:

  • Certificate issued by a Certificate Authority (CA) for production, or self-signed for development
  • RSA key size: minimum 2048 bits (4096 bits recommended)
  • Certificate in X.509 format
  • Public key formats: .cer, .pem, or .crt
  • Private key in PEM or PKCS#12 format

Registering Certificate with Azure

  1. Ensure app registration is complete with required permissions
  2. Navigate to Certificates & Secrets in the app registration
  3. Select the Certificates tab
  4. Click Upload certificate
  5. Select the public certificate file (.cer, .pem, or .crt)
  6. Add an optional description
  7. Click Add to upload

After upload, note these values:

  • Certificate Thumbprint - SHA-1 hash (e.g., "931E8F84B98A4B5F93AD609FD5E8D0BA1AB90F87")
  • Start Date and Expiration Date
  • Certificate ID - Automatically generated

Connection Configuration

Configure the following fields:

  • Tenant ID: Azure AD Directory ID from app registration
  • Client ID: Application ID from app registration
  • Certificate Thumbprint: SHA-1 thumbprint from uploaded certificate (remove spaces)
  • Private Key: Certificate private key in PEM format
  • Scope: https://graph.microsoft.com/.default for application permissions

Private Key Format

The private key must be in PEM format with appropriate headers:

-----BEGIN PRIVATE KEY-----
[base64 encoded private key]
-----END PRIVATE KEY-----

Or for RSA keys:

-----BEGIN RSA PRIVATE KEY-----
[base64 encoded RSA private key]
-----END RSA PRIVATE KEY-----
InputCommentsDefault
Base URLThe base URL for the Microsoft Graph API. Depending on your cloud environment, you can choose the correct one here.https://graph.microsoft.com
Microsoft Entra ID EndpointThe Microsoft Entra ID endpoint for the Microsoft Graph API. You can find this in the Azure portal or here.https://login.microsoftonline.com
TenantThe tenant ID or name for the Microsoft Graph API. This is the ID or name of the tenant that you are connecting to.
Client IDClient Id of your Azure application.
Private CertificateYour X.509 private certificate.
Certificate ThumbprintThumbprint of the certificate.
ScopesMicrosoft Graph API Scopes.https://graph.microsoft.com/.default

Microsoft SharePoint OAuth 2.0 (Deprecated)

Authenticates actions in the Microsoft SharePoint component.

Creating an App Registration

Once you have an instance of Microsoft SharePoint licensed to your account, you will need to create and configure a new "App Registration" within your Azure Active Directory tenant.

  1. Navigate to Microsoft Entra Identity > Applications > App registrations
  2. Select New registration
  3. Configure the basic settings:
    • Name: Provide a descriptive name for the application
    • Supported account types: Select Accounts in any organizational directory (Any Azure AD directory - Multitenant)
    • Redirect URI: Select Web platform and add https://oauth2.integrations.acme.com/callback
  4. Click Register to create the app registration

Obtaining Application Credentials

After registration, navigate to the Overview page and note:

  • Application (client) ID - This will be the Client ID
  • Directory (tenant) ID - Required for certain connection types

API Permissions Configuration

  1. Navigate to API Permissions
  2. Click Add a permission
  3. Select SharePoint for SharePoint-specific operations
  4. Choose Delegated permissions for user-authenticated flows
  5. Select the following permissions:

Essential Scopes:

  • offline_access - Required for refresh tokens (without this, users re-authenticate every hour)

Site Operations:

  • AllSites.Read - Read items in all site collections
  • AllSites.Write - Edit or delete items in all site collections
  • AllSites.Manage - Create, edit and delete items and lists in all site collections
  • AllSites.FullControl - Full control of all site collections

File Operations:

  • MyFiles.Read - Read user files
  • MyFiles.Write - Read and write user files
  • AllSites.Read - Read files in all sites
  • AllSites.Write - Read and write files in all sites

List Operations:

  • AllSites.Write - Required for list item operations
  • AllSites.Manage - For creating and managing lists

User Profile:

  • User.Read.All - Read all users' profiles
  • User.ReadBasic.All - Read all users' basic profiles
  1. Click Add permissions
  2. Important: Click Grant admin consent to activate the permissions

Creating Client Secret

  1. Navigate to Certificates & Secrets in the app registration
  2. Select the Client secrets tab
  3. Click New client secret
  4. Provide a description and select expiration period
  5. Click Add
  6. Important: Copy the secret Value immediately - it cannot be retrieved later

Connection Configuration

Configure the following fields:

  • Client ID: Application ID from app registration
  • Client Secret: Secret value created above
  • Authorize URL: Default provided, or tenant-specific URL if not using multitenant
  • Token URL: Default provided, or tenant-specific URL if not using multitenant

Tenant-Specific URLs

If the app registration is not configured as multitenant, replace the default URLs with tenant-specific versions:

  • Authorize URL: https://login.microsoftonline.com/{tenant-id}/oauth2/v2.0/authorize
  • Token URL: https://login.microsoftonline.com/{tenant-id}/oauth2/v2.0/token

This connection uses OAuth 2.0, a common authentication mechanism for integrations. Read about how OAuth 2.0 works here.

InputCommentsDefault
Base URLThe base URL for the Microsoft Graph API. Depending on your cloud environment, you can choose the correct one here.https://graph.microsoft.com
Authorize URLProvide a tenant specific OAuth 2.0 authorize endpoint.https://login.microsoftonline.com/common/oauth2/v2.0/authorize
Token URLProvide a tenant specific OAuth 2.0 token endpoint.https://login.microsoftonline.com/common/oauth2/v2.0/token
ScopesSpace separated OAuth 2.0 permission scopes.Sites.ReadWrite.All Sites.Manage.All offline_access
Client IDClient Id of your Azure application.
Client SecretClient Secret generated under 'Certificates & Secrets' in your Azure application.

OAuth 2.0 Authorization Code

Authenticates actions in all Microsoft's Graph API services.

The templated OAuth flow enables user authentication with SharePoint to access data on their behalf.

App Registration

First, create an app registration in Microsoft Entra by following the steps in the OAuth connection guide.

Permissions

Configure SharePoint Delegated permissions in the app registration:

  • Select all permissions required for the integration
  • Grant admin consent for the organization
  • Include offline_access scope for refresh token support

Creating Client Secret

  1. Navigate to Certificates & Secrets in the app registration
  2. Click New client secret
  3. Provide a description and select expiration period
  4. Click Add
  5. Copy the secret Value (not the Secret ID)

Connection Configuration

Configure the following fields:

  • Client ID: Application ID from app registration
  • Client Secret: Secret value created above

For non-multitenant applications, replace the default URLs:

  • Authorize URL: https://login.microsoftonline.com/{tenant-id}/oauth2/v2.0/authorize
  • Token URL: https://login.microsoftonline.com/{tenant-id}/oauth2/v2.0/token

This connection uses OAuth 2.0, a common authentication mechanism for integrations. Read about how OAuth 2.0 works here.

InputCommentsDefault
Base URLThe base URL for the Microsoft Graph API. Depending on your cloud environment, you can choose the correct one here.https://graph.microsoft.com
Tenant URLThe tenant URL for the Microsoft Graph API. This is the URL of the tenant that you are connecting to. You can find this in the Azure portal or here.login.microsoftonline.com/common
ScopesMicrosoft Graph API permission scopes are set on the OAuth application.Sites.ReadWrite.All Sites.Manage.All offline_access
Client IDClient Id of your Azure application.
Client secret valueClient Secret generated under 'Certificates & Secrets' in your Azure application.
Additional Authorization ParametersQuery string parameters to append to the OAuth authorization URL. Common parameters include prompt=consent to force the consent screen or login_hint=user@example.com to pre-fill the login email.

OAuth 2.0 Client Credentials

Authenticates actions in all Microsoft's Graph API services.

App Registration

First, create an app registration in Microsoft Entra by following the steps in the OAuth connection guide. Then configure the following Microsoft Graph Application permissions for app only authentication:

Site Operations:

  • Sites.Read.All - Read items in all site collections
  • Sites.ReadWrite.All - Read and write items in all site collections
  • Sites.Manage.All - Create, edit, and delete items and lists in all site collections
  • Sites.FullControl.All - Full control of all site collections

File Operations:

  • Files.Read.All - Read files in all site collections
  • Files.ReadWrite.All - Read and write files in all site collections

List Operations:

  • Sites.ReadWrite.All - Required for list operations
  • Sites.Manage.All - For creating and managing lists

User and Group Access:

  • User.Read.All - Read all users' profiles
  • Group.Read.All - Read all groups

Important: Grant admin consent for all configured permissions.

Creating Client Secret

  1. Navigate to Certificates & Secrets in the app registration
  2. Select the Client secrets tab
  3. Click New client secret
  4. Provide a description and select expiration period
  5. Click Add
  6. Important: Copy the secret Value immediately - it cannot be retrieved later

Connection Configuration

Configure the following fields:

  • Tenant ID: Azure AD Directory ID from app registration
  • Client ID: Application ID from app registration
  • Client Secret: Secret value created above
  • Scope: https://graph.microsoft.com/.default for application permissions

This connection uses OAuth 2.0, a common authentication mechanism for integrations. Read about how OAuth 2.0 works here.

InputCommentsDefault
Base URLThe base URL for the Microsoft Graph API. Depending on your cloud environment, you can choose the correct one here.https://graph.microsoft.com
Microsoft Entra ID EndpointThe Microsoft Entra ID endpoint for the Microsoft Graph API. You can find this in the Azure portal or here.https://login.microsoftonline.com
TenantThe tenant ID or name for the Microsoft Graph API. This is the ID or name of the tenant that you are connecting to.
Client IDClient Id of your Azure application.
Client SecretClient Secret generated under 'Certificates & Secrets' in your Azure application.
ScopesMicrosoft Graph API Scopes.https://graph.microsoft.com/.default

Triggers

Drive Subscription

Receive webhook notifications from SharePoint drives. Automatically creates and manages a webhook subscription when the instance is deployed, and removes the subscription when the instance is deleted.

InputCommentsDefault
ConnectionThe Microsoft SharePoint connection to use.
ResourceThe Microsoft Graph resource path to monitor. Examples: /me/drive/root, /sites/{site-id}/drive/root, /drives/{drive-id}/root
Change TypeThe type of changes that should generate notifications. Common values: updated, created, deleted.updated
Client StateOptional validation token sent with each notification. Use to verify notifications originate from Microsoft Graph.
Expiration Date TimeOptional expiration date/time for the subscription. If not provided, defaults to 3 days from now. Maximum is 30 days for SharePoint/OneDrive resources.

New and Updated Drive Items

Checks for new and updated items in a specified SharePoint drive on a configured schedule.

InputCommentsDefault
ConnectionThe Microsoft SharePoint connection to use.
DriveThe unique identifier of a SharePoint drive.

New and Updated Folder Items

Checks for new and updated items in a specified folder within a SharePoint drive on a configured schedule.

InputCommentsDefault
ConnectionThe Microsoft SharePoint connection to use.
DriveThe unique identifier of a SharePoint drive.
Folder IDThe ID of the folder to monitor for changes.

New and Updated Site Items

Checks for new and updated items across all drives in a SharePoint site on a configured schedule.

InputCommentsDefault
ConnectionThe Microsoft SharePoint connection to use.
Site IdThe unique identifier of a SharePoint site.

Webhook

Receive and validate webhook requests from SharePoint for manually configured webhook subscriptions.

Actions

Check Item Exists

Check if a file or folder exists in a SharePoint drive

InputCommentsDefault
ConnectionThe Microsoft SharePoint connection to use.
Site IdProvide the id of the site to check the item in.
DriveProvide the id of the drive to check the item in.
Item PathProvide the path to the file or folder, relative to the drive root.

Create a Folder

Create a Folder in a Drive

InputCommentsDefault
ConnectionThe Microsoft SharePoint connection to use.
Site IdProvide the id of the site to create the folder in.
DriveProvide the id of the drive to create the folder in.
Parent Item IdProvide the id of the parent element to create the folder in.
Folder NameProvide the name of the new folder.

Create a Subscription

Create a Subscription to notify you of changes to a resource

InputCommentsDefault
ConnectionThe Microsoft SharePoint connection to use.
Change TypeThe type of changes that should generate notifications. Common values: updated, created, deleted.updated
Notification URLThe URL where Microsoft Graph will deliver webhook notifications when changes occur.
ResourceThe Microsoft Graph resource path to monitor for changes.
Expiration Date TimeThe date and time when the subscription will expire if not updated or renewed.
Client StateAn optional validation token included in each notification to verify the notification source.
Allow DuplicatesWhen true, allows creating multiple subscriptions for the same endpoint.false

Create Item in Site List

Create a new item inside the given site list

InputCommentsDefault
ConnectionThe Microsoft SharePoint connection to use.
Site IdThe unique identifier of a SharePoint site.
List IdThe unique identifier of a SharePoint site list.
FieldsKey-value pairs to set as properties on the drive item. Each key represents a field name and its corresponding value.

Create Site List Subscription

Create a Site List subscription for Microsoft SharePoint

InputCommentsDefault
ConnectionThe Microsoft SharePoint connection to use.
Site IdThe unique identifier of a SharePoint site.
List IdThe unique identifier of a SharePoint site list.
Notification URLURL to send events of this Subscription to
Expiration Date/TimeExpiration date/time for subscription. If unspecified the default will be the current date/time plus 29 days (close to the maximum permitted by the Graph API).
Allow DuplicatesEnable to allow more than one webhook per endpointfalse

Delete All Instance Subscriptions

Delete all SharePoint subscriptions pointed at this instance

InputCommentsDefault
ConnectionThe Microsoft SharePoint connection to use.
Notification URLThe notification URL used when creating subscriptions for this instance. Only subscriptions with this URL will be deleted. If not provided, all subscriptions for this flow will be deleted.

Delete a Subscription

Delete a Subscription by ID

InputCommentsDefault
ConnectionThe Microsoft SharePoint connection to use.
Subscription IdThe unique identifier of the subscription to manage.

Download File

Download a file from the specified drive

InputCommentsDefault
ConnectionThe Microsoft SharePoint connection to use.
DriveThe unique identifier of a SharePoint drive.
Item IdThe unique identifier of a SharePoint item.

Get Current User

Get the information and metadata of the user that is currently logged in

InputCommentsDefault
ConnectionThe Microsoft SharePoint connection to use.

Get Drive

Returns the information and metadata of a SharePoint drive

InputCommentsDefault
ConnectionThe Microsoft SharePoint connection to use.
DriveThe unique identifier of a SharePoint drive.

Get File

Get a file from a Drive

InputCommentsDefault
ConnectionThe Microsoft SharePoint connection to use.
DriveThe unique identifier of a SharePoint drive.
Item IdThe unique identifier of a SharePoint item.

Get Item from Site List

Returns the information and metadata of the given item

InputCommentsDefault
ConnectionThe Microsoft SharePoint connection to use.
Site IdThe unique identifier of a SharePoint site.
List IdThe unique identifier of a SharePoint site list.
Item IdThe unique identifier of a SharePoint item.
Opt In FieldsComma-separated list of fields to return. Overrides the default result set.

Get Root Site

Returns the information and metadata of the root SharePoint site in your tenant

InputCommentsDefault
ConnectionThe Microsoft SharePoint connection to use.

Get Site

Returns the information and metadata of the given SharePoint site

InputCommentsDefault
ConnectionThe Microsoft SharePoint connection to use.
Site IdThe unique identifier of a SharePoint site.

Get Site List

Returns the information and metadata of an existing site list

InputCommentsDefault
ConnectionThe Microsoft SharePoint connection to use.
Site IdThe unique identifier of a SharePoint site.
List IdThe unique identifier of a SharePoint site list.

List Changes

Track changes in a driveItem and its children over time.

InputCommentsDefault
ConnectionThe Microsoft SharePoint connection to use.
URL to fetch for deltaThe URL to track changes in a driveItem and its children over time. You can also paste the @odata.nextLink or @odata.deltaLink from a previous response to resume tracking changes./drives/{drive-id}/root/delta
$select ParameterFilters properties (columns). https://learn.microsoft.com/en-us/graph/query-parameters?tabs=http#select-parameter
$expand ParameterRetrieves related resources. https://learn.microsoft.com/en-us/graph/query-parameters?tabs=http#expand-parameter
$top ParameterSets the page size of results. https://learn.microsoft.com/en-us/graph/query-parameters?tabs=http#top-parameter
Fetch AllWhen true, retrieves all results by automatically following pagination.false

List Drives

List all drives within any given SharePoint site

InputCommentsDefault
ConnectionThe Microsoft SharePoint connection to use.
Site IdThe unique identifier of a SharePoint site.
Page LimitThe maximum number of results to return per page.
Page TokenThe token for the desired page from a previous response.
Fetch AllWhen true, retrieves all results by automatically following pagination.false

List Files in Drive

List all the files from a Drive

InputCommentsDefault
ConnectionThe Microsoft SharePoint connection to use.
DriveThe unique identifier of a SharePoint drive.
Page LimitThe maximum number of results to return per page.
Page TokenThe token for the desired page from a previous response.
Fetch AllWhen true, retrieves all results by automatically following pagination.false
RecursiveWhen true, returns files from all subfolders in addition to the specified folder.false

List Files in Drive (Deprecated)

List all the files from a Drive. This version of the action is being deprecated. Please replace action with List Files In Drive.

InputCommentsDefault
ConnectionThe Microsoft SharePoint connection to use.
DriveThe unique identifier of a SharePoint drive.

List Folder Files in Drive

List all the files inside of a folder from a Drive

InputCommentsDefault
ConnectionThe Microsoft SharePoint connection to use.
DriveThe unique identifier of a SharePoint drive.
Folder IDThe unique identifier of a SharePoint folder. Leave empty to use root folder.
Page LimitThe maximum number of results to return per page.
Page TokenThe token for the desired page from a previous response.
Fetch AllWhen true, retrieves all results by automatically following pagination.false

List Folder Files in Drive (Deprecated)

List all the files inside of a folder from a Drive. This version of the action is being deprecated. Please replace action with List Folder Files In Drive.

InputCommentsDefault
ConnectionThe Microsoft SharePoint connection to use.
DriveThe unique identifier of a SharePoint drive.
Folder IDThe unique identifier of a SharePoint folder. Leave empty to use root folder.

List Followed Sites

List all Followed Sites

InputCommentsDefault
ConnectionThe Microsoft SharePoint connection to use.
Page LimitThe maximum number of results to return per page.
Page TokenThe token for the desired page from a previous response.
Fetch AllWhen true, retrieves all results by automatically following pagination.false

List Items

List Items in a Folder

InputCommentsDefault
ConnectionThe Microsoft SharePoint connection to use.
DriveProvide the id of the drive to list the items in.
Folder IDProvide the id of the folder to list the items in.

List Items in Site List

Return all items inside the given site list

InputCommentsDefault
ConnectionThe Microsoft SharePoint connection to use.
Site IdThe unique identifier of a SharePoint site.
List IdThe unique identifier of a SharePoint site list.
Page LimitThe maximum number of results to return per page.
Page TokenThe token for the desired page from a previous response.
Opt In FieldsComma-separated list of fields to return. Overrides the default result set.

List Shared Documents

Lists documents shared with the user.

InputCommentsDefault
ConnectionThe Microsoft SharePoint connection to use.

List Site Lists

List all Site Lists

InputCommentsDefault
ConnectionThe Microsoft SharePoint connection to use.
Site IdThe unique identifier of a SharePoint site.
Fetch AllWhen true, retrieves all results by automatically following pagination.false

List Sites

List all SharePoint sites

InputCommentsDefault
ConnectionThe Microsoft SharePoint connection to use.
Page LimitThe maximum number of results to return per page.
Page TokenThe token for the desired page from a previous response.
Fetch AllWhen true, retrieves all results by automatically following pagination.false

List Subscriptions

List all available Subscriptions

InputCommentsDefault
ConnectionThe Microsoft SharePoint connection to use.
Show Instance SubscriptionsWhen true, filters results to show only subscriptions created by this instance.true

Move a File

Move a File in a Drive

InputCommentsDefault
ConnectionThe Microsoft SharePoint connection to use.
DriveProvide the id of the drive to move the file in.
Item IdProvide the id of the file to move.
Destination Parent IdProvide the Id of the destination parent element to move file to.

Raw Request

Send raw HTTP request to Microsoft Sharepoint

InputCommentsDefault
ConnectionThe Microsoft SharePoint connection to use.
URLInput the path only (/me/followedSites), The base URL is already included (https://graph.microsoft.com/v1.0). For example, to connect to https://graph.microsoft.com/v1.0/me/followedSites, only /me/followedSites is entered in this field.
MethodThe HTTP method to use.
DataThe HTTP body payload to send to the URL.
Form DataThe Form Data to be sent as a multipart form upload.
File DataFile Data to be sent as a multipart form upload.
File Data File NamesFile names to apply to the file data inputs. Keys must match the file data keys above.
Query ParameterA list of query parameters to send with the request. This is the portion at the end of the URL similar to ?key1=value1&key2=value2.
HeaderA list of headers to send with the request.
Response TypeThe type of data you expect in the response. You can request json, text, or binary data.json
TimeoutThe maximum time that a client will await a response to its request
Retry Delay (ms)The delay in milliseconds between retries. This is used when 'Use Exponential Backoff' is disabled.0
Retry On All ErrorsIf true, retries on all erroneous responses regardless of type. This is helpful when retrying after HTTP 429 or other 3xx or 4xx errors. Otherwise, only retries on HTTP 5xx and network errors.false
Max Retry CountThe maximum number of retries to attempt. Specify 0 for no retries.0
Use Exponential BackoffSpecifies whether to use a pre-defined exponential backoff strategy for retries. When enabled, 'Retry Delay (ms)' is ignored.false

Rename a Folder

Rename a Folder in a Drive

InputCommentsDefault
ConnectionThe Microsoft SharePoint connection to use.
Site IdProvide the id of the site to rename the folder in.
DriveProvide the id of the drive to rename the folder in.
Folder IDProvide the id of the folder to rename.
Folder NameProvide the new name of the folder.

Renew Subscription

Extend the expiration date of an existing SharePoint subscription

InputCommentsDefault
ConnectionThe Microsoft SharePoint connection to use.
Subscription IdThe unique identifier of the subscription to manage.
Expiration DaysNumber of days to extend the subscription. Maximum is 30 days for SharePoint/OneDrive resources.3

Search Items

Search for items across all drives in a SharePoint site

InputCommentsDefault
ConnectionThe Microsoft SharePoint connection to use.
Site IdProvide the id of the site to search the items in.
QueryProvide the query to search for items by name.

Update File

Update a file to the specified drive

InputCommentsDefault
ConnectionThe Microsoft SharePoint connection to use.
DriveThe unique identifier of a SharePoint drive.
Item IdThe unique identifier of a SharePoint item.
File DataThe file content to upload to SharePoint. Reference a file from a previous step or provide file data.

Update Site List Subscription Expiration

Update existing Site List subscription expiration for Microsoft SharePoint

InputCommentsDefault
ConnectionThe Microsoft SharePoint connection to use.
Subscription IDSubscription ID to manage
Expiration Date/TimeExpiration date/time for subscription. If unspecified the default will be the current date/time plus 29 days (close to the maximum permitted by the Graph API).

Upload File

Upload a file to the specified drive or folder's drive

InputCommentsDefault
ConnectionThe Microsoft SharePoint connection to use.
DriveThe unique identifier of a SharePoint drive.
File NameThe name of the file including extension.
File DataThe file content to upload to SharePoint. Reference a file from a previous step or provide file data.
Folder IDThe unique identifier of a SharePoint folder. Leave empty to use root folder.