Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,176 questions
Authenticate an API call with Entra ID from VBA
Enrico Rossini
201
Reputation points
My company uses lots of Excel files and, until now, we read the database directly to manage the data. To access the database, we use a connection string. The issue is we want to distribute to clients this spreadsheet.
So, I have created some APIs to share those data and put them behind Azure API Management. The Azure API Management can authenticate the users again the Microsoft Entra ID. For all users, the MFA authentication is enabled. My idea is that the user has to authenticate himself or herself before calling the APIs.
What I can't find how to do is the call from Excel VBA to the APIs and the authentication.
For example, when I use Swagger, if I click the Authenticate button, it redirects the user to the Microsoft authentication page and sends back the token. How can I implement the same process in Excel?
Sign in to answer