community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

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

Bolide

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

Quasar
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.

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.

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

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.

 

 

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

 

Meteoroid

@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? 

Bolide
The server may not be setup to hit that path/folder.
Asteroid
Check that you have WebDav installed and enabled on the server
Labels