create-pilot-graph

create pilot graph is a project of the WOC 2020/21 combining Microsoft Graph API with Python.

The main goal of this project:

• Create new office user accounts form a CSV Import via MS Graph API

Project steps:

1. Connect to MS Graph API
2. Create Useraccount
3. Lizenz einem User zuweisen
4. Generate a password
5. check if userPrincipalName already exists
6. Location für Lizenzzuweisung per PATCH setzen
7. Einladungsmail versenden
8. CSV einlesen
9. Umlaute ersetzten
10. Vorname/ Nachname validieren
11. CSV validieren -> passt private E-Mail Format
12. Überprüfen welche Parameter beim erstellen des Users ausgefüllt seien müssen (private Mail für e-Mail Versand/ JobTitle/ preferedLanguage)
13. Code aufhübschen
14. Neu angelegte User zu Gruppen hinzufügen
15. UI für Import + ini erstellen

Standard API Functions:

Function	Description	Link
createUser()	Creates a Azure AD user	Link
uspExsist()	Checks if userPrincipalName already exists	Link
assign_licence()	Assign licence to user	Link
sendInvitationMail()	Sends a mail from an application. You need to set an account as a sender	Link

Lessons learned

1. First steps with graph api is difficult (~ 3h for first connection)
2. VS Studio Live Share good tool for coding collaboration
3. Postman is a very good tool for testing the api
4. API Debugging is very difficult
5. Testteant is recommended
6. Concentrate

Useful links

Links that helped us:

Get Users

Query parameter

Use count in query

Acess values in json python

Contributer:

• Arthur
• Stefan
• Roman
• Moritz