Zoom (v2) (Beta) | 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 (v2) integration, including release status, useful links, and the features supported in Stitch.

STITCH
Release status	Released on	Supported by	Singer Community
Stitch plan	Standard	API availability	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:

Admin access in Zoom. This is required to allow Stitch to replicate data.

Step 1: 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.

Step 2: 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 3: Authorize Stitch to access Zoom

This feature is currently in beta and is not publicly available. Check the Zoom v1 setup documentation for the current version of the integration.

Click Authorize to sign into your Zoom account. You’ll be taken through a series of steps to allow Stitch to access data from Zoom.
Click Okay for each step.
Once your credentials are validated, you will be redirected back to Stitch. Click Check and Save to save the connection.

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.

Removing the Zoom integration

To completely disconnect Stitch from your Zoom account, you need to delete the integration from Stitch, and uninstall the Stitch app from Zoom.

Disconnecting Zoom from Stitch will stop the replication of Zoom data to your Stitch destination. There will be no impact to the Zoom data, as Stitch is a read-only integration with Zoom. All data that has already replicated to your Stitch destination will be maintained and under your control.

Step 1: Deleting your Zoom integration

To delete your Zoom integration from your Stitch account:

Log in to your Stitch account and open the Integrations tab.
Click your Zoom integration and click Settings.
Scroll down to the bottom of the page and click Delete.
Click Delete to confirm.

Step 2: Uninstalling Stitch in your Zoom account

To uninstall Stitch in your Zoom account:

Log in to your Zoom account go to the Added Apps page in the App Marketplace.
Under Apps in Production, find the Stitch app and click Remove.
In the dialog box that appears, click Remove to confirm.

Once the Stitch app is removed from your Zoom App Marketplace, the access token credentials associated with your Zoom integration connection will no longer be authorized and will be deleted from the Stitch environment.

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 2 of this integration.

This is the latest version of the Zoom 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_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
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

date_time

DATE-TIME

polling_id

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

anonymous

BOOLEAN

STRING

meeting_id

STRING

poll_type

INTEGER

questions

ARRAY

Click to expand questions

answer_max_character

INTEGER

answer_min_character

INTEGER

answer_required

BOOLEAN

answers

ARRAY

case_sensitive

BOOLEAN

name

STRING

prompts

ARRAY

Click to expand prompts

prompt_question

STRING

prompt_right_answers

ARRAY

rating_max_label

STRING

rating_max_value

INTEGER

rating_min_label

STRING

rating_min_value

INTEGER

right_answers

ARRAY

show_as_dropdown

BOOLEAN

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

country

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

participant_pin_code

INTEGER

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_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

assistant_id

STRING

created_at

DATE-TIME

duration

INTEGER

encrypted_password

STRING

h323_password

STRING

host_email

STRING

host_id

STRING

INTEGER

join_url

STRING

meeting_id

STRING

occurrences

ARRAY

Click to expand occurrences

duration

INTEGER

occurrence_id

STRING

start_time

DATE-TIME

status

STRING

password

STRING

pmi

STRING

pre_schedule

BOOLEAN

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

STRING

settings

OBJECT

Click to expand settings

allow_multiple_devices

BOOLEAN

alternative_host_update_polls

BOOLEAN

alternative_hosts

STRING

alternative_hosts_email_notification

BOOLEAN

approval_type

INTEGER

approved_or_denied_countries_or_regions

OBJECT

Click to expand approved_or_denied_countries_or_regions

approved_list

ARRAY

denied_list

ARRAY

enable

BOOLEAN

method

STRING

audio

STRING

audio_conference_info

STRING

authentication_domains

STRING

authentication_exception

ARRAY

Click to expand authentication_exception

email

STRING

join_url

STRING

name

STRING

authentication_name

STRING

authentication_option

STRING

auto_recording

STRING

breakout_room

OBJECT

Click to expand breakout_room

enable

BOOLEAN

rooms

ARRAY

Click to expand rooms

name

STRING

participants

ARRAY

calendar_type

INTEGER

close_registration

BOOLEAN

contact_email

STRING

contact_name

STRING

custom_keys

ARRAY

Click to expand custom_keys

key

STRING

value

STRING

email_notification

BOOLEAN

encryption_type

STRING

focus_mode

BOOLEAN

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_save_video_order

BOOLEAN

host_video

BOOLEAN

jbh_time

INTEGER

join_before_host

BOOLEAN

language_interpretation

OBJECT

Click to expand language_interpretation

enable

BOOLEAN

interpreters

ARRAY

Click to expand interpreters

email

STRING

languages

STRING

meeting_authentication

BOOLEAN

mute_upon_entry

BOOLEAN

participant_video

BOOLEAN

private_meeting

BOOLEAN

registrants_confirmation_email

BOOLEAN

registrants_email_notification

BOOLEAN

registration_type

INTEGER

show_share_button

BOOLEAN

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

visible

BOOLEAN

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

bo_mtg_id

STRING

customer_key

STRING

duration

INTEGER

failover

BOOLEAN

STRING

join_time

DATE-TIME

leave_time

DATE-TIME

meeting_id

STRING

name

STRING

registrant_id

STRING

status

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

custom_keys

ARRAY

Click to expand custom_keys

key

STRING

value

STRING

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

customer_key

STRING

duration

INTEGER

failover

BOOLEAN

STRING

join_time

DATE-TIME

leave_time

DATE-TIME

name

STRING

registrant_id

STRING

status

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_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

custom_keys

ARRAY

Click to expand custom_keys

key

STRING

value

STRING

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

custom_attributes

ARRAY

Click to expand custom_attributes

key

STRING

name

STRING

value

STRING

dept

STRING

display_name

STRING

email

STRING

employee_unique_id

STRING

first_name

STRING

group_ids

ARRAY

STRING

im_group_ids

ARRAY

last_client_version

STRING

last_login_time

DATE-TIME

last_name

STRING

plan_united_type

STRING

pmi

INTEGER

role_id

STRING

status

STRING

timezone

STRING

type

INTEGER

user_created_at

DATE-TIME

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_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

country

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_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

name_tag_description

STRING

name_tag_id

STRING

name_tag_name

STRING

name_tag_pronouns

STRING

virtual_background_id

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_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

date_time

DATE-TIME

polling_id

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

anonymous

BOOLEAN

STRING

poll_type

INTEGER

questions

ARRAY

Click to expand questions

answer_max_character

INTEGER

answer_min_character

INTEGER

answer_required

BOOLEAN

answers

ARRAY

case_sensitive

BOOLEAN

name

STRING

prompts

ARRAY

Click to expand prompts

prompt_question

STRING

prompt_right_answers

ARRAY

rating_max_label

STRING

rating_max_value

INTEGER

rating_min_label

STRING

rating_min_value

INTEGER

right_answers

ARRAY

show_as_dropdown

BOOLEAN

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_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

country

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_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_email

STRING

host_id

STRING

INTEGER

is_simulive

BOOLEAN

join_url

STRING

occurrences

ARRAY

Click to expand occurrences

duration

INTEGER

occurrence_id

STRING

start_time

DATE-TIME

status

STRING

password

STRING

record_file_id

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

STRING

settings

OBJECT

Click to expand settings

add_audio_watermark

BOOLEAN

add_watermark

BOOLEAN

allow_multiple_devices

BOOLEAN

alternative_host_update_polls

BOOLEAN

alternative_hosts

STRING

approval_type

INTEGER

attendees_and_panelists_reminder_email_notification

OBJECT

Click to expand attendees_and_panelists_reminder_email_notification

enable

BOOLEAN

type

INTEGER

audio

STRING

audio_conference_info

STRING

authentication_domains

STRING

authentication_name

STRING

authentication_option

STRING

auto_recording

STRING

contact_email

STRING

contact_name

STRING

email_language

STRING

enable_session_branding

BOOLEAN

follow_up_absentees_email_notification

OBJECT

Click to expand follow_up_absentees_email_notification

enable

BOOLEAN

type

INTEGER

follow_up_attendees_email_notification

OBJECT

Click to expand follow_up_attendees_email_notification

enable

BOOLEAN

type

INTEGER

global_dial_in_countries

ARRAY

hd_video

BOOLEAN

hd_video_for_attendees

BOOLEAN

host_video

BOOLEAN

language_interpretation

OBJECT

Click to expand language_interpretation

enable

BOOLEAN

interpreters

ARRAY

Click to expand interpreters

email

STRING

languages

STRING

meeting_authentication

BOOLEAN

notify_registrants

BOOLEAN

on_demand

BOOLEAN

panelist_authentication

BOOLEAN

panelists_invitation_email_notification

BOOLEAN

panelists_video

BOOLEAN

post_webinar_survey

BOOLEAN

practice_session

BOOLEAN

question_and_answer

OBJECT

Click to expand question_and_answer

allow_anonymous_questions

BOOLEAN

allow_auto_reply

BOOLEAN

answer_questions

STRING

attendees_can_comment

BOOLEAN

attendees_can_upvote

BOOLEAN

auto_reply_text

STRING

enable

BOOLEAN

registrants_confirmation_email

BOOLEAN

registrants_email_notification

BOOLEAN

registrants_restrict_number

INTEGER

registration_type

INTEGER

send_1080p_video_to_attendees

BOOLEAN

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