How to Integrate SharePoint with Drupal

Overview

This document explains how you can easily connect Microsoft SharePoint with your Drupal website to keep content in sync. With the Drupal SharePoint Integration module, administrators can securely sync SharePoint Lists, Views, Files, and Pages into Drupal. This keeps content centralized, ensures consistency across platforms, and makes content management simpler and more efficient.

Configuration Steps

1. Configure Microsoft Entra ID (Azure AD):

• Log into the Azure portal with your Microsoft Entra ID credentials.
• From the Azure services section, click on App registrations.

• Then click on the New Registration.

• Enter the App name and click on the Register button.

• You will receive an Application ID and a Directory (Tenant) ID. Copy both the Application ID and Tenant ID, as you will need to provide them in the module configuration.

• Now, click on the Add a certificate or secret link.

• You will get the certificate from the Custom Certificates module. (Please reach out to drupalsupport@xecurify.com to get the Custom Certificate module.)

• Click on Add Custom Certificate button.

• Then, under Add Certificate, enter the Label, Description, and Public Key of the certificate.
• Click on the Save button.

• Click on the Certificates button and upload the generated certificate. Once done, click on the Add button.

2. API Permission to Microsoft Entra ID Application:

• From the Left panel, go to the API permissions and click on the Add a permission button.
• Select an API → Microsoft APIs → Microsoft Graph.

• Select Application permissions and search for the Sites in the search box.
• Select Sites.Read.All permission.
• Click on the Add permissions button.

• Similarly, you need to add permissions for the REST API. To do this, click on SharePoint under Microsoft APIs.

• Select Application permissions and search for Sites in the search box.
• Select the Sites.Read.All permission.
• Click on the Add permissions button.

• Click on the Grant admin consent for <tenant_name> button, then click Yes from the Grant admin consent confirmation window.

• You can check the granted status as shown in the image below.

3. Configure Drupal SharePoint module:

• Go to Configuration → People → SharePoint Integration in the Administration menu.

• After that, you will be redirected to the Connection tab.
• In the Connection tab enter the following details:
• Paste the Client ID that you copied earlier from Microsoft Entra ID application.
• Client Secret Certificate: This option allows certificate-based authentication instead of client secrets.
• Graph API Scope: Defines the permission scope required to access Microsoft Graph APIs.
• REST API Scope: Specifies the permission scope for SharePoint REST APIs.
• Token Endpoint: The Azure URL used to generate access tokens, usually containing the tenant ID.
• Click on the Save Configuration button.

4. Site Configuration:

• Go to Site Configuration tab of the module.
• You can add multiple sites from this screen. To do so, click on the Add Site button.



• Under the Add, enter the Label and Site URL.
• Enable or disable site visibility for end users.
• Enable automatic synchronization during Drupal cron runs: When enabled, SharePoint data is automatically synchronized with Drupal during scheduled cron runs.
• Click on the Fetch Metadata & save button.



• Site Created Successfully. now click on Sync under the Action.(It will sync the site data)



• You can check site operations by clicking on Edit button.

5. List

• Go to the List tab from the left side.
• You can view the lists available in the selected SharePoint site directory.
• Under the Status column, you can enable or disable a list.

6. File Browser

• Go to the File Browser tab from the left side.
• You can view the files available in the selected SharePoint site directory.
• Under the Status column, you can enable or disable a file.(The SharePoint file will not been shown to end-users if this field is disabled.)
• In Actions there is two options:
• Open: The Open action lets users preview or access files instantly.
• Download: The Download action allows users to save files locally.

7. List & Library Views

• Go to the List & Library Views tab from the left side.
• You can view the all the documents available in the selected SharePoint site directory.

• There are some options below in List & Library Views:
• Copy: The Copy option allows to copy SharePoint View URL.
• Limit: Defines number of rows fetched (Acts as pagination limit). And is configurable in SharePoint only.
• Status: The SharePoint list will not been shown if this field is disabled.
• Edit: Update the visible columns in UI for end-users.
• In Edit option you can select which columns you wish to show in UI. All columns will be visible in case of none selected.



• Update Column: Fetch and update the view columns from the SharePoint site.

8. Import & Export

• Go to the Import & Export tab under the Settings. This feature is divided into two main sections:

• Export Configuration: Admin can export the complete SharePoint integration configuration from the current Drupal instance.
• Click on the Export Configuration button to download the configuration file.
• The exported file can be reused on another Drupal site or kept as a backup.



• Import Configuration: Admin can import previously exported configurations into a new or existing Drupal instance.
• Upload the exported JSON configuration file.
• Click Validate & Upload button.
• Once validated, all saved settings are automatically applied.

9. Log Settings

• Go to the Log Settings tab under the Settings.
• Enable the Enable logs checkbox.
• When enabled, the module starts recording events related to SharePoint integration.
• When disabled, no logs are generated.
• Select Log Severity Levels:
• Admins can choose which severity levels should be logged based on their needs.

Related Articles

• Drupal SharePoint Integration
• Connect Microsoft SharePoint with Drupal