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

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

Step 2: Add Zoom as a Stitch data source

  1. Sign into your Stitch account.
  2. On the Stitch Dashboard page, click the Add Integration button.

  3. Click the Zoom icon.

  4. 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.

  5. 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.
  6. 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

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:

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

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:

  1. Individual tables and columns

  2. All tables and columns

Click the tabs to view instructions for each selection method.

  1. In the integration’s Tables to Replicate tab, locate a table you want to replicate.
  2. To track a table, click the checkbox next to the table’s name. A blue checkmark means the table is set to replicate.

  3. To track a column, click the checkbox next to the column’s name. A blue checkmark means the column is set to replicate.

  4. Repeat this process for all the tables and columns you want to replicate.
  5. When finished, click the Finalize Your Selections button at the bottom of the screen to save your selections.
  1. Click into the integration from the Stitch Dashboard page.
  2. Click the Tables to Replicate tab.

  3. In the list of tables, click the box next to the Table Names column.
  4. In the menu that displays, click Track all Tables and Fields:

    The Track all Tables and Fields menu in the Tables to Replicate tab

  5. 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.

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.


Zoom table reference

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

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

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

email

meeting_uuid

Useful links

meeting_poll_results schema on GitHub

Zoom API method

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

email

STRING

meeting_uuid

STRING

name

STRING

question_details

ARRAY

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

id

meeting_id

Useful links

meeting_polls schema on GitHub

Zoom API method

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

id

STRING

meeting_id

STRING

questions

ARRAY

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

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

custom_questions

ARRAY

answers

ARRAY

required

BOOLEAN

title

STRING

type

STRING

meeting_id

STRING

questions

ARRAY

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

id

meeting_id

Useful links

meeting_registrants schema on GitHub

Zoom API method

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

address

STRING

city

STRING

comments

STRING

county

STRING

create_time

DATE-TIME

custom_questions

ARRAY

title

STRING

value

STRING

email

STRING

first_name

STRING

id

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

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

agenda

STRING

created_at

DATE-TIME

duration

INTEGER

encrypted_Password

STRING

h323_password

STRING

host_id

STRING

id

INTEGER

join_url

STRING

meeting_id

STRING

occurences

ARRAY

duration

INTEGER

occurence_id

STRING

start_time

DATE-TIME

status

STRING

password

STRING

pmi

INTEGER

recurrence

OBJECT

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

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

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

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

id

meeting_id

Useful links

report_meeting_participants schema on GitHub

Zoom API method

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

duration

STRING

id

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

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

dept

STRING

duration

INTEGER

end_time

DATE-TIME

id

INTEGER

meeting_id

STRING

participants_count

INTEGER

start_time

DATE-TIME

topic

STRING

total_minutes

INTEGER

tracking_fields

ARRAY

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

id

webinar_id

Useful links

report_webinar_participants schema on GitHub

Zoom API method

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

attentiveness_score

STRING

duration

STRING

id

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

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

dept

STRING

duration

INTEGER

end_time

DATE-TIME

host_id

STRING

id

INTEGER

participants_count

INTEGER

start_time

DATE-TIME

topic

STRING

total_minutes

INTEGER

tracking_fields

ARRAY

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

id

Useful links

users schema on GitHub

Zoom API method

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

created_at

DATE-TIME

dept

STRING

email

STRING

first_name

STRING

group_ids

ARRAY

id

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

id

webinar_uuid

Useful links

webinar_absentees schema on GitHub

Zoom API method

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

address

STRING

city

STRING

comments

STRING

county

STRING

create_time

DATE-TIME

custom_questions

ARRAY

title

STRING

value

STRING

email

STRING

first_name

STRING

id

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

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

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

id

webinar_id

Useful links

webinar_panelists schema on GitHub

Zoom API method

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

email

STRING

id

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

email

Useful links

webinar_poll_results schema on GitHub

Zoom API method

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

email

STRING

name

STRING

question_details

ARRAY

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

id

webinar_id

Useful links

webinar_polls schema on GitHub

Zoom API method

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

id

STRING

questions

ARRAY

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

email

Useful links

webinar_qna_results schema on GitHub

Zoom API method

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

email

STRING

name

STRING

question_details

ARRAY

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

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

custom_questions

ARRAY

answers

ARRAY

required

BOOLEAN

title

STRING

type

STRING

questions

ARRAY

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

id

Useful links

webinar_registrants schema on GitHub

Zoom API method

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

address

STRING

city

STRING

comments

STRING

county

STRING

create_time

DATE-TIME

custom_questions

ARRAY

title

STRING

value

STRING

email

STRING

first_name

STRING

id

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

id

webinar_id

Useful links

webinar_tracking_sources schema on GitHub

Zoom API method

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

id

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

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

agenda

STRING

created_at

DATE-TIME

duration

INTEGER

host_id

STRING

id

STRING

join_url

STRING

occurences

ARRAY

duration

INTEGER

occurence_id

STRING

start_time

DATE-TIME

status

STRING

recurrence

OBJECT

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

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

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.