Section 1.1: Steps to Register Your Application

Step 1: Create an App in Azure Portal

1. Navigate to Active Directory and select App registrations.
2. Choose the necessary permissions under the application tab.
3. Establish a Redirect URI for your application.
4. Copy the Client ID, Redirect URI, and Tenant ID into your code or create a .yml file for storage.

Step 2: Authentication

Next, you will need to secure the authorization code, Access Token, and Refresh Token. First, you will create a sign-in through code that allows you to remotely access your work account. This process will generate an authorization code. Use the following code to initiate the authorization code generation:

import json

import requests

import pandas as pd

import yaml

from requests_oauthlib import OAuth2Session

import os

import time

# Load the OAuth settings

with open('oauth_settings.yml', 'r') as stream:

settings = yaml.safe_load(stream)

authorize_url = '{0}{1}'.format(settings['authority'], settings['authorize_endpoint'])

# Function to generate a sign-in URL

def get_sign_in_url():

aad_auth = OAuth2Session(settings['app_id'],

scope=settings['scopes'],

redirect_uri=settings['redirect'])

sign_in_url, state = aad_auth.authorization_url(authorize_url, prompt='login')

return sign_in_url, state

Step 3: Use the Authorization Code

Use the authorization code obtained from the sign-in process to generate Refresh and Access Tokens from the API. Here’s how:

def graphAccessToken():

response = requests.post(url,

headers={'Content-Type': 'application/x-www-form-urlencoded'},

data={

'client_id': "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",

'scope': 'openid profile offline_access user.read calendars.read Files.Read.All Files.ReadWrite.All Sites.Manage.All Sites.Read.All Sites.ReadWrite.All Directory.Read.All OnlineMeetings.Read ChannelMessage.Read.All Group.Read.All',

'code': 'xxxxxxxxxxxxxxxxxxxxxxxx',

'grant_type': 'authorization_code'

})

response_data = json.loads(response.text)

return response_data

Step 4: Refresh Access Token

Now that you have both the Access and Refresh Tokens, you can refresh the Access Token as follows:

def newAccessToken():

response = requests.post(url,

headers={'Content-Type': 'application/x-www-form-urlencoded'},

data={

'client_id': "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",

'scope': 'openid profile offline_access user.read calendars.read Files.Read.All Files.ReadWrite.All Sites.Manage.All Sites.Read.All Sites.ReadWrite.All Directory.Read.All OnlineMeetings.Read ChannelMessage.Read.All Group.Read.All',

'refresh_token': 'xxxxxxxxxxxxxxxxxxxxxxxxxxxx',

'grant_type': 'refresh_token'

})

json_response = response.json()

return json_response['access_token']

Section 1.2: Accessing SharePoint Data

To fetch sample data from SharePoint, use the following code snippet:

def spoint():

headers={'Authorization': 'Bearer ' + newAccessToken(),

'Content-Type': 'application/x-www-form-urlencoded'})

return response.text

You can also retrieve items from a SharePoint site using the site ID and folder names:

def datapoint():

headers={'Authorization': 'Bearer ' + newAccessToken()})

return response.json()

To obtain the attendance report, use the GET method with the following endpoint:

This request is only available in the beta version of the Microsoft Graph API. By following these steps, you will successfully extract attendance data from Microsoft Teams using the Graph API.