topic SharePoint connection issue - Token request failed in Alteryx Server Discussions

SharePoint connection issue - Token request failed

trzeciakwojtek — Fri, 27 Jan 2023 19:37:10 GMT

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

Re: SharePoint connection issue - Token request failed

gabrielvilella — Fri, 27 Jan 2023 20:46:58 GMT

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-failed/td-p/766668

Re: SharePoint connection issue - Token request failed

trzeciakwojtek — Fri, 27 Jan 2023 21:36:08 GMT

Re: SharePoint connection issue - Token request failed

gabrielvilella — Fri, 27 Jan 2023 21:38:45 GMT

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