Microsoft SharePoint Excel

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 ↗.

Beta

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.

Supported capabilities

CapabilityStatus
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.

Choose an Excel connector

How you access workbook dataConnector or workflow
Excel Services API on an on-premises SharePoint serverMicrosoft SharePoint Excel, described on this page
Microsoft 365 workbook access in SharePoint Online or OneDriveMicrosoft Excel Online
Workbook files in a supported storage backendMicrosoft Excel
Excel files already ingested into FoundryParse the files in Foundry

Configuration

The properties below are mandatory or recommended.

PropertyRequired?DescriptionDefault
AuthScheme ↗MandatoryThe scheme used for authentication. Accepted entries are NTLM,Basic,Digest,Forms,None,Negotiate,ADFS.NTLM
File ↗MandatoryThe name of the Excel file to which to connect.Book1.xlsx
SharePointVersion ↗MandatoryThe version of the SharePoint server to which you are connecting.SharePoint 2013
URL ↗MandatoryThe base URL for a site or site collection.https://myorg.sharepoint.com
Folder ↗RecommendedThe folder containing the workbook specified by the File property.—
Library ↗RecommendedThe Document Library to which to connect.—
Password ↗RecommendedThe password of the account used to authenticate to the server.—
User ↗RecommendedThe username of the account used to authenticate to the server.—
UseRESTAPI ↗RecommendedWhether or not the REST API is used for retrieving data.TRUE

Networking

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.

DomainRequired
<URL>Always. URL connection property
<KerberosKDC>:88If AuthScheme=Negotiate
<KerberosServiceKDC>:88If AuthScheme=Negotiate AND Kerberos topology uses multiple realms
<SSOLoginURL>If AuthScheme=ADFS