Query information about meetings in the Zoom account.
user_id must be provided in all queries to this table.
List all meetings for a given host
select*fromzoom_meetingwhereuser_id = 'RCKlotFLRpe-Hbnv-VK3CA'
List all meetings for a given host by email
select*fromzoom_meetingwhereuser_id in (select id from zoom_user where email = 'firstname.lastname@example.org')
Get a meeting by ID
select*fromzoom_meetingwhereid = 912357281124
Scheduled meetings for the host. Instant meetings are not returned.
|account_id||text||Zoom account ID.|
|created_at||timestamp without time zone||Time when the meeting was created.|
|encrypted_password||text||Encrypted passcode for third party endpoints (H323/SIP).|
|h323_password||text||H.323/SIP room system passcode.|
|id||bigint||Meeting ID, also known as the meeting number.|
|join_url||text||URL using which participants can join a meeting.|
|occurrences||jsonb||Array of occurrence objects.|
|pmi||text||Personal meeting ID.|
|start_time||timestamp without time zone||Meeting start time in GMT/UTC. Start time will not be returned if the meeting is an instant meeting.|
|start_url||text||The start_url of a meeting is a URL using which a host or an alternative host can start the Meeting.|
|status||text||Meeting status: waiting or started.|
|timezone||text||Timezone to format the meeting start time.|
|type||bigint||Meeting Types: 1 - Instant meeting. 2 - Scheduled meeting. 3 - Recurring meeting with no fixed time. 8 - Recurring meeting with fixed time.|
|user_id||text||ID of the user who is set as the host of the meeting.|
|uuid||text||Unique Meeting ID. Each meeting instance will generate its own Meeting UUID.|