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 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 needs to be able to access in order to successfully 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 |