OneDrive Tools

[#1]

Microsoft OneDrive Help Page

OneDrive Input uses the Graph REST API to read files from OneDrive 365 and OneDrive Output uses the Graph REST API to write files to OneDrive 365. The supported file formats are XLSX, CSV, and YXDB.

Current version

OneDrive Tools v2.2.1 (December 14, 2022)

• Added support for certificates which contain special characters.

Previous versions 

OneDrive Tools v2.2.0 (September 9, 2022)

• Compatible with Designer and Server 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 in 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.

OneDrive Tools v2.1.0 (April 29, 2022)

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

OneDrive Tools v2.0.2 (December 23, 2021)

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

OneDrive Tools v2.0.1 (November 03, 2021)

• 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.

OneDrive Tools v2.0.0 (September 2, 2021)

• Built-in multitenant Azure App with an option to use custom Azure App (incl. 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.

OneDrive Tools v1.0.2

• Updated Code Page options.

• Distinguish between encodings with same language (e.g., ‘Language’ -> ‘Language (specific code)’) and ordered encodings alphabetically.

• Allows 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.

• Fixed 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.

OneDrive Tools v1.0.1

• Fixed issue preventing packages from being installed successfully.

OneDrive Tools v1.0.0

• Initial release for OneDrive Input and OneDrive Output.

This tool uses a .yxi file format. A .yxi file is a package that includes an Alteryx Tool and all of its dependencies zipped into a single file. When this file is imported into Alteryx, the tool is added to the tool palette in the category specified by the tool.

When sharing a workflow that uses a .yxi tool, the tool is not included and must be installed by the recipient.

[bneves_tim]

@AlteryxProducts , The Issue persists:

I have a call tomorrow with support to check it out.

Version: 2021.3.3.63061

[natalia_flood]

Does it works for you? I am trying to use it.

[bneves_tim]

@natalia_flood

1. First you need to setup the application on azure as the documentation: https://help.alteryx.com/20213/designer/microsoft-onedrive 
2. Install the most updated onedrive add on;
3. Create the registry as bellow: (According to alteryx support this registry step wont be necessary on new version (2021.4 / 22.1). Let's see.)
   1. I 'am using the 2021.3.3 version;
   2. You must be admin privileges;

   3. The PythonAllowHideEncryption key must be set on each user’s machine, as well as on all Worker nodes. Worker nodes must also have the tools (in this case, Sharepoint Files Input) installed.  The process is the same for a non-Admin install on the user's machine as it is for an Admin install.
      1. Create Key
      Administrators will need to create a new string value PythonAllowHideEncryption under the Alteryx Registry Key:

      1. Registry Key: HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\SRC\Alteryx
         Value Name: PythonAllowHideEncryption
         Value Data: true
      2. Steps to create the new key:
      1. Type regedit in Windows Start Menu
      2. Browse to the folder location: HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\SRC\Alteryx
      3. Right click and select New > String Value
      4. Set the KeyName to PythonAllowHideEncryption and the Value to true
      2. Gallery Interaction Changes
      The below descriptions assume that all users interacting with the Gallery have the registry key set to true.
      a. Uploading to Gallery: Encrypted values for the supported Python tools will be updated to a hide encryption once you publish to the Gallery.
      b. Running on Gallery: Only workflows that originated from machines with the registry key set will be able to run successfully on the Gallery. The worker nodes must also have the registry key set and the respective Python tools installed.
      c. Opening from Gallery: The original encryption method will be restored. These Python based tools might need to be reconfigured in order for the workflow to run.
      
      Once you've added the registry key to the local machine, server machine, and any worker nodes, you'll want to reauthenticate the tool.  

[andrewtcarlson]

I keep getting this error when trying to install it - any ideas as to how to resolve it? 

Best, 

Andrew

[Tybo]

@andrewtcarlson  Have you found a solution yet? I'm having this issue as well but for the SharePoint tools. 

[AndyCJ]

Yeah, I'm getting the same issue with Sharepoint and OneDrive tools - same error & grpcio version number?  Any joy on a resolution??

[jrobiso2]

Same error installing to version 2020.2.3

[mobasti]

Hi, I could install the addin without problem. However, the login via Internet explorer is not working. Any Ideas?

BR Sebastian

[jvernon]

I was unable to get this tool to work on Designer versions 2021.3 It installs, allows me to log in through the web but crashes designer when trying to save the tool settings.

[admusNets123]

Hi everyone,
I have followed the guide from Alteryx: Microsoft OneDrive | Alteryx Help

And everything seems to have been done in the right way, however, whenever I try to log-in I get this error. Has anyone tried this before?