SharePoint connector

The SharePoint connector imports files from Microsoft SharePoint Online document libraries into Mammoth as datasets. Authentication uses Azure app credentials (Tenant ID, Client ID, Client Secret)—this is an app-level connection, not tied to an individual user account.

Before you start

You need to register an Azure Active Directory app with Microsoft Graph access to the target SharePoint site. This is a one-time setup done by a Microsoft 365 admin.

Register the Azure AD app

1. Go to Azure Portal → Azure Active Directory → App registrations
2. Click New registration—name it (e.g., Mammoth SharePoint) and click Register
3. Copy the Application (client) ID—this is your Client ID
4. Copy the Directory (tenant) ID—this is your Tenant ID
5. Go to Certificates & secrets → New client secret, add a description, set an expiry, and click Add
6. Copy the secret Value immediately (it won't be shown again)—this is your Client Secret
7. Go to API permissions → Add a permission → Microsoft Graph → Application permissions
8. Add Sites.Read.All (or Sites.Selected for tighter scope)
9. Click Grant admin consent

Step 1: Select the SharePoint connector

1. In Mammoth, go to Data Library and click + New Dataset
2. Select Connectors
3. Search for SharePoint or find it in the Cloud Storage category
4. Click the SharePoint tile

Step 2: Create a connection

Click New Connection to open the credential form.

Field	Description	Example
Server URL	Your SharePoint site URL	https://mycompany.sharepoint.com/sites/Analytics
Tenant ID	Azure AD Directory (tenant) ID	xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx
Client ID	Azure AD Application (client) ID	yyyyyyyy-yyyy-yyyy-yyyy-yyyyyyyyyyyy
Client Secret	The app secret value you created	—

All four fields are required. Click Connect once they're filled in—there's no OAuth sign-in step, since the connector authenticates directly with the app credentials above. If validation fails, the error message appears at the bottom of the form.

Step 3: Select your SharePoint file

After connecting, select the connection under Existing Connections, then browse the SharePoint document library file tree to find your file.

Supported SharePoint file formats

.txt · .csv · .tsv · .psv · .xls · .xlsx · .xml · .zip · .bz2 · .gz · .tar · .7z

Step 4: Create the SharePoint dataset

Click Create new dataset. Mammoth does not ask you to choose an update method for this connector.

To keep the dataset in sync as the source file changes, set up a Dataset Refresh automation.

Troubleshoot SharePoint connections

Authentication fails

• Check all four values (Server URL, Tenant ID, Client ID, Client Secret) are copied correctly—GUIDs are case-insensitive but must be complete
• Confirm admin consent has been granted for the API permissions

Client secret expired

• Client secrets expire based on the duration you set during creation—generate a new secret in Azure Portal and update the connection in Mammoth

Permission denied accessing files

• Confirm Sites.Read.All (or Sites.Selected with the correct site) has been granted with admin consent