Unable to output CSV to Sharepoint

I've been working on a use case with one of our business users and can't seem to find cause/solution to this error.

The workflow is solid. It builds a data set that gets divided into separate CSV files, by date, when being saved.

The problem is saving them though. He needs them saved to a Sharepoint document library.

Output is set to \\ourcompany.sharepoint.com\thisdepartment\thatlibrary\Filename{%date for group of output%}.csv

When run on a desktop - no problem.

When run in desktop scheduler - again, no problem.

But, when run from the server's scheduler: "Cannot access the folder \\ourcompany.sharepoint.com\thisdepartment\thatlibrary\."

Thought it was a permissions issue with the server running under its own service account so we added the server's account to 'full control' level of permissions for this library. That didn't make a different.

We tried a number of other things, like sending it through DavWWWRoot, but that didn't help either.

At our organization, even if it's our server we cannot access it. We have to send a request through IT. So, for the most part we don't have much visibility to the Alteryx settings.

Our one attempt thus far to resolve this ended by IT advising that they prefer we not output directly to the Sharepoint and instead use a DFS which is mapped to Sharepoint. But, they couldn't actually advise us on how to do this...

1. What Alteryx server setting should we be looking at?

2. Does anyone have a creative workaround?

3. I'm not experienced with Sharepoint and couldn't find any postings online elsewhere than matched up with IT's recommendation. Does anyone have experience mapping a DFS to Sharepoint?

Publish

Settings

Output

Sharepoint

Accepted answers

michael_treadwell

I've experienced a similar issue but it did not involve SharePoint. I am going to share it in case it helps but I am not 100% sure it will be a solution.

For us, the fix was in the server Run As account. Do you have the server setup to use a Run As account? If so, try removing that and setting up the actual AlteryxService to run as the account you wish: https://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/sys_srv_logon_user.mspx?mfr=true

All comments

michael_treadwell

I've experienced a similar issue but it did not involve SharePoint. I am going to share it in case it helps but I am not 100% sure it will be a solution.

patrick_mcauliffe

Thanks.

That is sort of what I was afraid of hearing.

We can't make that modification due to IT policy.

We have an account set up to Run As (the service account IT gave us specifically for the server). But, IT ultimately controls the permissions on that account.

Our IT security is top notch, which is usually good but can have its disadvantages as well. This would be one of those.

BobR

I'm getting the same error as the original poster, but its not due to the reason mentioned in the solution.

It seems as though alteryx is doing a permission check before it writes, its good, but seems to be incompatible with sharepoint. It only seems to be doing this when run from my company's gallery and not when run directly on the desktop. Example...

This is what is configured in the output tool. This works when run on the desktop.
\\server.net@SSL\DavWWWRoot\sites\spz342t\DropZone\File.csv

The error I'm getting from alteryx is that it can not access this path. See the \. tacked on the end.

\\server.net@SSL\DavWWWRoot\sites\spz342t\DropZone\.

If you try to get to these locations using windows explore the one with \. fails as well. Whereas if I just go to \\server.net@SSL\DavWWWRoot\sites\spz342t\DropZone it works fine.

It seems to center around how alteryx does the permissions check and this seems to be different if run in gallery vs on the desktop.

Any help would be appreciated.

patrick_mcauliffe

@BobRhave your Sharepoint admin check permissions. It sounds like the Alteryx server's service account isn't allow to access.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703