CSV files from Sharepoint to Amazon S3 by COZYROC

Elevate your data integration to new heights with this COZYROC gem, which effortlessly transfers CSV files from SharePoint to Amazon S3 for seamless data management and analysis.

This gem facilitates seamless CSV file transfers from SharePoint to Amazon S3, offering a secure and automated solution for cross-platform data management. It ensures real-time synchronization, eliminates manual uploads, and enhances productivity by streamlining file handling. Files are stored using a currentdate_CSVFile naming format, enabling clear, organized, and date-specific file management—ideal for teams focused on efficient and secure cloud operations.

Setup Guide

This gem integrates Microsoft Graph API with Amazon S3 to seamlessly retrieve CSV files from SharePoint and upload them to a specified Amazon S3 bucket for secure storage and further processing.

To run this gem and enable automated CSV transfers from SharePoint to Amazon S3, please configure the parameters listed below.

Microsoft Graph

• Server Host Required. Default is set to https://graph.microsoft.com/v1.0/sites/root when connecting to the default SharePoint instance. Set to https://graph.microsoft.com/v1.0/sites/<site-id> when connecting to a specific SharePoint instance.
• Token File Required. Select the Rest Token file from the drop-down list. Review the documentation article here on how to generate the token file.
• Source Folder Required. Specify the path to the source folder, ending with a trailing slash.
• Filter Optional. Specify to filter the list of files.

Amazon S3

• Server Host Required. Provide the relevant [bucket] and [region] in the Server URL.
• Access Key Required. Specify the access key for Amazon S3 service.
• Secret Key Required. Specify the secret key for Amazon S3 service.
• Destination Folder Required. Specify the path to the destination folder, ending with a trailing slash.