Zoom

This connector is currently in development, and it is not available yet.

Zoom is a cloud-based solution for online form building and online surveys. The solution is designed for companies of all sizes. Zoom features survey design, where users can design customized surveys simply via the drag-and-drop interface.

Data integration: Skyvia supports importing data to and from Zoom, exporting Zoom data to CSV files, and replicating Zoom data to relational databases.

Backup: Skyvia Backup does not support Zoom.

Query: Skyvia Query supports Zoom.

Establishing Connection

Creating Connection

To create a connection to Zoom, sign in to Zoom via OAuth 2.0.

  1. Click Sign In with Zoom.
  2. Enter your Zoom email and password in the appeared window.

    Connection Editor window

  3. Click Allow.
  4. Click Create Connection.

    Connection Editor window

Additional Connection Parameters

Suppress Extended Requests

Zoom API returns only part of the fields for some objects when querying multiple records. To query the values of additional fields, Skyvia performs additional extended requests for each record of such an object. However, this can decrease performance and significantly increase the number of API calls.

The list of such additional fields is the following:

OBJECT FIELD
RoomLocations Description, Timezone, SupportEmail, SupportPhone, RoomPasscode, and RequiredCodeToExt

To reduce the number of API calls, select the Suppress Extended Requests checkbox. However, please note that some fields in such objects are unavailable in Skyvia (return empty values) even if they have values in Zoom because its API does not return them without extended requests.

Disconnecting Skyvia from Zoom

If you don’t want Skyvia to be able to connect to your Zoom data anymore, you can remove the Skyvia app from your Zoom account and delete the Zoom connection and all objects related to it on Skyvia.

Removing the Skyvia app from your Zoom account invalidates the access token, stored in the Zoom connection on Skyvia, so Skyvia won’t be able to connect to your Zoom data after it until you edit the connection and re-obtain the token. Deleting the connection object and all the related objects on Skyvia would ensure that there are no traces of data stored on Skyvia, for example, in error or success logs, etc.

To remove Skyvia app from your Zoom account, perform the following steps:

  1. Log in to your Zoom account and navigate to the Zoom App Marketplace.
  2. Click Manage > Added Apps or search for the Skyvia app.
  3. Click the Remove button.

See our User Interface Basics to know how to delete the connection and the related objects from Skyvia.

Connector Specifics

Incremental Replication

Skyvia supports Incremental Replication for the Users, Meetings, MeetingRegistrants, Webinars, and WebinarRegistrants objects only. It supports only adding new records with incremental updates, it does not update or delete existing records if they are modified or deleted in Zoom.

Synchronization

Skyvia does not support Synchronization for Zoom.

Meetings

The Meetings object supports only scheduled meetings. Zoom API currently does not allow working with instant meetings.

UserCloudRecording

The UserCloudRecording object has from and to fields. These fields don’t return data for queried records. Instead, they must be used in filters to specify the period for which to obtain records. By default (without filters), the object returns records for the current day. Maximal period for querying records is one month.

When querying data from this object, you must specify the period to query data using from and to fields either in filters or in the WHERE clause.

Zoom Scopes Needed

When you connect to Zoom using Skyvia, it gets access to the scopes listed below.

View all users’ contacts/contact:read:admin

This scope is needed to allow the user to perform the following actions in Skyvia:

  • Query the Contacts object in the Query tool
  • Export Contacts data with Export packages
  • Replicate the Contacts data to databases and cloud data warehouses
  • Load data from the Contacts object to other cloud apps and databases with Import packages and Data Flows
  • Perform GET API calls against web API endpoints created in Skyvia Connect for the Contacts object

View all users’ meetings information on Dashboard/dashboard_meetings:read:admin

This scope is needed to allow the user to perform the following actions in Skyvia:

  • Query the DashboardMetricMeetings object in the Query tool
  • Export DashboardMetricMeetings data with Export packages
  • Replicate the DashboardMetricMeetings data to databases and cloud data warehouses
  • Load data from the DashboardMetricMeetings object to other cloud apps and databases with Import packages and Data Flows
  • Perform GET API calls against web API endpoints created in Skyvia Connect for the DashboardMetricMeetings object

View all users’ webinar information on Dashboard/dashboard_webinars:read:admin

This scope is needed to allow the user to perform the following actions in Skyvia:

  • Query the DashboardMetricWebinars object in the Query tool
  • Export DashboardMetricWebinars data with Export packages
  • Replicate the DashboardMetricWebinars data to databases and cloud data warehouses
  • Load data from the DashboardMetricWebinars object to other cloud apps and databases with Import packages and Data Flows
  • Perform GET API calls against web API endpoints created in Skyvia Connect for the DashboardMetricWebinars object

View and manage groups/group:write:admin

This scope is needed to allow the user to perform the following actions in Skyvia:

  • Query the Groups, GroupAdmins, and GroupMembers objects in the Query tool
  • Execute INSERT SQL statements against the Groups, GroupAdmins, and GroupMembers objects in the Query tool
  • Execute UPDATE and DELETE SQL statements against the Groups and GroupMembers objects in the Query tool
  • Export data from the Groups, GroupAdmins, and GroupMembers objects with Export packages
  • Replicate the Groups, GroupAdmins, and GroupMembers data to databases and cloud data warehouses
  • Load data from the Groups, GroupAdmins, and GroupMembers objects to other cloud apps and databases with Import packages and Data Flows
  • Insert records to the Groups, GroupAdmins, and GroupMembers objects Import packages and Data Flows
  • Update records in the Groups, and GroupMembers objects Import packages and Data Flows
  • Delete records from the Groups and GroupMembers objects Import packages and Data Flows
  • Perform GET and POST API calls against web API endpoints created in Skyvia Connect for the Groups, GroupAdmins, and GroupMembers objects
  • Perform PATCH and DELETE API calls against web API endpoints created in Skyvia Connect for the Groups and GroupMembers objects

View and manage all user meetings/meeting:write:admin

This scope is needed to allow the user to perform the following actions in Skyvia:

  • Query the Meetings, MeetingRegistrants, MeetingPolls, MeetingLiveStream, MeetingRegistrationQuestions, MeetingInvitation, and MeetingTemplates objects in the Query tool
  • Execute INSERT SQL statements to the Meetings, MeetingRegistrants, MeetingPolls, and MeetingRegistrationQuestions objects in the Query tool
  • Execute UPDATE SQL statements to the Meetings and MeetingPolls objects in the Query tool
  • Execute DELETE SQL statements to the Meetings, MeetingRegistrants, and MeetingPolls objects in the Query tool
  • Export data from the Meetings, MeetingRegistrants, MeetingPolls, MeetingLiveStream, MeetingRegistrationQuestions, MeetingInvitation, and MeetingTemplates objects with Export packages
  • Replicate the Meetings, MeetingRegistrants, MeetingPolls, MeetingLiveStream, MeetingRegistrationQuestions, MeetingInvitation, and MeetingTemplates data to databases and cloud data warehouses
  • Load data from the Meetings, MeetingRegistrants, MeetingPolls, MeetingLiveStream, MeetingRegistrationQuestions, MeetingInvitation, and MeetingTemplates objects to other cloud apps and databases with Import packages and Data Flows
  • Insert records to the Meetings, MeetingRegistrants, MeetingPolls, and MeetingRegistrationQuestions objects Import packages and Data Flows
  • Update records in the Meetings and MeetingPolls objects Import packages and Data Flows
  • Delete records from the Meetings, MeetingRegistrants, and MeetingPolls objects Import packages and Data Flows
  • Perform GET API calls against web API endpoints created in Skyvia Connect for the Meetings, MeetingRegistrants, MeetingPolls, MeetingLiveStream, MeetingRegistrationQuestions, MeetingInvitation, and MeetingTemplates objects
  • Perform POST API calls against web API endpoints created in Skyvia Connect for the Meetings, MeetingRegistrants, MeetingPolls, and MeetingRegistrationQuestions objects
  • Perform PATCH API calls against web API endpoints created in Skyvia Connect for the Meetings and MeetingPolls objects
  • Perform DELETE API calls against web API endpoints created in Skyvia Connect for the Meetings, MeetingRegistrants, and MeetingPolls objects

View and manage all user recordings/recording:write:admin

This scope is needed to allow the user to perform the following actions in Skyvia:

  • Query the UserCloudRecordings, MeetingRecordings, and MeetingRecordingRegistrants objects in the Query tool
  • Execute INSERT SQL statements against the UserCloudRecordings, MeetingRecordings, and MeetingRecordingRegistrants objects in the Query tool
  • Export data from the UserCloudRecordings, MeetingRecordings, and MeetingRecordingRegistrants objects with Export packages
  • Replicate the UserCloudRecordings, MeetingRecordings, and MeetingRecordingRegistrants data to databases and cloud data warehouses
  • Load data from the UserCloudRecordings, MeetingRecordings, and MeetingRecordingRegistrants objects to other cloud apps and databases with Import packages and Data Flows
  • Insert records to the UserCloudRecordings, MeetingRecordings, and MeetingRecordingRegistrants objects Import packages and Data Flows
  • Perform GET and POST API calls against web API endpoints created in Skyvia Connect for the UserCloudRecordings, MeetingRecordings, and MeetingRecordingRegistrants objects

View report data/report:read:admin

This scope is needed to allow the user to perform the following actions in Skyvia:

  • Query the WebinarDetailReports and MeetingDetailReports objects in the Query tool
  • Export WebinarDetailReports and MeetingDetailReports data with Export packages
  • Replicate the WebinarDetailReports and MeetingDetailReports data to databases and cloud data warehouses
  • Load data from the WebinarDetailReports and MeetingDetailReports objects to other cloud apps and databases with Import packages and Data Flows
  • Perform GET API calls against web API endpoints created in Skyvia Connect for the WebinarDetailReports and MeetingDetailReports objects

View and manage all users’ Zoom Rooms information/room:write:admin

This scope is needed to allow the user to perform the following actions in Skyvia:

  • Query the Rooms, RoomDevices, RoomDigitalSignageFolder, RoomDigitalSignageContent, RoomAccountProfile, RoomLocations, RoomMeetingSettings, RoomAlertSettings, LocationAlertSettings, LocationMeetingSettings, LocationSignageSettings, AccountAlertSettings, and AccountSignageSettings objects in the Query tool
  • Execute INSERT SQL statements to the Rooms and RoomLocations objects in the Query tool
  • Execute UPDATE SQL statements to the Rooms object in the Query tool
  • Execute DELETE SQL statements to the Rooms and RoomLocations objects in the Query tool
  • Export data from the Rooms, RoomDevices, RoomDigitalSignageFolder, RoomDigitalSignageContent, RoomAccountProfile, RoomLocations, RoomMeetingSettings, RoomAlertSettings, LocationAlertSettings, LocationMeetingSettings, LocationSignageSettings, AccountAlertSettings, and AccountSignageSettings objects with Export packages
  • Replicate the Rooms, RoomDevices, RoomDigitalSignageFolder, RoomDigitalSignageContent, RoomAccountProfile, RoomLocations, RoomMeetingSettings, RoomAlertSettings, LocationAlertSettings, LocationMeetingSettings, LocationSignageSettings, AccountAlertSettings, and AccountSignageSettings data to databases and cloud data warehouses
  • Load data from Rooms, RoomDevices, RoomDigitalSignageFolder, RoomDigitalSignageContent, RoomAccountProfile, RoomLocations, RoomMeetingSettings, RoomAlertSettings, LocationAlertSettings, LocationMeetingSettings, LocationSignageSettings, AccountAlertSettings, and AccountSignageSettings objects to other cloud apps and databases with Import packages and Data Flows
  • Insert records to the Rooms and RoomLocations objects Import packages and Data Flows
  • Update records in the Rooms object Import packages and Data Flows
  • Delete records from the Rooms and RoomLocations objects Import packages and Data Flows
  • Perform GET API calls against web API endpoints created in Skyvia Connect for the Rooms, RoomDevices, RoomDigitalSignageFolder, RoomDigitalSignageContent, RoomAccountProfile, RoomLocations, RoomMeetingSettings, RoomAlertSettings, LocationAlertSettings, LocationMeetingSettings, LocationSignageSettings, AccountAlertSettings, and AccountSignageSettings objects
  • Perform POST API calls against web API endpoints created in Skyvia Connect for the Rooms and RoomLocations objects
  • Perform PATCH API calls against web API endpoints created in Skyvia Connect for the Rooms object
  • Perform DELETE API calls against web API endpoints created in Skyvia Connect for the Rooms and RoomLocations objects

View and manage TSP info/tsp:write:admin

This scope is needed to allow the user to perform the following actions in Skyvia:

  • Query the TSP and UserTSP objects in the Query tool
  • Execute DML SQL statements against the TSP and UserTSP objects in the Query tool
  • Export data from the TSP and UserTSP objects with Export packages
  • Replicate the TSP and UserTSP data to databases and cloud data warehouses
  • Load data from the TSP and UserTSP objects to other cloud apps and databases with Import packages and Data Flows
  • Insert records to the UserTSP object Import packages and Data Flows
  • Update records in the UserTSP object Import packages and Data Flows
  • Delete records from the UserTSP objects Import packages and Data Flows
  • Perform GET, POST, PATCH, and DELETE API calls against web API endpoints created in Skyvia Connect for the UserTSP objects

View users information and manage users/user:write:admin

This scope is needed to allow the user to perform the following actions in Skyvia:

  • Query the Users, UserAssistants, UserSchedulers, UserSettings, and UserToken objects in the Query tool
  • Execute INSERT SQL statements to the Users and UserAssistants objects in the Query tool
  • Execute UPDATE SQL statements to the Users and UserSettings objects in the Query tool
  • Execute DELETE SQL statements to the Users, UserAssistants, and UserSchedulers objects in the Query tool
  • Export data from the Users, UserAssistants, UserSchedulers, UserSettings, and UserToken objects with Export packages
  • Replicate the Users, UserAssistants, UserSchedulers, UserSettings, and UserToken data to databases and cloud data warehouses
  • Load data from Users, UserAssistants, UserSchedulers, UserSettings, and UserToken objects to other cloud apps and databases with Import packages and Data Flows
  • Insert records to the Users and UserAssistants objects Import packages and Data Flows
  • Update records in the Users and UserSettings objects Import packages and Data Flows
  • Delete records from the Users, UserAssistants, and UserSchedulers objects Import packages and Data Flows
  • Perform GET API calls against web API endpoints created in Skyvia Connect for the Users, UserAssistants, UserSchedulers, UserSettings, and UserToken objects
  • Perform POST API calls against web API endpoints created in Skyvia Connect for the Users and UserAssistants objects
  • Perform PATCH API calls against web API endpoints created in Skyvia Connect for the Users and UserSettings objects
  • Perform DELETE API calls against web API endpoints created in Skyvia Connect for the Users, UserAssistants, and UserSchedulers objects

View and manage all user Webinars/webinar:write:admin

This scope is needed to allow the user to perform the following actions in Skyvia:

  • Query the Webinars, WebinarPanelists, WebinarPolls, WebinarRegistrants, WebinarRegistrantQuestions, WebinarRegistrantCustomQuestions, WebinarTemplates, WebinarLiveStream, WebinarTrackingSources, PastWebinarInstances, PastWebinarParticipants, and PastWebinarQuestionAndAnswer objects in the Query tool
  • Execute INSERT SQL statements to the Webinars, WebinarPanelists, WebinarPolls, and WebinarRegistrants objects in the Query tool
  • Execute UPDATE SQL statements to the Webinars and WebinarPolls objects in the Query tool
  • Execute DELETE SQL statements to the Webinars, WebinarPanelists, WebinarPolls, and WebinarRegistrants objects in the Query tool
  • Export data from the Webinars, WebinarPanelists, WebinarPolls, WebinarRegistrants, WebinarRegistrantQuestions, WebinarRegistrantCustomQuestions, WebinarTemplates, WebinarLiveStream, WebinarTrackingSources, PastWebinarInstances, PastWebinarParticipants, and PastWebinarQuestionAndAnswer objects with Export packages
  • Replicate the Webinars, WebinarPanelists, WebinarPolls, WebinarRegistrants, WebinarRegistrantQuestions, WebinarRegistrantCustomQuestions, WebinarTemplates, WebinarLiveStream, WebinarTrackingSources, PastWebinarInstances, PastWebinarParticipants, and PastWebinarQuestionAndAnswer data to databases and cloud data warehouses
  • Load data from Webinars, WebinarPanelists, WebinarPolls, WebinarRegistrants, WebinarRegistrantQuestions, WebinarRegistrantCustomQuestions, WebinarTemplates, WebinarLiveStream, WebinarTrackingSources, PastWebinarInstances, PastWebinarParticipants, and PastWebinarQuestionAndAnswer objects to other cloud apps and databases with Import packages and Data Flows
  • Insert records to the Webinars, WebinarPanelists, WebinarPolls, and WebinarRegistrants objects Import packages and Data Flows
  • Update records in the Webinars and WebinarPolls objects Import packages and Data Flows
  • Delete records from the Webinars, WebinarPanelists, WebinarPolls, and WebinarRegistrants objects Import packages and Data Flows
  • Perform GET API calls against web API endpoints created in Skyvia Connect for the Webinars, WebinarPanelists, WebinarPolls, WebinarRegistrants, WebinarRegistrantQuestions, WebinarRegistrantCustomQuestions, WebinarTemplates, WebinarLiveStream, WebinarTrackingSources, PastWebinarInstances, PastWebinarParticipants, and PastWebinarQuestionAndAnswer objects
  • Perform POST API calls against web API endpoints created in Skyvia Connect for the Webinars, WebinarPanelists, WebinarPolls, and WebinarRegistrants objects
  • Perform PATCH API calls against web API endpoints created in Skyvia Connect for the Webinars and WebinarPolls objects
  • Perform DELETE API calls against web API endpoints created in Skyvia Connect for the Webinars, WebinarPanelists, WebinarPolls, and WebinarRegistrants objects

DML Operations Support

Skyvia supports the following DML operations for Zoom objects:

Operation Objects
INSERT, UPDATE, DELETE GroupMembers, Groups, MeetingPolls, Rooms, UserTSP, Users, WebinarPolls, Webinars
INSERT, DELETE MeetingRegistrants, UserAssistants, WebinarPanelists, WebinarRegistrants
INSERT, UPDATE RoomLocations
INSERT GroupAdmins, MeetingRecordingRegistrants
UPDATE UserSettings
DELETE UserSchedulers

Supported Actions

Skyvia supports all the common actions for Acuity Scheduling.