Microsoft OneDrive

The Microsoft OneDrive connector is a Palantir-provided driver for Microsoft OneDrive.

To create a new Microsoft OneDrive source, follow the standard setup flow for Palantir-provided drivers, then use the sections below for Microsoft OneDrive-specific configuration and networking. For the complete property reference, see the official Microsoft OneDrive driver documentation ↗.

Configuration

The properties below are mandatory or recommended.

PropertyRequired?DescriptionDefault
AuthSchemeRecommendedSpecifies the type of authentication to use when connecting to Microsoft OneDrive. If this property is left blank, the default authentication is used.AzureServicePrincipal
AzureTenantRecommendedIdentifies the Microsoft OneDrive tenant being used to access data, either by name (for example, contoso.onmicrosoft.com) or ID. (Conditional).
InitiateOAuthRecommendedSpecifies the process for obtaining or refreshing the OAuth access token, which maintains user access while an authenticated, authorized user is working.GETANDREFRESH
OAuthClientIdRecommendedSpecifies 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.
OAuthClientSecretRecommendedSpecifies 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.

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.

DomainRequired
graph.microsoft.comIf AzureEnvironment=GLOBAL (default)
login.microsoftonline.comIf AuthScheme=AzureAD (default), AzureServicePrincipal, AzureServicePrincipalCert AND AzureEnvironment=GLOBAL
microsoftgraph.chinacloudapi.cnIf AzureEnvironment=CHINA
login.chinacloudapi.cnIf AuthScheme=AzureAD (default), AzureServicePrincipal , AzureServicePrincipalCert AND AzureEnvironment=CHINA
graph.microsoft.usIf AzureEnvironment=USGOVT
login.microsoftonline.usIf AuthScheme=AzureAD (default), AzureServicePrincipal, AzureServicePrincipalCert AND AzureEnvironment=USGOVT or USGOVTDOD
dod-graph.microsoft.usIf AzureEnvironment=USGOVTDOD

Extracting files

Files can be extracted from Microsoft OneDrive by executing the DownloadFile ↗ stored procedure.

To extract a file, add the following SQL query in the sync definition.

Copied!
1 EXECUTE DownloadFile ResourceId = '1234'

This will produce an output dataset with the file content stored in a Base64 encoded string column, which should be decoded to binary in a downstream data transformation.

Microsoft OneDrive sync extracting a file using a stored procedure.