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 ↗.
Configuration¶
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 |
Networking¶
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 |
|---|---|
| \ |
Always. URL connection property |
| \ |
If SharePointEdition='SharePoint OnPremise' (default) AND AuthScheme=Negotiate |
| \ |
If SharePointEdition='SharePoint OnPremise' (default) AND AuthScheme=Negotiate AND Kerberos topology uses multiple realms |
| \ |
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 |
中文翻译¶
Microsoft SharePoint Excel¶
Microsoft SharePoint Excel 连接器是一个由 Palantir 提供的驱动程序(Palantir-provided driver)，用于连接 Microsoft SharePoint Excel。
要创建新的 Microsoft SharePoint Excel 数据源，请遵循Palantir 提供驱动程序的标准设置流程，然后使用以下各节进行 Microsoft SharePoint Excel 特定的配置和网络设置。有关完整的属性参考，请参阅官方 Microsoft SharePoint Excel 驱动程序文档 ↗。
配置¶
以下属性为必填或推荐设置。
| 属性 | 是否必填 | 描述 | 默认值 |
|---|---|---|---|
AuthScheme ↗ |
必填 | 用于身份验证的方案。可接受的值为 NTLM、Basic、Digest、Forms、None、Negotiate、ADFS。 | NTLM |
File ↗ |
必填 | 要连接的 Excel 文件名。 | Book1.xlsx |
SharePointVersion ↗ |
必填 | 所连接的 SharePoint 服务器版本。 | SharePoint 2013 |
URL ↗ |
必填 | 站点或站点集合的基础 URL。 | https://myorg.sharepoint.com |
Folder ↗ |
推荐 | 包含 File 属性所指定工作簿的文件夹。 | — |
Library ↗ |
推荐 | 要连接的文档库(Document Library)。 | — |
Password ↗ |
推荐 | 用于向服务器进行身份验证的账户密码。 | — |
User ↗ |
推荐 | 用于向服务器进行身份验证的账户用户名。 | — |
UseRESTAPI ↗ |
推荐 | 是否使用 REST API 检索数据。 | TRUE |
网络配置¶
下表列出了数据源为成功运行而需要能够访问的域名。
对于每个域名，请添加相应的出口策略(egress policy)。如果数据源部署在本地且无法从 Foundry 直接访问，请改用代理出口策略(agent proxy egress policy)；代理主机本身也必须能够访问所列出的域名。有关详细信息，请参阅使用代理作为代理服务器。
| 域名 | 必需条件 |
|---|---|
| \ |
始终需要。URL 连接属性 |
| \ |
如果 SharePointEdition='SharePoint OnPremise'（默认值）且 AuthScheme=Negotiate |
| \ |
如果 SharePointEdition='SharePoint OnPremise'（默认值）且 AuthScheme=Negotiate 且 Kerberos 拓扑使用多个领域 |
| \ |
如果 SharePointEdition='SharePoint OnPremise'（默认值）且 AuthScheme=ADFS |
| login.microsoftonline.com | 如果 SharePointEdition='SharePoint Online' 且 AuthScheme=AzureAD、AzurePassword、SharePointOAuth、OAuthJWT 且 AzureEnvironment=GLOBAL（默认值） |
| login.chinacloudapi.cn | 如果 SharePointEdition='SharePoint Online' 且 AuthScheme=AzureAD、AzurePassword、SharePointOAuth、OAuthJWT 且 AzureEnvironment=CHINA |
| login.microsoftonline.us | 如果 SharePointEdition='SharePoint Online' 且 AuthScheme=AzureAD、AzurePassword、SharePointOAuth、OAuthJWT 且 AzureEnvironment=USGOVT 或 USGOVTDOD |