# Zoom

Zoom is a video conferencing platform.

Zoom integration replicates data using the [Zoom API](https://developers.zoom.us/docs/api/).

See the [Schema](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#Schema) section for a list of objects available for replication.

## Preparing for authentication

To access your data, you need to authenticate the connection with your account credentials.

Information noteMake sure that the account you use has read access to the tables you want to fetch.

Before connecting Zoom with QTC, ensure the following requirements are met:

* You must have a Zoom Pro plan or higher.
* For webinar use, your plan must include the Webinar Add-On, and the feature must be enabled in your Zoom instance.
* Your Zoom account has an admin role or higher.

To set up a Zoom App, choose one of the following:

* Internal App (Server-to-Server OAuth)
  1. Follow the instructions at [Zoom Internal Apps documentation](https://developers.zoom.us/docs/internal-apps/).
  2. In the app settings, add the required scopes listed below.
* OAuth App
  1. Follow the instructions at [Creating an OAuth App](https://developers.zoom.us/docs/integrations/create/).
  2. In the app settings, add the required scopes listed below.

For both app types, add the following scopes:

* `meeting:read:list_meetings:admin`
* `meeting:read:list_poll_results:admin`
* `meeting:read:list_polls:admin`
* `meeting:read:list_registrants:admin`
* `meeting:read:list_registration_questions:admin`
* `meeting:read:meeting:admin`
* `report:read:list_meeting_participants:admin`
* `report:read:list_webinar_participants:admin`
* `report:read:meeting:admin`
* `report:read:webinar:admin`
* `user:read:list_users:admin`
* `webinar:read:list_absentees:admin`
* `webinar:read:list_panelists:admin`
* `webinar:read:list_past_polls:admin`
* `webinar:read:list_polls:admin`
* `webinar:read:list_registrants:admin`
* `webinar:read:list_registration_questions:admin`
* `webinar:read:list_tracking_sources:admin`
* `webinar:read:list_webinars:admin`
* `webinar:read:past_qa:admin`
* `webinar:read:webinar:admin`

## Creating the connection

For more information, see [Connecting to SaaS applications](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Landing/connecting-web-applications.htm).

1. Click Authenticate when you have filled in the required connection settings.

   You may be asked to log in to the source application.

   A window is displayed with an authentication code.

2. Copy the code to the clipboard and return to the connection dialog.

3. Paste the code in Complete authentication with the code provided by the source and click Verify.

   Tip noteYou may need to scroll down to see this field.

   When status is Verified, the authentication is verified.

4. Provide a name for the connection in Connection name.

5. Select Open connection metadata to define metadata for the connection when it has been created.

Connection settings

| Setting | Description |
| --- | --- |
| Data gateway | Select a Data Movement gateway if required by your use case.<br><br>Information note<br><br>This field is not available with the Qlik Talend Cloud Starter subscription, as it does not support Data Movement gateway. If you have another subscription tier and do not want to use Data Movement gateway, select None.<br><br>For information on the benefits of Data Movement gateway and use cases that require it, see [Qlik Data Gateway - Data Movement](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Gateways/replication-gateway.htm). |
| Start Date | Enter the date, in the format `MM/DD/YYYY`, from which the data must be replicated from your source to your target. |
| Client ID | Client ID. |
| Client Secret | Client secret. |

## Schema

Information note

Schemas and naming conventions can change from version to version. It is recommended to verify your version before continuing.

The schema and info displayed below is for version 1.

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

### 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<br><br>file\_name |
| **Useful links** | [Zoom API method](https://marketplace.zoom.us/Content/api-reference/zoom-api/meetings/listpastmeetingfiles "Opens in new tab: Zoom API method") |

meeting\_files table foreign keys

| Join meeting\_files with | on |
| --- | --- |
| [meeting_poll_results](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#meeting-poll-results) | ```<br>meeting_files.meeting_uuid = meeting_poll_results.meeting_uuid<br>``` |
| [meetings](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#meetings) | ```<br>meeting_files.meeting_uuid = meetings.uuid<br>``` |

meeting\_files table schema

| **download\_url**<br><br><br>STRING |
| --- |
| **file\_name**<br><br><br>STRING |
| **file\_size**<br><br><br>INTEGER |
| **meeting\_uuid**<br><br><br>STRING |

### meeting\_poll\_results

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

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

| **Replication Method** | Full Table |
| --- | --- |
| **Primary Keys** | email<br><br>meeting\_id |
| **Useful links** | [Zoom API method](https://developers.zoom.us/docs/api/meetings/#tag/polls/get/past_meetings/{meetingId}/polls "Opens in new tab: Zoom API method") |

meeting\_poll\_results table foreign keys

| Join meeting\_poll\_results with | on |
| --- | --- |
| [meeting_files](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#meeting-files) | ```<br>meeting_poll_results.meeting_uuid = meeting_files.meeting_uuid<br>``` |
| [meetings](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#meetings) | ```<br>meeting_poll_results.meeting_uuid = meetings.uuid<br>``` |

meeting\_poll\_results table schema

| **email**<br><br><br>STRING |
| --- |
| **meeting\_uuid**<br><br><br>STRING |
| **name**<br><br><br>STRING |
| **question\_details**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>answer: STRING</li><li>question: STRING</li></ul> |

### meeting\_polls

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

**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<br><br>meeting\_id |
| **Useful links** | [Zoom API method](https://developers.zoom.us/docs/api/meetings/#tag/polls/get/meetings/{meetingId}/polls "Opens in new tab: Zoom API method") |

meeting\_polls table foreign keys

| Join meeting\_polls with | on |
| --- | --- |
| [meeting_questions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#meeting-questions) | ```<br>meeting_polls.meeting_id = meeting_questions.meeting_id<br>``` |
| [meeting_registrants](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#meeting-registrants) | ```<br>meeting_polls.meeting_id = meeting_registrants.meeting_id<br>``` |
| [meetings](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#meetings) | ```<br>meeting_polls.meeting_id = meetings.meeting_id<br>``` |
| [report_meeting_participants](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#report-meeting-participants) | ```<br>meeting_polls.meeting_id = report_meeting_participants.meeting_id<br>``` |
| [report_meetings](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#report-meetings) | ```<br>meeting_polls.meeting_id = report_meetings.meeting_id<br>``` |

meeting\_polls table schema

| **id**<br><br><br>STRING |
| --- |
| **meeting\_id**<br><br><br>STRING |
| **questions**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>answers: ARRAY, which is also a nested data structure.</li><li>name: STRING</li><li>type: STRING</li></ul> |
| **status**<br><br><br>STRING |
| **title**<br><br><br>STRING |

### meeting\_questions

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

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

| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | meeting\_id |
| **Useful links** | [Zoom API method](https://developers.zoom.us/docs/api/meetings/#tag/invitation--registration/get/meetings/{meetingId}/registrants/questions "Opens in new tab: Zoom API method") |

meeting\_questions table foreign keys

| Join meeting\_questions with | on |
| --- | --- |
| [meeting_polls](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#meeting-polls) | ```<br>meeting_questions.meeting_id = meeting_polls.meeting_id<br>``` |
| [meeting_registrants](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#meeting-registrants) | ```<br>meeting_questions.meeting_id = meeting_registrants.meeting_id<br>``` |
| [meetings](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#meetings) | ```<br>meeting_questions.meeting_id = meetings.meeting_id<br>``` |
| [report_meeting_participants](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#report-meeting-participants) | ```<br>meeting_questions.meeting_id = report_meeting_participants.meeting_id<br>``` |
| [report_meetings](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#report-meetings) | ```<br>meeting_questions.meeting_id = report_meetings.meeting_id<br>``` |

meeting\_questions table schema

| **custom\_questions**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>answers: ARRAY, which is also a nested data structure.</li><li>required: BOOLEAN</li><li>title: STRING</li><li>type: STRING</li></ul> |
| --- |
| **meeting\_id**<br><br><br>STRING |
| **questions**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>field_name: STRING</li><li>required: BOOLEAN</li></ul> |

### meeting\_registrants

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

**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<br><br>meeting\_id |
| **Useful links** | [Zoom API method](https://developers.zoom.us/docs/api/meetings/#tag/invitation--registration "Opens in new tab: Zoom API method") |

meeting\_registrants table foreign keys

| Join meeting\_registrants with | on |
| --- | --- |
| [meeting_polls](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#meeting-polls) | ```<br>meeting_registrants.meeting_id = meeting_polls.meeting_id<br>``` |
| [meeting_questions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#meeting-questions) | ```<br>meeting_registrants.meeting_id = meeting_questions.meeting_id<br>``` |
| [meetings](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#meetings) | ```<br>meeting_registrants.meeting_id = meetings.meeting_id<br>``` |
| [report_meeting_participants](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#report-meeting-participants) | ```<br>meeting_registrants.meeting_id = report_meeting_participants.meeting_id<br>``` |
| [report_meetings](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#report-meetings) | ```<br>meeting_registrants.meeting_id = report_meetings.meeting_id<br>``` |

meeting\_registrants table schema

| **address**<br><br><br>STRING |
| --- |
| **city**<br><br><br>STRING |
| **comments**<br><br><br>STRING |
| **county**<br><br><br>STRING |
| **create\_time**<br><br><br>DATE-TIME |
| **custom\_questions**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>title: STRING</li><li>value: STRING</li></ul> |
| **email**<br><br><br>STRING |
| **first\_name**<br><br><br>STRING |
| **id**<br><br><br>STRING |
| **industry**<br><br><br>STRING |
| **job\_title**<br><br><br>STRING |
| **join\_url**<br><br><br>STRING |
| **last\_name**<br><br><br>STRING |
| **meeting\_id**<br><br><br>STRING |
| **no\_of\_employees**<br><br><br>STRING |
| **org**<br><br><br>STRING |
| **phone**<br><br><br>STRING |
| **purchasing\_time\_frame**<br><br><br>STRING |
| **role\_in\_purchase\_process**<br><br><br>STRING |
| **state**<br><br><br>STRING |
| **status**<br><br><br>STRING |
| **zip**<br><br><br>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** | [Zoom API method](https://developers.zoom.us/docs/api/meetings/#tag/meetings/get/meetings/{meetingId} "Opens in new tab: Zoom API method") |

meetings table foreign keys

| Join meetings with | on |
| --- | --- |
| [meeting_poll_results](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#meeting-poll-results) | ```<br>meetings.uuid = meeting_poll_results.meeting_uuid<br>``` |
| [meeting_files](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#meeting-files) | ```<br>meetings.uuid = meeting_files.meeting_uuid<br>``` |
| [meeting_polls](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#meeting-polls) | ```<br>meetings.meeting_id = meeting_polls.meeting_id<br>``` |
| [meeting_questions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#meeting-questions) | ```<br>meetings.meeting_id = meeting_questions.meeting_id<br>``` |
| [meeting_registrants](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#meeting-registrants) | ```<br>meetings.meeting_id = meeting_registrants.meeting_id<br>``` |
| [report_meeting_participants](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#report-meeting-participants) | ```<br>meetings.meeting_id = report_meeting_participants.meeting_id<br>``` |
| [report_meetings](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#report-meetings) | ```<br>meetings.meeting_id = report_meetings.meeting_id<br>``` |

meetings table schema

| **agenda**<br><br><br>STRING |
| --- |
| **created\_at**<br><br><br>DATE-TIME |
| **duration**<br><br><br>INTEGER |
| **encrypted\_Password**<br><br><br>STRING |
| **h323\_password**<br><br><br>STRING |
| **host\_id**<br><br><br>STRING |
| **id**<br><br><br>INTEGER |
| **join\_url**<br><br><br>STRING |
| **meeting\_id**<br><br><br>STRING |
| **occurences**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>duration: INTEGER</li><li>occurence_id: STRING</li><li>start_time: DATE-TIME</li><li>status: STRING</li></ul> |
| **password**<br><br><br>STRING |
| **pmi**<br><br><br>INTEGER |
| **recurrence**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>end_date_time: DATE-TIME</li><li>end_times: INTEGER</li><li>monthly_day: INTEGER</li><li>monthly_week: INTEGER</li><li>monthly_week_day: INTEGER</li><li>repeat_interval: INTEGER</li><li>type: INTEGER</li><li>weekly_days: INTEGER</li></ul> |
| **settings**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>alternative_hosts: STRING</li><li>approval_type: INTEGER</li><li>audio: STRING</li><li>authentication_domains: STRING</li><li>authentication_option: STRING</li><li>auto_recording: STRING</li><li>close_registration: BOOLEAN</li><li>cn_meeting: BOOLEAN</li><li>contact_email: BOOLEAN</li><li>contact_name: BOOLEAN</li><li>enforce_login: BOOLEAN</li><li>enforce_login_domains: STRING</li><li>global_dial_in_countries: ARRAY, which is also a nested data structure.</li><li>global_dial_in_numbers: ARRAY, which is also a nested data structure.											<ul><li>city: STRING</li><li>country: STRING</li><li>country_name: STRING</li><li>number: STRING</li><li>type: STRING</li></ul></li><li>host_video: BOOLEAN</li><li>in_meeting: BOOLEAN</li><li>join_before_host: BOOLEAN</li><li>meeting_authentication: BOOLEAN</li><li>mute_upon_entry: BOOLEAN</li><li>participant_video: BOOLEAN</li><li>registrants_confirmation_email: BOOLEAN</li><li>registrants_email_notification: BOOLEAN</li><li>registration_type: INTEGER</li><li>use_pmi: BOOLEAN</li><li>waiting_room: BOOLEAN</li><li>watermark: BOOLEAN</li></ul> |
| **start\_time**<br><br><br>DATE-TIME |
| **start\_url**<br><br><br>STRING |
| **status**<br><br><br>STRING |
| **timezone**<br><br><br>STRING |
| **topic**<br><br><br>STRING |
| **tracking\_fields**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>field: STRING</li><li>value: STRING</li></ul> |
| **type**<br><br><br>INTEGER |
| **uuid**<br><br><br>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<br><br>meeting\_id |
| **Useful links** | [Zoom API method](https://developers.zoom.us/docs/api/meetings/#tag/reports/get/report/meetings/{meetingId}/participants "Opens in new tab: Zoom API method") |

report\_meeting\_participants table foreign keys

| Join report\_meeting\_participants with | on |
| --- | --- |
| [meeting_polls](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#meeting-polls) | ```<br>report_meeting_participants.meeting_id = meeting_polls.meeting_id<br>``` |
| [meeting_questions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#meeting-questions) | ```<br>report_meeting_participants.meeting_id = meeting_questions.meeting_id<br>``` |
| [meeting_registrants](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#meeting-registrants) | ```<br>report_meeting_participants.meeting_id = meeting_registrants.meeting_id<br>``` |
| [meetings](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#meetings) | ```<br>report_meeting_participants.meeting_id = meetings.meeting_id<br>``` |
| [report_meetings](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#report-meetings) | ```<br>report_meeting_participants.meeting_id = report_meetings.meeting_id<br>``` |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#users) | ```<br>report_meeting_participants.user_id = users.id<br>``` |
| [report_webinar_participants](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#report-webinar-participants) | ```<br>report_meeting_participants.user_id = report_webinar_participants.user_id<br>``` |

report\_meeting\_participants table schema

| **duration**<br><br><br>STRING |
| --- |
| **id**<br><br><br>STRING |
| **join\_time**<br><br><br>DATE-TIME |
| **leave\_time**<br><br><br>DATE-TIME |
| **meeting\_id**<br><br><br>STRING |
| **name**<br><br><br>STRING |
| **user\_email**<br><br><br>STRING |
| **user\_id**<br><br><br>STRING |

### report\_meetings

The `report_meetings` table contains detailed reports about past Zoom meetings.

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

| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | meeting\_id |
| **Useful links** | [Zoom API method](https://developers.zoom.us/docs/api/rest/reference/zoom-api/methods/#operation/reportMeetingDetails "Opens in new tab: Zoom API method") |

report\_meetings table foreign keys

| Join report\_meetings with | on |
| --- | --- |
| [meeting_polls](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#meeting-polls) | ```<br>report_meetings.meeting_id = meeting_polls.meeting_id<br>``` |
| [meeting_questions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#meeting-questions) | ```<br>report_meetings.meeting_id = meeting_questions.meeting_id<br>``` |
| [meeting_registrants](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#meeting-registrants) | ```<br>report_meetings.meeting_id = meeting_registrants.meeting_id<br>``` |
| [meetings](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#meetings) | ```<br>report_meetings.meeting_id = meetings.meeting_id<br>``` |
| [report_meeting_participants](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#report-meeting-participants) | ```<br>report_meetings.meeting_id = report_meeting_participants.meeting_id<br>``` |

report\_meetings table schema

| **dept**<br><br><br>STRING |
| --- |
| **duration**<br><br><br>INTEGER |
| **end\_time**<br><br><br>DATE-TIME |
| **id**<br><br><br>INTEGER |
| **meeting\_id**<br><br><br>STRING |
| **participants\_count**<br><br><br>INTEGER |
| **start\_time**<br><br><br>DATE-TIME |
| **topic**<br><br><br>STRING |
| **total\_minutes**<br><br><br>INTEGER |
| **tracking\_fields**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>field: STRING</li><li>value: STRING</li></ul> |
| **type**<br><br><br>INTEGER |
| **user\_email**<br><br><br>STRING |
| **user\_name**<br><br><br>STRING |
| **uuid**<br><br><br>STRING |

### report\_webinar\_participants

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

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

| **Replication Method** | Full Table |
| --- | --- |
| **Primary Keys** | id<br><br>webinar\_id |
| **Useful links** | [Zoom API method](https://developers.zoom.us/docs/api/meetings/#tag/reports/get/report/webinars/{webinarId}/participants "Opens in new tab: Zoom API method") |

report\_webinar\_participants table foreign keys

| Join report\_webinar\_participants with | on |
| --- | --- |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#users) | ```<br>report_webinar_participants.user_id = users.id<br>``` |
| [report_meeting_participants](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#report-meeting-participants) | ```<br>report_webinar_participants.user_id = report_meeting_participants.user_id<br>``` |
| [report_webinars](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#report-webinars) | ```<br>report_webinar_participants.webinar_id = report_webinars.webinar_id<br>``` |
| [webinar_panelists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinar-panelists) | ```<br>report_webinar_participants.webinar_id = webinar_panelists.webinar_id<br>``` |
| [webinar_registrants](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinar-registrants) | ```<br>report_webinar_participants.webinar_id = webinar_registrants.webinar_id<br>``` |
| [webinar_polls](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinar-polls) | ```<br>report_webinar_participants.webinar_id = webinar_polls.webinar_id<br>``` |
| [webinar_questions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinar-questions) | ```<br>report_webinar_participants.webinar_id = webinar_questions.webinar_id<br>``` |
| [webinar_tracking_sources](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinar-tracking-sources) | ```<br>report_webinar_participants.webinar_id = webinar_tracking_sources.webinar_id<br>``` |

report\_webinar\_participants table schema

| **attentiveness\_score**<br><br><br>STRING |
| --- |
| **duration**<br><br><br>STRING |
| **id**<br><br><br>STRING |
| **join\_time**<br><br><br>DATE-TIME |
| **leave\_time**<br><br><br>DATE-TIME |
| **name**<br><br><br>STRING |
| **user\_email**<br><br><br>STRING |
| **user\_id**<br><br><br>STRING |
| **webinar\_id**<br><br><br>STRING |

### report\_webinars

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

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

| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [Zoom API method](https://developers.zoom.us/docs/api/meetings/#tag/reports/get/report/webinars/{webinarId} "Opens in new tab: Zoom API method") |

report\_webinars table foreign keys

| Join report\_webinars with | on |
| --- | --- |
| [report_webinar_participants](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#report-webinar-participants) | ```<br>report_webinars.webinar_id = report_webinar_participants.webinar_id<br>``` |
| [webinar_panelists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinar-panelists) | ```<br>report_webinars.webinar_id = webinar_panelists.webinar_id<br>``` |
| [webinar_registrants](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinar-registrants) | ```<br>report_webinars.webinar_id = webinar_registrants.webinar_id<br>``` |
| [webinar_polls](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinar-polls) | ```<br>report_webinars.webinar_id = webinar_polls.webinar_id<br>``` |
| [webinar_questions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinar-questions) | ```<br>report_webinars.webinar_id = webinar_questions.webinar_id<br>``` |
| [webinar_tracking_sources](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinar-tracking-sources) | ```<br>report_webinars.webinar_id = webinar_tracking_sources.webinar_id<br>``` |
| [webinar_absentees](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinar-absentees) | ```<br>report_webinars.uuid = webinar_absentees.webinar_uuid<br>``` |
| [webinar_files](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinar-files) | ```<br>report_webinars.uuid = webinar_files.webinar_uuid<br>``` |
| [webinar_poll_results](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinar-poll-results) | ```<br>report_webinars.uuid = webinar_poll_results.webinar_uuid<br>``` |
| [webinar_qna_results](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinar-qna-results) | ```<br>report_webinars.uuid = webinar_qna_results.webinar_uuid<br>``` |
| [webinars](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinars) | ```<br>report_webinars.uuid = webinars.uuid<br>``` |

report\_webinars table schema

| **dept**<br><br><br>STRING |
| --- |
| **duration**<br><br><br>INTEGER |
| **end\_time**<br><br><br>DATE-TIME |
| **host\_id**<br><br><br>STRING |
| **id**<br><br><br>INTEGER |
| **participants\_count**<br><br><br>INTEGER |
| **start\_time**<br><br><br>DATE-TIME |
| **topic**<br><br><br>STRING |
| **total\_minutes**<br><br><br>INTEGER |
| **tracking\_fields**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>field: STRING</li><li>value: STRING</li></ul> |
| **type**<br><br><br>INTEGER |
| **user\_email**<br><br><br>STRING |
| **user\_id**<br><br><br>STRING |
| **user\_name**<br><br><br>STRING |
| **uuid**<br><br><br>STRING |
| **webinar\_id**<br><br><br>STRING |

### users

The `users` table contains user data from your Zoom account.

| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [Zoom API method](https://developers.zoom.us/docs/api/users/#tag/users "Opens in new tab: Zoom API method") |

users table foreign keys

| Join users with | on |
| --- | --- |
| [report_meeting_participants](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#report-meeting-participants) | ```<br>users.id = report_meeting_participants.user_id<br>``` |
| [report_webinar_participants](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#report-webinar-participants) | ```<br>users.id = report_webinar_participants.user_id<br>``` |

users table schema

| **created\_at**<br><br><br>DATE-TIME |
| --- |
| **dept**<br><br><br>STRING |
| **email**<br><br><br>STRING |
| **first\_name**<br><br><br>STRING |
| **group\_ids**<br><br><br>ARRAY<br><br>This is a nested data structure. |
| **id**<br><br><br>STRING |
| **im\_group\_ids**<br><br><br>ARRAY<br><br>This is a nested data structure. |
| **last\_client\_version**<br><br><br>STRING |
| **last\_login\_time**<br><br><br>DATE-TIME |
| **last\_name**<br><br><br>STRING |
| **pmi**<br><br><br>INTEGER |
| **status**<br><br><br>STRING |
| **timezone**<br><br><br>STRING |
| **type**<br><br><br>INTEGER |
| **verified**<br><br><br>INTEGER |

### webinar\_absentees

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

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

| **Replication Method** | Full Table |
| --- | --- |
| **Primary Keys** | id<br><br>webinar\_id |
| **Useful links** | [Zoom API method](https://developers.zoom.us/docs/api/meetings/#tag/webinars/get/past_webinars/{webinarId}/absentees "Opens in new tab: Zoom API method") |

webinar\_absentees table foreign keys

| Join webinar\_absentees with | on |
| --- | --- |
| [report_webinars](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#report-webinars) | ```<br>webinar_absentees.webinar_uuid = report_webinars.uuid<br>``` |
| [webinar_files](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinar-files) | ```<br>webinar_absentees.webinar_uuid = webinar_files.webinar_uuid<br>``` |
| [webinar_poll_results](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinar-poll-results) | ```<br>webinar_absentees.webinar_uuid = webinar_poll_results.webinar_uuid<br>``` |
| [webinar_qna_results](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinar-qna-results) | ```<br>webinar_absentees.webinar_uuid = webinar_qna_results.webinar_uuid<br>``` |
| [webinars](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinars) | ```<br>webinar_absentees.webinar_uuid = webinars.uuid<br>``` |

webinar\_absentees table schema

| **address**<br><br><br>STRING |
| --- |
| **city**<br><br><br>STRING |
| **comments**<br><br><br>STRING |
| **county**<br><br><br>STRING |
| **create\_time**<br><br><br>DATE-TIME |
| **custom\_questions**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>title: STRING</li><li>value: STRING</li></ul> |
| **email**<br><br><br>STRING |
| **first\_name**<br><br><br>STRING |
| **id**<br><br><br>STRING |
| **industry**<br><br><br>STRING |
| **job\_title**<br><br><br>STRING |
| **join\_url**<br><br><br>STRING |
| **last\_name**<br><br><br>STRING |
| **no\_of\_employees**<br><br><br>STRING |
| **org**<br><br><br>STRING |
| **phone**<br><br><br>STRING |
| **purchasing\_time\_frame**<br><br><br>STRING |
| **role\_in\_purchase\_process**<br><br><br>STRING |
| **state**<br><br><br>STRING |
| **status**<br><br><br>STRING |
| **webinar\_uuid**<br><br><br>STRING |
| **zip**<br><br><br>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<br><br>file\_name |
| **Useful links** | [Zoom API method](https://marketplace.zoom.us/Content/api-reference/zoom-api/webinars/listpastwebinarfiles "Opens in new tab: Zoom API method") |

webinar\_files table foreign keys

| Join webinar\_files with | on |
| --- | --- |
| [report_webinars](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#report-webinars) | ```<br>webinar_files.webinar_uuid = report_webinars.uuid<br>``` |
| [webinar_absentees](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinar-absentees) | ```<br>webinar_files.webinar_uuid = webinar_absentees.webinar_uuid<br>``` |
| [webinar_poll_results](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinar-poll-results) | ```<br>webinar_files.webinar_uuid = webinar_poll_results.webinar_uuid<br>``` |
| [webinar_qna_results](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinar-qna-results) | ```<br>webinar_files.webinar_uuid = webinar_qna_results.webinar_uuid<br>``` |
| [webinars](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinars) | ```<br>webinar_files.webinar_uuid = webinars.uuid<br>``` |

webinar\_files table schema

| **download\_url**<br><br><br>STRING |
| --- |
| **file\_name**<br><br><br>STRING |
| **file\_size**<br><br><br>INTEGER |
| **webinar\_uuid**<br><br><br>STRING |

### webinar\_panelists

The `webinar_panelists` table contains information about your Zoom webinar panelists.

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

| **Replication Method** | Full Table |
| --- | --- |
| **Primary Keys** | id<br><br>webinar\_id |
| **Useful links** | [Zoom API method](https://developers.zoom.us/docs/api/meetings/#tag/webinars/get/webinars/{webinarId}/panelists "Opens in new tab: Zoom API method") |

webinar\_panelists table foreign keys

| Join webinar\_panelists with | on |
| --- | --- |
| [report_webinar_participants](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#report-webinar-participants) | ```<br>webinar_panelists.webinar_id = report_webinar_participants.webinar_id<br>``` |
| [report_webinars](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#report-webinars) | ```<br>webinar_panelists.webinar_id = report_webinars.webinar_id<br>``` |
| [webinar_registrants](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinar-registrants) | ```<br>webinar_panelists.webinar_id = webinar_registrants.webinar_id<br>``` |
| [webinar_polls](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinar-polls) | ```<br>webinar_panelists.webinar_id = webinar_polls.webinar_id<br>``` |
| [webinar_questions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinar-questions) | ```<br>webinar_panelists.webinar_id = webinar_questions.webinar_id<br>``` |
| [webinar_tracking_sources](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinar-tracking-sources) | ```<br>webinar_panelists.webinar_id = webinar_tracking_sources.webinar_id<br>``` |

webinar\_panelists table schema

| **email**<br><br><br>STRING |
| --- |
| **id**<br><br><br>STRING |
| **join\_url**<br><br><br>STRING |
| **name**<br><br><br>STRING |
| **webinar\_id**<br><br><br>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

| **Replication Method** | Full Table |
| --- | --- |
| **Primary Keys** | webinar\_id<br><br>email |
| **Useful links** | [Zoom API method](https://developers.zoom.us/docs/api/meetings/#tag/webinars/get/past_webinars/{webinarId}/polls "Opens in new tab: Zoom API method") |

webinar\_poll\_results table foreign keys

| Join webinar\_poll\_results with | on |
| --- | --- |
| [report_webinars](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#report-webinars) | ```<br>webinar_poll_results.webinar_uuid = report_webinars.uuid<br>``` |
| [webinar_absentees](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinar-absentees) | ```<br>webinar_poll_results.webinar_uuid = webinar_absentees.webinar_uuid<br>``` |
| [webinar_files](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinar-files) | ```<br>webinar_poll_results.webinar_uuid = webinar_files.webinar_uuid<br>``` |
| [webinar_qna_results](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinar-qna-results) | ```<br>webinar_poll_results.webinar_uuid = webinar_qna_results.webinar_uuid<br>``` |
| [webinars](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinars) | ```<br>webinar_poll_results.webinar_uuid = webinars.uuid<br>``` |

webinar\_poll\_results table schema

| **email**<br><br><br>STRING |
| --- |
| **name**<br><br><br>STRING |
| **question\_details**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>answer: STRING</li><li>question: STRING</li></ul> |
| **webinar\_uuid**<br><br><br>STRING |

### webinar\_polls

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

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

| **Replication Method** | Full Table |
| --- | --- |
| **Primary Keys** | id<br><br>webinar\_id |
| **Useful links** | [Zoom API method](https://developers.zoom.us/docs/api/meetings/#tag/webinars/get/webinars/{webinarId}/polls "Opens in new tab: Zoom API method") |

webinar\_polls table foreign keys

| Join webinar\_polls with | on |
| --- | --- |
| [report_webinar_participants](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#report-webinar-participants) | ```<br>webinar_polls.webinar_id = report_webinar_participants.webinar_id<br>``` |
| [report_webinars](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#report-webinars) | ```<br>webinar_polls.webinar_id = report_webinars.webinar_id<br>``` |
| [webinar_panelists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinar-panelists) | ```<br>webinar_polls.webinar_id = webinar_panelists.webinar_id<br>``` |
| [webinar_registrants](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinar-registrants) | ```<br>webinar_polls.webinar_id = webinar_registrants.webinar_id<br>``` |
| [webinar_questions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinar-questions) | ```<br>webinar_polls.webinar_id = webinar_questions.webinar_id<br>``` |
| [webinar_tracking_sources](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinar-tracking-sources) | ```<br>webinar_polls.webinar_id = webinar_tracking_sources.webinar_id<br>``` |

webinar\_polls table schema

| **id**<br><br><br>STRING |
| --- |
| **questions**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>answers: ARRAY, which is also a nested data structure.</li><li>name: STRING</li><li>type: STRING</li></ul> |
| **status**<br><br><br>STRING |
| **title**<br><br><br>STRING |
| **webinar\_id**<br><br><br>STRING |

### webinar\_qna\_results

The `webinar_qna_results` table contains information about about the questions and answers 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

| **Replication Method** | Full Table |
| --- | --- |
| **Primary Keys** | webinar\_id<br><br>email |
| **Useful links** | [Zoom API method](https://developers.zoom.us/docs/api/meetings/#tag/webinars/get/past_webinars/{webinarId}/qa "Opens in new tab: Zoom API method") |

webinar\_qna\_results table foreign keys

| Join webinar\_qna\_results with | on |
| --- | --- |
| [report_webinars](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#report-webinars) | ```<br>webinar_qna_results.webinar_uuid = report_webinars.uuid<br>``` |
| [webinar_absentees](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinar-absentees) | ```<br>webinar_qna_results.webinar_uuid = webinar_absentees.webinar_uuid<br>``` |
| [webinar_files](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinar-files) | ```<br>webinar_qna_results.webinar_uuid = webinar_files.webinar_uuid<br>``` |
| [webinar_poll_results](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinar-poll-results) | ```<br>webinar_qna_results.webinar_uuid = webinar_poll_results.webinar_uuid<br>``` |
| [webinars](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinars) | ```<br>webinar_qna_results.webinar_uuid = webinars.uuid<br>``` |

webinar\_qna\_results table schema

| **email**<br><br><br>STRING |
| --- |
| **name**<br><br><br>STRING |
| **question\_details**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>answer: STRING</li><li>question: STRING</li></ul> |
| **webinar\_uuid**<br><br><br>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, a Zoom Pro plan or higher with the webinar add-on enabled is required to retrieve this data.

| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | webinar\_id |
| **Useful links** | [Zoom API method](https://developers.zoom.us/docs/api/meetings/#tag/webinars/get/webinars/{webinarId}/registrants/questions "Opens in new tab: Zoom API method") |

webinar\_questions table foreign keys

| Join webinar\_questions with | on |
| --- | --- |
| [report_webinar_participants](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#report-webinar-participants) | ```<br>webinar_questions.webinar_id = report_webinar_participants.webinar_id<br>``` |
| [report_webinars](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#report-webinars) | ```<br>webinar_questions.webinar_id = report_webinars.webinar_id<br>``` |
| [webinar_panelists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinar-panelists) | ```<br>webinar_questions.webinar_id = webinar_panelists.webinar_id<br>``` |
| [webinar_registrants](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinar-registrants) | ```<br>webinar_questions.webinar_id = webinar_registrants.webinar_id<br>``` |
| [webinar_polls](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinar-polls) | ```<br>webinar_questions.webinar_id = webinar_polls.webinar_id<br>``` |
| [webinar_tracking_sources](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinar-tracking-sources) | ```<br>webinar_questions.webinar_id = webinar_tracking_sources.webinar_id<br>``` |

webinar\_questions table schema

| **custom\_questions**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>answers: ARRAY, which is also a nested data structure.</li><li>required: BOOLEAN</li><li>title: STRING</li><li>type: STRING</li></ul> |
| --- |
| **questions**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>field_name: STRING</li><li>required: BOOLEAN</li></ul> |
| **webinar\_id**<br><br><br>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, a Zoom Pro plan or higher with the webinar add-on enabled is required to retrieve this data.

| **Replication Method** | Full Table |
| --- | --- |
| **Primary Keys** | webinar\_id<br><br>id |
| **Useful links** | [Zoom API method](https://developers.zoom.us/docs/api/meetings/#tag/webinars/get/webinars/{webinarId}/registrants "Opens in new tab: Zoom API method") |

webinar\_registrants table foreign keys

| Join webinar\_registrants with | on |
| --- | --- |
| [report_webinar_participants](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#report-webinar-participants) | ```<br>webinar_registrants.webinar_id = report_webinar_participants.webinar_id<br>``` |
| [report_webinars](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#report-webinars) | ```<br>webinar_registrants.webinar_id = report_webinars.webinar_id<br>``` |
| [webinar_panelists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinar-panelists) | ```<br>webinar_registrants.webinar_id = webinar_panelists.webinar_id<br>``` |
| [webinar_polls](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinar-polls) | ```<br>webinar_registrants.webinar_id = webinar_polls.webinar_id<br>``` |
| [webinar_questions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinar-questions) | ```<br>webinar_registrants.webinar_id = webinar_questions.webinar_id<br>``` |
| [webinar_tracking_sources](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinar-tracking-sources) | ```<br>webinar_registrants.webinar_id = webinar_tracking_sources.webinar_id<br>``` |

webinar\_registrants table schema

| **address**<br><br><br>STRING |
| --- |
| **city**<br><br><br>STRING |
| **comments**<br><br><br>STRING |
| **county**<br><br><br>STRING |
| **create\_time**<br><br><br>DATE-TIME |
| **custom\_questions**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>title: STRING</li><li>value: STRING</li></ul> |
| **email**<br><br><br>STRING |
| **first\_name**<br><br><br>STRING |
| **id**<br><br><br>STRING |
| **industry**<br><br><br>STRING |
| **job\_title**<br><br><br>STRING |
| **join\_url**<br><br><br>STRING |
| **last\_name**<br><br><br>STRING |
| **no\_of\_employees**<br><br><br>STRING |
| **org**<br><br><br>STRING |
| **phone**<br><br><br>STRING |
| **purchasing\_time\_frame**<br><br><br>STRING |
| **role\_in\_purchase\_process**<br><br><br>STRING |
| **state**<br><br><br>STRING |
| **status**<br><br><br>STRING |
| **webinar\_id**<br><br><br>STRING |
| **zip**<br><br><br>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, a Zoom Pro plan or higher with the webinar add-on enabled is required to retrieve this data.

| **Replication Method** | Full Table |
| --- | --- |
| **Primary Keys** | id<br><br>webinar\_id |
| **Useful links** | [Zoom API method](https://developers.zoom.us/docs/api/meetings/#tag/webinars/get/webinars/{webinarId}/tracking_sources "Opens in new tab: Zoom API method") |

webinar\_tracking\_sources table foreign keys

| Join webinar\_tracking\_sources with | on |
| --- | --- |
| [report_webinar_participants](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#report-webinar-participants) | ```<br>webinar_tracking_sources.webinar_id = report_webinar_participants.webinar_id<br>``` |
| [report_webinars](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#report-webinars) | ```<br>webinar_tracking_sources.webinar_id = report_webinars.webinar_id<br>``` |
| [webinar_panelists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinar-panelists) | ```<br>webinar_tracking_sources.webinar_id = webinar_panelists.webinar_id<br>``` |
| [webinar_registrants](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinar-registrants) | ```<br>webinar_tracking_sources.webinar_id = webinar_registrants.webinar_id<br>``` |
| [webinar_polls](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinar-polls) | ```<br>webinar_tracking_sources.webinar_id = webinar_polls.webinar_id<br>``` |
| [webinar_questions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinar-questions) | ```<br>webinar_tracking_sources.webinar_id = webinar_questions.webinar_id<br>``` |

webinar\_tracking\_sources table schema

| **id**<br><br><br>STRING |
| --- |
| **registration\_count**<br><br><br>INTEGER |
| **source\_name**<br><br><br>STRING |
| **tracking\_url**<br><br><br>STRING |
| **visitor\_count**<br><br><br>INTEGER |
| **webinar\_id**<br><br><br>STRING |

### webinars

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

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

| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | uuid |
| **Useful links** | [Zoom API method](https://developers.zoom.us/docs/api/meetings/#tag/webinars/get/users/{userId}/webinars "Opens in new tab: Zoom API method") |

webinars table foreign keys

| Join webinars with | on |
| --- | --- |
| [report_webinars](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#report-webinars) | ```<br>webinars.uuid = report_webinars.uuid<br>``` |
| [webinar_absentees](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinar-absentees) | ```<br>webinars.uuid = webinar_absentees.webinar_uuid<br>``` |
| [webinar_files](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinar-files) | ```<br>webinars.uuid = webinar_files.webinar_uuid<br>``` |
| [webinar_poll_results](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinar-poll-results) | ```<br>webinars.uuid = webinar_poll_results.webinar_uuid<br>``` |
| [webinar_qna_results](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Zoom.htm#webinar-qna-results) | ```<br>webinars.uuid = webinar_qna_results.webinar_uuid<br>``` |

webinars table schema

| **agenda**<br><br><br>STRING |
| --- |
| **created\_at**<br><br><br>DATE-TIME |
| **duration**<br><br><br>INTEGER |
| **host\_id**<br><br><br>STRING |
| **id**<br><br><br>STRING |
| **join\_url**<br><br><br>STRING |
| **occurences**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>										duration: INTEGER</li><li>occurence_id: STRING</li><li>start_time: DATE-TIME</li><li>status: STRING</li></ul> |
| **recurrence**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>end_date_time: DATE-TIME</li><li>end_times: INTEGER</li><li>monthly_day: INTEGER</li><li>monthly_week: INTEGER</li><li>monthly_week_day: INTEGER</li><li>repeat_interval: INTEGER</li><li>type: INTEGER</li><li>weekly_days: INTEGER</li></ul> |
| **settings**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>allow_multiple_devices: BOOLEAN</li><li>alternative_hosts: STRING</li><li>approval_type: INTEGER</li><li>audio: STRING</li><li>authentication_domains: STRING</li><li>authentication_option: STRING</li><li>auto_recording: STRING</li><li>close_registration: BOOLEAN</li><li>contact_email: BOOLEAN</li><li>contact_name: BOOLEAN</li><li>enforce_login: BOOLEAN</li><li>enforce_login_domains: STRING</li><li>global_dial_in_countries: ARRAY, which is also a nested data structure.</li><li>hd_video: BOOLEAN</li><li>host_video: BOOLEAN</li><li>meeting_authentication: BOOLEAN</li><li>notify_registrants: BOOLEAN</li><li>on_demand: BOOLEAN</li><li>panelists_video: BOOLEAN</li><li>post_webinar_survey: BOOLEAN</li><li>practice_session: BOOLEAN</li><li>registrants_confirmation_email: BOOLEAN</li><li>registrants_email_notification: BOOLEAN</li><li>registrants_restrict_number: INTEGER</li><li>registration_type: INTEGER</li><li>show_share_button: BOOLEAN</li><li>survey_url: STRING</li></ul> |
| **start\_time**<br><br><br>DATE-TIME |
| **start\_url**<br><br><br>STRING |
| **timezone**<br><br><br>STRING |
| **topic**<br><br><br>STRING |
| **tracking\_fields**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>field: STRING</li><li>value: STRING</li></ul> |
| **type**<br><br><br>INTEGER |
| **uuid**<br><br><br>STRING |