Fail to upload SharePoint Connection tool to Alteryx Server

[dreldrel]

Hi there,

I'm trying the new SharePoint tools. But it shows there are one or more errors that occurred when I uploaded it to Alteryx Server. Is there any possible reason causing this?

It's just a simple workflow with SharePoint Input and Output

Many thanks in advance

[gabrielvilella]

You need to have those custom connectors installed on the Server. Please contact your Server admin and make sure that they are installed for all users. 

https://help.alteryx.com/current/server/install-custom-tools 

[PanPP]

Hi @dreldrel 

In order to utilize the same SharePoint tool, it will need to be installed on the Server machine. Following the steps below will ensure the tool is installed properly.

1) Run Designer as admin on Server machine

2) Click File top left in designer

3) Click Open workflow

4) Browse to the .yxi file to install the tool for all users.

Below are the directories for the tool installation:

Client machine (non admin install) - C:\Users\username\AppData\Roaming\Alteryx\Tools

Server Machine (Admin install) - C:\ProgramData\Alteryx\Tools

You may also need to add a registry key on your machine and server machine.

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 

 

Hope this helps. If it does, please like the post and mark it as a solution.

[dreldrel]

Hi all, it turns out the uploading issue comes from the version of Alteryx Designer.

I followed your steps and the admin successfully downloaded the SharePoint connector. The thing is that it shows failed to authenticate when I ran the workflow on the server. The workflow runs well on the Designer side. Any idea about it?

[PanPP]

Hi @dreldrel 

Did you implement the registry edits on your machine, server machine, and all worker nodes associated with the server machine?

I think that will resolve the issue. 

[gabrielvilella]

Please make sure that you are authenticating via Client ID, Secret and Tenant ID or Username, Password and URL