ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
The Alteryx Community will be temporarily unavailable for a time due to scheduled maintenance on Thursday, April 22nd. Please plan accordingly.

Alteryx Designer Discussions

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

SharePoint list Input fails in Gallery

MichalK
8 - Asteroid

Hi,

 

I have a workflow that reads data from a sharepoint list, does some calculations and then updates a database.

It's working fine when I run it in Designer - but when I uploaded it to Gallery, it fails with error 'Could not create SSL/TLS secure channel'.

 

Is there anything in the server setting that might be missing and cause this, or could there be any other explanation?

 

Thanks, Michal

rafalolbert
11 - Bolide
11 - Bolide

Hi @MichalK,

 

This suggest that your server is potentially missing some SSL certificates and is not authorising your Alteryx connection.

 

I've been working with both technologies for the past few years and have never come across this one.

 

I'm aware of some other limitations like 5K for a single data pull, funny behaviour with lists with many fields etc., but my setup has never created such error.

 

What i would do myself (this is provided i have server access), i would go to server remotely and try navigating to your SP site via browser and see if this is working fine, my theory is that it will not work and most likely you'll need to work with your support team to address this security element before resolving your Alteryx connectivity issue.

 

Powodzenia! 🙂   

 

Thanks,

Rafal

 

#Excuse me, so you speak Alteryx!

 

 

MichalK
8 - Asteroid

Thanks!

Do you know how the connection works in the background? The tool requires entering access credentials (which I'm passing as App parameters), does the server worker need access to that sharepoint anyway?

 

Michal

rafalolbert
11 - Bolide
11 - Bolide

Hi @MichalK,

 

Most likely the Alteryx tool runs RESTful APIs behind the scenes.

 

Based on the limitations i've mentioned in my previous post, i've actually develop SP connectivity myself from ground up using Microsoft APIs.

 

This is simply because there were many limitations with out of the box tools, for example the 5K limit, connectivity for library interaction including file upload and download and few others.

 

I explained this not long ago in this post: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Sharepoint-List-Threshold-Exceeded-whe...

 

I'm also planning to create macros for the same and publish on the Public Gallery for everyone to consume in an app encapsulated format, but this may still take a few weeks until i fully QA this and release.

 

Thanks,

Rafal

Anuj
8 - Asteroid

hi @rafalolbert ,were you able to create these macros.. we keep getting intermittent SSL errors when downloading files from Sharepoint. 

AinsleyHarriott
5 - Atom

I had this exact issue and resolved it by ensuring that the correct SharePoint Version was selected in the SharePoint List Input tool.

 

This had been set to 2007 and ran fine when running from Designer but caused the "Could not create SSL/TLS secure channel" error when running from the Gallery. Once updating the SharePoint List Input tool SharePoint Version to the correct version of SharePoint (2016), it now runs from the Gallery.

Labels