SharePoint


Connector Details

Connector AttributesDetails
NameSharePoint
DescriptionThe SharePoint connector enables seamless integration with Microsoft's SharePoint platform, facilitating efficient collaboration, document management, and content sharing across teams and organizations. With the SharePoint connector, users can easily connect to their SharePoint sites, allowing access to files, folders, and lists for streamlined workflows and enhanced productivity. Whether retrieving or updating content, the connector simplifies the management of large volumes of documents, ensuring compliance and version control. Its robust support for real-time collaboration, metadata organization, and secure file sharing empowers organizations to maintain operational efficiency, drive knowledge sharing, and improve decision-making processes across departments.
Connector TypeClass B

Features

Feature NameFeature Details
Load StrategiesFull Load
Metadata ExtractionSupported
Data AcquisitionSupported
Data PublishingNot Supported
Automated Schema Drift HandlingNot Supported

Source Connection Attributes

Connection ParametersData TypeExample
Connection NameStringSHAREPOINT
Tenant IDString
Client IDString
Client Secret (App secret)String
Site IDString
Silver Schema (Optional)String
Bronze Schema (Optional)String

Connector Specific Configuration Details

The Empower Microsoft SharePoint connector requires registering an application in the Azure Tenant's The connector will then connect to and authenticate with the Entra ID Graph API.

Below are the steps to register and assign permissions.

Create an Azure AD Application

1. Log in to the Azure Portal

2. Navigate to Microsoft Entra ID

  • In the left-hand menu, click on Microsoft Entra ID.
    image.png

3. Register a New Application

  • In the Microsoft Entra ID section, select App registrations.
  • Click + Add at the top of the screen.

4. Configure App Registration

  • Name: Enter a name for your application (e.g., SharePointGraphAPIApp).
  • Supported Account Types: Choose the option that applies to your application, for example:
    • Accounts in this organizational directory only (Single tenant) for internal apps.
  • Redirect URI: You can leave this blank for now, or set it based on your app’s needs (e.g., a backend service might not need this initially).
  • Once everything is configured, click Register.

5. Save Application (Client) ID and Directory (Tenant) ID

  • After registering the application, you'll see its Overview page. Copy and save both the Application (Client) ID and the Directory (Tenant) ID. You’ll need these values for your backend configuration.

Create a Client Secret

1. Navigate to Certificates & Secrets

  • On your app’s Overview page, in the left-hand navigation menu, click Certificates & secrets.

2. Create a New Client Secret

  • Under the Client secrets section, click + New client secret.
  • Description: Add a description (e.g., BackendAppSecret).
  • Expiration: Select an expiration duration (e.g., 6 months, 12 months, or 24 months). You will need to rotate this secret periodically based on the expiration.

3. Save the Client Secret Value

  • After creating the secret, copy the Value immediately. You won’t be able to view it again once you navigate away from this page.
  • This Client Secret Value will be used later in the backend application for authentication.

Grant API Permissions

1. Navigate to API Permissions

  • In the left-hand menu, select API Permissions.

2. Add Microsoft Graph Permissions

  • Click on + Add a permission.
  • In the Request API permissions window, select Microsoft Graph.

3. Choose the Appropriate Permissions

  • For the actions your backend app will perform in SharePoint, you’ll need to select Application permissions.

Common Permissions for SharePoint:

  • Delegated Permissions: If your app acts on behalf of a signed-in user, choose from permissions like Sites.Read.All, Sites.ReadWrite.All, User.Read, etc.
  • Application Permissions: If your app accesses data without a signed-in user, select permissions such as Sites.Read.All, Sites.ReadWrite.All, etc.
  • Select the necessary permissions for your app and click Add permissions.

4. Grant Admin Consent (If Required)

  • Some permissions (especially Application permissions) may require Admin Consent. Click Grant admin consent for {Your Organization} to allow these permissions.

Finding the SharePoint Site ID

1. Log in to SharePoint and navigate to the site you wish to connect to SharepoinConnector.

2. Go to the Home page and copy the URL of the site.

3. Append /_api/site/id to the copied URL. Enter this new URL in your browser's address bar.

4. You’ll see the Site ID displayed on the page. Make sure you're signed in to your SharePoint account when performing this step.

Note down the Site ID as you will need it for the next steps.


Mandatory conditions for the Sharepoint static CSV files:

File Format

The connector is designed to handle files only in CSV format. Ensure all files used or processed by the system are in .csv format for compatibility with the connector.

Use of Separator

Always use a comma , as the separator in your data files. This ensures consistency and compatibility across different systems and processes.

Encoding Standard

Ensure that all files are saved and processed using UTF-8 encoding. This is crucial to maintain character integrity, especially when working with international data or special characters.

File Movement or Renaming

When you move or rename a file, it is essential to update the associated metadata. This ensures that all references to the file are accurate and that no processes relying on this data are disrupted.

Replacing a File Without Dropping

If you are replacing a file but not dropping and creating a new one, you can continue to use the same table name. This allows for a seamless transition and minimal disruption to the existing data structure.

Dropping and Creating a New File

When you drop and create a new file with the same name, it is necessary to update the metadata. This ensures that the system properly references and recognizes the new file, preventing potential issues with outdated information.


Screenshot To Use Connector