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 |
Use this connector to read workbook data through Excel Services on an on-premises SharePoint server, then ingest it with a batch sync. The server must expose the Excel Services API; storing an Excel file in SharePoint is not sufficient. The driver lists SharePoint 2010 and 2013 ↗ in its SharePointVersion property.
| How you access workbook data | Connector or workflow |
|---|---|
| Excel Services API on an on-premises SharePoint server | Microsoft SharePoint Excel, described on this page |
| Microsoft 365 workbook access in SharePoint Online or OneDrive | Microsoft Excel Online |
| Workbook files in a supported storage backend | Microsoft Excel |
| Excel files already ingested into Foundry | Parse the files in Foundry |
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 AuthScheme=Negotiate |
| <KerberosServiceKDC>:88 | If AuthScheme=Negotiate AND Kerberos topology uses multiple realms |
| <SSOLoginURL> | If AuthScheme=ADFS |