Zoom

Zoom is a video conferencing platform.

Zoom integration replicates data using the Zoom API.

See the Schema section for a list of objects available for replication.

Una visión detallada de este conector, incluye enlaces útiles y funcionalidad compatible.

Función/Capacidad	Detalles de compatibilidad
Compatibilidad con proyectos de Qlik Talend Data Integration	Solo proyectos de replicación. No se admiten proyectos de canalización de datos.
Métodos de actualización de destinos	Tareas de replicación: Aplicar los cambios Guardar cambios Tareas de aterrizaje de datos en un lago de datos: Captura de datos de cambios (CDC)
Administrar los metadatos	No es necesario generar metadatos manualmente.
Evolución del esquema	Solo se admite la operación Cambiar tipo de datos de columna.
Replicación de columnas LOB (NCLOB, CLOB y BLOB)	No admitido.
CDC programado	Obligatorio. Así es como el destino se mantiene actualizado con los cambios en la fuente. Para tareas de replicación, vea Programar tareas Para tareas de aterrizaje en un lago de datos, vea Programación de CDC para tareas de destino/aterrizaje en un lago de datos
Notificaciones	Parcialmente compatible Configuración de notificaciones sobre cambios
Supervisión	Solo CDC, ya que la carga completa no es relevante para este conector. Supervisar una tarea individual de datos
Descarte automático de cargas útiles de columnas JSON	No admitido. Las cargas útiles de columnas JSON en los conjuntos de datos de origen no se deniegan automáticamente en el destino.

Preparing for authentication

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

Asegúrese de que la cuenta que utiliza tenga acceso de lectura a las tablas que desea recuperar.

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.
2. Select the necessary scopes to match the required QTC capabilities.
OAuth App
1. Follow the instructions at Creating an OAuth App.
2. Choose the appropriate scopes for your use case.

Creating the connection

For more information, see Conexión a aplicaciones SaaS.

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.
Copy the code to the clipboard and return to the connection dialog.
Paste the code in Complete authentication with the code provided by the source and click Verify.
Nota de sugerenciaYou may need to scroll down to see this field.
When status is Verified, the authentication is verified.
Provide a name for the connection in Connection name.
Select Open connection metadata to define metadata for the connection when it has been created.

Connection settings
Setting	Description
Data gateway	Seleccione una Data Movement gateway si su caso de uso así lo requiere. Nota informativa Este campo no está disponible con la suscripción Qlik Talend Cloud Starter porque Data Movement gateway no se admite. Si tiene otro nivel de suscripción y no desea utilizar Data Movement gateway, seleccione Ninguna. Para obtener información sobre las ventajas de Data Movement gateway y los casos de uso que lo requieren, consulte Pasarela de movimiento de datos de Qlik.
Start Date	Indique la fecha, en el formato `MM/DD/YYYY`, a partir de la cual deben replicarse los datos de su fuente a su destino.
Client ID	Client ID.
Client Secret	Client secret.

Schema

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

file_name

Useful links

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

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

This is a nested data structure:

answer: STRING
question: STRING

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

meeting_id

Useful links

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

STRING

meeting_id

STRING

questions

ARRAY

This is a nested data structure:

answers: ARRAY, which is also a nested data structure.
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.

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

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

This is a nested data structure:

answers: ARRAY, which is also a nested data structure.
required: BOOLEAN
title: STRING
type: STRING

meeting_id

STRING

questions

ARRAY

This is a nested data structure:

field_name: STRING
required: BOOLEAN

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

meeting_id

Useful links

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

This is a nested data structure:

title: STRING
value: STRING

email

STRING

first_name

STRING

industry

STRING

job_title

STRING

join_url

STRING

last_name

STRING

meeting_id

STRING

no_of_employees

STRING

org

STRING

phone

STRING

purchasing_time_frame

STRING

role_in_purchase_process

STRING

state

STRING

status

STRING

zip

STRING

meetings

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

Replication Method

Full Table

Primary Key

uuid

Useful links

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

INTEGER

join_url

STRING

meeting_id

STRING

occurences

ARRAY

This is a nested data structure:

duration: INTEGER
occurence_id: STRING
start_time: DATE-TIME
status: STRING

password

STRING

pmi

INTEGER

recurrence

OBJECT

This is a nested data structure:

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

This is a nested data structure:

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, which is also a nested data structure.
global_dial_in_numbers: ARRAY, which is also a nested data structure.
- 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

This is a nested data structure:

field: STRING
value: STRING

type

INTEGER

uuid

STRING

report_meeting_participants

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

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

Replication Method

Full Table

Primary Keys

meeting_id

Useful links

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

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.

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

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

INTEGER

meeting_id

STRING

participants_count

INTEGER

start_time

DATE-TIME

topic

STRING

total_minutes

INTEGER

tracking_fields

ARRAY

This is a nested data structure:

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

Useful links

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

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.

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

Useful links

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

INTEGER

participants_count

INTEGER

start_time

DATE-TIME

topic

STRING

total_minutes

INTEGER

tracking_fields

ARRAY

This is a nested data structure:

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

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

This is a nested data structure.

STRING

im_group_ids

ARRAY

This is a nested data structure.

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.

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

Useful links

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

This is a nested data structure:

title: STRING
value: STRING

email

STRING

first_name

STRING

industry

STRING

job_title

STRING

join_url

STRING

last_name

STRING

no_of_employees

STRING

org

STRING

phone

STRING

purchasing_time_frame

STRING

role_in_purchase_process

STRING

state

STRING

status

STRING

webinar_uuid

STRING

zip

STRING

webinar_files

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

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

Replication Method

Full Table

Primary Keys

webinar_uuid

file_name

Useful links

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

Useful links

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

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

Replication Method

Full Table

Primary Keys

webinar_id

Useful links

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

This is a nested data structure:

answer: STRING
question: STRING

webinar_uuid

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

webinar_id

Useful links

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

STRING

questions

ARRAY

This is a nested data structure:

answers: ARRAY, which is also a nested data structure.
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.

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

Useful links

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

This is a nested data structure:

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

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

This is a nested data structure:

answers: ARRAY, which is also a nested data structure.
required: BOOLEAN
title: STRING
type: STRING

questions

ARRAY

This is a nested data structure:

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

Useful links

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

This is a nested data structure:

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

Useful links

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

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

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

join_url

STRING

occurences

ARRAY

This is a nested data structure:

duration: INTEGER
occurence_id: STRING
start_time: DATE-TIME
status: STRING

recurrence

OBJECT

This is a nested data structure:

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

This is a nested data structure:

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, which is also a nested data structure.
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

This is a nested data structure:

field: STRING
value: STRING

type

INTEGER

uuid

STRING

¿Esta página le ha sido útil?

Si encuentra algún problema con esta página o su contenido (errores tipográficos, pasos que faltan o errores técnicos), no dude en ponerse en contacto con nosotros.

Deje aquí sus comentarios