This workflow demonstrates how to connect to your personal SharePoint file system using the Microsoft Authentication and SharePoint Online Connector nodes. It provides examples of how to access and manage files stored in SharePoint.

Workflow Structure

The workflow includes the following key functionalities:

Authentication: Connects to SharePoint Online using Microsoft Authentication.
File and Folder Management: Lists files and folders stored in SharePoint.
Data I/O Operations:
- Reads and writes Excel (XLSX) and CSV files.
- Writes tables in Excel (XLSX), CSV, Parquet, and SVG formats.

Sandbox Environment

Following Microsoft's official guidance, a sandbox environment was created for this blueprint workflow. The workflow has been tested using a fake SharePoint site named company-test-site, simulating real-world use cases.

Use Case

This workflow is useful for automating SharePoint file operations, integrating SharePoint data into KNIME workflows, and exporting processed data in various formats.

Required Configuration

To use this workflow, ensure that you have:

Valid Microsoft credentials with access to SharePoint Online.
The Microsoft Authentication and SharePoint Online Connector nodes are installed in KNIME.

Type	Name
	Go back to parent directory
	01_Amazon_S3_Remote_File_Example
	02_Azure_Blob_Store_Remote_File_Example
	03_ZIP_Local_vs_remoteHTTP
	04_AmazonS3-MSBlobStorage_Census_Data
	05_SAS_SPSS_MATLAB_meet_S3
	06_Amazon_S3_meets_DynamoDB
	07_Microsoft_Sharepoint_Data_Access
	08_Microsoft_Sharepoint_meets_Google_Cloud_Storage
	09_Data_Transfer_between_Clouds
	Connect to box and upload files

Examples