Skip to main content

NTLM Authentication for SharePoint

The Download tool allows you to download data from Microsoft SharePoint 2016 and 2019 using the NTLM (New Technology LAN Manager) authentication. This method is only supported with DCM.

Set Up the NTLM Authentication

To connect using the NTLM authentication…

  1. In SharePoint, go to the data you want to download.

  2. In Settings, find the Web Address. For example: https://my.sharepoint.com/sites/MySite

  3. In Designer, add a Text Input tool to the canvas, and connect a Download tool to it.

  4. In the Text Input tool, name the first column, such as URL, and paste the copied web address without its domain in the first cell of that column. For example: /MySite

  5. In the Download tool, select the Use Data Connection Manager (DCM) checkbox to set up the connection.

  6. Select the Set Up a Connection button. This opens DCM.

  7. In the New Data Source window, Technology is preset to URL for Downloading.

  8. Enter the Data Source Name of your choice.

  9. In Base URL, paste the domain of the copied web address. For example: https://my.sharepoint.com

  10. Select Save. This adds the Connections options to the window.

  11. In Authentication Method, select NTLM.

  12. Choose the authentication type.

    Implicit: In the Credential dropdown, select the X icon to withdraw from using any credentials. This type uses the Windows integrated credentials. Therefore, the corresponding Windows user must have access to SharePoint.

    Explicit: In the USERNAME AND PASSWORD options, select your Credential, enter your Credential Name, Username, and Password. Then, select Create and Link to use your credentials explicitly.

  13. Select Connect to use your preferred authentication type.

  14. In the Download tool > URL > Field options, select the name of the column of the Text Input tool. For example: URL

  15. Run your workflow.

Nota

The tool might return the HTTP/1.1 401 Unauthorized message. If you see this message, search the whole response header for the HTTP/1.1 200 OK message to confirm the authentication success.