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.

Connecting Skyvia to Zoom

To create a connection to Zoom, you simply need to sign in to Zoom via OAuth 2.0. The OAuth authentication token is stored on the Skyvia server. Your Zoom account login and password are not stored on the Skyvia server.

1. Click +NEW in the top menu.
2. Click Connection in the menu on the left to open the Select Connector page.
3. In the opened pane, click Zoom.
4. In the Connection Editor page, in the Untitled field, specify a connection name that will be used to identify the connection.
5. Click Sign In with Zoom.

6. In the opened window, enter the email and password used when signing up to Zoom.

   

7. Click Allow.

8. The authentication token is generated. Use the Test Connection button to make sure that the connection is successful and then click Create Connection.

   

Suppressing Extended Requests

For some objects, Zoom API returns only part of the fields when querying multiple records. In order to query values of additional fields, Skyvia performs additional extended requests. Such API requests can be performed for each record of such object. However, this can decrease performance and significantly increase the number of API calls used.

To reduce the number of API calls, you can select the Suppress Extended Requests checkbox. However, please note that some of the fields in such objects will not be available in Skyvia (will return empty values) even if they have values in Zoom because Zoom 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 untill you edit the connection and reobtain 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.

Zoom Scopes Needed

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

Zoom-Specific Features and Limitations

Skyvia has the following limitations for Zoom:

• In the Data Integration product, Zoom connections are supported only for packages, which use a new data integration runtime.

  Make sure that the Use new runtime checkbox is selected on the tab bar if you want to use Zoom in your package.

• Skyvia supports Replication with Incremental Updates 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.
• Skyvia does not support Synchronization for Zoom.
• The Meetings object supports only scheduled meetings. Zoom API currently does not allow working with instant meetings.
• 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.
• The UserCloudRecording object has from and to fields. When querying data from this object, you must specify the period to query data using these fields - either in filters or in the WHERE clause.
• Skyvia supports DML operations for such Zoom objects:
  • INSERT, UPDATE, DELETE: GroupMembers, Groups, MeetingPolls, Rooms, UserTSP, Users, WebinarPolls, Webinars.
  • INSERT, UPDATE: RoomLocations.
  • INSERT, DELETE: MeetingRegistrants, UserAssistants, WebinarPanelists, WebinarRegistrants.
  • INSERT: GroupAdmins, MeetingRecordingRegistrants.
  • UPDATE: UserSettings.
  • DELETE: UserSchedulers.

Supported Actions and Actions Specifics

Zoom connector supports the following actions:

• Execute Command in Source, Lookup, and Target Data Flow components and in Import and Export tasks in the Advanced mode.

• Execute Query in Source Data Flow components and in Import and Export tasks in the Advanced mode.

• Lookup in Lookup Data Flow components.
• Insert in Target Data Flow components.
• Update in Target Data Flow components.
• Delete in Target Data Flow components.