Zoom

Zoom is a video conferencing and collaboration platform.

ingestr supports Zoom as a source.

Prerequisites

• A Zoom Server-to-Server OAuth App
• Appropriate permissions related to meetings, users and participants must be added in the app's scopes user:read,user:write,user:read:admin,user:write:admin
• Obtain the client_id, client_secret and account_id credentials from the app

Please follow the steps below to get Zoom credentials

• Go to Zoom App Marketplace and log in with your Zoom account.
• Click Develop > Build App.
• Select Server-to-Server OAuth as the app type and click Create.
• Give your app a name.
• Go to App Credentials, you will find your Account ID, Client ID, and Client Secret.
• Go to Scopes and add the required permissions depending on the tables you want to ingest:
  • meeting:read:admin, meeting:read for meetings. Granular permissions: meeting:read:list_meetings, meeting:read:list_meetings:admin
  • user:read, user:read:admin for users. Granular permissions: user:read:list_users:admin
  • report:read:admin for participants. Granular permissions: report:read:list_meeting_participants:admin
• Go to Activation and activate your app. Your app will not work until it is activated.

URI format

zoom://?client_id=<client_id>&client_secret=<client_secret>&account_id=<account_id>

This command copies meetings data from the Zoom source to DuckDB.

ingestr ingest \
  --source-uri 'zoom://?client_id=abc&client_secret=xyz&account_id=123' \
  --source-table 'meetings' \
  --dest-uri duckdb:///zoom.duckdb \
  --dest-table 'dest.meetings'

## Tables

Zoom source allows ingesting the following tables:

Table	PK	Inc Key	Inc Strategy	Details
meetings	id	start_time	merge	Retrieve all valid previous meetings, live meetings, and upcoming scheduled meetings for all users in the given Zoom account. Permissions required: meeting:read:admin,meeting:read, Granular permissions, meeting:read:list_meetings,meeting:read:list_meetings:admin
users	id	–	merge	Retrieve a list of users in your account. Permissions required: user:read, user:write, user:read:admin, user:write:admin, Granular permissions: user:read:list_users:admin, Prerequisites: A Pro or higher plan.
participants	id	join_time	merge	Return a report of a past meeting that had participants, including the host. It only returns data for meetings within the last 6 months.Permissions required: report:read:admin. Granular permissions: report:read:list_meeting_participants:admin. Prerequisites: A Pro or higher plan.

Use these as the --source-table parameter in the ingestr ingest command.