Skip to main content

​
Creating a Microsoft Excel connection

Create the connection by using one of the following methods:

​
Using OAuth

​
Creating your connection

  1. In the Blink platform, navigate to the Connections page > Add connection. A New Connection dialog box opens displaying icons of external service providers available.
  2. Select the Microsoft Excel icon. A dialog box with name of the connection and connection methods appear.
  3. (Optional) Edit the name of the connection. At a later stage you cannot edit the name.
  4. Click Excel to authenticate using OAuth.
  5. Sign in using your credentials.

​
Using App Registration

To create the connection you need:
  • A Client ID
  • A Client Secret
  • A Tenant ID

​
Obtaining the credentials

  1. Log into the Azure Portal.
  2. Go to the Microsoft Entra ID resource.
Azure Active Directory Resource
  1. In the left-hand menu, click App registrations.
App Registrations
  1. Create a new application registration or click on one of your existing applications.
My App
  1. In the left-hand menu, click API permissions.
API Permissions
  1. Click Add a permission and select Microsoft Graph.
Add Permission
  1. Choose Application permissions and mark the permissions you wish to add.
Application Permissions To support all Blink actions, add the following application permissions:
Least privileged permissionsHigher privileged permissions
Files.ReadWrite-
  1. Click Add permissions to save the changes.
  2. Click Grant admin consent for <your tenant> on the API permissions page. Only admins can grant consent.
Grant Admin Consent
  1. Confirm that the added permissions are now verified.
Granted Admin Consent
  1. Navigate to Overview and Copy your client ID and tenant ID.
Client ID & Tenant ID
  1. Create a new client secret.
Client Secret
  1. Copy the secret value.
Client Secret

​
Creating your connection

  1. In the Blink platform, navigate to the Connections page > Add connection. A New Connection dialog box opens displaying icons of external service providers available.
  2. Select the Microsoft Excel icon. A dialog box with name of the connection and connection methods appear.
  3. (Optional) Edit the name of the connection. At a later stage you cannot edit the name.
  4. Select App Registration as the method to create the connection.
  5. Fill in the parameters:
    • The Client ID
    • The Client Secret
    • The Tenant ID
  6. (Optional) Click Test Connection to test it.
  7. Click Create connection. The new connection appears on the Connections page.
⌘I