Set up Zoom API Access

[Rabia2219]

Overview

We need to pull data from all the HfLA Zoom accounts through the Zoom API into a Google spreadsheet so that we can use this spreadsheet in our Monthly Team Calendar audits

Action Items

• [ ] Review Zoom Documentation (resource 1.01)
• [ ] Review (resource 1.02) to determine data needed for mvp
• [ ] Review the steps listed below (resource 1.05)
• [ ] identify resources needed in GitHub (potentially admin access, so that you can create secrets and GitHub actions)
• [ ] get access to the Zoom API
• [ ] identify areas which might require multiple GETs to discuss with the team. We may not need the data for MVP, and want to reduce time spent on optimizing for rate limits if the data is not currently a priority.
• [ ] get a one time pull of the data required into the spreadsheet

Resources/Instructions

• 1.00 API Folder
• 1.01 https://developers.zoom.us/docs/internal-apps/
• 1.02 CAL: API results for all zoom accounts

Zoom API

• 1.03 Use this to get a list of meetings: https://developers.zoom.us/docs/api/rest/reference/zoom-api/methods/#operation/meetings
  • GET /users/{userId}/meetings
• 1.04 Once you have the meeting ID from the list of meetings, you can look up individual data about each meetingAPI https://developers.zoom.us/docs/api/rest/reference/zoom-api/methods/#operation/meeting
  • GET /meetings/{meetingId}

1.05 Steps

• scroll down on the help file
• go to Zoom app marketplace
• open 1password
• click on build app under develop tab
• sign in using Zoom account (using credentials from 1password)
• click on build app
• click on create for OAuth app
• not available for external users
• Webhook only after OAuth
• select Learn more for Webhook
• it needs to be setup using GitHub actions and secrets
  • see hfla info about secrets https://github.com/hackforla/ops/issues/73

[Rabia2219]

Steps:

• scroll down on the help file
• go to Zoom app marketplace
• open 1password
• click on build app under develop tab
• sign in using Zoom account (using credentials from 1password)
• click on build app
• click on create for OAuth app
• not available for external users
• Webhook only after OAuth
• select Learn more for Webhook
• it needs to be setup using GitHub actions and secrets
  • see hfla info about secrets https://github.com/hackforla/ops/issues/73

[hasandiwan]

According to this, to create an OAuth key, one needs to click on the "Developer" tab on Zoom's UI. I don't see the Developer tab when logged in as zoom4. I haven't checked the other provided accounts, but I think they will be similar.

[Rabia2219]

According to this, to create an OAuth key, one needs to click on the "Developer" tab on Zoom's UI. I don't see the Developer tab when logged in as zoom4. I haven't checked the other provided accounts, but I think they will be similar.

it shows up on full screen

[hasandiwan]

Do we want the app to be published on the "Zoom Marketplace"?

Is this meant to be an "account level" or "user managed" app?

[Rabia2219]

Do we want the app to be published on the "Zoom Marketplace"?

Is this meant to be an "account level" or "user managed" app?

No to the first question. For the 2nd, what is the difference? Could you provide links to definitions/explanations? Thanks!

[hasandiwan]

Account level - This app must be added by admin and can manage all users in the account

User level - This app can be added and managed by individual users

[Rabia2219]

Account level - This app must be added by admin and can manage all users in the account

User level - This app can be added and managed by individual users

This will be an Account Level app...

[Rabia2219]

You can create a new Google Sheet in resource 1.00 API Folder linked in the issue above...thanks!

[Rabia2219]

Never used a Google API key before...

[hasandiwan]

What were you using to write to the spreadsheet then? -- H

[Rabia2219]

What were you using to write to the spreadsheet then? -- H

The App Script...

[Rabia2219]

The one I have to pull the VRMS data works...you cannot use that for the Zoom data without updates... The script that I have for the Zoom data is just a generic code...I have not tested it out...

[Rabia2219]

Yes...I didn't run it because I didn't have the API key and getting that required more learning/digging and I was pressed for time...hence we reached out for help... I had sent the script to you...please try using the API key you have retrieved to check if it works 👍