The Microsoft SharePoint Excel connector is a Palantir-provided driver for Microsoft SharePoint Excel.
To create a new Microsoft SharePoint Excel source, follow the standard setup flow for Palantir-provided drivers, then use the sections below for Microsoft SharePoint Excel-specific configuration and networking. For the complete property reference, see the official Microsoft SharePoint Excel driver documentation ↗.
The Microsoft SharePoint Excel connector is in the beta phase of development and may not be available on your enrollment. Functionality may change during active development.
| Capability | Status |
|---|---|
| Exploration | 🟡 Beta |
| Batch syncs | 🟡 Beta |
| Incremental | 🟡 Beta |
The properties below are mandatory or recommended.
| Property | Required? | Description | Default |
|---|---|---|---|
AuthScheme ↗ | Mandatory | The scheme used for authentication. Accepted entries are NTLM,Basic,Digest,Forms,None,Negotiate,ADFS. | NTLM |
File ↗ | Mandatory | The name of the Excel file to which to connect. | Book1.xlsx |
SharePointVersion ↗ | Mandatory | The version of the SharePoint server to which you are connecting. | SharePoint 2013 |
URL ↗ | Mandatory | The base URL for a site or site collection. | https://myorg.sharepoint.com |
Folder ↗ | Recommended | The folder containing the workbook specified by the File property. | — |
Library ↗ | Recommended | The Document Library to which to connect. | — |
Password ↗ | Recommended | The password of the account used to authenticate to the server. | — |
User ↗ | Recommended | The username of the account used to authenticate to the server. | — |
UseRESTAPI ↗ | Recommended | Whether or not the REST API is used for retrieving data. | TRUE |
The table below lists the domains that the source must be able to access to run.
For each domain, add a corresponding egress policy. If the source is hosted on-premises and not directly reachable from Foundry, use an agent proxy egress policy instead. The agent host itself must also be able to reach the listed domains. See using an agent as a proxy for details.
| Domain | Required |
|---|---|
| <URL> | Always. URL connection property |
| <KerberosKDC>:88 | If SharePointEdition='SharePoint OnPremise' (default) AND AuthScheme=Negotiate |
| <KerberosServiceKDC>:88 | If SharePointEdition='SharePoint OnPremise' (default) AND AuthScheme=Negotiate AND Kerberos topology uses multiple realms |
| <SSOLoginURL> | If SharePointEdition='SharePoint OnPremise' (default) AND AuthScheme=ADFS |
| login.microsoftonline.com | If SharePointEdition='SharePoint Online' AND AuthScheme=AzureAD, AzurePassword, SharePointOAuth, OAuthJWT AND AzureEnvironment=GLOBAL (default) |
| login.chinacloudapi.cn | If SharePointEdition='SharePoint Online' AND AuthScheme=AzureAD, AzurePassword, SharePointOAuth, OAuthJWT AND AzureEnvironment=CHINA |
| login.microsoftonline.us | If SharePointEdition='SharePoint Online' AND AuthScheme=AzureAD, AzurePassword, SharePointOAuth, OAuthJWT AND AzureEnvironment=USGOVT or USGOVTDOD |