topic Re: Fail to upload SharePoint Connection tool to Alteryx Server in Alteryx Server Discussions

Fail to upload SharePoint Connection tool to Alteryx Server

dreldrel — Thu, 15 Dec 2022 13:20:27 GMT

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

Re: Fail to upload SharePoint Connection tool to Alteryx Server

gabrielvilella — Thu, 15 Dec 2022 14:18:21 GMT

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

Re: Fail to upload SharePoint Connection tool to Alteryx Server

PanPP — Fri, 16 Dec 2022 17:24:25 GMT

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.

Re: Fail to upload SharePoint Connection tool to Alteryx Server

dreldrel — Fri, 16 Dec 2022 16:15:01 GMT

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?

Re: Fail to upload SharePoint Connection tool to Alteryx Server

PanPP — Fri, 16 Dec 2022 17:24:06 GMT

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.

Re: Fail to upload SharePoint Connection tool to Alteryx Server

gabrielvilella — Fri, 16 Dec 2022 18:27:03 GMT

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