Support for Connector to SharePoint List behind Claims-Based Authentication

[Scott_Snowman]

Request: Currently Alteryx does not support a connector to SharePoint lists if those lists are on SP sites with claims-based authentication. Please add in this functionality so data can be imported directly into a workflow.

Rationale: Claims-based authentication can be used in situations where two workgroups (or companies) want to collaborate on information housed in a SharePoint list. The claims-based authentication allows for both "internal" and "external" consumers of the information to access the SharePoint site, perhaps with different permission levels.

However, if information is placed in a claims-based authenticated site, it cannot be accessed directly in Alteryx. Using the data in workflows becomes extremely difficult without cumbersome workarounds. The power and flexibility of Alteryx workflow scheduling, analysis, reporting, and notifications should be extended to cover data in all SharePoint sites.

Sample Use Case: I maintain a SharePoint site / list for vendors to report in on the status of projects we have assigned them. The site uses claims-based authentication to enable the vendors, who are not employees of our company, to access and update the list.

SharePoint's built-in workflows are adequate for notification and updating when a new item is added, or an item changes. However, I often want to obtain and send out snapshots of the data as they stand: how many items are open, how many have recently been closed within SLA, etc. This cannot be done within the SharePoint platform without extremely convoluted means and potentially tying up resources on the SharePoint server.

Alteryx has the perfect tools for easily performing this analysis and sending notifications to stakeholders -- and when using the Gallery scheduler, it can do so on an automated basis. However, without direct import into Alteryx from SharePoint, I need to have scheduled exports to an intermediary Excel file. Said intermediate export has issues with authentication, which would be resolved with a SharePoint connector that authenticates with saved credentials every time.

[amruta]

True, Alteryx should start supporting SharePoint with Claims based authentication. Its a high demand request from VIZIO

[Community_Admin]

The status of this idea has been changed to 'Inactive'. This status indicates that:

1. The idea has not had activity in the form of likes or comments in over a year.

2. The idea has not reached ten likes.

3. The idea is still in the 'New Idea' status. 

However, this doesn't mean your idea won't be implemented! The Community can still like and comment on this idea. With enough renewed interest, this idea can be brought back into the 'New Idea' status. 

Thank you for contributing to the Alteryx Community and the Alteryx Product Idea Boards!

[Stuart_Nulty]

Definitely could have done with this functionality. Doing a data migration currently and having to look at a lot of workarounds to get Shaprepoint into Alteryx using this Auth method.