Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
ALTER.NEXT:

Join us on Dec 2 for a half-day virtual analytics + data science event!
US & CA customers only

SAVE YOUR SPOT
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
SOLVED

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

Highlighted
11 - Bolide

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

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

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

Highlighted
6 - Meteoroid

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

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

 

 

Highlighted
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

 

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

Highlighted
11 - Bolide
The server may not be setup to hit that path/folder.
Highlighted
8 - Asteroid
Check that you have WebDav installed and enabled on the server
Highlighted
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