Zoom (v1) | Stitch Documentation

Zoom is supported by the Singer community
This integration is powered by Singer's Zoom tap. For support, visit the GitHub repo or join the Singer Slack.

Zoom integration summary

Stitch’s Zoom integration replicates data using the Zoom REST API v2. Refer to the Schema section for a list of objects available for replication.

Zoom feature snapshot

A high-level look at Stitch's Zoom (v1) integration, including release status, useful links, and the features supported in Stitch.

STITCH
Release status	Deprecated on	Supported by	Singer Community
Stitch plan	Standard	API availability	Not available
Singer GitHub repository	singer-io/tap-zoom
REPLICATION SETTINGS
Anchor Scheduling	Supported	Advanced Scheduling	Supported
Table-level reset	Unsupported	Configurable Replication Methods	Unsupported
DATA SELECTION
Table selection	Supported	Column selection	Supported
Select all	Supported
TRANSPARENCY
Extraction Logs	Supported	Loading Reports	Supported

Connecting Zoom

Zoom setup requirements

To set up Zoom in Stitch, you need:

A Zoom authentication app. You’ll need one of the following apps to connect your Zoom account to Stitch:
- An OAuth app. Click here for more information on OAuth apps. If using a Zoom OAuth App to connect to Stitch, make sure that the following scopes are included in the app:
  - account:read:admin
  - meeting:read:admin
  - report:read:admin
  - user:read:admin
  - webinar:read:admin
- A JSON Web Tokens (JWT) app. Click here for more information on JWT apps.

Step 1: Obtain your Zoom authentication app tokens

Login to your Zoom account on the Zoom App Marketplace.
Click Manage in the upper right corner of the page.
Click on the OAuth or JWT app you’d like to use to connect to Stitch.
If using a JWT app, copy the JWT. If using an OAuth app, copy the Client ID, Client Secret, and Refresh Token.
Keep your token(s) readily available for the next step.

Step 2: Add Zoom as a Stitch data source

Sign into your Stitch account.
On the Stitch Dashboard page, click the Add Integration button.
Click the Zoom icon.
Enter a name for the integration. This is the name that will display on the Stitch Dashboard for the integration; it’ll also be used to create the schema in your destination.

For example, the name “Stitch Zoom” would create a schema called stitch_zoom in the destination. Note: Schema names cannot be changed after you save the integration.
If connecting to Stitch with a Zoom OAuth app, paste the Client ID, Client Secret, and Refresh Token you obtained in Step 1 into their respective fields.
If connecting to Stitch with a Zoom JWT app, paste the JWT you obtained in Step 1 into the JWT field.

Step 3: Create a replication schedule

Replication schedules affect the time Extraction begins, not the time to data loaded. Refer to the Replication Scheduling documentation for more information.

In the Replication Frequency section, you’ll create the integration’s replication schedule. An integration’s replication schedule determines how often Stitch runs a replication job, and the time that job begins.

Zoom integrations support the following replication scheduling methods:

Replication Frequency
Anchor Scheduling
Advanced Scheduling using Cron (Advanced or Premium plans only)

To keep your row usage low, consider setting the integration to replicate less frequently. See the Understanding and Reducing Your Row Usage guide for tips on reducing your usage.

Step 4: Set objects to replicate

Is an object missing or not replicating? Verify that the object meets the requirements for selection and replication.

The last step is to select the tables and columns you want to replicate. Learn about the available tables for this integration.

Note: If a replication job is currently in progress, new selections won’t be used until the next job starts.

For Zoom integrations, you can select:

Individual tables and columns
All tables and columns

Click the tabs to view instructions for each selection method.

In the integration’s Tables to Replicate tab, locate a table you want to replicate.
To track a table, click the checkbox next to the table’s name. A blue checkmark means the table is set to replicate.
To track a column, click the checkbox next to the column’s name. A blue checkmark means the column is set to replicate.
Repeat this process for all the tables and columns you want to replicate.
When finished, click the Finalize Your Selections button at the bottom of the screen to save your selections.

Important: Using the Select All feature will overwrite any previous selections. However, selections aren’t final until Finalize Your Selections is clicked. Clicking Cancel will restore your previous selections. Refer to the Select All guide for more info about this feature.

Click into the integration from the Stitch Dashboard page.
Click the Tables to Replicate tab.
In the list of tables, click the box next to the Table Names column.
In the menu that displays, click Track all Tables and Fields:
Click the Finalize Your Selections button at the bottom of the page to save your data selections.

Initial and historical replication jobs

After you finish setting up Zoom, its Sync Status may show as Pending on either the Stitch Dashboard or in the Integration Details page.

For a new integration, a Pending status indicates that Stitch is in the process of scheduling the initial replication job for the integration. This may take some time to complete.

Initial replication jobs with Anchor Scheduling

If using Anchor Scheduling, an initial replication job may not kick off immediately. This depends on the selected Replication Frequency and Anchor Time. Refer to the Anchor Scheduling documentation for more information.

Free historical data loads

The first seven days of replication, beginning when data is first replicated, are free. Rows replicated from the new integration during this time won’t count towards your quota. Stitch offers this as a way of testing new integrations, measuring usage, and ensuring historical data volumes don’t quickly consume your quota.

Replication will continue after the seven days are over. If you’re no longer interested in this source, be sure to pause or delete the integration to prevent unwanted usage.

Zoom table reference

Schemas and versioning

Schemas and naming conventions can change from version to version, so we recommend verifying your integration’s version before continuing.

The schema and info displayed below is for version 1 of this integration.

Table and column names in your destination

Depending on your destination, table and column names may not appear as they are outlined below.

For example: Object names are lowercased in Redshift (CusTomERs > customers), while case is maintained in PostgreSQL destinations (CusTomERs > CusTomERs). Refer to the Loading Guide for your destination for more info.

meeting_files

The meeting_files table contains information about files shared during meetings in your Zoom account. Note:Zoom deletes these files 24 hours after completion of the meeting.

Replication Method

Full Table

Primary Keys

meeting_uuid

file_name

Useful links

meeting_files schema on GitHub

Zoom API method

meeting_files table foreign keys

Join meeting_files with	on
meeting_poll_results	meeting_files.meeting_uuid = meeting_poll_results.meeting_uuid
meetings	meeting_files.meeting_uuid = meetings.uuid

meeting_files table schema

download_url

STRING

file_name

STRING

file_size

INTEGER

meeting_uuid

STRING

meeting_poll_results

The meeting_poll_results table contains information about the results of polls from your Zoom meetings.

Note: This data is available only if the host user’s role is Pro and the meeting was scheduled.

Replication Method

Full Table

Primary Keys

meeting_uuid

Useful links

meeting_poll_results schema on GitHub

Zoom API method

meeting_poll_results table foreign keys

Join meeting_poll_results with	on
meeting_files	meeting_poll_results.meeting_uuid = meeting_files.meeting_uuid
meetings	meeting_poll_results.meeting_uuid = meetings.uuid

meeting_poll_results table schema

email

STRING

meeting_uuid

STRING

name

STRING

question_details

ARRAY

Click to expand question_details

answer

STRING

question

STRING

meeting_polls

The meeting_polls table contains information about the polls from your Zoom meetings.

Replication Method

Full Table

Primary Keys

meeting_id

Useful links

meeting_polls schema on GitHub

Zoom API method

meeting_polls table foreign keys

Join meeting_polls with	on
meeting_questions	meeting_polls.meeting_id = meeting_questions.meeting_id
meeting_registrants	meeting_polls.meeting_id = meeting_registrants.meeting_id
meetings	meeting_polls.meeting_id = meetings.meeting_id
report_meeting_participants	meeting_polls.meeting_id = report_meeting_participants.meeting_id
report_meetings	meeting_polls.meeting_id = report_meetings.meeting_id

meeting_polls table schema

STRING

meeting_id

STRING

questions

ARRAY

Click to expand questions

answers

ARRAY

name

STRING

type

STRING

status

STRING

title

STRING

meeting_questions

The meeting_questions table contains questions that users will see when registering for your Zoom meetings.

Replication Method

Full Table

Primary Key

meeting_id

Useful links

meeting_questions schema on GitHub

Zoom API method

meeting_questions table foreign keys

Join meeting_questions with	on
meeting_polls	meeting_questions.meeting_id = meeting_polls.meeting_id
meeting_registrants	meeting_questions.meeting_id = meeting_registrants.meeting_id
meetings	meeting_questions.meeting_id = meetings.meeting_id
report_meeting_participants	meeting_questions.meeting_id = report_meeting_participants.meeting_id
report_meetings	meeting_questions.meeting_id = report_meetings.meeting_id

meeting_questions table schema

custom_questions

ARRAY

Click to expand custom_questions

answers

ARRAY

required

BOOLEAN

title

STRING

type

STRING

meeting_id

STRING

questions

ARRAY

Click to expand questions

field_name

STRING

required

BOOLEAN

meeting_registrants

The meeting_registrants table contains the list of users who have registered for your Zoom meetings.

Replication Method

Full Table

Primary Keys

meeting_id

Useful links

meeting_registrants schema on GitHub

Zoom API method

meeting_registrants table foreign keys

Join meeting_registrants with	on
meeting_polls	meeting_registrants.meeting_id = meeting_polls.meeting_id
meeting_questions	meeting_registrants.meeting_id = meeting_questions.meeting_id
meetings	meeting_registrants.meeting_id = meetings.meeting_id
report_meeting_participants	meeting_registrants.meeting_id = report_meeting_participants.meeting_id
report_meetings	meeting_registrants.meeting_id = report_meetings.meeting_id

meeting_registrants table schema

address

STRING

city

STRING

comments

STRING

county

STRING

create_time

DATE-TIME

custom_questions

ARRAY

Click to expand custom_questions

title

STRING

value

STRING

email

STRING

first_name

STRING

industry

STRING

job_title

STRING

join_url

STRING

last_name

STRING

meeting_id

STRING

no_of_employees

STRING

org

STRING

phone

STRING

purchasing_time_frame

STRING

role_in_purchase_process

STRING

state

STRING

status

STRING

zip

STRING

meetings

The meetings table contains information about instant, scheduled, and recurring meetings in your Zoom account.

Replication Method

Full Table

Primary Key

uuid

Useful links

meetings schema on GitHub

Zoom API method

meetings table foreign keys

Join meetings with	on
meeting_poll_results	meetings.uuid = meeting_poll_results.meeting_uuid
meeting_files	meetings.uuid = meeting_files.meeting_uuid
meeting_polls	meetings.meeting_id = meeting_polls.meeting_id
meeting_questions	meetings.meeting_id = meeting_questions.meeting_id
meeting_registrants	meetings.meeting_id = meeting_registrants.meeting_id
report_meeting_participants	meetings.meeting_id = report_meeting_participants.meeting_id
report_meetings	meetings.meeting_id = report_meetings.meeting_id

meetings table schema

agenda

STRING

created_at

DATE-TIME

duration

INTEGER

encrypted_Password

STRING

h323_password

STRING

host_id

STRING

INTEGER

join_url

STRING

meeting_id

STRING

occurences

ARRAY

Click to expand occurences

duration

INTEGER

occurence_id

STRING

start_time

DATE-TIME

status

STRING

password

STRING

pmi

INTEGER

recurrence

OBJECT

Click to expand recurrence

end_date_time

DATE-TIME

end_times

INTEGER

monthly_day

INTEGER

monthly_week

INTEGER

monthly_week_day

INTEGER

repeat_interval

INTEGER

type

INTEGER

weekly_days

INTEGER

settings

OBJECT

Click to expand settings

alternative_hosts

STRING

approval_type

INTEGER

audio

STRING

authentication_domains

STRING

authentication_option

STRING

auto_recording

STRING

close_registration

BOOLEAN

cn_meeting

BOOLEAN

contact_email

BOOLEAN

contact_name

BOOLEAN

enforce_login

BOOLEAN

enforce_login_domains

STRING

global_dial_in_countries

ARRAY

global_dial_in_numbers

ARRAY

Click to expand global_dial_in_numbers

city

STRING

country

STRING

country_name

STRING

number

STRING

type

STRING

host_video

BOOLEAN

in_meeting

BOOLEAN

join_before_host

BOOLEAN

meeting_authentication

BOOLEAN

mute_upon_entry

BOOLEAN

participant_video

BOOLEAN

registrants_confirmation_email

BOOLEAN

registrants_email_notification

BOOLEAN

registration_type

INTEGER

use_pmi

BOOLEAN

waiting_room

BOOLEAN

watermark

BOOLEAN

start_time

DATE-TIME

start_url

STRING

status

STRING

timezone

STRING

topic

STRING

tracking_fields

ARRAY

Click to expand tracking_fields

field

STRING

value

STRING

type

INTEGER

uuid

STRING

report_meeting_participants

The report_meeting_participants table contains information about your Zoom’s meeting participants.

Note: As per Zoom’s docs, a Zoom Pro plan or higher is required to retrieve this data.

Replication Method

Full Table

Primary Keys

meeting_id

Useful links

report_meeting_participants schema on GitHub

Zoom API method

report_meeting_participants table foreign keys

Join report_meeting_participants with	on
meeting_polls	report_meeting_participants.meeting_id = meeting_polls.meeting_id
meeting_questions	report_meeting_participants.meeting_id = meeting_questions.meeting_id
meeting_registrants	report_meeting_participants.meeting_id = meeting_registrants.meeting_id
meetings	report_meeting_participants.meeting_id = meetings.meeting_id
report_meetings	report_meeting_participants.meeting_id = report_meetings.meeting_id
users	report_meeting_participants.user_id = users.id
report_webinar_participants	report_meeting_participants.user_id = report_webinar_participants.user_id

report_meeting_participants table schema

duration

STRING

join_time

DATE-TIME

leave_time

DATE-TIME

meeting_id

STRING

name

STRING

user_email

STRING

user_id

STRING

report_meetings

The report_meetings table contains detailed reports about past Zoom meetings.

Replication Method

Full Table

Primary Key

uuid

Useful links

report_meetings schema on GitHub

Zoom API method

report_meetings table foreign keys

Join report_meetings with	on
meeting_polls	report_meetings.meeting_id = meeting_polls.meeting_id
meeting_questions	report_meetings.meeting_id = meeting_questions.meeting_id
meeting_registrants	report_meetings.meeting_id = meeting_registrants.meeting_id
meetings	report_meetings.meeting_id = meetings.meeting_id
report_meeting_participants	report_meetings.meeting_id = report_meeting_participants.meeting_id

report_meetings table schema

dept

STRING

duration

INTEGER

end_time

DATE-TIME

INTEGER

meeting_id

STRING

participants_count

INTEGER

start_time

DATE-TIME

topic

STRING

total_minutes

INTEGER

tracking_fields

ARRAY

Click to expand tracking_fields

field

STRING

value

STRING

type

INTEGER

user_email

STRING

user_name

STRING

uuid

STRING

report_webinar_participants

The report_webinar_participants table contains information about your Zoom’s webinar participants.

Note: As per Zoom’s docs, a Pro plan or higher with with the webinar add-on enabled is required to retrieve this data.

Replication Method

Full Table

Primary Keys

webinar_id

Useful links

report_webinar_participants schema on GitHub

Zoom API method

report_webinar_participants table foreign keys

Join report_webinar_participants with	on
users	report_webinar_participants.user_id = users.id
report_meeting_participants	report_webinar_participants.user_id = report_meeting_participants.user_id
report_webinars	report_webinar_participants.webinar_id = report_webinars.webinar_id
webinar_panelists	report_webinar_participants.webinar_id = webinar_panelists.webinar_id
webinar_registrants	report_webinar_participants.webinar_id = webinar_registrants.webinar_id
webinar_polls	report_webinar_participants.webinar_id = webinar_polls.webinar_id
webinar_questions	report_webinar_participants.webinar_id = webinar_questions.webinar_id
webinar_tracking_sources	report_webinar_participants.webinar_id = webinar_tracking_sources.webinar_id

report_webinar_participants table schema

attentiveness_score

STRING

duration

STRING

join_time

DATE-TIME

leave_time

DATE-TIME

name

STRING

user_email

STRING

user_id

STRING

webinar_id

STRING

report_webinars

The report_webinars table contains information about past webinars in your Zoom account.

Replication Method

Full Table

Primary Key

uuid

Useful links

report_webinars schema on GitHub

Zoom API method

report_webinars table foreign keys

Join report_webinars with	on
report_webinar_participants	report_webinars.webinar_id = report_webinar_participants.webinar_id
webinar_panelists	report_webinars.webinar_id = webinar_panelists.webinar_id
webinar_registrants	report_webinars.webinar_id = webinar_registrants.webinar_id
webinar_polls	report_webinars.webinar_id = webinar_polls.webinar_id
webinar_questions	report_webinars.webinar_id = webinar_questions.webinar_id
webinar_tracking_sources	report_webinars.webinar_id = webinar_tracking_sources.webinar_id
webinar_absentees	report_webinars.uuid = webinar_absentees.webinar_uuid
webinar_files	report_webinars.uuid = webinar_files.webinar_uuid
webinar_poll_results	report_webinars.uuid = webinar_poll_results.webinar_uuid
webinar_qna_results	report_webinars.uuid = webinar_qna_results.webinar_uuid
webinars	report_webinars.uuid = webinars.uuid

report_webinars table schema

dept

STRING

duration

INTEGER

end_time

DATE-TIME

host_id

STRING

INTEGER

participants_count

INTEGER

start_time

DATE-TIME

topic

STRING

total_minutes

INTEGER

tracking_fields

ARRAY

Click to expand tracking_fields

field

STRING

value

STRING

type

INTEGER

user_email

STRING

user_id

STRING

user_name

STRING

uuid

STRING

webinar_id

STRING

users

The users table contains user data from your Zoom account.

Replication Method

Full Table

Primary Key

Useful links

users schema on GitHub

Zoom API method

users table foreign keys

Join users with	on
report_meeting_participants	users.id = report_meeting_participants.user_id
report_webinar_participants	users.id = report_webinar_participants.user_id

users table schema

created_at

DATE-TIME

dept

STRING

email

STRING

first_name

STRING

group_ids

ARRAY

STRING

im_group_ids

ARRAY

last_client_version

STRING

last_login_time

DATE-TIME

last_name

STRING

pmi

INTEGER

status

STRING

timezone

STRING

type

INTEGER

verified

INTEGER

webinar_absentees

The webinar_absentees table contains information about webinar absentees from your Zoom webinars.

Replication Method

Full Table

Primary Keys

webinar_uuid

Useful links

webinar_absentees schema on GitHub

Zoom API method

webinar_absentees table foreign keys

Join webinar_absentees with	on
report_webinars	webinar_absentees.webinar_uuid = report_webinars.uuid
webinar_files	webinar_absentees.webinar_uuid = webinar_files.webinar_uuid
webinar_poll_results	webinar_absentees.webinar_uuid = webinar_poll_results.webinar_uuid
webinar_qna_results	webinar_absentees.webinar_uuid = webinar_qna_results.webinar_uuid
webinars	webinar_absentees.webinar_uuid = webinars.uuid

webinar_absentees table schema

address

STRING

city

STRING

comments

STRING

county

STRING

create_time

DATE-TIME

custom_questions

ARRAY

Click to expand custom_questions

title

STRING

value

STRING

email

STRING

first_name

STRING

industry

STRING

job_title

STRING

join_url

STRING

last_name

STRING

no_of_employees

STRING

org

STRING

phone

STRING

purchasing_time_frame

STRING

role_in_purchase_process

STRING

state

STRING

status

STRING

webinar_uuid

STRING

zip

STRING

webinar_files

The webinar_files table contains information about files shared in-meeting in your Zoom account.

Note: Zoom deletes these files 24 hours after completion of the webinar.

Replication Method

Full Table

Primary Keys

webinar_uuid

file_name

Useful links

webinar_files schema on GitHub

Zoom API method

webinar_files table foreign keys

Join webinar_files with	on
report_webinars	webinar_files.webinar_uuid = report_webinars.uuid
webinar_absentees	webinar_files.webinar_uuid = webinar_absentees.webinar_uuid
webinar_poll_results	webinar_files.webinar_uuid = webinar_poll_results.webinar_uuid
webinar_qna_results	webinar_files.webinar_uuid = webinar_qna_results.webinar_uuid
webinars	webinar_files.webinar_uuid = webinars.uuid

webinar_files table schema

download_url

STRING

file_name

STRING

file_size

INTEGER

webinar_uuid

STRING

webinar_panelists

The webinar_panelists table contains information about your Zoom webinar panelists.

Note: As per Zoom’s docs, a Pro plan or higher with with the webinar add-on enabled is required to retrieve this data.

Replication Method

Full Table

Primary Keys

webinar_id

Useful links

webinar_panelists schema on GitHub

Zoom API method

webinar_panelists table foreign keys

Join webinar_panelists with	on
report_webinar_participants	webinar_panelists.webinar_id = report_webinar_participants.webinar_id
report_webinars	webinar_panelists.webinar_id = report_webinars.webinar_id
webinar_registrants	webinar_panelists.webinar_id = webinar_registrants.webinar_id
webinar_polls	webinar_panelists.webinar_id = webinar_polls.webinar_id
webinar_questions	webinar_panelists.webinar_id = webinar_questions.webinar_id
webinar_tracking_sources	webinar_panelists.webinar_id = webinar_tracking_sources.webinar_id

webinar_panelists table schema

email

STRING

join_url

STRING

name

STRING

webinar_id

STRING

webinar_poll_results

The webinar_poll_results data contains information about poll results from specific Zoom webinars.

Note: As per Zoom’s docs, the following requirements must be met to retrieve this data:

A Zoom webinar license
A Pro plan or higher
An authentication app with the webinar:read:admin and webinar:read scopes

Replication Method

Full Table

Primary Keys

webinar_uuid

Useful links

webinar_poll_results schema on GitHub

Zoom API method

webinar_poll_results table foreign keys

Join webinar_poll_results with	on
report_webinars	webinar_poll_results.webinar_uuid = report_webinars.uuid
webinar_absentees	webinar_poll_results.webinar_uuid = webinar_absentees.webinar_uuid
webinar_files	webinar_poll_results.webinar_uuid = webinar_files.webinar_uuid
webinar_qna_results	webinar_poll_results.webinar_uuid = webinar_qna_results.webinar_uuid
webinars	webinar_poll_results.webinar_uuid = webinars.uuid

webinar_poll_results table schema

email

STRING

name

STRING

question_details

ARRAY

Click to expand question_details

answer

STRING

question

STRING

webinar_uuid

STRING

webinar_polls

The webinar_polls table contains information about polls in your Zoom webinars.

Replication Method

Full Table

Primary Keys

webinar_id

Useful links

webinar_polls schema on GitHub

Zoom API method

webinar_polls table foreign keys

Join webinar_polls with	on
report_webinar_participants	webinar_polls.webinar_id = report_webinar_participants.webinar_id
report_webinars	webinar_polls.webinar_id = report_webinars.webinar_id
webinar_panelists	webinar_polls.webinar_id = webinar_panelists.webinar_id
webinar_registrants	webinar_polls.webinar_id = webinar_registrants.webinar_id
webinar_questions	webinar_polls.webinar_id = webinar_questions.webinar_id
webinar_tracking_sources	webinar_polls.webinar_id = webinar_tracking_sources.webinar_id

webinar_polls table schema

STRING

questions

ARRAY

Click to expand questions

answers

ARRAY

name

STRING

type

STRING

status

STRING

title

STRING

webinar_id

STRING

webinar_qna_results

The webinar_qna_results table contains information about about the questions and answers from specific Zoom webinars.

Replication Method

Full Table

Primary Keys

webinar_uuid

Useful links

webinar_qna_results schema on GitHub

Zoom API method

webinar_qna_results table foreign keys

Join webinar_qna_results with	on
report_webinars	webinar_qna_results.webinar_uuid = report_webinars.uuid
webinar_absentees	webinar_qna_results.webinar_uuid = webinar_absentees.webinar_uuid
webinar_files	webinar_qna_results.webinar_uuid = webinar_files.webinar_uuid
webinar_poll_results	webinar_qna_results.webinar_uuid = webinar_poll_results.webinar_uuid
webinars	webinar_qna_results.webinar_uuid = webinars.uuid

webinar_qna_results table schema

email

STRING

name

STRING

question_details

ARRAY

Click to expand question_details

answer

STRING

question

STRING

webinar_uuid

STRING

webinar_questions

The webinar_questions table contains information about your questions to be answered when registering for a Zoom webinar.

Note: As per Zoom’s docs, the following requirements must be met to retrieve this data:

A Pro plan or higher with a webinar add-on
An authentication app with the webinar:read:admin and webinar:read scopes

Replication Method

Full Table

Primary Key

webinar_id

Useful links

webinar_questions schema on GitHub

Zoom API method

webinar_questions table foreign keys

Join webinar_questions with	on
report_webinar_participants	webinar_questions.webinar_id = report_webinar_participants.webinar_id
report_webinars	webinar_questions.webinar_id = report_webinars.webinar_id
webinar_panelists	webinar_questions.webinar_id = webinar_panelists.webinar_id
webinar_registrants	webinar_questions.webinar_id = webinar_registrants.webinar_id
webinar_polls	webinar_questions.webinar_id = webinar_polls.webinar_id
webinar_tracking_sources	webinar_questions.webinar_id = webinar_tracking_sources.webinar_id

webinar_questions table schema

custom_questions

ARRAY

Click to expand custom_questions

answers

ARRAY

required

BOOLEAN

title

STRING

type

STRING

questions

ARRAY

Click to expand questions

field_name

STRING

required

BOOLEAN

webinar_id

STRING

webinar_registrants

The webinar_registrants table contains information about the users registered for a webinar in your Zoom account. Only webinars where registration is required are included in this table.

Note: As per Zoom’s docs, the following requirements must be met to retrieve this data:

A Pro plan or higher with a webinar add-on
An authentication app with the webinar:read:admin and webinar:read scopes

Replication Method

Full Table

Primary Keys

webinar_id

Useful links

webinar_registrants schema on GitHub

Zoom API method

webinar_registrants table foreign keys

Join webinar_registrants with	on
report_webinar_participants	webinar_registrants.webinar_id = report_webinar_participants.webinar_id
report_webinars	webinar_registrants.webinar_id = report_webinars.webinar_id
webinar_panelists	webinar_registrants.webinar_id = webinar_panelists.webinar_id
webinar_polls	webinar_registrants.webinar_id = webinar_polls.webinar_id
webinar_questions	webinar_registrants.webinar_id = webinar_questions.webinar_id
webinar_tracking_sources	webinar_registrants.webinar_id = webinar_tracking_sources.webinar_id

webinar_registrants table schema

address

STRING

city

STRING

comments

STRING

county

STRING

create_time

DATE-TIME

custom_questions

ARRAY

Click to expand custom_questions

title

STRING

value

STRING

email

STRING

first_name

STRING

industry

STRING

job_title

STRING

join_url

STRING

last_name

STRING

no_of_employees

STRING

org

STRING

phone

STRING

purchasing_time_frame

STRING

role_in_purchase_process

STRING

state

STRING

status

STRING

webinar_id

STRING

zip

STRING

webinar_tracking_sources

The webinar_tracking_sources lists all information about tracking sources in your Zoom account. Only webinars where registration is required will be included in this table.

Note: As per Zoom’s docs, the following requirements must be met to retrieve this data:

A Zoom webinar license
An authentication app with the webinar:read:admin and webinar:read scopes

Replication Method

Full Table

Primary Keys

webinar_id

Useful links

webinar_tracking_sources schema on GitHub

Zoom API method

webinar_tracking_sources table foreign keys

Join webinar_tracking_sources with	on
report_webinar_participants	webinar_tracking_sources.webinar_id = report_webinar_participants.webinar_id
report_webinars	webinar_tracking_sources.webinar_id = report_webinars.webinar_id
webinar_panelists	webinar_tracking_sources.webinar_id = webinar_panelists.webinar_id
webinar_registrants	webinar_tracking_sources.webinar_id = webinar_registrants.webinar_id
webinar_polls	webinar_tracking_sources.webinar_id = webinar_polls.webinar_id
webinar_questions	webinar_tracking_sources.webinar_id = webinar_questions.webinar_id

webinar_tracking_sources table schema

STRING

registration_count

INTEGER

source_name

STRING

tracking_url

STRING

visitor_count

INTEGER

webinar_id

STRING

webinars

The webinars table contains information bout webinars scheduled from your Zoom account.

Note: As per Zoom’s docs, the following requirements must be met to retrieve this data:

A Pro plan or higher with a webinar add-on
An authentication app with the webinar:read:admin and webinar:read scopes

Replication Method

Full Table

Primary Key

uuid

Useful links

webinars schema on GitHub

Zoom API method

webinars table foreign keys

Join webinars with	on
report_webinars	webinars.uuid = report_webinars.uuid
webinar_absentees	webinars.uuid = webinar_absentees.webinar_uuid
webinar_files	webinars.uuid = webinar_files.webinar_uuid
webinar_poll_results	webinars.uuid = webinar_poll_results.webinar_uuid
webinar_qna_results	webinars.uuid = webinar_qna_results.webinar_uuid

webinars table schema

agenda

STRING

created_at

DATE-TIME

duration

INTEGER

host_id

STRING

join_url

STRING

occurences

ARRAY

Click to expand occurences

duration

INTEGER

occurence_id

STRING

start_time

DATE-TIME

status

STRING

recurrence

OBJECT

Click to expand recurrence

end_date_time

DATE-TIME

end_times

INTEGER

monthly_day

INTEGER

monthly_week

INTEGER

monthly_week_day

INTEGER

repeat_interval

INTEGER

type

INTEGER

weekly_days

INTEGER

settings

OBJECT

Click to expand settings

allow_multiple_devices

BOOLEAN

alternative_hosts

STRING

approval_type

INTEGER

audio

STRING

authentication_domains

STRING

authentication_option

STRING

auto_recording

STRING

close_registration

BOOLEAN

contact_email

BOOLEAN

contact_name

BOOLEAN

enforce_login

BOOLEAN

enforce_login_domains

STRING

global_dial_in_countries

ARRAY

hd_video

BOOLEAN

host_video

BOOLEAN

meeting_authentication

BOOLEAN

notify_registrants

BOOLEAN

on_demand

BOOLEAN

panelists_video

BOOLEAN

post_webinar_survey

BOOLEAN

practice_session

BOOLEAN

registrants_confirmation_email

BOOLEAN

registrants_email_notification

BOOLEAN

registrants_restrict_number

INTEGER

registration_type

INTEGER

show_share_button

BOOLEAN

survey_url

STRING

start_time

DATE-TIME

start_url

STRING

timezone

STRING

topic

STRING

tracking_fields

ARRAY

Click to expand tracking_fields

field

STRING

value

STRING

type

INTEGER

uuid

STRING

Questions? Feedback?

Did this article help? If you have questions or feedback, feel free to submit a pull request with your suggestions, open an issue on GitHub, or reach out to us.

Related	Troubleshooting
Destination & Integration Compatibility Replication Scheduling Syncing Historical SaaS Data Resetting Replication Keys Nested Data Structures & Row Count Impact	Third-Party Downtime Understanding & Reducing Your Usage Re-Authorizing Integrations Replication Issues