SharePoint is a cloud-based file storage service provided by Microsoft.
Prerequisites
Read and write permissions from this account
Later when creating a dataset or configuring Microsoft SharePoint as a destination, you’ll need the following:
A SharePoint folder containing files with supported file types and encodings
The URL of your SharePoint folder or file that you want to sync
Set Up Microsoft SharePoint in Savant
In Savant
Click Authenticate. You will be redirected to SharePoint to grant Savant access. Log in to your SharePoint account.
Understanding Microsoft SharePoint Limitations
There are no known limitations to Savant’s Microsoft SharePoint connector.
Read data from Microsoft SharePoint
From the "Data” tab click on “New Dataset”.
Find the SharePoint system that you have configured and click "Next."
Configuring the Data Set:
Select the file type (text file, Excel, or blob).
For text files, choose the delimiter or qualifier if applicable.
Specify the file or folder URL. Ensure that the system used to authenticate the SharePoint system has read and write permissions to this location.
Additional Configurations:
For file URLs, configure options like skip rows, headerless data, metadata inclusion, etc.
For folder URLs, configure file pattern, compression method, common headers, etc.
Once you have configured all the necessary options, click on "Apply."
Make sure to select and configure all the fields that you want to include in the dataset.
Click "Next" at the top right when you're ready to finalize the dataset and name your dataset appropriately.
Write Data to Microsoft OneDrive
Open the destination pane and click on "Add Destination."
Find the SharePoint system you want to write to.
Configuring the Destination:
Select the file type for your output data.
Choose the folder link in which you want to create the file.
Specify a filename. You can either manually enter the filename or name the file dynamically based on a field.
Handling Existing Files:
Configure what happens if the file already exists. You can select either "replace" or "insert."
Sorting Options:
If needed, select a sort option to sort your data upon output.
Completing the Process:
Once you have configured all the necessary options, save the configuration by clicking “Apply”.