In-DB version of SharePoint tool

[KI5JEB]

I realize a true "In-DB" version of the SharePoint tool may not be possible due to the complexity and layers to get to an actual SharePoint Database. However, would it be possible to add some parameters for pre-filtering? O365 version of SharePoint has some timeout limitations that cause the SharePoint tool to fail randomly. If I could specify parameters (such as a date minus some number of days or hours on a particular date field) to filter the dataset. Or specify record ID ranges to pull records in batches, this would allow users to work around this issue.

[braggis]

SharePoint supports OData queries and either an In-DB tool or expansion of the SharePoint tool in Alteryx to allow an OData query would improve performance when working with Lists.

[KI5JEB]

@braggis Can you provide a working example showing how the SP tool can be expanded?

[KylieF]

Thank you for submitting your feedback to the Alteryx Idea product board!

We appreciate all the feedback we get and are working to review and respond to all ideas that have met the criteria to be brought to our product team. If you haven’t yet, please be sure to review our updated Submission Guidelines.