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.