On-prem sharepoint connection

Hi ​@LAHCEN AGLAGAL ,

Connecting Automation Anywhere to on-premises SharePoint using only user credentials (User ID and password) can be tricky, as most Automation Anywhere SharePoint packages are designed for cloud-based SharePoint and rely on OAuth or app-based authentication. Here's what you need to know and some potential workarounds:

Automation Anywhere’s SharePoint package is built primarily for SharePoint Online and uses OAuth or app-based permissions for authentication. On-premises SharePoint (e.g., 2016/2019) typically doesn’t support OAuth in the same way unless configured with server-to-server (S2S) trust or claims-based authentication. The Authenticate action in Automation Anywhere requires a tenant ID or OAuth connection, which isn’t available in a basic on-prem setup.

1. Use REST API with HTTP Package

If your SharePoint on-premises instance exposes REST endpoints and supports basic authentication:

• Use the HTTP package in Automation Anywhere.
• Set up a Basic Auth header using your username and password.
• Send requests to endpoints like:

  http://yoursharepointserver/_api/web/lists
  

• Make sure the SharePoint server allows basic auth and CORS (cross-origin requests).

2. Use PowerShell Bridge

If REST isn’t viable:

• Write a PowerShell script that performs the SharePoint operations (upload/download files, read lists, etc.).
• Use Automation Anywhere’s Run Script or Command Prompt action to execute the PowerShell script.
• Pass parameters (like file paths or list names) from the bot to the script.