topic Re: Microsoft SharePoint API Connectivity Issue in University Forum

Microsoft SharePoint API Connectivity Issue

prateekgrover — Mon, 28 Nov 2022 07:59:17 GMT

We are facing an unexpected issue for one of the BOTS while connecting with the SharePoint via API.
While the same code is working on the other BOTS, it is failing in this BOT. Can someone pinpoint what exactly is wrong with this BOT .
Please find the error listed below:
ERROR: System Exception : Unexpected error Error during Web API HTTP Request
HTTP Status Code: 403
_HTTP Response Content: {"error":{"code":"accessDenied","message":"Access denied","innerError"...

Re: Microsoft SharePoint API Connectivity Issue

ewilson — Mon, 28 Nov 2022 14:30:55 GMT

@prateek grover,

Are all bots using the same credentials to connect via the API or are there different client IDs for each one?

Cheers,
Eric

Re: Microsoft SharePoint API Connectivity Issue

prateekgrover — Sat, 03 Dec 2022 04:52:23 GMT

@ewilson Yes all the BOTS are using the same Client ID and Client Secret. Just the BOT ID and Password Differs.
Also the BOT was recently updated to M365 version. Do you think it might have lost some relevant access regarding SharePoint due to the upgrade?

Regards,
Prateek

Re: Microsoft SharePoint API Connectivity Issue

ewilson — Mon, 05 Dec 2022 15:34:59 GMT

Hi @prateek grover,

Since the only difference appears to be the user ID and password of the bot, I would agree that it seems there's a permissions issues or something similar related to that specific user account. Definitely review the permissions on the SharePoint site for that user.

Cheers,
Eric