Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How do I Output an Excel file to my SharePoint site?

Brad1
11 - Bolide

How do I Output an Excel file to my SharePoint site?

9 REPLIES 9
dataMack
12 - Quasar

Alteryx can write files to sharepoint sites - the trick is getting Alteryx/windows to treat sharepoint as a network drive location instead of a website.  You do this by using this convention:

 

\\sharepoint.yourcompany.com@SSL\DavWWWRoot\sites\yourSiteName\yourLibraryName

 

The ''@SSL ' is necessary if you are using HTTPS on the site.

Brad1
11 - Bolide

Thanks for your answer.

 

I own the SharePoint site so there shouldn't be an issue there.  It not https so I removed @SSL from:

 

\\sharepoint.yourcompany.com@SSL\DavWWWRoot\sites\yourSiteName\yourLibraryName

 

I get: Error creating the file "\\sharepoint[....]Networks": Access is denied.   [.....] is me leaving out the full addr.  Any idea?  Does http need to be in front of \\?

 

Thanks for any help.

nnickerson
6 - Meteoroid

Were you able to get this solved?  I'm having the same issues accessing Sharepoint server from Scheduler Server. 

Brad1
11 - Bolide

I'm not sure I have an answer to your question.  I do have an answer to mine. 

 

I was trying to push up an Excel file to my SharePoint Site that is http and not https.

 

The format is:

 

//sharepoint.Your_Company_Name.com/sites/Your_SharePoint_Site_Name/Your_Library_Name/Your_File_Name.xlsx|||Your_Sheet_Name

 

Note: do not add http: to the front of that path

and if you have a space in your Library Name or other parts of the path then you need to add   %20   where the space would be.

 

Good luck.

 

 

nnickerson
6 - Meteoroid

It works find from my PC, but when running on a server, I'm getting an error: cannot access the folder:

 

Here's my filename:

 

//sharepoint.myorg.com/departments/deptname/Reports/page/filename.csv

 

AndrewK
7 - Meteor

@nnickerson I am running into the same problem. Works on my PC but not in the server. 

 

So far I have tried the following. 

Running with my credentials

Granting access to the Alteryx server service account

Replacing Spaces with %20

 

I sill get an error saying the folder cannot be accessed.

 

Any other ideas? 

Brad1
11 - Bolide
The server may not be setup to hit that path/folder.
JTCairns
8 - Asteroid
Check that you have WebDav installed and enabled on the server
JDong
8 - Asteroid

Hi @dataMack @Brad1 @JTCairns @AndrewK @nnickerson 

 

I was able to configure the Sharepoint output path as shared by dataMack.

 

My question is I am unable to schedule this on a weekly basis, when I push the flow to gallery it does not work. Is there a way to resolve this ?

 

Also in my company I need to first authenticate the Sharepoint link on Internet explorer for the first time and only then does the flow work.

 

Any guidance here would be valuable.

 

Thanks in advance

Labels