Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Microsoft Onedrive Tools seem to not work, even after following Alteryx tutorial

TheOC
15 - Aurora
15 - Aurora

Hello!
I am currently trying to get the Microsoft Onedrive tools working - and have been following this tutorial by @JakeS (https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-One-Drive/ta-p/299125)

I have the latest version of the tools, and just for sanity going to take you through the steps on the tutorial that I have taken as documented in the tool mastery:

1. Go to the Azure Application Registration Portal

2. When prompted, sign in with your account credentials.

TheOC_1-1628509343849.png

 

3. Select "New Registration":

4. This will prompt you to enter a name for the application, the supported account types, and the redirect URI. Select either of the multitenant options (You may have to work with your Azure admin to determine which will be best for you) and enter https://login.live.com/oauth20_desktop.srf as the redirect URI. This is required for the OneDrive tools to connect.

TheOC_2-1628509484497.png

 

5. Once the app is created, an application ID will automatically be created. This is the Client ID that is used in Alteryx to login to the app:

TheOC_3-1628509528415.png

 

6. If you are using the application for a OneDrive Business account (organization account) you will need to generate a client secret. This will be entered as the Secret Key when logging in from the OneDrive tool in Alteryx:

TheOC_4-1628509586652.png

 

7. Next, you will have to set permissions for the application. You can access API permissions for the application from the application "overview page":

TheOC_5-1628509745173.png

 

 

Business: For OneDrive Business Accounts, you will need both a Client ID as well as a Secret Key that is associated with the application:

TheOC_6-1628509826128.png

 

Once you provide the application credentials, A new window will pop up, and you will be prompted to log in to an account that has access to the OneDrive:

TheOC_7-1628509868106.png

 

so all steps appear to be configured correct at this stage, but I get this error:

TheOC_8-1628509877543.png

 

This suggests it should not be a web application, and instead a single page application as specified in step 4. No problem, I'll go change this:

TheOC_9-1628509986875.png

 

 

So i delete the web URL, and add it as a single page:

TheOC_11-1628510042391.png

 

try again, and i get this error:

TheOC_12-1628510066740.png

 

Okay so proof key for code exchange is required?

 

There is so little on the internet about this, the closest being an article stating I need to go back to a 'web' based redirect url:
https://stackoverflow.com/questions/64692600/aadsts9002325-proof-key-for-code-exchange-is-required-f... 

Which obviously takes me back to error 1. 

 

This seems to suggest to me that the tools are just broken/outdated, however as far as I am aware people are still using them. Any advice on this would be massively appreciated!

Thanks,
TheOC

 


Bulien
2 REPLIES 2
JoshML
Alteryx
Alteryx

This is the result of a current known issue with the OneDrive Tools. For anyone else currently experiencing this particular behavior, you can contact Alteryx Support and reference item DE29345.

VojtechT
Alteryx
Alteryx

Hi @TheOC , can you try the new version of the OneDrive tools

Vojta T., PM for Data Connectors
Try our Beta data connectors at https://bit.ly/3Ae8HgY
Labels