Has anyone got to connect n8n either community or paid with SharePoint 2016/2016/SE on premises? Trying to see if I can use oauth, read cookies or is there a specific way to do so? Active Directoy is in Windows Server 2019 Locally.
Hey @Charles_M
No existing solution for SharePoint on-premises in n8n so far… The only practical workaround I found is SharePoint App-Only auth: register an app directly in your SharePoint at /_layouts/15/appregnew.aspx, grab the client ID and secret, then hit the SharePoint REST API via HTTP Request nodes. No ADFS or OAuth needed.
Let me know how it goes !
Hey the built-in SharePoint node in n8n only works with SharePoint Online through Microsoft Graph, so it’s basically useless for on-prem. The bigger problem is n8n doesn’t support NTLM authentication at all in the HTTP Request node, and that’s what SharePoint on-prem with local AD typically needs. Your best bet is probably setting up a small middleware service (even just a simple Node.js app using the httpntlm package) that handles the NTLM handshake and exposes a basic REST endpoint that n8n can hit with a regular HTTP Request node, it’s an extra moving part but it works reliably once it’s set up.
Appreciate both for answering. Will try making a service that handles authentication and see how it goes!