Sharepoint Files Input Tool not able to schedule

[MartWClimber]

I've got a workflow with an Sharepoint Files Input tool in it.

the tool gets data and processes this downstream.

When I run this in Designer the WF run's just fine but after I schedule the same workflow I get an error

Error: SharePoint Files Input (1): Failed to authenticate.

How can I make sure that the Scheduler also uses the sames valid credentials to authenticate against the sharepoint environment?

I'm using the SharePointFiles_v1.1.0.yxi version because the latest version starts from version 3.4 (we got 3.3)

[fmvizcaino]

Hey @MartWClimber ,

Take a look at this suggestion from Alteryx support and check if it works.

Instructions from Alteryx Support:

The SharePoint Files connector is a Python-based connector, so it will require the following registry key to exist in both the end users 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 

 
Once this key has been added, the user would need to reauthenticate the Salesforce tool on his workflow in Designer and republish the workflow to gallery.

Best,

Fernando Vizcaino

[MartWClimber]

@fmvizcaino can you give me screenshot of what i need to do?

I've opened up the Registry Editor en gone to WOW6432NODE/SRC/Alteryx

after that i've right clicked and then on the right side a new row appiers.

the options what do I need to fill in?

Columns I got are Name, Type, Data

Name: New Value#1

Type REG_SZ

Data: empty

[fmvizcaino · Accepted solution]

@MartWClimber 

1. Select string value after right-clicking.

2. Right-click and rename to PythonAllowHideEncryption 

3. Double-click and include true as value

[MartWClimber]

@fmvizcaino on the server VM I got this created. on the designer VM I get the following Error 

I still tried an run it but with no Luck. I still got the same Error.

Does this mean that I also need to create a registry entery on the designer VM too for it to work?

EDIT:

on the server VM I can schedule a WF with the credentials and everything runs.

[fmvizcaino]

@MartWClimber , 

Yes, you have to do in both machines. I suggest you testing and publishing from the designer on the server machine and if that works, you go after debugging the registry issue

[raychase]

@fmvizcaino - what exactly does this registry change do?  I've tried researching it, and there doesn't appear to be a plethora of information readily available.

[lzanotti]

hi Community, 
hope you are well.
we have different workflows which uses SharePoint Input/Ouptut tool and works perfect loacally in Designer. 

However when publishing in the gallery (even though deployment is successful) the run from the server generates error on SharePoint "Failed to authenticate". 
The steps we have done so far is to install a regedit key as explained here but again with not avail. 

The tool itslef uses the Sign-in browser option but now we may try to use the Client/Tenant Secret: we are awaiting our IT dept to provide these.  

Do you know if the Sign in browser should work anyway, is there any step we may have missed? 

Thanks

Luca

[fmvizcaino]

Hi @lzanotti ,

I could be mistaken here but from what I know, these are the options you can use on the gallery.

Best,

Fernando Vizcaino

[lzanotti]

Hi Fernando, 

many thanks to get back to me on this. 

Unfortunately option 3 does not work, it continues to return error 401 even though I am quiet confident the URL is ok and also the username pwd. 

We are exploring option 2 now but waiting our IT dept. get back to us. 

Thansk

Luca