251031_​Bar Chart - Pivot - Forum

<p>This workflow demonstrates how to connect to your personal SharePoint file system using the <strong>Microsoft Authentication</strong> and <strong>SharePoint Online Connector</strong> nodes. It provides examples of how to access and manage files stored in SharePoint.</p><p><strong>Workflow Structure</strong></p><p>The workflow includes the following key functionalities:</p><ul><li><p><strong>Authentication</strong>: Connects to SharePoint Online using Microsoft Authentication.</p></li><li><p><strong>File and Folder Management</strong>: Lists files and folders stored in SharePoint.</p></li><li><p><strong>Data I/O Operations</strong>:</p><ul><li><p>Reads and writes <strong>Excel (XLSX)</strong> and <strong>CSV</strong> files.</p></li><li><p>Writes tables in <strong>Excel (XLSX), CSV, Parquet</strong>, and <strong>SVG </strong>formats.</p></li></ul></li></ul><p><strong>Sandbox Environment</strong></p><p>Following Microsoft's official guidance, a <strong>sandbox environment</strong> was created for this blueprint workflow. The workflow has been tested using a <strong>fake SharePoint site</strong> named company-test-site, simulating real-world use cases.</p><p><strong>Use Case</strong></p><p>This workflow is useful for automating SharePoint file operations, integrating SharePoint data into KNIME workflows, and exporting processed data in various formats.</p><p><strong>Required Configuration</strong></p><p>To use this workflow, ensure that you have:</p><ul><li><p>Valid <strong>Microsoft credentials</strong> with access to SharePoint Online.</p></li><li><p>The <strong>Microsoft Authentication</strong> and <strong>SharePoint Online Connector</strong> nodes are installed in KNIME.</p></li></ul>