Skip to main content

SharePoint and OneDrive

SharePoint and OneDrive connections let Liberator read delimited files, Parquet, Excel, and other supported formats from Microsoft 365 storage. In Liberator 2.2 and later, paste a standard share link copied from the browser or desktop to connect. Wildcard folder paths (for example, reports/*.csv) are supported for both source types.
1

Copy a share link in Microsoft 365

In the browser or desktop app, open the file or folder, then Share → Copy link. The link looks like https://your-org.sharepoint.com/:f:/s/....
2

Add a connection in Liberator

Go to Connections → Add Connection and select SharePoint or OneDrive.
3

Paste the share link

Paste the link into the Share link field. Liberator clears any previously entered folder path when a share link is detected.
4

Sign in with Microsoft

Complete the Sign in with Microsoft dialog. If it does not appear automatically, click Sign in with Microsoft.
5

Test connection

Click Test Connection. On success, the resolved internal path replaces the share link in the field. Confirm the account has at least read access to the linked location.
6

Finish onboarding

Continue through dataset configuration (file pattern, columns, date/time) as for other file-based sources.

Fixed date and time (non-time-series files)

For static reference files without a date column:
  1. On the Date / Time step, select Fixed date and time.
  2. Enter the timestamp Liberator should assign to records.
If the source has a date column, select it from the Date column dropdown instead.

Date format picker (2.2+)

When choosing a date format during onboarding, Liberator:
  • Shows a live example from your sample data (for example, 25 Jun 2026 instead of generic DD MMM YYYY).
  • Ranks formats by likelihood, with the best match at the top.
Select the example that matches your source dates.

Supported formats

File extensions available on SharePoint and OneDrive connections

Local file reference

Shared data_args fields for file-based datasets