Zoom

Zoom is a widely-used video communications and collaboration platform that enables virtual meetings, webinars, phone services, and workspace collaboration. This data integration provides comprehensive access to Zoom's organizational configuration, user management, security settings, meeting information, and recording data, enabling administrators and security teams to monitor, audit, and manage their Zoom deployment.

Category	Collaboration
Direction	Query source
Sign-in	Server-to-Server OAuth, SDK/JWT App
Query languages	SQLite
Tables	10
Query templates	33
Website	zoom.us

Before you start

Huntbase can sign in to Zoom with any of these methods: Server-to-Server OAuth, SDK/JWT App. Pick one, create the credential in Zoom, then keep it to hand for the Connect step.

Server-to-Server OAuth

Zoom Server-to-Server OAuth app credentials (account ID

1. In the Zoom App Marketplace, select Develop › Build an app.
2. Pick Server-to-Server OAuth app and click Create.
3. Copy the Account ID, Client ID, and Client Secret.
4. Fill in the app information, then choose Add Scopes and add the read scopes listed below.
5. Activate the app.

Permissions:

• user:read:list_users:admin
• user:read:user:admin
• role:read:list_roles:admin
• role:read:list_members:admin
• meeting:read:list_meetings:admin
• group:read:list_groups:admin
• group:read:list_members:admin
• cloud_recording:read:list_user_recordings:admin
• account:read:settings:admin
• account:read:lock_settings:admin

Watch out for

• You need permission to view and edit Server-to-Server OAuth apps. You also need an admin-level role to add admin-level scopes.
• If the app owner loses admin status, Zoom removes the app's admin-level scopes unless ownership moves to an admin.
• Zoom deactivated all JWT apps after September 8, 2023, so the SDK/JWT App method no longer works. Use Server-to-Server OAuth.

For the vendor's own instructions, see Zoom Server-to-Server OAuth app documentation.

tip

Use a dedicated, read-only credential for Huntbase where the product allows it. Huntbase only needs to read.

Connect Zoom

1. Go to Connections and click New connection, or click New connection on the Zoom product page.
2. On Product, pick Zoom and choose the Owner.
3. On Details, give the connection a Name and, optionally, a Description.
4. On Connect, fill in the settings and credentials described below.
5. On Verify, review the summary and click Create & check.

For everything else on the setup page — saving a draft, I'll do this later, and what each check result means — see Connections.

Settings

Where your Zoom lives:

Field	Required	Notes
Account ID	Yes
Client ID	Yes

Credentials

Choose a Method, enter a Credential label (for example Production), then fill in the fields for that method.

Server-to-Server OAuth

Field	Required	Notes
Client Secret	Yes	Secret — not shown again after you save it.

SDK/JWT App

Field	Required	Notes
API Key	Yes	Secret — not shown again after you save it.
API Secret	Yes	Secret — not shown again after you save it.

Query it

Once connected, Zoom can serve these languages in a query tab, and Scout can use it when you ask in Auto:

Language	Use it for
SQLite	SQL over the 10 tables listed below, alongside every other connected source.

Example: SQLite

List all users — Explore all registered users within a Zoom account to ensure proper management and oversight.

select
  *
from
  zoom_user;

Zoom ships with 33 query templates. Find them in Library › Queries — see Query templates.

What syncs automatically

Zoom comes with a content pack. These queries run on a schedule on each new connection so the entities they find appear in the Activity Feed without you asking. You can turn syncing off from the connection's Synchronisation Settings card.

Query	Finds
Sync groups and members	group, user
Sync roles and members	group, user
Sync role privileges	group

Tables

Zoom adds 10 tables. Browse their columns from Schema in the query bar's ⋯ menu.

All 10 tables

Table	Contains
zoom_account_lock_settings	Lock settings for the Zoom account. If true, the setting is locked at the account level.
zoom_account_settings	Settings for the Zoom account.
zoom_cloud_recording	Meetings and webinars recorded to the cloud.
zoom_group	A Zoom account can have one or more groups.
zoom_group_member	Members of a Zoom group.
zoom_meeting	Scheduled meetings for the host. Instant meetings are not returned.
zoom_my_user	Basic information about the authenticated user being used by the plugin.
zoom_role	A Zoom account can have one or more roles.
zoom_role_member	Members of a Zoom role.
zoom_user	A Zoom account can have one or more users.

Next steps

• Connections — health, credentials and settings after you connect
• Query languages — syntax, parameters and time ranges
• Chatting with Scout — ask questions without writing a query
• All integrations — the rest of the catalog