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? 

[kgalbert]

When I output to excel onto OneDrive my dates come out 70 years into the future.  Looks like this was a bug that was fixed in the SharePoint and Tableau output tools.  Is there a work around for this?

Update: Figured this one out myself.  This only happened to me for Date data type fields.  Not for DateTime.  I switched the Date fields to String and they come out not 70 years in the future.

[aehrenwo]

I recently installed the most current version fo the OneDrive tool, and I am getting this error when I try to run after successfully connecting and referencing a CSV file. 

we are on Alteryx Designer 2022.1-- is that the issue? 

Error: OneDrive Input (3): local variable 'no_of_records' referenced before assignment

Seems like a python error. Any suggestions? download older version?

[sophiadocimo]

Hello - I've recently installed the OneDrive tool, but seems that the Login via browser doesn't work, it keeps loading and nothing happens, it won't open any browser window. Has anyone had this issue before? How did you solve it? 

[MariaEduarda]

I was using the onedrive tool input with the version 2.2.1 and I had the same issue :

Error: OneDrive Input (3): local variable 'no_of_records' referenced before assignment

When I was trying to understand the problem I discovered that my excel file had a configuration problem with the authenticator. So , I changed the file and  the tooll returns to work. 

Try to look the warning log when you run your workflow to see if there is some problem with the file. 

[bo_peng2022]

OneDrive v2.2.1 when trying to setup DCM, no technology available to select from, thus unable to run on server, anyone has this issue and is there a workaround?

[Amit_G_Limbasia]

I have Sucessfully connected, DCM With one drive. Can you plese revert error what you get in details then I am ready to help. for bo_peng2022