We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.

SharePoint connection issue - Token request failed

trzeciakwojtek
7 - Meteor

Hello Everyone, 

 

Workflow runs perfectly fine in designer. Tokens work perfectly fine. Just does not run when run in gallery. 

 

Just in case, I already created new tokens using Microsoft's procedure: Granting access using SharePoint App-Only | Microsoft Learn

Still no success. 

 

There's a potential workaround (linked below) that I've been considering which involves created a generic email for my team, and a password. This way we can avoid using the tokens, which fail. Has anyone been able to successfully go work around this "Token Failed" issue? 

 

Alteryx Designer: Sharepoint List Input Tool: Erro... - Alteryx Community

 

trzeciakwojtek_0-1674847854450.png

 

3 REPLIES 3
gabrielvilella
14 - Magnetar

You might also make sure that you have done the following:

The SharePoint Files connector is a Python-based connector, so it will require the following registry key to exist in both the end-user's machine as well as each worker node on the server.  

Type regedit in Windows Start Menu  

Browse to the folder location: HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\SRC\Alteryx  

Right click and select New > String Value  

Registry Key: HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\SRC\Alteryx  
Value Name: PythonAllowHideEncryption  
Value Data: true 

 

And here is another article that might help:

https://community.alteryx.com/t5/Alteryx-Server-Discussions/SharePoint-List-Input-SPO-Token-request-...  

trzeciakwojtek
7 - Meteor

trzeciakwojtek_0-1674855362207.png

 

gabrielvilella
14 - Magnetar

You need permission to do that probably. I’d contact IT.