OneDrive Integration Setup

This article will walk through the setup of the OneDrive integration with bvoip.

What does this accomplish?

The OneDrive integration will export call data as Comma-Separated Values (CSV) files to a designated OneDrive account, refreshing the data every hour. You can then leverage your own tools and automations or third-party tools to further action or review the data.

Setting up the Entra App

1. Go to your Entra Admin portal. This is the Identity option under Admin centers in the Microsoft 365 Admin Portal, if you can't see it you may need to click Show All first.
   
2. On the left under Identity go to Applications > App registrations.
   
3. In the top left click on New registration.
   
4. In the Name field, provide a name such as bvoip BrightGauge.
   
5. Click the Register button.
6. Copy the Application (Client) ID and the Directory (Tenant) ID and paste them into a Notepad.
   
7. Go to Certificates & Secrets on the left-hand side.
   
8. Click on the New client secret button.
   
9. In the Description text box, input a description. 
10. In the Expires drop-down, select the 24 months option.
11. Click the Add button.
    
12. Copy the secret Value and Paste it into a Notepad. 
    
13. Go to API Permissions on the left.
    
14. Click on the Add a Permission button. The Requested API Permissions side screen will appear.
    
15. Select the Microsoft Graph option.
    
16. Click on Application Permissions. 
    
17. Under Files select Files.ReadWrite.All
18. Under Users select User.Read.All
19. Click on the Add Permissions button.
    
20. Click on the Grant admin consent for... button. The Grant Consent Confirmation pop-up will appear.
    
21. Click on the Yes button.
    

Setting up the 1Stream Integration

1. Log into the 1Stream Portal.
2. Go to Administration > Manage Organization.
   
3. Scroll down to the Connected Accounts and CRM Settings section, and click the green + sign in the top right.
   
4. In the Add New CRM Platform pop up window, select OneDrive and then click Save
   
5. In the API Key field, paste the Application (client) ID.
6. In the API Private Key field, paste the Client Secret.
7. In the Integration Code field, paste the Directory (tenant) ID.
8. In the CRM Username field, enter the username (with domain) of the OneDrive account you're connecting to.
9. Click the Save button.
   

The integration between OneDrive and 1Stream is now complete! You won't see data until the next hour cycle, but then you should see two files in the root of your OneDrive like below.

Next Steps

From here you can take the CSV files and use them as you see fit, but our guides below will further walk through loading the data into the most common applications.

• Opening .CSV Files In Microsoft Power BI
• Importing .CSV Files In BrightGauge