MCP
A2ARegister Your Application in Microsoft Entra ID
To connect Microsoft Excel with StackOne, you need to register an application in Microsoft Entra ID to obtain OAuth 2.0 credentials.
Sign in to Microsoft Entra Admin Center
Sign in to the Microsoft Entra admin center as at least an Application Developer. If you have access to multiple tenants, click the Settings (gear) icon in the top-right corner, then select the desired tenant from the list under Directory + subscription.
Create a New App Registration
Navigate to App registrations by searching from the top search bar and click on New registration.
- Enter a meaningful Name for your app (e.g., StackOne Microsoft Excel Integration).
- Under Supported account types, select Accounts in this organizational directory only for single-tenant use, or Accounts in any organizational directory if you need multi-tenant access.
- Leave the Redirect URI field blank for now — this will be configured in the next section.
- Select Register to create the app registration.
Copy the Application (Client) ID
After registration, you’ll be directed to the application’s Overview page. Copy the Application (client) ID value and store it securely for use later.
Configure Redirect URI
Set up the OAuth 2.0 callback URL to enable authentication flow between StackOne and Microsoft Excel.
Navigate to Authentication Settings
From your app’s Overview page, select Authentication (Preview) from the left menu under Manage. If you are using the older UI, this may appear as Authentication.
Add Platform Configuration
Click Add a platform, then select Web. If you are in the Preview experience and don’t see Add a platform, add the Redirect URI directly in the Redirect URIs section instead.
Set the Redirect URI
In the Redirect URIs field, enter the StackOne OAuth callback URL https://api.stackone.com/connect/oauth2/microsoftexcel/callback and click Configure.
Configure API Permissions
Grant your application the necessary Microsoft Graph API permissions to access Excel workbooks.
Open API Permissions
From the left menu under Manage, select API permissions.
Add Microsoft Graph Permissions
Click Add a permission, then select Microsoft Graph.
- Select Delegated permissions to view the list of permissions.
- Add Files.ReadWrite to allow reading and writing Excel workbooks.
- Optionally add Files.ReadWrite.All and Sites.ReadWrite.All for broader access.
- Click Add permissions to save.
Grant Admin Consent
Click Grant admin consent for [tenant name] and select Yes to consent on behalf of all users in your tenant. After granting, verify that Granted for [tenant name] appears under the Status column.
Generate Client Secret
Create a client secret that will be used to authenticate your application.
Navigate to Certificates & Secrets
From the left menu under Manage, select Certificates & secrets.
Create a New Client Secret
Under the Client secrets tab, click New client secret.
- Add a Description (e.g., StackOne Integration Secret).
- Select an expiration period.
- Click Add.
Copy the Client Secret Value
Immediately copy the Value of the newly created client secret and store it securely for use later. This value will only be shown once and cannot be retrieved again.
Creating the StackOne Connector Profile
To create the Connector Profile in StackOne for Microsoft Excel:Navigate to Connector Profiles
Create New Connector Profile
- Click + Connector Profile
- Search for and select Microsoft Excel
- Select Type as OAuth 2.0
- Fill out the fields using details retrieved from your provider:
- Client ID
- Client Secret
- Scopes (Optional)
- (Optional) Select Actions to be enabled for this Connector Profile
- Click Create profile