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.