Microsoft OneDrive
Type of Support: | Read & Write |
Connection Type: | Alteryx Tool. The latest version is available from the Alteryx Community. |
Release Notes
Version | Description |
v2.2.0 |
|
v2.1.0 |
|
v2.0.2 |
|
v2.0.1 |
|
v2.0.0 |
|
v1.0.2 |
|
v1.0.1 | Fixed issue preventing packages from being installed successfully. |
v1.0.0 | Initial release for OneDrive Input and OneDrive Output. |
Alteryx Tools Used to Connect
Data Connection Manager
The OneDrive tools support Designer DCM for an easier and a safer storage of your credentials. Create a connection to OneDrive and easily reuse the stored credentials in workflows that include the OneDrive tools. Alteryx Server requires stored credentials to successfully run the published workflows.
Enable AMP Engine
Make sure you have the Alteryx AMP Engine enabled for the workflows which contain the OneDrive tools to leverage the full potential of Designer capabilities.
Custom API Application Setup
For more information on how to build and manage an application using the Microsoft Azure cloud services, refer to the Azure documentation.
- Navigate to https://portal.azure.com/#home.
- Sign in with your Microsoft Azure Active Directory account.
- On the Home screen use Search, or go to the upper left corner menu to open the Azure Active Directory service.
- Open App registrations in the left menu.
- Select + New registration.
- Specify the Name of the app.
- Choose desired account type–both Single tenant and Multitenant are allowed.
- In the optional Redirect URL:
- For OneDrive Input and Output version 2.0.2. and earlier: Select Single-page application (SPA) from the dropdown menu and set the 2 URLs:
- https://cef.alteryx.com/designer/oauthcallback
- https://login.live.com/oauth20_desktop.srf
- For OneDrive Input and Output version 2.1.0 and later: Select Web-page application (WPA) from the dropdown menu and set the URL:
- http://localhost/
- For OneDrive Input and Output version 2.0.2. and earlier: Select Single-page application (SPA) from the dropdown menu and set the 2 URLs:
- Select Register.
- The Application (client) ID is your Client ID.
- The Directory (tenant) ID is your Tenant ID.
- Go to API permissions to add these Delegated permissions - Microsoft Graph.
- Files.ReadWrite.All
- offline_access
- openid
- User.Read
- profile
- To use service principal (app-only authentication) proceed to Certificates & secrets and add New client secret. Copy the Value as it won't be accessible again once you leave the page – this is your Secret ID. In API permissions add these Application permissions - Microsoft Graph.
- Files.Read.All
- Files.ReadWrite.All
- Sites.Read.All
Limitations
Login Expiration
Standard login, Sign in via Internet Browser option, expires after 24 hours so it isn’t suitable for scheduling workflows. For scheduling, select Use Service Principal after selecting Provide authentication information option. Service Principal requires a custom API Application.