Skip to main content

Microsoft OneDrive

Connection Type

Alteryx Tool. The latest version is available from the Alteryx Marketplace.

Type of Support

Read & Write

Version

Description

v2.3.0

  • Compatible with Designer 2021.4.2 Patch 4, 2022.1 Patch 2 and later.

  • Compatible with AMP engine only.

  • DCM is required for running this connector on Alteryx Server.

  • Improved the authentication options window.

  • OneDrive Input’s output now includes the sheet names when you download XLSX files locally. You can use the sheet names in other tools of your workflow.

  • Fixed issue where OneDrive Output set to overwrite a specific sheet in XLSX file modified other sheets as well.

  • Fixed issue where the OneDrive tools' authentication didn't work properly. (TPM-3833)

  • Fixed issue where OneDrive Input didn't read certain data types correctly. (TPM-3751, TPM-3722, TPM-3721)

  • Fixed issue where OneDrive Output wrote incorrect files if the data contained Fixed Decimal or Null values. (TPM-3720)

  • Fixed issue where OneDrive Output incorrectly converted Null values in CSV files. (TPM-3719)

  • Fixed issue where the service principal authentication didn't work in OneDrive Output. (TPM-3580)

  • Fixed issue where, despite user’s settings to exclude the field of the Select Sheet options, OneDrive Output included the field in the output. (TPM-3393)

  • Fixed issue where OneDrive Output didn't correctly append data. (TPM-2564)

  • Fixed issue where OneDrive Output’s Abort option didn't work correctly for all data types. (TPM-2563)

  • Fixed the OneDrive tools' encoding issues. (TPM-1984)

  • Fixed issue where OneDrive Output changed the headers' format. (TPM-1375)

  • Fixed issue where OneDrive Output’s Append option overwrote document’s formatting and formulas. (TPM-1179)

  • Fixed issue where OneDrive Input couldn't read YXDB files with DateTime data. (TPM-1100)

  • Fixed issue where OneDrive Output fails when the workflow includes data of Byte and Int16 data types. (TPM-209)

v2.2.0

  • Compatible with Designer 2021.4.2 Patch 4, 2022.1 Patch 2 and later.

  • Compatible with AMP engine only.

  • Added support for DCM.

    • DCM is required for running this connector on Alteryx Server.

  • FIPS capable.

  • Added option to overwrite only one sheet.

  • Changed the behavior of sheet name field to be excluded from the written data. Added option to keep the sheet name field.

  • SSL/TLS validation is now performed against Windows Certificate Store.

v2.1.0

  • Authentication occurs using user's browser instead of embedded CEF in Designer to comply with modern security policies.

v2.0.2

  • Fixed issue with tool configuration being lost in case of "Provide authentication Information" being enabled.

v2.0.1

  • Fixed blank screen issue when authenticating in Designer 2021.3.2.54175. Please note that you also need to update to Designer 21.3.3.63061 or later.

v2.0.0

  • Built-in multitenant Azure App with an option to use a custom Azure App (including single-tenant app or Service Principal).

  • Supports reading and writing XLSX, CSV, and YXDB file formats.

  • Proxy support.

  • Compatible with Alteryx Designer version 2021.2.2 and later.

  • Requires OneDrive 365.

v1.0.2

  • Update Code Page options.

  • Distinguish between encodings with same language (for example, 'Language' -> 'Language (specific code)') and ordered encodings alphabetically.

  • Allow user to specify encoding for CSV files on output tool.

  • Improved data conversion handling to not throw a warning instead of an error when a field is missing a value.

  • Fix issue where default value settings were occasionally not respected.

  • Disabled production logging to prevent permissions issues for different installations/configurations of Designer and support scheduled workflow functionality.

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 version 2.2.0 and later support Data Connection Manager 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 AMP engine enabled for the workflows which contain the OneDrive tools version 2.2.0 and later.

Custom Microsoft Azure API Application Setup

To set up a custom API application for this tool, see our guide.Set Up Microsoft Azure API Application