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.
