Microsoft Excel Online¶
The Microsoft Excel Online connector is a Palantir-provided driver for Microsoft Excel Online.
To create a new Microsoft Excel Online source, follow the standard setup flow for Palantir-provided drivers, then use the sections below for Microsoft Excel Online-specific configuration and networking. For the complete property reference, see the official Microsoft Excel Online driver documentation ↗.
Configuration¶
The properties below are mandatory or recommended.
| Property | Required? | Description | Default |
|---|---|---|---|
AuthScheme ↗ |
Recommended | Specifies the type of authentication to use when connecting to Microsoft Excel Online. If this property is left blank, the default authentication is used. | AzureServicePrincipal |
AzureTenant ↗ |
Recommended | Identifies the Microsoft Excel Online tenant being used to access data, either by name (for example, contoso.onmicrosoft.com) or ID. (Conditional). | — |
Drive ↗ |
Recommended | The Id of the drive. | — |
IncludeSharePointSites ↗ |
Recommended | Whether to retrieve drives for all SharePoint sites when querying Drives view. If 'true' the provider will retrieve all Site IDs recursively and for each of them issue a separate call to get their drives. Therefore, be aware that setting this property to 'true' may decrease performance for the Drives view. Note that the SharePointAccessToken or OAuthJWTCert connection property must be specified to query the SharePointSites view and other views if IncludeSharePointSites is set to 'true' when using the CLIENT OAuthGrantType or the AzureServicePrincipal AuthScheme. | FALSE |
InitiateOAuth ↗ |
Recommended | Specifies the process for obtaining or refreshing the OAuth access token, which maintains user access while an authenticated, authorized user is working. | GETANDREFRESH |
OAuthClientId ↗ |
Recommended | Specifies the client Id that was assigned when the custom OAuth application was created. (Also known as the consumer key.) This ID registers the custom application with the OAuth authorization server. | — |
OAuthClientSecret ↗ |
Recommended | Specifies the client secret that was assigned when the custom OAuth application was created. (Also known as the consumer secret). This secret registers the custom application with the OAuth authorization server. | — |
ShowSharedDocuments ↗ |
Recommended | Whether or not to show shared documents. | FALSE |
Workbook ↗ |
Recommended | The name or Id of the workbook. | — |
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 |
|---|---|
| graph.microsoft.com | If AzureEnvironment=GLOBAL (default) |
| login.microsoftonline.com | If AuthScheme=AzureAD (default), AzureServicePrincipal, AzureServicePrincipalCert AND AzureEnvironment=GLOBAL |
| microsoftgraph.chinacloudapi.cn | If AzureEnvironment=CHINA |
| login.chinacloudapi.cn | If AuthScheme=AzureAD (default), AzureServicePrincipal , AzureServicePrincipalCert AND AzureEnvironment=CHINA |
| graph.microsoft.us | If AzureEnvironment=USGOVT |
| login.microsoftonline.us | If AuthScheme=AzureAD (default), AzureServicePrincipal, AzureServicePrincipalCert AND AzureEnvironment=USGOVT or USGOVTDOD |
| dod-graph.microsoft.us | If AzureEnvironment=USGOVTDOD |
| \ |
If setting the SharepointURL property |
中文翻译¶
Microsoft Excel Online¶
Microsoft Excel Online 连接器是 Palantir 提供的一个用于 Microsoft Excel Online 的驱动程序。
要创建新的 Microsoft Excel Online 数据源，请遵循 Palantir 提供驱动程序的标准设置流程，然后使用以下各节进行 Microsoft Excel Online 特定的配置和网络设置。有关完整的属性参考，请参阅官方 Microsoft Excel Online 驱动程序文档 ↗。
配置¶
以下属性为必填或推荐项。
| 属性 | 是否必填 | 描述 | 默认值 |
|---|---|---|---|
AuthScheme ↗ |
推荐 | 指定连接到 Microsoft Excel Online 时使用的身份验证类型。如果此属性留空，则使用默认身份验证。 | AzureServicePrincipal |
AzureTenant ↗ |
推荐 | 标识用于访问数据的 Microsoft Excel Online 租户，可通过名称（例如 contoso.onmicrosoft.com）或 ID 指定。（条件性）。 | — |
Drive ↗ |
推荐 | 驱动器的 ID。 | — |
IncludeSharePointSites ↗ |
推荐 | 查询 Drives 视图时是否检索所有 SharePoint 站点的驱动器。如果设置为 'true'，提供程序将递归检索所有站点 ID，并为每个站点单独调用以获取其驱动器。因此，请注意将此属性设置为 'true' 可能会降低 Drives 视图的性能。注意：当使用 CLIENT OAuthGrantType 或 AzureServicePrincipal AuthScheme 时，如果 IncludeSharePointSites 设置为 'true'，则必须指定 SharePointAccessToken 或 OAuthJWTCert 连接属性才能查询 SharePointSites 视图和其他视图。 | FALSE |
InitiateOAuth ↗ |
推荐 | 指定获取或刷新 OAuth 访问令牌的过程，该令牌在已认证授权用户工作时维持其访问权限。 | GETANDREFRESH |
OAuthClientId ↗ |
推荐 | 指定创建自定义 OAuth 应用程序时分配的客户端 ID（也称为消费者密钥）。此 ID 将自定义应用程序注册到 OAuth 授权服务器。 | — |
OAuthClientSecret ↗ |
推荐 | 指定创建自定义 OAuth 应用程序时分配的客户端密钥（也称为消费者密钥）。此密钥将自定义应用程序注册到 OAuth 授权服务器。 | — |
ShowSharedDocuments ↗ |
推荐 | 是否显示共享文档。 | FALSE |
Workbook ↗ |
推荐 | 工作簿的名称或 ID。 | — |
网络设置¶
下表列出了数据源成功运行所需访问的域名。
对于每个域名，请添加相应的出站策略。如果数据源部署在本地且无法直接从 Foundry 访问，请改用代理出站策略；代理主机本身也必须能够访问列出的域名。详情请参阅使用代理作为代理服务器。
| 域名 | 必需条件 |
|---|---|
| graph.microsoft.com | 如果 AzureEnvironment=GLOBAL（默认） |
| login.microsoftonline.com | 如果 AuthScheme=AzureAD（默认）、AzureServicePrincipal、AzureServicePrincipalCert 且 AzureEnvironment=GLOBAL |
| microsoftgraph.chinacloudapi.cn | 如果 AzureEnvironment=CHINA |
| login.chinacloudapi.cn | 如果 AuthScheme=AzureAD（默认）、AzureServicePrincipal、AzureServicePrincipalCert 且 AzureEnvironment=CHINA |
| graph.microsoft.us | 如果 AzureEnvironment=USGOVT |
| login.microsoftonline.us | 如果 AuthScheme=AzureAD（默认）、AzureServicePrincipal、AzureServicePrincipalCert 且 AzureEnvironment=USGOVT 或 USGOVTDOD |
| dod-graph.microsoft.us | 如果 AzureEnvironment=USGOVTDOD |
| \ |
如果设置了 SharepointURL 属性 |