Sharepoint Connector Error-Authentication Fail/ Connection to platform was not successful

Question

Does anyone have a list of the sites that the Sharepoint Connector accesses during the connection with Sharepoint?  I've been struggling with this for over a month and have been on several calls with Alteryx support and my IT group.  At this point, both sides are pointing at each other for next steps.

Here's the stats of what I have:

* I'm currently using Designer 2022.3.1 and Sharepoint Connector 2.3.0 and using Sharepoint 365
* We have set up the proper authorizations with Azure. 
* We have added the Sharepoint .cert files to the main.pyz file by changing it to a .zip but NOT unzipping the file and deleting the .shiv folder, etc.
* I'm attempting to use the Custom App Authentication method with a Tenant ID, Client ID and Client Secret.
* I can navigate to the site and the folders/files on the site.  However, when I try to bring in a list of the files on the site or a single file I get different messages depending on if I'm going through our Proxy or if I have it off.  However, they basically boil down to the Authentication Failed.
* We've been using Fiddler to try to determine where the blocks are, but we aren't making much progress with that.

IT has lifted the following sites in trying to determine where the block is:

* mobile.events.data.microsoft.com
* *mobile.events.data.microsoft.com
* *.mp.microsoft.com
* whitelist.alteryx.com
* substrate.office.com
* graph.microsoft.com

Since these look like generic sites, I thought I'd see if anyone else has a list of sites that caused them trouble.  Or was there anything else that you did to get it to work?

AA_alteryx · Answer

I have been facing the same issue, connected with the Alteryx team frequently but is not of much help with respect to the fix so far.
I am able to connect and get the results on Designer(v2022.1.1) but when the same workflow is published on Gallery, and run from their it throws Auth error. I have tried multiple version but currently keep switching Sharepoint v2.6.2 and v2.4.1.

I need solution with respect to the Gallery run auth issue. Already tried almost all Alteryx documentations which tried covering this issue but nothing works

Have already tried DCM option(Alteryx team suggested), Service Principal(SP) with DCM doesn't work but connecting normally using OAuth or SP without DCM works on Designer but not on Gallery.

Any suggestions will be appreciate which can fix this server auth issue.

image.png

lwolfie · Answer

It's now working when I use the latest connector.  Alteryx changed the way they connected to SharePoint in the 2.4 version which works better.  I haven't attempted to roll this out onto server though.

timandrews72 · Answer

Did you get anywhere with this? I am having the same challenges. There seems to be multiple posts around this but none have a answer and alot refer to server (I am trying first to even just get it to run in designer then will face the server when we get this working)

Any help is much appreciated as am also having back and forth with IT and Alteryx support.