# SharePoint

SharePoint (opens new window) is a web-based collaboration, document management and storage system integrated with Microsoft Office. It is primarily used for document management and storage but is highly configurable and usage varies substantially among organizations.

Workato's SharePoint connector enables you to build integrations and automations around SharePoint and other third-party applications.

# API version

The SharePoint connector uses the SharePoint REST API v1 (opens new window).

# How to connect to SharePoint

To connect SharePoint to Workato, you must have an Azure account. Workato supports the following authentication methods:

# Authorization code grant connection

This method requires the following fields:

  • Subdomain
  • Client ID (optional)
  • Client Secret (optional)

# Register the Workato app in the Azure Portal

Complete the following steps to register the Workato app and generate a client ID and secret for authorization code grant connections.

1
Register the Workato app in the Azure Portal
2

Select App registrations > + New registration, under Azure services.

Add an app registration

3

Enter a unique name for the application and select a Supported account type.

4

Select Web from the Select a platform drop-down menu.

5

Enter https://www.workato.com/oauth/callback as the Redirect URI and select Register.

Register appRegister an app

2
Assign permissions to your app
1

Go to Manage > API permissions in the navigation sidebar.

2

Click + Add a permission and select Microsoft Graph APIs.

Add permissionsAdd permissions

3

Add the required permissions listed in the Permissions required to connect section. Assign Application or Delegated permissions based on your connection type.

Add permissionsAdd permissions

4

Click Add permissions.

Admin consent is required for specific permissions. Refer to the Granting admin consent section to learn more.

3
Obtain the Directory (tenant ID) from the Azure Portal
1

Go to the Overview > Essentials section.

App detailsApp details

2

Copy the Directory (tenant) ID for use in Workato.

After you complete these steps, configure the SharePoint connection in Workato using the API permissions you set up in the Azure portal.

# Complete setup in Workato

1

Sign in to Workato.

2

Select the project where you plan to store the connection.

3

Click Create > Connection.

4

Search for and select SharePoint as your connection on the New connection page.

5

Provide a name for your connection in the Connection name field.

Connect to SharePointConnect to SharePoint

6

Use the Location drop-down menu to select the project where you plan to store the connection.

7

Select the Authorization code grant option from the Authentication type drop-down menu.

8

Enter your SharePoint Subdomain. You can find it in your SharePoint URL. For example, if your SharePoint URL is https://abc.sharepoint.com, the subdomain is abc.

9

Provide the Client ID generated in SharePoint.

10

Provide the Client secret generated in SharePoint.

11

Provide the name of your SharePoint site in the Site name field. Enter the name as it appears in the site URL. For example, if the URL is https://company-name.sharepoint.com/sites/product, the site name is product. If left blank, Workato connects to your default home site.

12

Click Sign in with Microsoft.

# Client credentials grant connection

This method requires the following values:

  • Subdomain
  • Tenant ID
  • Client ID
  • Certificate
  • Private Key

# Register the Workato app in the Azure Portal

Complete the following steps to register the Workato app and obtain a client ID, secret, and private key for client credentials grant connections.

1
Register the Workato app in the Azure Portal
2

Select App registrations > + New registration, under Azure services.

Add an app registration

3

Enter a unique name for the application and select a Supported account type.

4

Select Web from the Select a platform drop-down menu.

5

Enter https://www.workato.com/oauth/callback as the Redirect URI and select Register.

Register appRegister an app

2
Assign permissions to your app
1

Go to Manage > API permissions in the navigation sidebar.

2

Click + Add a permission and select Microsoft Graph APIs.

Add permissionsAdd permissions

3

Add the required permissions listed in the Permissions required to connect section. Assign Application or Delegated permissions based on your connection type.

Add permissionsAdd permissions

4

Click Add permissions.

Admin consent is required for specific permissions. Refer to the Granting admin consent section to learn more.

3
Generate an API key
1

Go to Manage > Certificates & Secrets > Client secrets and click + New client secret.

2

Provide a Description for the client secret and specify an expiry date.

3

Click Add. Copy and save this secret for use in Workato.

4
Obtain the Application (client) ID, Object ID, and Directory (tenant) ID from the Azure Portal
1

Go to the Overview > Essentials section.

App detailsApp details

2

Copy the Application (client) ID, Object ID, and Directory (tenant) ID for use in Workato.

5
Obtain the User ID from the Azure Portal
1

Go to Home > Users to obtain the User ID.

UsersSelect users

2

Search for and select the default user you plan to use to perform operations. This user does not establish the connection but is required for performing certain operations that an app can't perform. It is also required in picklists to pull user data. For example the folder picklist populates folders belonging to the default user.

3

Copy the User principal name. Use this value as the User ID in Workato.

Return to Workato to finish setting up your connection.

# Complete setup in Workato

Complete the following steps to create a SharePoint connection in Workato after you configure your app in the Azure Portal:

1

Sign in to Workato.

2

Select the project where you plan to store the connection.

3

Click Create > Connection.

4

Search for and select SharePoint as your connection on the New connection page.

5

Provide a name for your connection in the Connection name field.

Connect to SharePointConnect to SharePoint

6

Use the Location drop-down menu to select the project where you plan to store the connection.

7

Select the Client credentials option from the Authentication type drop-down menu.

8

Enter your SharePoint Subdomain. You can find it in your SharePoint URL. For example, if your SharePoint URL is https://abc.sharepoint.com, the subdomain is abc.

9

Provide the Tenant ID generated in SharePoint.

10

Provide the Client ID generated in SharePoint.

11

Provide the Certificate generated in SharePoint.

12

Provide the Private key string generated in SharePoint.

13

Provide the name of your SharePoint site in the Site name field. Enter the name as it appears in the site URL. For example, if the URL is https://company-name.sharepoint.com/sites/product, the site name is product. If left blank, Workato connects to your default home site.

14

Click Sign in with Microsoft.

# Permissions required to connect

You must assign the correct Microsoft Graph API permissions to the Workato app in the Azure Portal before you can create a connection. The required scopes vary by authentication type.

# Minimum scopes for authorization code grant connections

The following minimum scope is required to establish a connection to SharePoint using authorization code grant authentication:

  • AllSites.Read

We recommend the following scope for authorization code grant connections. This scope is necessary to use all of this connector's triggers and actions. Additionally, you must assign this permission to the Workato app as a Delegated permission in the Azure Portal:

  • Files.ReadWrite.All

# Minimum scopes for client credentials grant connections

The following minimum scope is required to establish a connection to SharePoint using client credentials grant authentication:

  • Sites.Read.All

We recommend the following scope for client credentials connections. This scope is necessary to use all of this connector's triggers and actions. Additionally, you must assign this permission to the Workato app as a Application permission in the Azure Portal:

  • Sites.ReadWrite.All

To connect to the SharePoint connector using a Microsoft Entra ID account, ensure that all the consent requests are granted by admins.

Complete the following steps to grant admin consent using an admin account:

1

Sign in to your Azure portal and navigate to Enterprise Applications > Activity > Admin consent requests.

2

Approve the necessary consent requests.


Last updated: 5/13/2025, 5:19:49 PM