Microsoft SharePoint Exporter

📘
Checkout the API docs here for more information.

The connector is used for exporting CSV files from the Data Warehouse into Sharepoint.

Set up

The connector uses Kleene's multi-tenanted oAuth application for authentication. To be able to successfully run extracts using this source please check within Azure App Services that there is not a restriction that would prevent access. If you need to have IP whitelisting for compliance reasons please contact Kleene and we will help to set this up.

To set up the source you will just need your SharePoint username and password. You will also need to make sure this user has access to the relevant Sharepoint Sites.

Features

Feature	Support	Notes
API reliability	🟢	Reliable

Reports detail

⬇️ Report	🔑 Incremental key	🔑 Primary key	📄 Link to API endpoint
SharePoint- New CSV file	`N/A`	`N/A`	Upload or replace the contents of a driveItem
SharePoint- Replace CSV file	`N/A`	`N/A`	Upload or replace the contents of a driveItem

To setup the extract for the "SharePoint- New CSV file" report you will need your Base Url, the Site and Folder Path (the folder where you want to upload the CSV file to; note you will need at lease one folder above the root). Here is an example:

To setup the extract for the "SharePoint- Replace CSV file" report you will need your Base Url, the Site and File Path (the file path to the CSV you want to replace; note that you need to include the folder path and file name and the extension as well). Here is an example:

Limitation

For the "SharePoint- New CSV file" you need to include at least one folder (you won't be able to upload files in the root folder of your Site
The connector is intended for small files (around 1 MB size for compressed files)