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

alteryx server Ideas

Share your Server product ideas - we're listening!
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More

Enable Scheduler to read SharePoint Excel files

Many people maintain valuable information in Excel files, and many organizations, like ours, also use SharePoint to store and share structured and unstructured information. We see most user-generated and maintained data in Excel files in SharePoint document libraries, and one of the great benefits of Alteryx is the ability to join that Excel data with other data sources.  Unfortunately, the v11.0 Scheduler cannot resolve the UNC-style ( \\server@SSL\DavWWWRoot\site-name\document-library\filename ) addresses, so workflows that access this valuable SharePoint Excel data must be run manually. The SharePoint List Input tool can read the list-style metadata for Document Library files, but does not access the file content.

The Scheduler should be enhanced so that scheduled workflows can read Excel data stored in SharePoint Document Libraries. 

6 Comments
Atom

+1 for this functionality.

 

We have a very similar problem. Our Alteryx Scheduler/Worker throws a File not found error when running a scheduled workflow that involves an Excel file in a SharePoint folder, even though that same workflow runs flawlessly when done manually.

This needs to be supported

Meteor

This is a common use case shared amongst many enterprises based on previous interactions.

This would be great! Has this been incorporated yet?

Meteor

Have run into this exact problem today, workflow accesses a file on a sharepoint, workflow runs fine in Designer but returns an error. (redacted below)

 

Invalid Directory "\\xxxxxx.net@SSL\DavWWWRoot\sites\xxxxxxxxxxx\Shared Documents\*.xlsx": The network path was not found. (53)

Moderator
Moderator
Status changed to: Not Planned

Thank you for posting to the Community! I'm updating this idea to not planned, as unfortunately this issue is outside of Alteryx's control. The source of this issue is due to a Windows limitation that causes Server to be unable to input information into the related dynamic Windows pop-up. Windows would need to update how their pop-up behaves to accept Server input to correct this issue.