Setting up a Microsoft Graph Odata Connection

Published: Mar 10, 2023

Setting up a Microsoft Graph Odata Connection

Published: Mar 10, 2023

Microsoft Graph API is a RESTful web API that enables you to access Microsoft Cloud service resources. After registering an app in Azure and authenticating, SmartConnect can make requests to the Microsoft Graph API. For more information, see Overview of Microsoft Graph. 

 

SmartConnect uses Graph for connections to OneDrive, Outlook, Teams and SharePoint. 

Setting up the application in Azure 

1. Navigate to portal.azure.com. 

2. Search for App registrations in the top search bar and select App registrations. 

3. Click New Registration and enter a name for the application. 

4. Choose the appropriate Supported Account Type.  

Most companies will use “Accounts in this organizational directory only”. 

63c83dbf7ca3d1884c9f0a49 01 image 13

5. Redirect URI – Choose Web and enter the correct URL based on deployment/region: 

  • In SmartConnect.com navigate to Connections > Create Connection > Microsoft Graph Odata and copy the redirect URL displayed in the connection window. 

63c83dd6c05d013426b4def8 02 image 9

6. Click Register. 

7. Click “Certificates & secrets” in the navigation on the left. 

8. Click “New client secret”. 

9. Give the secret a description and choose how long you want the secret to last.   

Note: When the secret expires any connections using this secret will no longer connect successfully until a new secret is generated and used in the connection.  

63c6f82dbfd1f04c9f89b8dc 03 image

10. Click Add to generate the new secret. Copy and save the “Value” somewhere as it will not be fully visible again once you navigate away from the Azure Portal. 

63c6f840a627b71a3c0c9cca 04 image

11. Click on “API Permission” in the navigation bar on the left. 

12. Click “Add a permission” and choose Microsoft Graph. 

13. Select Delegated permission enable the following Permissions. 

  • OneDrive 
    • Files.ReadWrite.All 
  • Outlook 
    • Mail.Read 
    • Mail.ReadBasic 
  • Teams 
    • Team.ReadBasic.All 
    • Channel.ReadBasic.All 
    • ChannelMessage.Send 
    • Chat.ReadWrite 
  • SharePoint 
    • Team.ReadBasic.All 

14. Click Add permissions. 

63c83e4054fd8bf8147f03ac 05 image 6

15. Click on Overview in the navigation bar on the left. 

16. Copy and save the “Application (client) ID” and “Directory (tenant) ID” values. 

63c83e57b7bf5d64863ea0bf 06 image 2

17. With the Application ID, Tenant ID, and Secret Value copied and saved from the application setup, the Graph Odata connection in SmartConnect can now be configured. 

Setting up the connector in SmartConnect 

1. Login to login.smartconnect.com if not already. 

2. Navigate to Connections > Create Connection button (or edit an existing Graph connection). 

3. Select Microsoft Graph Odata. 

4. Description – Friendly description for connector. 

5. Tenant Id – Directory (tenant) ID from Azure app. 

6. Application (client) Id – Application (client) ID from Azure app. 

7. Client Secret – Secret value from Azure app. 

8. Platform – Select platform(s) the Graph connection will be used with. 

63c83e78cdb5f281326842e6 07 image 1

9. Click Validate.  This will start the OAuth process and you will be directed to a Microsoft login if not already logged in.  If you were still logged in, you will be asked to grant permissions.  Click accept to grant the permissions.  If your user does not have the proper permissions, you will need to have an admin user grant the permissions as referenced in this Microsoft article. 

Note: It is important for the browser to prompt for credentials. If the browser automatically signs the user in, it may not be the correct account authorizing the application. 

63c83e9b48755eeae9214326 08 image 1

 

10. After successful validating you will be redirected back to the Microsoft Graph Odata connector in SmartConnect. 

11. Default Company – Choose a company. 

12. After successfully completing the validation and access steps, the connector can now be saved. 

Content
Setting up the application in Azure Setting up the connector in SmartConnect

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

Reset Filters