OfficeDev/O365-EDU-AngularNodeJS-Samples

Name: O365-EDU-AngularNodeJS-Samples

Owner: Office Developer

Description: null

Created: 2017-01-20 22:19:22.0

Updated: 2018-02-27 22:02:32.0

Pushed: 2017-12-29 06:23:28.0

Homepage: null

Size: 5747

Language: TypeScript

GitHub Committers

UserMost Recent Commit# Commits

Other Committers

UserEmailMost Recent Commit# Commits

README

EDUGraphAPI - Office 365 Education Code Sample

In this sample, we show you how to integrate with school roles/roster data as well as O365 services available via the Graph API.

School data is kept in sync in O365 Education tenants by Microsoft School Data Sync.

Table of Contents

Sample Goals

The sample demonstrates:

EDUGraphAPI is based on NodeJS (the server-side) and Angular 2 (the client-side).

Prerequisites

Deploying and running this sample requires:

Register the application in Azure Active Directory
  1. Sign into the new Azure Portal: https://portal.azure.com/.

  2. Choose your Azure AD tenant by selecting your account in the top right corner of the page:

  3. Click Azure Active Directory -> App registrations -> +Add.

  4. Input a Name, and select Web app / API as Application Type.

    Input Sign-on URL: https://localhost:44380/

    Click Create.

  5. Once completed, the app will show in the list.

  6. Click it to view its details.

  7. Click All settings, if the setting window did not show.

  8. Click Properties, then set Multi-tenanted to Yes.

    Copy aside Application ID, then Click Save.

  9. Click Required permissions. Add the following permissions:

    | API | Application Permissions | Delegated Permissions | | —————————— | ———————– | —————————————- | | Microsoft Graph | Read directory data | Read all users' full profiles
    Read directory data
    Read directory data
    Access directory as the signed in user
    Sign users in | | Windows Azure Active Directory | | Sign in and read user profile
    Read and write directory data |

  10. Click Keys, then add a new key:

    Click Save, then copy aside the VALUE of the key.

    Close the Settings window.

Build and debug locally

This project can be opened with the edition of Visual Studio 2015 you already have, or download and install the Community edition to run, build and/or develop this application locally.

The following tools are also required:

Debug the EDUGraphAPI.Web:

  1. Configure Environment Variables. Right-click the project in Solution Explorer, then click Properties.

  2. clientId: use the Client Id of the app registration you created earlier.

  3. clientSecret: use the Key value of the app registration you created earlier.

  4. SourceCodeRepositoryURL: use the repository URL of your fork.

  5. In the Solution Explorer, right-click npm, then click Install Missing npm Packages:

  6. Press F5.

Deploy the sample to Azure

GitHub Authorization

  1. Generate Token

  2. Open https://github.com/settings/tokens in your web browser.

  3. Sign into your GitHub account where you forked this repository.

  4. Click Generate Token

  5. Enter a value in the Token description text box

  6. Select the followings (your selections should match the screenshot below):

    • repo (all) -> repo:status, repo_deployment, public_repo
    • admin:repo_hook -> read:repo_hook

  7. Click Generate token

  8. Copy the token

  9. Add the GitHub Token to Azure in the Azure Resource Explorer

  10. Open https://resources.azure.com/providers/Microsoft.Web/sourcecontrols/GitHub in your web browser.

  11. Log in with your Azure account.

  12. Selected the correct Azure subscription.

  13. Select Read/Write mode.

  14. Click Edit.

  15. Paste the token into the token parameter.

  16. Click PUT

Deploy the Azure Components from GitHub

  1. Check to ensure that the build is passing VSTS Build.

  2. Fork this repository to your GitHub account.

  3. Click the Deploy to Azure Button:

    Deploy to Azure

  4. Fill in the values in the deployment page and select the I agree to the terms and conditions stated above checkbox.

  5. Resource group: we suggest you create a new group.

  6. Site Name: please input a name. Like EDUGraphAPITest003 or EDUGraphAPI993.

    Note: If the name you input is taken, you will get some validation errors:

    Click it you will get more details like storage account is already in other resource group/subscription.

    In this case, please use another name.

  7. Source Code Repository URL: replace with the repository name of your fork.

  8. Source Code Manual Integration: choose false, since you are deploying from your own fork.

  9. Client Id: use the Client Id of the app registration you created earlier.

  10. Client Secret: use the Key value of the app registration you created earlier.

  11. Check I agree to the terms and conditions stated above.

  12. Click Purchase.

Add REPLY URL to the app registration

  1. After the deployment, open the resource group:

  2. Click the web app.

    Copy the URL aside and change the schema to https. This is the replay URL and will be used in next step.

  3. Navigate to the app registration in the new Azure Portal, then open the setting windows.

    Add the reply URL:

    Note: to debug the sample locally, make sure that https://localhost:44380/ is in the reply URLs.

  4. Click SAVE.

Understand the code
Introduction

Solution Component Diagram

The top layer of the solution contains the two parts of the EDUGraphAPI.Web project:

The bottom layers contain the three data sources.

EDUGraphAPI.Web - Server

The server-side app is based on Node.js and implemented with Typescript.

Authentication Mechanisms

Passport and its 2 plugins are used to enable local and O365 authentications:

The 2 kinds of authentication are implemented in the /auth/appAuth.ts file.

Web APIs

The server app exposes several Web APIs:

| Path | Method | Description | | —————————————- | ——– | —————————————- | | /api/me | GET | Return the current user and the user's organization and roles | | /api/me/favoriteColor | POST | Update current user's favorite color | | /api/me/accesstoken | GET | Get current user's access token | | /api/tenant | POST | Update information (isAdminConsented) of current user's tenant | | /api/tenant/unlinkAllUsers | POST | Unlink all users in current user's tenant | | /api/users/linked | GET | Get all linked users | | /api/users/:userId/unlink | POST | Unlink the specified user | | /api/admin/consent | GET | Redirect the user to login page to perform admin consent | | /api/admin/consented | POST | Will be invoked after admin consented | | /api/schools/seatingArrangements/:classId | GET/POST | Get or set the seating arrangement of the specified class |

These APIs are defined in the /routes folder.

Data Access

Sequelize is used in this sample to access data from a SQL Database.

The DbContext exposes the models and methods that are used to access data.

The tables used in this demo:

| Table | Description | | —————————- | —————————————- | | Users | Contains the user's information: name, email, hashed password…
O365UserId and O365Email are used to connect the local user with an O365 user. | | UserRoles | Contains users' role. Three roles are used in this sample: admin, teacher, and student. | | Organizations | A row in this table represents a tenant in AAD.
IsAdminConsented column records than if the tenant consented by an administrator. | | TokenCache | Contains the users' access/refresh tokens. | | ClassroomSeatingArrangements | Contains the classroom seating arrangements. |

You will find the DbContext class and related model interfaces in the /data/dbContext.ts file.

Services

The services used by the server-side app:

| Service | Description | | —————– | —————————————- | | MSGraphClient | Contains methods used to access MS Graph APIs | | SchoolService | Contains two methods: get/update seating arrangements | | TenantService | Contains methods that operate tenants in the database | | TokenCacheService | Contains method used to get and update cache from the database | | UserService | Contains method used to manipulate users in the database |

The services are in the /services folder.

Multi-tenant app

This web application is a multi-tenant app. In the AAD, we enabled the option:

Users from any Azure Active Directory tenant can access this app. Some permissions used by this app require an administrator of the tenant to consent before users can use the app. Otherwise, users will see this error:

For more information, see Build a multi-tenant SaaS web application using Azure AD & OpenID Connect.

EDUGraphAPI.Web - Client

The client-side app which resides in the /app folder is based on Angular 2 and is also implemented with Typescript 2.

Note: Getting and using declaration files in TypeScript 2.0 is much easier than in TypeScript 1. To get declarations for a library like lodash for example, all you need is npm:

install --save @types/lodash

Components

These components are used in the client app.

| Folder | Component | | ———– | ——————— | | / | App | | /aboutme | AboutMe | | /admin | Admin | | | LinkedAccounts | | | Consent | | /demoHeoper | DemoHelper | | /header | Header | | /link | Link | | | LinkCreateLocal | | | LinkLoginLocal | | | LinkLoginO365Requried | | /login | Login | | /O365login | O365login | | /register | Register | | /schools | Schools | | | Classes | | | MyClasses | | | ClassDetails |

Services

| Folder | Name | | ———– | —————– | | /aboutme | AboutMeService | | /admin | AdminService | | /demoHelper | DemoHelperService | | /link | LinkService | | /services | MeService | | | UserService | | | UserPhotoService | | | DataService |

Office 365 Education API

The Office 365 Education APIs return data from any Office 365 tenant which has been synced to the cloud by Microsoft School Data Sync. The APIs provide information about schools, sections, teachers, students, and rosters. The Schools REST API provides access to school entities in Office 365 for Education tenants.

In this sample, the Microsoft.Education Class Library project encapsulates the Office 365 Education API.

The EducationServiceClient is the core class of the library. It is used to easily get education data.

Get schools

chools(): Observable<any[]> {
return this.dataService.getArray<any>(this.urlBase + "/administrativeUnits");

ypescript
choolById(id: string): Observable<any> {
return this.dataService.getObject(this.urlBase + '/administrativeUnits/' + id );

Get classes

lasses(schoolId: string, nextLink: string): Observable<PagedCollection<any>> {
let url: string = this.urlBase + "/groups?$top=12&$filter=extension_fe2174665583431c953114ff7268b7b3_Education_ObjectType%20eq%20'Section'%20and%20extension_fe2174665583431c953114ff7268b7b3_Education_SyncSource_SchoolId%20eq%20'" + schoolId + "'" + (nextLink ? "&" + GraphHelper.getSkipToken(nextLink) : '');
return this.dataService.getPagedCollection<any>(url);

ypescript
lassById(classId: string): Observable<any> {
return this.dataService.getObject<any>(this.urlBase + "/groups/" + classId + "?$expand=members");

Get users

sers(schoolId: string, nextLink: string): Observable<PagedCollection<any>> {
var url = this.urlBase + "/administrativeUnits/" + schoolId + "/members?$top=12" +
extLink ? "&" + GraphHelper.getSkipToken(nextLink) : '');
return this.dataService.getPagedCollection<any>(url);

Below are some screenshots of the sample app that show the education data.

In /app/services/dataService.ts, three generic methods simplify the invoking of REST APIs.

For HTTP GET request sent by the 3 methods above, an access token is included in the bearer authentication header.

Authentication Flows

There are 4 authentication flows in this project.

The first 2 flows (Local Login/O365 Login) enable users to login in with either a local account or an Office 365 account, then link to the other type account. This procedure is implemented in the LinkController.

Local Login Authentication Flow

O365 Login Authentication Flow

Admin Login Authentication Flow

This flow shows how an administrator logs into the system and performs administrative operations.

After logging into the app with an office 365 account, the administrator will be asked to link to a local account. This step is not required and can be skipped.

As mentioned earlier, the web app is a multi-tenant app which uses some application permissions, so tenant administrator must consent the app first.

This flow is implemented in the AdminController.

Two Kinds of Graph APIs

There are two distinct Graph APIs used in this sample:

| | Azure AD Graph API | Microsoft Graph API | | ———— | —————————————- | —————————————- | | Description | The Azure Active Directory Graph API provides programmatic access to Azure Active Directory through REST API endpoints. Apps can use the Azure AD Graph API to perform create, read, update, and delete (CRUD) operations on directory data and directory objects, such as users, groups, and organizational contacts | A unified API that also includes APIs from other Microsoft services like Outlook, OneDrive, OneNote, Planner, and Office Graph, all accessed through a single endpoint with a single access token. | | Client | Install-Package Microsoft.Azure.ActiveDirectory.GraphClient | Install-Package Microsoft.Graph | | End Point | https://graph.windows.net | https://graph.microsoft.com | | API Explorer | https://graphexplorer.cloudapp.net/ | https://graph.microsoft.io/graph-explorer |

IMPORTANT NOTE: Microsoft is investing heavily in the new Microsoft Graph API, and they are not investing in the Azure AD Graph API anymore (except fixing security issues).

Therefore, please use the new Microsoft Graph API as much as possible and minimize how much you use the Azure AD Graph API.

Below is a piece of code shows how to get “me” from the Microsoft Graph API.

ic getMe(): Promise<any> {
return new Promise((resolve, reject) => {
    request
        .get(Constants.MSGraphResource + "/v1.0/me/?$select=id,givenName,surname,userPrincipalName,assignedLicenses")
        .set('Authorization', 'Bearer ' + this.accessToken)
        .end((err, res) => {
            if (err) { return reject(err) }
            resolve(res.body);
        })
})

Note that in the AAD Application settings, permissions for each Graph API are configured separately:

Questions and comments
Contributing

We encourage you to contribute to our samples. For guidelines on how to proceed, see our contribution guide.

This project has adopted the Microsoft Open Source Code of Conduct. For more information see the Code of Conduct FAQ or contact opencode@microsoft.com with any additional questions or comments.

Copyright (c) 2017 Microsoft. All rights reserved.


This work is supported by the National Institutes of Health's National Center for Advancing Translational Sciences, Grant Number U24TR002306. This work is solely the responsibility of the creators and does not necessarily represent the official views of the National Institutes of Health.