--- availability: INSTALLABLE description: A plugin that allows the user to generate an attendance report of a meet. installation_asset_uuid: 3c5ad01b-af12-4faf-8e0b-7a6555ae59e3 name: Lookup Attendance Report purple_chat_link: https://marketplace.moveworks.com/purple-chat?conversation=%7B%22startTimestamp%22%3A%2211%3A43%2BAM%22%2C%22messages%22%3A%5B%7B%22parts%22%3A%5B%7B%22richText%22%3A%22Hi%2C+can+you+get+me+the+attendance+report+for+a+meeting%3F%22%7D%5D%2C%22role%22%3A%22user%22%7D%2C%7B%22parts%22%3A%5B%7B%22richText%22%3A%22Alright.+Please+provide+the+start+and+end+dates+for+the+range+you%27re+interested+in.%22%7D%5D%2C%22role%22%3A%22assistant%22%7D%2C%7B%22parts%22%3A%5B%7B%22richText%22%3A%22Let%27s+go+from+October+1st%2C+2023+to+October+7th%2C+2023.%22%7D%5D%2C%22role%22%3A%22user%22%7D%2C%7B%22parts%22%3A%5B%7B%22richText%22%3A%22Here+are+the+meetings+scheduled+between+October+1st+and+October+7th%3A%22%7D%2C%7B%22richText%22%3A%22%3Col%3E%5Cn++%3Cli%3E%3Cb%3EProject+Update%3C%2Fb%3E+on+October+2nd%2C+2023%3C%2Fli%3E%5Cn++%3Cli%3E%3Cb%3ETeam+Sync%3C%2Fb%3E+on+October+4th%2C+2023%3C%2Fli%3E%5Cn++%3Cli%3E%3Cb%3EClient+Review%3C%2Fb%3E+on+October+6th%2C+2023%3C%2Fli%3E%5Cn%3C%2Fol%3E%5CnPlease+choose+the+number+of+the+meeting+you+want+the+attendance+report+for.%22%7D%5D%2C%22role%22%3A%22assistant%22%7D%2C%7B%22parts%22%3A%5B%7B%22richText%22%3A%22I+want+the+attendance+report+for+the+%3Cb%3EProject+Update%3C%2Fb%3E+meeting%2C+which+is+option+1.%22%7D%5D%2C%22role%22%3A%22user%22%7D%2C%7B%22parts%22%3A%5B%7B%22richText%22%3A%22You+selected+the+%3Cb%3EProject+Update%3C%2Fb%3E+meeting+on+October+2nd%2C+2023.+Is+that+correct%3F%22%7D%5D%2C%22role%22%3A%22assistant%22%7D%2C%7B%22parts%22%3A%5B%7B%22richText%22%3A%22Yes%2C+that%27s+correct.%22%7D%5D%2C%22role%22%3A%22user%22%7D%2C%7B%22parts%22%3A%5B%7B%22reasoningSteps%22%3A%5B%7B%22richText%22%3A%22%3Cp%3ECalling+Ms+Graph+API+to+get+attendance+report%3C%2Fp%3E%22%2C%22status%22%3A%22pending%22%7D%5D%7D%5D%2C%22role%22%3A%22assistant%22%7D%2C%7B%22parts%22%3A%5B%7B%22richText%22%3A%22%3Cp%3EThe+attendance+report+for+the+Teams+meeting+%3Cstrong%3EProject+Update%3C%2Fstrong%3E+on+October+2nd%2C+2023+has+been+successfully+generated.+Here+are+the+updated+details%3A%3C%2Fp%3E%22%7D%2C%7B%22richText%22%3A%22%3Cp%3ETotal+Number+of+participants+for+this+meet+%3A+%26nbsp%3B2%3Cbr%3E%5Cn%3Cbr%3E%5Cn1.+%3Cstrong%3EAttendee+1%3C%2Fstrong%3E%3Cbr%3E%5Cn+%26nbsp%3B-+%3Cstrong%3ERole%3A%3C%2Fstrong%3E+Organizer%3Cbr%3E%5Cn+%26nbsp%3B-+%3Cstrong%3EEmail%3A%3C%2Fstrong%3E+%3Ca+href%3D%5C%22mailto%3Asvc-product-admin%40deepnets.onmicrosoft.com%5C%22+rel%3D%5C%22noopener+noreferrer%5C%22+target%3D%5C%22_blank%5C%22%3Eabc%40example.com%3C%2Fa%3E%3Cbr%3E%5Cn+%26nbsp%3B-+%3Cstrong%3ETotal+Attendance+Duration%3A%3C%2Fstrong%3E+5+minutes+and+40+seconds%3Cbr%3E%5Cn+%26nbsp%3B-+%3Cstrong%3EJoin+Time%3A%3C%2Fstrong%3E+March+28%2C+2025%2C+12%3A11+PM+IST%3Cbr%3E%5Cn+%26nbsp%3B-+%3Cstrong%3ELeave+Time%3A%3C%2Fstrong%3E+March+28%2C+2025%2C+12%3A16+PM+IST%3C%2Fp%3E%5Cn%3Cp%3E2.+%3Cstrong%3EAttendee+2%3C%2Fstrong%3E%3Cbr%3E%5Cn+%26nbsp%3B-+%3Cstrong%3ERole%3A%3C%2Fstrong%3E+Presenter%3Cbr%3E%5Cn+%26nbsp%3B-+%3Cstrong%3EEmail%3A%3C%2Fstrong%3E+%3Ca+href%3D%5C%22mailto%3Avijval.narayana%40moveworks.ai%5C%22+rel%3D%5C%22noopener+noreferrer%5C%22+target%3D%5C%22_blank%5C%22%3Exyz%40example.com%3C%2Fa%3E%3Cbr%3E%5Cn+%26nbsp%3B-+%3Cstrong%3ETotal+Attendance+Duration%3A%3C%2Fstrong%3E+2+minutes+and+17+seconds%3Cbr%3E%5Cn+%26nbsp%3B-+%3Cstrong%3EJoin+Time%3A%3C%2Fstrong%3E+March+28%2C+2025%2C+12%3A14+PM+IST%3Cbr%3E%5Cn+%26nbsp%3B-+%3Cstrong%3ELeave+Time%3A%3C%2Fstrong%3E+March+28%2C+2025%2C+12%3A16+PM+IST%3Cbr%3E%5Cn%3Cbr%3E%5CnIf+you+need+further+assistance+or+details%2C+feel+free+to+ask%21%3C%2Fp%3E%22%7D%2C%7B%22citations%22%3A%5B%7B%22citationTitle%22%3A%22Project+Update+Attendance+Report%22%2C%22connectorName%22%3A%22microsoft-graph%22%7D%5D%7D%5D%2C%22role%22%3A%22assistant%22%7D%2C%7B%22parts%22%3A%5B%7B%22richText%22%3A%22Thank+you%21%22%7D%5D%2C%22role%22%3A%22user%22%7D%2C%7B%22parts%22%3A%5B%7B%22richText%22%3A%22You%27re+welcome%21+If+you+have+any+more+questions%2C+just+let+me+know.%22%7D%5D%2C%22role%22%3A%22assistant%22%7D%5D%7D solution_tags: - Productivity systems: - microsoft-graph --- # Introduction The **Get Attendance Report for Teams** plugin enables users to view detailed information about participants from scheduled meetings directly through the Moveworks AI Assistant. Users can effortlessly access details such as participant names, join and leave times, and overall attendance—all within their chat interface. This guide will help you install this plugin within minutes in Agent Studio. Let’s get started! # Prerequisites - Access to Agent Studio - [Ms Graph Connector](https://developer.moveworks.com/creator-studio/resources/connector?id=microsoft-graph) set up in Creator Studio - View Teams Meetings Plugin # What are we building? ## Agent Design This [purple chat](https://developer.moveworks.com/creator-studio/developer-tools/purple-chat/?conversation=%7B%22startTimestamp%22%3A%2211%3A43%2BAM%22%2C%22messages%22%3A%5B%7B%22parts%22%3A%5B%7B%22richText%22%3A%22Hi%2C+can+you+get+me+the+attendance+report+for+a+meeting%3F%22%7D%5D%2C%22role%22%3A%22user%22%7D%2C%7B%22parts%22%3A%5B%7B%22richText%22%3A%22Alright.+Please+provide+the+start+and+end+dates+for+the+range+you%27re+interested+in.%22%7D%5D%2C%22role%22%3A%22assistant%22%7D%2C%7B%22parts%22%3A%5B%7B%22richText%22%3A%22Let%27s+go+from+October+1st%2C+2023+to+October+7th%2C+2023.%22%7D%5D%2C%22role%22%3A%22user%22%7D%2C%7B%22parts%22%3A%5B%7B%22richText%22%3A%22Here+are+the+meetings+scheduled+between+October+1st+and+October+7th%3A%22%7D%2C%7B%22richText%22%3A%22%3Col%3E%5Cn++%3Cli%3E%3Cb%3EProject+Update%3C%2Fb%3E+on+October+2nd%2C+2023%3C%2Fli%3E%5Cn++%3Cli%3E%3Cb%3ETeam+Sync%3C%2Fb%3E+on+October+4th%2C+2023%3C%2Fli%3E%5Cn++%3Cli%3E%3Cb%3EClient+Review%3C%2Fb%3E+on+October+6th%2C+2023%3C%2Fli%3E%5Cn%3C%2Fol%3E%5CnPlease+choose+the+number+of+the+meeting+you+want+the+attendance+report+for.%22%7D%5D%2C%22role%22%3A%22assistant%22%7D%2C%7B%22parts%22%3A%5B%7B%22richText%22%3A%22I+want+the+attendance+report+for+the+%3Cb%3EProject+Update%3C%2Fb%3E+meeting%2C+which+is+option+1.%22%7D%5D%2C%22role%22%3A%22user%22%7D%2C%7B%22parts%22%3A%5B%7B%22richText%22%3A%22You+selected+the+%3Cb%3EProject+Update%3C%2Fb%3E+meeting+on+October+2nd%2C+2023.+Is+that+correct%3F%22%7D%5D%2C%22role%22%3A%22assistant%22%7D%2C%7B%22parts%22%3A%5B%7B%22richText%22%3A%22Yes%2C+that%27s+correct.%22%7D%5D%2C%22role%22%3A%22user%22%7D%2C%7B%22parts%22%3A%5B%7B%22reasoningSteps%22%3A%5B%7B%22richText%22%3A%22%3Cp%3ECalling+Ms+Graph+API+to+get+attendance+report%3C%2Fp%3E%22%2C%22status%22%3A%22pending%22%7D%5D%7D%5D%2C%22role%22%3A%22assistant%22%7D%2C%7B%22parts%22%3A%5B%7B%22richText%22%3A%22%3Cp%3EThe+attendance+report+for+the+Teams+meeting+%3Cstrong%3EProject+Update%3C%2Fstrong%3E+on+October+2nd%2C+2023+has+been+successfully+generated.+Here+are+the+updated+details%3A%3C%2Fp%3E%22%7D%2C%7B%22richText%22%3A%22%3Cp%3ETotal+Number+of+participants+for+this+meet+%3A+%26nbsp%3B2%3Cbr%3E%5Cn%3Cbr%3E%5Cn1.+%3Cstrong%3EAttendee+1%3C%2Fstrong%3E%3Cbr%3E%5Cn+%26nbsp%3B-+%3Cstrong%3ERole%3A%3C%2Fstrong%3E+Organizer%3Cbr%3E%5Cn+%26nbsp%3B-+%3Cstrong%3EEmail%3A%3C%2Fstrong%3E+%3Ca+href%3D%5C%22mailto%3Asvc-product-admin%40deepnets.onmicrosoft.com%5C%22+rel%3D%5C%22noopener+noreferrer%5C%22+target%3D%5C%22_blank%5C%22%3Eabc%40example.com%3C%2Fa%3E%3Cbr%3E%5Cn+%26nbsp%3B-+%3Cstrong%3ETotal+Attendance+Duration%3A%3C%2Fstrong%3E+5+minutes+and+40+seconds%3Cbr%3E%5Cn+%26nbsp%3B-+%3Cstrong%3EJoin+Time%3A%3C%2Fstrong%3E+March+28%2C+2025%2C+12%3A11+PM+IST%3Cbr%3E%5Cn+%26nbsp%3B-+%3Cstrong%3ELeave+Time%3A%3C%2Fstrong%3E+March+28%2C+2025%2C+12%3A16+PM+IST%3C%2Fp%3E%5Cn%3Cp%3E2.+%3Cstrong%3EAttendee+2%3C%2Fstrong%3E%3Cbr%3E%5Cn+%26nbsp%3B-+%3Cstrong%3ERole%3A%3C%2Fstrong%3E+Presenter%3Cbr%3E%5Cn+%26nbsp%3B-+%3Cstrong%3EEmail%3A%3C%2Fstrong%3E+%3Ca+href%3D%5C%22mailto%3Avijval.narayana%40moveworks.ai%5C%22+rel%3D%5C%22noopener+noreferrer%5C%22+target%3D%5C%22_blank%5C%22%3Exyz%40example.com%3C%2Fa%3E%3Cbr%3E%5Cn+%26nbsp%3B-+%3Cstrong%3ETotal+Attendance+Duration%3A%3C%2Fstrong%3E+2+minutes+and+17+seconds%3Cbr%3E%5Cn+%26nbsp%3B-+%3Cstrong%3EJoin+Time%3A%3C%2Fstrong%3E+March+28%2C+2025%2C+12%3A14+PM+IST%3Cbr%3E%5Cn+%26nbsp%3B-+%3Cstrong%3ELeave+Time%3A%3C%2Fstrong%3E+March+28%2C+2025%2C+12%3A16+PM+IST%3Cbr%3E%5Cn%3Cbr%3E%5CnIf+you+need+further+assistance+or+details%2C+feel+free+to+ask%21%3C%2Fp%3E%22%7D%2C%7B%22citations%22%3A%5B%7B%22citationTitle%22%3A%22Project+Update+Attendance+Report%22%2C%22connectorName%22%3A%22microsoft-graph%22%7D%5D%7D%5D%2C%22role%22%3A%22assistant%22%7D%2C%7B%22parts%22%3A%5B%7B%22richText%22%3A%22Thank+you%21%22%7D%5D%2C%22role%22%3A%22user%22%7D%2C%7B%22parts%22%3A%5B%7B%22richText%22%3A%22You%27re+welcome%21+If+you+have+any+more+questions%2C+just+let+me+know.%22%7D%5D%2C%22role%22%3A%22assistant%22%7D%5D%7D) shows the experience we are going to build. # Installation Steps While you can create a connector during plugin installation, we do recommend that you create a connector in Agent Studio before installing this plugin to streamline the process. Please follow our [**Microsoft Graph Connector Guide**](http://developer.moveworks.com/marketplace/package/?id=microsoft-graph&hist=home%2Cbrws) to do so. Once you have done this, simply follow our plugin installation documentation to get your plugin installed in minutes. **Permissions Needed:** - `OnlineMeetings.Read.All` - `OnlineMeetings.ReadWrite.All` - `OnlineMeetingTranscript.Read.All` - `OnlineMeetingArtifact.Read.All` - `OnlineMeetingRecording.Read.All` # Appendix ## A combination of 4 APIs makes this possible: - The first API call is designed to fetch the user details of the user requesting. ```bash curl -X GET "https://graph.microsoft.com/v1.0/users/{{user_email}}" \ --header "accept: application/json" \ --header "authorization: Bearer {{personal_access_token}}" \ --header "content-type: application/json" ``` - Required parameters: - **`user_email`**: User’s email. - The second API call is designed to retrieve the online meeting object using join web url. ```bash curl -X GET "https://graph.microsoft.com/v1.0/users/{{userid}}/onlineMeetings/?$filter=JoinWebUrl eq '{{weburl}}'" \ --header "accept: application/json" \ --header "authorization: Bearer {{personal_access_token}}" \ --header "content-type: application/json" ``` - Required parameters: - **`userid`**: The identifier for the user to whose meeting list the query pertains. - **`weburl`**: The exact web URL link for the meeting, used to filter and identify the specific meeting. - The third API request retrieves the attendance reports for a specific online meeting. ```bash curl -X GET "https://graph.microsoft.com/v1.0/users/{{userid}}/onlineMeetings/{{meeting_id}}/attendanceReports" \ --header "accept: application/json" \ --header "authorization: Bearer {{personal_access_token}}" ``` - Required parameters: - **`userid`**: The identifier for the user to whose meeting list the query pertains. - **`meeting_id`**: Unique identifier for the meeting, obtained from the previous API's response. - The Fourth API is responsible for retrieving the specific attendance report of the meeting. ```bash curl -X GET "https://graph.microsoft.com/v1.0/users/{{userid}}/onlineMeetings/{{meeting_id}}/attendanceReports/{{report_id}}?$expand=attendanceRecords" \ --header "accept: application/json" \ --header "authorization: Bearer {{personal_access_token}}" \ --header "content-type: application/json"" ``` - Required parameters: - **`user_id`**: The identifier for the user to whose meeting list the query pertains. - **`meeting_id`**: Unique identifier for the meeting, obtained from the previous API's response. - **`report_id`**: Unique identifier for the attendance report, obtained from the previous API's response.