Skip to main content

Hello Community,

I'm looking for a way to connect to SharePoint from Automation Anywhere. The SharePoint I'm dealing with is on-premises, and I only have the user credentials (User ID, password).

Can you help me with this?

Hi ​@LAHCEN AGLAGAL  - This might help you.

 

 


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.

thanks ​@Padmakumar  ​@madhu subbegowda  for your support 


Reply