Microsoft SharePoint is a web-based collaborative platform that integrates natively with Microsoft 365. SharePoint is primarily sold as a document management and storage system, although it is also used for sharing information through an intranet, implementing internal applications, and for implementing business processes.

This article provides an overview to get started with the Sharepoint connector in Peliqan. Please contact support if you have any additional questions or remarks.

Contents

Connect

In peliqan, go to Connections, click on Add new. Find Sharepoint in the list and select it. Click on the Connect button. This will open Sharepoint and allow you to authorize access for Peliqan. Once that is done, you will return to Peliqan.

You can choose between following connectors for Sharepoint:

• Sharepoint Site: to work with Sharepoint and lists in low-code Python scripts
• Sharepoint List: to work with one specific list on Sharepoint, including an ETL pipeline
• Sharepoint Excel 365 Writeback: to work with Excel on Sharepoint, writeback onky (low-code Python scripts), no ETL pipelines. Click here for more info.
• Sharepoint Excel 365 External Tenant: same as above but to connect to an external tenant, a tenant that you do not own but that was shared with you (using the “Grant access” setting under Sharing in Excel) or when you are a guest user to that Sharepoint site.

How to find your Site id (Sharepoint)

Using Sharepoint admin

Go to: https://{tenant}-admin.sharepoint.com

Replace {tenant} with your Sharepoint subdomain.