Office 365 - Integration Course

Download PDF guide

 

Office 365 - OneDrive Pre-Requisites​​​​​​​

 

To enable the Office 365 OneDrive integration with FrogLearn some initial steps will need to be configured within the school’s Office 365 tenancy. This will include the generation of a client secret.

Should your school wish to have single sign on between Office 365 OneDrive and the Frog platform then you may wish to consider one of the integrations below:

  • Active Directory Federated Services (ADFS)
  • Azure

Both integrations will be the responsibility of the school to configure, however, if you would like any guidance then please contact the Service Desk on 01422 395 939 or support@frogeducation.com.

 


 

How-to

 

To configure the OneDrive integration, navigate to your Office 365 Azure instance via the URL https://portal.azure.com. Enter your school’s Office 365 administrator account for the tenancy and then select the Next button.

 

1.png

 

Enter the associated password for your school’s Office 365 administrator account for the tenancy. Then select the Sign In button.

 

2.png

 

Once logged into your Microsoft Azure instance, select Azure Active Directory.

 

Office365_OneDrive_Azure Active Directory.png

 

The Azure Active Directory options are displayed. Select the App Registration option.

From the left-hand side menu select App registrations.

 

Office365_OneDrive__App_Registrations.png

 

Select New Registration.

 

Office365_OneDrive_New Registration.png


The Register an application window will be displayed.  Complete the following details to register your Frog platform as an application:

  1. Name – Enter in a name that will allow you to easily identify the application that you are wanting to register.  e.g. Wilson Academy FrogLearn – OneDrive
  2. Support account types – In most instances schools will be a single tenant, however the choice is up to the administrator of your Office 365 tenancy.  In this example we are going to select the option Accounts in this organizational directory only
  3. Redirect URI – From the first drop-down box select the option Web.  Next you will need to enter a specific endpoint URL (/app/acceptonedrivebusinessauth) used for communication between the Frog platform and your Office 365 tenancy for the OneDrive integration.  

 

Office365_OneDrive_Register an application.png

 

When happy with the information entered select the Register button.

 

Office365_OneDrive_Register button.png

 

The application is created and displayed as per the details entered.  In this example, all details relating to the application Wilson Academy FrogLearn – OneDrive is displayed.

 

Office365_OneDrive_Wilson Academy FrogLearn – OneDrive.png

 

The next step is to configure a second redirect URI.  From the left-hand side menu select Authentication.


Office365_OneDrive_Wilson Academy FrogLearn Authentication.png

 

Within the Authentication options, select the Add URI link within the Web section.

 

Office365_OneDrive_Wilson Academy Add URI link.png

 

The first entry will display the endpoint (/app/acceptonedrivebusinessauth) used for communication between the Frog platform and your Office 365 tenancy for the OneDrive integration.  In this example, this is:

https://wilson-academy.frogtest.co.uk/app/acceptonedrivebusinessauth

Now, in the new URL field enter your FrogLearn platform URL.  In this example, this is:

https://wilson-academy.frogtest.co.uk

After this has been entered a green tick should be displayed at the end of the URL.

 

Office365_OneDrive_Wilson Academy green tick.png

 

When happy with the information entered select the Save button.

 

Office365_OneDrive_Wilson Academy save.png

 

The next step is to configure a unique shared password to be used between the Frog platform and Office 365 tenancy.  Select Certificates & secrets from the left-hand side menu.

 

Office365_OneDrive_Wilson Academy Certificates & secrets.png


Within the Certificates & secrets options, select the New client secret link within the Client secrets section.

 

Office365_OneDrive_Wilson Academy Client secrets.png

 

An Add a client secret pop-up window will be displayed on the right-hand side.  

Complete the following fields to create a unique shared password for the OneDrive integration:

  • Description – Enter the text client_secret.
  • Expires – This will be up to the school as to the length of time the unique shared password between the Frog platform and Office 365 is to be active. You will have the following choices:
  • Recommended: 6 months
  • 3 months
  • 12 months
  • 18 months
  • 24 months
  •  Custom

In this example, we have opted to select the option 12 months.

NOTE - Please keep in mind though that in a year you will need to re-generate a new unique shared password for the integration to stay active.

 

Office365_OneDrive_Wilson Academy  Add button.png

 

When happy with the information entered select the Add button.

 

Office365_OneDrive_Wilson Academy  Add button2.png

 

The unique shared password will be displayed under the Value field. Copy this password into a text file for use later.

NOTE – Please be aware that after you exit this page, the password can’t be retrieved again.

 

Office365_OneDrive_Wilson Academy  Value field.png

 

The next step is to configure the permissions the Frog platform will have to the Office 365 tenancy. Select API permissions from the left-hand side menu.

 

Office365_OneDrive_Wilson Academy  API permissions.png

 

Within the API permissions options, select the Add a permission link within the Configured permissions section.

 

Office365_OneDrive_Wilson Academy  API permissions2.png

 

A Request API permissions pop-up window will be displayed on the right-hand side.  Select the option Microsoft Graph.

 

Office365_OneDrive_Wilson Academy  Microsoft Graph.png

 

Within the Microsoft Graph options, select Delegated permissions.

 

Office365_OneDrive_Wilson Academy  Delegated permissions.png

 

Within the search box just below Select Permissions, enter in the text files.  

A search on all available permissions will be returned.  Expand the Files section and then select the following option:

  • Files.ReadWrite.All – Have full access to all files user can access

 

Office365_OneDrive_Wilson Academy FilesReadWrite All.png

 

Next enter in the text offline within the search box.  

A search on all available permissions will be returned.  Expand the OpenID permissions section and then select the following option:

  • offline_access – Maintain access to data you have given it access to

 

Office365_OneDrive_Wilson Academy offline_access.png

 

When happy with the permissions selected, click on the Add permissions button.

 

Office365_OneDrive_Wilson Academy Add permissions button.png

 

You be returned to the API permissions page. Under the section Configured permissions, you will see an overview of the API’s selected for the integration.

 

Office365_OneDrive_Wilson Academy APIs selected.png

 

The OneDrive setup within the Office 365 tenancy is nearly completed.  The last action that you need to complete is to take note of the identifiers for the fields below:

  • Application (client) ID
  • Directory (tenant) ID

Select Overview from the left-hand side menu.

 

Office365_OneDrive_Wilson Academy APIs Overview.png

 

Within the Essentials section, copy the identifiers displayed for the fields below into a text file for use later:

  • Application (client) ID e.g. 988b3dfe-4f72-4d40-9727-b9f8dcb5fd83
  •  Directory (tenant) ID – e.g  8acced50-8c19-42cf-b3f3-2655af328818

 

Office365_OneDrive_Wilson Academy Essentials section.png

 

Just to reiterate the items that you should have noted in your text file for use later are below:

  • Client Secret - uGdd2_-u8C~R.~3_46R22qYu2y5KQk80..
  • Application (client) ID – 988b3dfe-4f72-4d40-9727-b9f8dcb5fd83
  • Directory (tenant) ID – 8acced50-8c19-42cf-b3f3-2655af328818

Please refer to the document Office 365 - OneDrive Preferences for steps on how to configure your FrogLearn platform with your Office 365 tenancy in order to integrate OneDrive.