This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
When a user/admin installs the One-Drive tool, the installation starts and errors with the following error message on the Alteryx Designer:
Any version which is 2020.3 or below
Affects all the Python based Data Connectors
Azure Data Lake Store
Salesforce 4.0 and above(Python based)
This is a known issue(DE28032) - which is caused because of the missing cryptography version on the requirements.txt file.
Please note - This error can occur for any Python based Data Connectors like - Google BigQuery, DynamicsCRM, ADLS, OneDrive, PowerBI, Salesforce 4.0 and above
Following steps are the workaround, in order to resolve the issue. Please note - As this error can occur to any of the python based Data Connector tools, you may need to edit the "requirements.txt" file for the Input or Output based connectors, for each category.
For example, Google Big Query, ADLS, OneDrive, Salesforce - all these python based tools have both Input and Output connectors, and each of the input/output folders have their own requirements.txt file, which you need to edit to fix this error.
Create a new folder(for example - OneDriveTool) and place your downloaded .yxi file(in this case one_drive_v1.0.2.yxi)
Ensure that you are able to see the file extension on this yxi file. If you do not see the .yxi extension, you may need to enable "File name extensions" check box under the "View" menu of the File Explorer:
Rename this .yxi file to .zip file, by right clicking and renaming the extension, as below:
Once it is renamed to .zip file, right click and extract all files in this folder location:
You would see two folders - One for Onedrive Input and the other for OneDrive Output. Please note - you need to make the changes from the below steps 1 and 2 for both the OneDrive Input folder and the OneDrive Output folder.
Navigate into the newly extracted folder(OneDrive Input and OneDrive Output) and locate the rquirements.txt and open it
Add cryptography==2.9.2 to the first line and save it
Please apply the above change for the OneDrive Input and OneDrive Output folders - i.e - you would be editing the same file(requirements.txt) in each of the OneDrive Input / Output folder.
After saving, select all the files on this OneDrive folder, where you have the extracted files, right click and select "7-zip" --> "Add to one_drive_v1.0.2.zip" to rezip the changes.
This will archive all the extracted files into a new zip file. Now, rename this zip file, to .yxi, as below:
After renaming, reinstall the tool set by re-running the .yxi file installer