Zoom Connector
Documentation
Version: 1
Documentation

Zoom Connector - Source Code


<ApiConfig Name="Zoom" Slug="zoom-connector" Id="f8617a7f-1bac-45ca-a407-95c0b5fcf2eb"
	EngineVersion="4"
	Desc="Zoom Connector can be used to integrate Zoom REST API in your App / BI Tools. You can read/write data about Meetings, Invite, Users, Accounts and more."
	HelpLink="https://marketplace.zoom.us/docs/api-reference/introduction/"
	Logo="data:image/jpeg;base64,/9j/4AAQSkZJRgABAQEAYABgAAD/4QBaRXhpZgAATU0AKgAAAAgABQMBAAUAAAABAAAASgMDAAEAAAABAAAAAFEQAAEAAAABAQAAAFERAAQAAAABAAAOw1ESAAQAAAABAAAOwwAAAAAAAYagAACxj//bAEMACAYGBwYFCAcHBwkJCAoMFA0MCwsMGRITDxQdGh8eHRocHCAkLicgIiwjHBwoNyksMDE0NDQfJzk9ODI8LjM0Mv/bAEMBCQkJDAsMGA0NGDIhHCEyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMv/AABEIAJYAkQMBIgACEQEDEQH/xAAfAAABBQEBAQEBAQAAAAAAAAAAAQIDBAUGBwgJCgv/xAC1EAACAQMDAgQDBQUEBAAAAX0BAgMABBEFEiExQQYTUWEHInEUMoGRoQgjQrHBFVLR8CQzYnKCCQoWFxgZGiUmJygpKjQ1Njc4OTpDREVGR0hJSlNUVVZXWFlaY2RlZmdoaWpzdHV2d3h5eoOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4eLj5OXm5+jp6vHy8/T19vf4+fr/xAAfAQADAQEBAQEBAQEBAAAAAAAAAQIDBAUGBwgJCgv/xAC1EQACAQIEBAMEBwUEBAABAncAAQIDEQQFITEGEkFRB2FxEyIygQgUQpGhscEJIzNS8BVictEKFiQ04SXxFxgZGiYnKCkqNTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqCg4SFhoeIiYqSk5SVlpeYmZqio6Slpqeoqaqys7S1tre4ubrCw8TFxsfIycrS09TV1tfY2dri4+Tl5ufo6ery8/T19vf4+fr/2gAMAwEAAhEDEQA/APeuc5I+fsKPXHf71HtnP+16VBeXlvYWslzcyCOKMZZj3ppNuyE2krsn4xg/c7GkZgCCxAbtk15brnxGu7iR4tLUQQ9A7DLH39q5G41bUbpy897O5PrIa9qhkVaavUfL+Z41fO6MHaC5vyPffPiGf3iZP3vmFHnwYx5ybPXcK+eTLI3WRj9TTd7f3j+ddX+r3/Tz8P8AgnN/b/8A07/H/gH0R58WQTLHuHT5hR58WSRKmT975hXzvvb+8fzpd7f3j+dH+ry/5+fh/wAEP7ff/Pv8f+AfQ/nwYx5qbPXcKPPiyCZUyOnzCvnfe394/nRvb+8fzo/1eX/Pz8P+CH9vv/n3+P8AwD6I8+LJIlj3Hr8wo8+DGPNTZ67hXzvvb+8fzpd7f3j+dH+ry/5+fh/wQ/t9/wDPv8f+AfQ/nxcZlTI+78woE8WciRN3cbhXzxvb+8fzoEkg6Ow+ho/1e/6efh/wQ/t//p3+P/APokMjDCsCncg070z2+77189w6jfQMDFeToR/dkNdRo3xD1OydUvj9rg6ZPDj6GuetkNaKvTkpfgb0c8oydqkWvxPXOc5H3u4o4xgfd7mqOlaraazZrc2cu5D1z1B9DV73x/wH1rxJRlCTjJWaPajJSXNF3QmI/wC8aKXP/TOipKEyApP8A614/wCN/Ekmram9pC5+x27bVA/iPc16b4jvTp+gXt0PlkSI7R7ngV4OSScnkmvociw0ZSlWl00R8/nmJlFKjHrqxKKKK+oPmgooooAKKKKACiiigAooooAKKKKACiiigDb8Ma/LoOqJLuJt3IWZPUev1Fe4RSLNGkiMG3qGVh0Ir50r2bwFeteeFYVc5MLGIn6dP0xXzmfYaPKq632Z9DkeJlzOg9t0dRiT1FFNwn980V8yfSHNeP3MfhC6HUsyDP8AwIV4xXsfxC/5FCfb93zE/wDQhXjlfX5Ev9mfq/yR8nnj/wBpXovzYUUUV7R4wUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAV6n8L3J0S7UnIW46f8AARXlleofC7/kGXuPvecMf98ivKzpf7I/VHqZO/8Aa18zvdy/3KKX977UV8WfYnKfEPnwlOTwd6cf8CFeOV7H8Q+PCU4PJ3pz/wACFeOV9fkX+6v1f6HyWef7yvRfqFFFFe0eOPihlnk8uGN5HPRUUk/pVj+ytR/58Lr/AL8t/hW98PP+Rwtv9x//AEE17RgegrxswzWWEq+zUb6XPYwGVxxVL2jlbWx88/2VqP8Az4XX/flv8KP7K1H/AJ8Lr/vy3+FfQ2B6CjA9BXD/AKwT/k/E7f7Ah/P+B88/2VqP/Phdf9+W/wAKRtMv0Us1jcqo6kxMB/KvofA9KMD0FH+sE/5PxD+wI/z/AIHzdRXsfjPwnZajpdzfQQrFfQIZN6DHmADJB9frXj8MMk8qxRIzyMcBVGSa9rBY2GKp88dLbnjYzBTwtTklrfYZSkEYyCM9K9I8M/Dn7t3rQ91tgf8A0I/0rG+I0UcHiGOKJFRFgUBVGAKmnmNKriPYU9fPoVUy+rSoe2qaeXU4+iiiu84Qr1D4Xf8AIKvh284c/wDARXl9eofC7/kFXxPTzhkf8BFeVnP+6S+X5np5P/vcfn+R3m1f79FG5P7hor4s+yOW+IX/ACKE+37vmJ/6EK8cr2P4h8+EpyeP3icf8CFeOV9fkX+6v1f6HyWef7yvRfqFFFFe0eOdT8PP+Rwtv9x//QTXtNeLfDz/AJHC2/3H/wDQTXtNfIZ7/vK9F+bPrMj/AN2fq/yQUUUV4p7IUUUUAVNU/wCQTe/9cH/9BNc54D0axttAtdQSEG6nUlpG5I5IwPTpXR6p/wAgm9/64P8A+gmsvwX/AMifpv8A1zP/AKEa7ITlHCSSe8l+TOOcYyxUW1tF/mjfryD4l/8AIzL/ANcVr1+vIPiX/wAjMv8A1xWuzI/96+TOTOv91+aOMooor7E+RCvUPhd/yDL3H3vOGP8AvkV5fXqHwu/5BV8On78c+nyivKzn/dJfL8z08n/3uPz/ACO+/e+gopMD/npRXxZ9kcr8Q+PCU4blt6c/8CFeOV7H8Qv+RRn28r5if+hCvHK+vyL/AHV+r/Q+Szz/AHlei/UKKKK9o8c6f4fuqeMLXccZVwPrg17VXzrZ3c1jeQ3UDbZYmDKfcV61pXxF0e7t1+2ubS4A+ZWUlSfYj+tfN51g6tSoqtNXVraH0WTYylTpulN2d76nY0lYH/Cb+Hf+glH/AN8t/hR/wm/h3/oJR/8AfLf4V4X1TEfyP7me39bofzr70dBRXP8A/Cb+Hf8AoJR/98t/hSf8Jv4d/wCglH/3y3+FH1TEfyP7mH1uh/OvvRrap/yCbz/rg/8A6Ca4HwX43s7ayt9J1ACAR/LHP/CcnPzenXrXQX/jPw/Np11HHqMZd4XVRtPJIPtXi1e1luX+2ozp14taq3TuePmOP9lWhUoyT0d+vY+kFZXQOjBlYZBByDXkXxL/AORmX/ritZ3h3xhqOgSKgYz2efmgc9P909qPGOs2uu6rHeWu4KYgGVhgqfStsDl1XCYu71jZ6mOOzGlisJZaSutDnaKKK+hPACvUPhd/yCr4n7vnDI/4CK8vr1D4Xf8AIMvcfe84YH/ARXlZz/ukvl+Z6eT/AO9x+f5HeZT+6aKdmT+6KK+LPsjlPiHz4RnPT94nH/AhXjlex/EP/kUp93Lb0/8AQhXjlfX5F/ur9X+h8lnn+8r0X6hRRRXtHjhRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABXqHwu/wCQXfDp++HPp8ory+vUfhdn+yb4n7vnjP8A3yK8rOf90l8vzPTyf/e4/P8AI7zH/TSikzH6Giviz7I5zx3Hv8H3gXkAo2fowrxavoDVrIajpF1aYwJYyuPfHWvApYngmeKRSroxVgexFfVZBUToyh1Tv9//AAx8vntNqrGfRq33DKKKK988IKKKKACiiigAooooAKKKKACiiigAooooAK9W+GMe3QrmT+Jrg4Hr8orymvcPCGnHTPDdrA4xI6+Yx9CecV4ueVFHDcvVs9jJKbliObsjezJ/cFFJtP8Az0or5A+tDnPP3+1eb+PfCjmV9XsYywPNwijof7wr0jjGM5X1pCAwwwGP511YTFTwtVVIf8Oc2LwsMTTdOR850V65rnw+sNSdp7NvslwxyVAyp/CuQufh1rkLHyhDOg6Mr4/Q19bQzXC1Vfms+zPlK+V4mk/huvI5KiuhbwP4hX/mHsc9MOv+NJ/whPiLOP7NfP8Avr/jXV9cw/8AOvvRzfVMR/I/uZz9Fb//AAhPiHGf7Ofj/bX/ABo/4QnxDx/xLn5/21/xo+t4f+dfehfVK/8AI/uZgUV0H/CE+Is4/s18/wC+v+NJ/wAIV4hxn+zn4/21/wAaPreH/nX3oPqlf+R/czAorf8A+EJ8Q4z/AGc/P+2v+NL/AMIT4izj+zXz/vr/AI0fW8P/ADr70H1Sv/I/uZz9Fb//AAhPiH/oHPx/tr/jSjwR4hP/ADDmGfV1/wAaPreH/nX3oPqmI/kf3M5+iuqg+HuvyuA8MUWf78n+FdTo/wAN7W1dZtRn+0sOTGowo/xrnrZphaSvzX9NToo5Ziarty29dDnfBHhWXVLxL+5jK2kR3KG/jI/pXrYwFwB8g6imxRRwxLFGoSNRhQoxT++cfN2HrXyWNxk8XU55aLoj6rBYOGFp8kd+rE/d+hop25v7gorjOwTIxuA+XuKPTPfp7UUUAGDnbn5vWjjGQPlHUetFFAB0xnoentRg7tufm9aKKADqCRwB1HrR2BPQ9B6UUUAGDu25+b1o7EjoOo9aKKADsCeh6D0owd23PzetFFAB6kduvvRxgE9D0HpRRQAYO7bn5vWjrnHGOvvRRQAcYz/Ceg9KOc7c/MehoooAXY/9+iiigD//2Q==">

	<VersionHistory>
	    <Change Date="2022-12-08">Fixed the table name issues</Change>
		<Change Date="2022-09-27">Added HelpLink and Descriptions to all Endpoints</Change>
		<Change Date="2022-04-29">Initial version</Change>
	</VersionHistory>
	<ServiceUrls>
		<ServiceUrl Name="Zoom API" Url="https://api.zoom.us/v2" />
	</ServiceUrls>
	<Auths>
		<Auth Type="OAuth" Name="OAuth" Label="OAuth Authentication" Desc="OAuth App must be created under Admin Console &gt; Channel &gt; API &gt; Settings."
		  HelpLink="https://marketplace.zoom.us/docs/api-reference/zoom-api/methods#section/Authentication"
		  ConnStr="Provider=Custom;OAuthVersion=OAuth2;ScopeSeparator={space};ReturnUrl=[$RedirectUrl$];AuthUrl=[$AuthorizationUrl$];TokenUrl=[$TokenUrl$];ClientId=[$ClientId$];ClientSecret=[$ClientSecret$];Scope=[$Scope$];"
		  TestEndPoint="get_settings">
			<Params>
				<Param Name="ClientId" Required="True" />
				<Param Name="ClientSecret" Secret="True" Required="True"/>
				<Param Name="Scope" MultiSelect="True" Options="meeting:read;meeting:write;user:read;user:write;user_info:read;meeting:read:admin;
					   chat_channel:read;chat_channel:write;chat_contact:read;chat_message:read;chat_message:write;contact:read;pac:read;pac:write;phone:read;phone:write
					   phone_call_control:read;phone_call_control:write;phone_call_log:read;phone_call_log:write;phone_e911:read;phone_recording:read;phone_recording:write;
					   phone_sms:read;phone_sms:write;phone_voicemail:read;phone_voicemail:write;recording:read;recording:write;tsp:read
					   tsp:write;user:read;user:write;user_info:read;user_zak:read;webinar:read;webinar:write" />
				<Param Name="RedirectUrl" Value="https://zappysys.com/oauth" Required="True"  />
				<Param Name="TokenUrl" Value="https://zoom.us/oauth/token" Required="True" Hidden="True" />
				<Param Name="AuthorizationUrl" Value="https://zoom.us/oauth/authorize" Required="True"  Hidden="True"/>
				<Param Name="RetryMode" Value="RetryWhenStatusCodeMatch" Options="None;RetryAny;RetryWhenStatusCodeMatch;" Hidden="True" />
				<Param Name="RetryStatusCodeList" Value="429" Hidden="True" />
				<Param Name="RetryCountMax" Value="5" Hidden="True" />
				<Param Name="RetryMultiplyWaitTime" Value="True" Hidden="True" />
			</Params>
			<Notes>
				<![CDATA[<p>Perform the following steps to get the Zoom OAuth credentials (i.e. Client ID and Client Secret)<p />
<ol>
  <li>Go to <a target="_blank" href="https://marketplace.zoom.us/" _target="blank"><b>Zoom Marketplace Portal</b></a> and sign in there.</li>
  <li>Once you successfully login then select "Build App" option from <b><a href="https://marketplace.zoom.us/develop/create" _target="blank">Develop</a></b> dropdown from top left on the page.</li>
  <li>Click on <b>Create</b> button of OAuth panel section of page.</li>
  <li>Enter the name for your application and choose app type (Recommneded "Account-Level App") option for your API </li>
  <li>Then proceed with clicking <b>Create</b> button. </li>  
  <li>In <b>Redirect URL</b> for OAuth enter this <b>https://zappysys.com/oauth</b> as Redirect URI and add it to allow lists.</li>
  <li>Copy <b>Client ID </b> and <b>Client Secret</b> here and  paste it into Connection Manager Required Paramters section in respective place holders </li>
  <li>Add appropiate scopes from the <b> Scopes </b> menu option to the right side of page for your API as below : <b>
  <ul><li>meeting:read;</li>
  <li>meeting:write;</li>
  <li>user:read;</li>
  <li>user:write;</li>
  <li>user_info:read;</li>
  <li>meeting:read:admin;</li>
  <li>chat_channel:read;</li>
  <li>chat_channel:write;</li>
  <li>chat_contact:read;</li>
  <li>chat_message:read;</li>
  <li>chat_message:write;</li>
  <li>contact:read;</li>
  <li>pac:read;</li>
  <li>pac:write;</li>
  <li>phone:read;</li>
  <li>phone:write</li>
  <li>phone_call_control:read;</li>
  <li>phone_call_control:write;</li>
  <li>phone_call_log:read;</li>
  <li>phone_call_log:write;</li>
  <li>phone_e911:read;</li>
  <li>phone_recording:read;</li>
  <li>phone_recording:write;</li>
  <li>phone_sms:read;</li>
  <li>phone_sms:write;</li>
  <li>phone_voicemail:read;</li>
  <li>phone_voicemail:write;</li>
  <li>recording:read;</li>
  <li>recording:write;</li>
  <li>tsp:read</li>
  <li>tsp:write;</li>
  <li>user:read;</li>
  <li>user:write;</li>
  <li>user_info:read;</li>
  <li>user_zak:read;</li>
  <li>webinar:read;</li>
  <li>webinar:write</li></b></ul>
  <li>Click <b>Generate Token</b> button on Connection Manager UI to generate tokens.</li>
  <li>That's it!</li>
</ol>

]]>
			</Notes>

		</Auth>
	</Auths>
	<Template>
		<Param Name="tp_MeetingId" Required="True" Desc="The Meeting ID for which you want to get details." IsKey="True" ReadAs="id" DataType="DT_I8" />
		<Param Name="tp_UserId" Value="me" Required="True" Desc="The user ID or email address of the user. For user-level apps, pass the me value." IsKey="True" ReadAs="id" DataType="DT_I8" OptionsEndPoint="list_users"
                  OptionsEndPointLabelColumn="first_name"
                  OptionsEndPointValueColumn="id" />
		<Param Name="tp_WebinarId" Required="True" Desc="The Webinar ID for which you want to get details." IsKey="True" ReadAs="id" DataType="DT_I8" />
		<EndPoint  Name="tp_Pagination">
			<Params>
				<Param Name="NextUrlAttributeOrExpr" Type="Property" Value="$.next_page_token" />
				<Param Name="NextUrlSuffix" Type="Property" Value="next_page_token=&lt;%nextlink%&gt;" />
				<Param Name="page_size" Label="PageSize" Type="Query" Value="300" Hidden="True" />
			</Params>
		</EndPoint>
	</Template>

	<!-- When name not specified in EndPoints node .. its considered as base for all other template -->


	<EndPoints>
		<EndPoint Name="get_settings" Label="GET Settings" Url="/users/[$UserId$]/settings" Method="GET" 
				  HelpLink="https://marketplace.zoom.us/docs/api-reference/zoom-api/methods/#operation/userSettings" Desc="Retrieve a user's settings. For user-level apps, pass the me value instead of the userId parameter.">
			<Params>
				<Param Name="UserId" Template="tp_UserId" Type="Placeholder"  />

			</Params>
			<OutputColumns>
				<Column Name="schedule_meeting.host_video" Label="schedule_meeting_host_video" DataType="DT_BOOL" />
				<Column Name="schedule_meeting.participants_video" Label="schedule_meeting_participants_video" DataType="DT_BOOL" />
				<Column Name="schedule_meeting.audio_type" Label="schedule_meeting_audio_type" DataType="DT_WSTR" Length="16" />
				<Column Name="schedule_meeting.join_before_host" Label="schedule_meeting_join_before_host" DataType="DT_BOOL" />
				<Column Name="schedule_meeting.personal_meeting" Label="schedule_meeting_personal_meeting" DataType="DT_BOOL" />
				<Column Name="schedule_meeting.use_pmi_for_scheduled_meetings" Label="schedule_meeting_use_pmi_for_scheduled_meetings" DataType="DT_BOOL" />
				<Column Name="schedule_meeting.use_pmi_for_instant_meetings" Label="schedule_meeting_use_pmi_for_instant_meetings" DataType="DT_BOOL" />
				<Column Name="schedule_meeting.force_pmi_jbh_password" Label="schedule_meeting_force_pmi_jbh_password" DataType="DT_BOOL" />
				<Column Name="schedule_meeting.require_password_for_scheduling_new_meetings" Label="schedule_meeting_require_password_for_scheduling_new_meetings" DataType="DT_BOOL" />
				<Column Name="schedule_meeting.require_password_for_scheduled_meetings" Label="schedule_meeting_require_password_for_scheduled_meetings" DataType="DT_BOOL" />
				<Column Name="schedule_meeting.default_password_for_scheduled_meetings" Label="schedule_meeting_default_password_for_scheduled_meetings" DataType="DT_WSTR" Length="24" />
				<Column Name="schedule_meeting.require_password_for_instant_meetings" Label="schedule_meeting_require_password_for_instant_meetings" DataType="DT_BOOL" />
				<Column Name="schedule_meeting.require_password_for_pmi_meetings" Label="schedule_meeting_require_password_for_pmi_meetings" DataType="DT_WSTR" Length="12" />
				<Column Name="schedule_meeting.pmi_password" Label="schedule_meeting_pmi_password" DataType="DT_WSTR" Length="24" />
				<Column Name="schedule_meeting.pstn_password_protected" Label="schedule_meeting_pstn_password_protected" DataType="DT_BOOL" />
				<Column Name="schedule_meeting.mute_upon_entry" Label="schedule_meeting_mute_upon_entry" DataType="DT_BOOL" />
				<Column Name="schedule_meeting.embed_password_in_join_link" Label="schedule_meeting_embed_password_in_join_link" DataType="DT_BOOL" />
				<Column Name="schedule_meeting.meeting_password_requirement.length" Label="schedule_meeting_meeting_password_requirement_length" DataType="DT_I8" />
				<Column Name="schedule_meeting.meeting_password_requirement.have_letter" Label="schedule_meeting_meeting_password_requirement_have_letter" DataType="DT_BOOL" />
				<Column Name="schedule_meeting.meeting_password_requirement.have_number" Label="schedule_meeting_meeting_password_requirement_have_number" DataType="DT_BOOL" />
				<Column Name="schedule_meeting.meeting_password_requirement.have_special_character" Label="schedule_meeting_meeting_password_requirement_have_special_character" DataType="DT_BOOL" />
				<Column Name="schedule_meeting.meeting_password_requirement.have_upper_and_lower_characters" Label="schedule_meeting_meeting_password_requirement_have_upper_and_lower_characters" DataType="DT_BOOL" />
				<Column Name="schedule_meeting.meeting_password_requirement.only_allow_numeric" Label="schedule_meeting_meeting_password_requirement_only_allow_numeric" DataType="DT_BOOL" />
				<Column Name="schedule_meeting.meeting_password_requirement.consecutive_characters_length" Label="schedule_meeting_meeting_password_requirement_consecutive_characters_length" DataType="DT_I8" />
				<Column Name="schedule_meeting.meeting_password_requirement.weak_enhance_detection" Label="schedule_meeting_meeting_password_requirement_weak_enhance_detection" DataType="DT_BOOL" />
				<Column Name="in_meeting.e2e_encryption" Label="in_meeting_e2e_encryption" DataType="DT_BOOL" />
				<Column Name="in_meeting.chat" Label="in_meeting_chat" DataType="DT_BOOL" />
				<Column Name="in_meeting.private_chat" Label="in_meeting_private_chat" DataType="DT_BOOL" />
				<Column Name="in_meeting.auto_saving_chat" Label="in_meeting_auto_saving_chat" DataType="DT_BOOL" />
				<Column Name="in_meeting.entry_exit_chime" Label="in_meeting_entry_exit_chime" DataType="DT_WSTR" Length="16" />
				<Column Name="in_meeting.record_play_voice" Label="in_meeting_record_play_voice" DataType="DT_BOOL" />
				<Column Name="in_meeting.file_transfer" Label="in_meeting_file_transfer" DataType="DT_BOOL" />
				<Column Name="in_meeting.feedback" Label="in_meeting_feedback" DataType="DT_BOOL" />
				<Column Name="in_meeting.attendee_on_hold" Label="in_meeting_attendee_on_hold" DataType="DT_BOOL" />
				<Column Name="in_meeting.show_meeting_control_toolbar" Label="in_meeting_show_meeting_control_toolbar" DataType="DT_BOOL" />
				<Column Name="in_meeting.allow_show_zoom_windows" Label="in_meeting_allow_show_zoom_windows" DataType="DT_BOOL" />
				<Column Name="in_meeting.annotation" Label="in_meeting_annotation" DataType="DT_BOOL" />
				<Column Name="in_meeting.remote_control" Label="in_meeting_remote_control" DataType="DT_BOOL" />
				<Column Name="in_meeting.non_verbal_feedback" Label="in_meeting_non_verbal_feedback" DataType="DT_BOOL" />
				<Column Name="in_meeting.breakout_room" Label="in_meeting_breakout_room" DataType="DT_BOOL" />
				<Column Name="in_meeting.closed_caption" Label="in_meeting_closed_caption" DataType="DT_BOOL" />
				<Column Name="in_meeting.remote_support" Label="in_meeting_remote_support" DataType="DT_BOOL" />
				<Column Name="in_meeting.far_end_camera_control" Label="in_meeting_far_end_camera_control" DataType="DT_BOOL" />
				<Column Name="in_meeting.virtual_background" Label="in_meeting_virtual_background" DataType="DT_BOOL" />
				<Column Name="in_meeting.virtual_background_settings.enable" Label="in_meeting_virtual_background_settings_enable" DataType="DT_BOOL" />
				<Column Name="in_meeting.virtual_background_settings.allow_videos" Label="in_meeting_virtual_background_settings_allow_videos" DataType="DT_BOOL" />
				<Column Name="in_meeting.virtual_background_settings.allow_upload_custom" Label="in_meeting_virtual_background_settings_allow_upload_custom" DataType="DT_BOOL" />
				<Column Name="in_meeting.virtual_background_settings.files" Label="in_meeting_virtual_background_settings_files" DataType="DT_WSTR" Length="8" />
				<Column Name="in_meeting.auto_answer" Label="in_meeting_auto_answer" DataType="DT_BOOL" />
				<Column Name="in_meeting.screen_sharing" Label="in_meeting_screen_sharing" DataType="DT_BOOL" />
				<Column Name="in_meeting.attention_mode_focus_mode" Label="in_meeting_attention_mode_focus_mode" DataType="DT_BOOL" />
				<Column Name="in_meeting.who_can_share_screen" Label="in_meeting_who_can_share_screen" DataType="DT_WSTR" Length="16" />
				<Column Name="in_meeting.who_can_share_screen_when_someone_is_sharing" Label="in_meeting_who_can_share_screen_when_someone_is_sharing" DataType="DT_WSTR" Length="16" />
				<Column Name="in_meeting.waiting_room" Label="in_meeting_waiting_room" DataType="DT_BOOL" />
				<Column Name="in_meeting.participants_to_place_in_waiting_room" Label="in_meeting_participants_to_place_in_waiting_room" DataType="DT_I8" />
				<Column Name="in_meeting.request_permission_to_unmute_participants" Label="in_meeting_request_permission_to_unmute_participants" DataType="DT_BOOL" />
				<Column Name="in_meeting.meeting_reactions" Label="in_meeting_meeting_reactions" DataType="DT_BOOL" />
				<Column Name="in_meeting.show_a_join_from_your_browser_link" Label="in_meeting_show_a_join_from_your_browser_link" DataType="DT_BOOL" />
				<Column Name="in_meeting.allow_participants_to_rename" Label="in_meeting_allow_participants_to_rename" DataType="DT_BOOL" />
				<Column Name="in_meeting.allow_participants_chat_with" Label="in_meeting_allow_participants_chat_with" DataType="DT_I8" />
				<Column Name="in_meeting.allow_users_save_chats" Label="in_meeting_allow_users_save_chats" DataType="DT_I8" />
				<Column Name="in_meeting.meeting_polling.enable" Label="in_meeting_meeting_polling_enable" DataType="DT_BOOL" />
				<Column Name="in_meeting.closed_captioning.enable" Label="in_meeting_closed_captioning_enable" DataType="DT_BOOL" />
				<Column Name="in_meeting.closed_captioning.save_caption" Label="in_meeting_closed_captioning_save_caption" DataType="DT_BOOL" />
				<Column Name="in_meeting.slide_control" Label="in_meeting_slide_control" DataType="DT_BOOL" />
				<Column Name="in_meeting.webinar_polling.enable" Label="in_meeting_webinar_polling_enable" DataType="DT_BOOL" />
				<Column Name="in_meeting.disable_screen_sharing_for_host_meetings" Label="in_meeting_disable_screen_sharing_for_host_meetings" DataType="DT_BOOL" />
				<Column Name="in_meeting.disable_screen_sharing_for_in_meeting_guests" Label="in_meeting_disable_screen_sharing_for_in_meeting_guests" DataType="DT_BOOL" />
				<Column Name="email_notification.jbh_reminder" Label="email_notification_jbh_reminder" DataType="DT_BOOL" />
				<Column Name="email_notification.cancel_meeting_reminder" Label="email_notification_cancel_meeting_reminder" DataType="DT_BOOL" />
				<Column Name="recording.local_recording" Label="recording_local_recording" DataType="DT_BOOL" />
				<Column Name="recording.auto_recording" Label="recording_auto_recording" DataType="DT_WSTR" Length="16" />
				<Column Name="recording.recording_disclaimer" Label="recording_recording_disclaimer" DataType="DT_BOOL" />
				<Column Name="recording.auto_delete_cmr" Label="recording_auto_delete_cmr" DataType="DT_BOOL" />
				<Column Name="recording.recording_password_requirement.length" Label="recording_recording_password_requirement_length" DataType="DT_I8" />
				<Column Name="recording.recording_password_requirement.have_letter" Label="recording_recording_password_requirement_have_letter" DataType="DT_BOOL" />
				<Column Name="recording.recording_password_requirement.have_number" Label="recording_recording_password_requirement_have_number" DataType="DT_BOOL" />
				<Column Name="recording.recording_password_requirement.have_special_character" Label="recording_recording_password_requirement_have_special_character" DataType="DT_BOOL" />
				<Column Name="recording.recording_password_requirement.only_allow_numeric" Label="recording_recording_password_requirement_only_allow_numeric" DataType="DT_BOOL" />
				<Column Name="telephony.third_party_audio" Label="telephony_third_party_audio" DataType="DT_BOOL" />
				<Column Name="telephony.audio_conference_info" Label="telephony_audio_conference_info" DataType="DT_WSTR" Length="80" />
				<Column Name="telephony.show_international_numbers_link" Label="telephony_show_international_numbers_link" DataType="DT_BOOL" />
				<Column Name="telephony.telephony_regions.allowed_values" Label="telephony_telephony_regions_allowed_values" DataType="DT_WSTR" Length="344" />
				<Column Name="feature.meeting_capacity" Label="feature_meeting_capacity" DataType="DT_I8" />
				<Column Name="feature.large_meeting" Label="feature_large_meeting" DataType="DT_BOOL" />
				<Column Name="feature.webinar" Label="feature_webinar" DataType="DT_BOOL" />
				<Column Name="feature.zoom_events" Label="feature_zoom_events" DataType="DT_BOOL" />
				<Column Name="feature.cn_meeting" Label="feature_cn_meeting" DataType="DT_BOOL" />
				<Column Name="feature.in_meeting" Label="feature_in_meeting" DataType="DT_BOOL" />
				<Column Name="feature.zoom_phone" Label="feature_zoom_phone" DataType="DT_BOOL" />
				<Column Name="feature.zoom_iq_for_sales" Label="feature_zoom_iq_for_sales" DataType="DT_BOOL" />
				<Column Name="integration.linkedin_sales_navigator" Label="integration_linkedin_sales_navigator" DataType="DT_BOOL" />
				<Column Name="audio_conferencing.toll_free_and_fee_based_toll_call.enable" Label="audio_conferencing_toll_free_and_fee_based_toll_call_enable" DataType="DT_BOOL" />
			</OutputColumns>
		</EndPoint>
		<EndPoint Name="list_meetings" Template="tp_Pagination" Label="List Meetings" Url="/users/[$UserId$]/meetings" Method="GET" HelpLink="https://marketplace.zoom.us/docs/api-reference/zoom-api/methods/#operation/meetings"
				  Filter="$.meetings[*]" Desc="Get the list of scheduled meetings. For current user (me) or specified user Id. To get more details about a meeting you can call get_meeting EndPoint.">
			<Params>
				<Param Name="UserId" Template="tp_UserId" Type="Placeholder"
				  OptionsEndPoint="list_users"
                  OptionsEndPointLabelColumn="first_name"
                  OptionsEndPointValueColumn="id"/>
			</Params>
			<OutputColumns>
				<Column Name="id" DataType="DT_I8" Key="True" />		>
				<Column Name="topic" DataType="DT_WSTR" Length="500" />
				<Column Name="type" DataType="DT_I8" />
				<Column Name="start_time" DataType="DT_DBTIMESTAMP" />
				<Column Name="duration" DataType="DT_I8" />
				<Column Name="timezone" DataType="DT_WSTR" Length="100" />
				<Column Name="agenda" DataType="DT_WSTR" Length="4000" />
				<Column Name="created_at" DataType="DT_DBTIMESTAMP" />
				<Column Name="join_url" DataType="DT_WSTR" Length="1000" />
				<Column Name="pmi" DataType="DT_WSTR" Length="100" />
				<Column Name="uuid" DataType="DT_WSTR" Length="100" />
			</OutputColumns>
		</EndPoint>
		<EndPoint Name="get_meeting" Label="Get Meeting By Id" Url="/meetings/[$MeetingId$]" Method="GET" HelpLink="https://marketplace.zoom.us/docs/api-reference/zoom-api/methods/#operation/meeting" 
				  Desc="The Meeting Id or email address of the user. For user-level apps, pass the me value." >
			<Params>
				<Param Name="MeetingId" Template="tp_MeetingId" Type="Placeholder"
				  OptionsEndPoint="list_meetings"
                  OptionsEndPointLabelColumn="topic"
                  OptionsEndPointValueColumn="id"  />
			</Params>
			<OutputColumns>
				<Column Name="id" DataType="DT_I8" />
				<Column Name="host_id" DataType="DT_WSTR" Length="100" />
				<Column Name="host_email" DataType="DT_WSTR" Length="255" />
				<Column Name="assistant_id" DataType="DT_WSTR" Length="100" />
				<Column Name="topic" DataType="DT_WSTR" Length="400" />
				<Column Name="type" DataType="DT_I8" />
				<Column Name="status" DataType="DT_WSTR" Length="30" />
				<Column Name="timezone" DataType="DT_WSTR" Length="100" />
				<Column Name="agenda" DataType="DT_NTEXT" />
				<Column Name="created_at" DataType="DT_DBTIMESTAMP" />
				<Column Name="start_url" DataType="DT_WSTR" Length="4000" />
				<Column Name="join_url" DataType="DT_WSTR" Length="500" />
				<Column Name="registration_url" DataType="DT_WSTR" Length="500" />
				<Column Name="password" DataType="DT_WSTR" Length="100" />
				<Column Name="h323_password" DataType="DT_WSTR" Length="100" />
				<Column Name="pstn_password" DataType="DT_WSTR" Length="100" />
				<Column Name="encrypted_password" DataType="DT_WSTR" Length="400" />
				<Column Name="occurrences" DataType="DT_NTEXT" />
				<Column Name="settings.host_video" Label="settings_host_video" DataType="DT_BOOL" />
				<Column Name="settings.participant_video" Label="settings_participant_video" DataType="DT_BOOL" />
				<Column Name="settings.cn_meeting" Label="settings_cn_meeting" DataType="DT_BOOL" />
				<Column Name="settings.in_meeting" Label="settings_in_meeting" DataType="DT_BOOL" />
				<Column Name="settings.join_before_host" Label="settings_join_before_host" DataType="DT_BOOL" />
				<Column Name="settings.jbh_time" Label="settings_jbh_time" DataType="DT_I8" />
				<Column Name="settings.mute_upon_entry" Label="settings_mute_upon_entry" DataType="DT_BOOL" />
				<Column Name="settings.watermark" Label="settings_watermark" DataType="DT_BOOL" />
				<Column Name="settings.use_pmi" Label="settings_use_pmi" DataType="DT_BOOL" />
				<Column Name="settings.approval_type" Label="settings_approval_type" DataType="DT_I8" />
				<Column Name="settings.registration_type" Label="settings_registration_type" DataType="DT_I8" />
				<Column Name="settings.audio" Label="settings_audio" DataType="DT_WSTR" Length="16" />
				<Column Name="settings.auto_recording" Label="settings_auto_recording" DataType="DT_WSTR" Length="20" />
				<Column Name="settings.enforce_login" Label="settings_enforce_login" DataType="DT_BOOL" />
				<Column Name="settings.enforce_login_domains" Label="settings_enforce_login_domains" DataType="DT_WSTR" Length="255" />
				<Column Name="settings.alternative_hosts" Label="settings_alternative_hosts" DataType="DT_WSTR" Length="4000" />
				<Column Name="settings.alternative_host_update_polls" Label="settings_alternative_host_update_polls" DataType="DT_BOOL" />
				<Column Name="settings.close_registration" Label="settings_close_registration" DataType="DT_BOOL" />
				<Column Name="settings.show_share_button" Label="settings_show_share_button" DataType="DT_BOOL" />
				<Column Name="settings.allow_multiple_devices" Label="settings_allow_multiple_devices" DataType="DT_BOOL" />
				<Column Name="settings.registrants_confirmation_email" Label="settings_registrants_confirmation_email" DataType="DT_BOOL" />
				<Column Name="settings.waiting_room" Label="settings_waiting_room" DataType="DT_BOOL" />
				<Column Name="settings.request_permission_to_unmute_participants" Label="settings_request_permission_to_unmute_participants" DataType="DT_BOOL" />
				<Column Name="settings.global_dial_in_countries" Label="settings_global_dial_in_countries" DataType="DT_WSTR" Length="4000" />
				<Column Name="settings.global_dial_in_numbers" Label="settings_global_dial_in_numbers" DataType="DT_WSTR" Length="4000" />
				<Column Name="settings.registrants_email_notification" Label="settings_registrants_email_notification" DataType="DT_BOOL" />
				<Column Name="settings.meeting_authentication" Label="settings_meeting_authentication" DataType="DT_BOOL" />
				<Column Name="settings.encryption_type" Label="settings_encryption_type" DataType="DT_WSTR" Length="76" />
				<Column Name="settings.approved_or_denied_countries_or_regions.enable" Label="settings_approved_or_denied_countries_or_regions_enable" DataType="DT_BOOL" />
				<Column Name="settings.breakout_room.enable" Label="settings_breakout_room_enable" DataType="DT_BOOL" />
				<Column Name="settings.alternative_hosts_email_notification" Label="settings_alternative_hosts_email_notification" DataType="DT_BOOL" />
				<Column Name="settings.device_testing" Label="settings_device_testing" DataType="DT_BOOL" />
				<Column Name="settings.focus_mode" Label="settings_focus_mode" DataType="DT_BOOL" />
				<Column Name="settings.private_meeting" Label="settings_private_meeting" DataType="DT_BOOL" />
				<Column Name="settings.email_notification" Label="settings_email_notification" DataType="DT_BOOL" />
				<Column Name="recurrence.type" Label="recurrence_type" DataType="DT_I8" />
				<Column Name="recurrence.repeat_interval" Label="recurrence_repeat_interval" DataType="DT_I8" />
				<Column Name="recurrence.end_date_time" Label="recurrence_end_date_time" DataType="DT_DBTIMESTAMP" />
				<Column Name="pre_schedule" DataType="DT_BOOL" />
				<Column Name="uuid" DataType="DT_WSTR" Length="100" />
			</OutputColumns>
		</EndPoint>
		<EndPoint Name="list_meeting_registrants" Template="tp_Pagination" Label="List Meeting Registrants" Url="/meetings/[$MeetingId$]/registrants" 
				  HelpLink="https://marketplace.zoom.us/docs/api-reference/zoom-api/methods/#operation/meetingRegistrants" Desc="A host or a user with admin permission can require registration for a Zoom meeting. Use this API to list users that have registered for a meeting." 
				  Method="GET" Filter="$.registrants[*]">
			<Params>
				<Param Name="UserId" Desc="Only Used to list Meetings in the UI" Template="tp_UserId"  ></Param>
				<Param Name="MeetingId" Template="tp_MeetingId" Type="Placeholder"
				  OptionsEndPoint="list_meetings"
				  OptionsEndPointParameters="UserId=[$UserId$]"
                  OptionsEndPointLabelColumn="topic"
                  OptionsEndPointValueColumn="id"  />
			</Params>
			<OutputColumns>
				<Column Name="id" DataType="DT_WSTR" Length="255" />
				<Column Name="first_name" DataType="DT_WSTR" Length="255" />
				<Column Name="last_name" DataType="DT_WSTR" Length="255" />
				<Column Name="email" DataType="DT_WSTR" Length="255" />
				<Column Name="address" DataType="DT_WSTR" Length="255" />
				<Column Name="city" DataType="DT_WSTR" Length="100" />
				<Column Name="country" DataType="DT_WSTR" Length="100" />
				<Column Name="zip" DataType="DT_WSTR" Length="100" />
				<Column Name="state" DataType="DT_WSTR" Length="100" />
				<Column Name="phone" DataType="DT_WSTR" Length="100" />
				<Column Name="industry" DataType="DT_WSTR" Length="100" />
				<Column Name="org" DataType="DT_WSTR" Length="255" />
				<Column Name="job_title" DataType="DT_WSTR" Length="255" />
				<Column Name="purchasing_time_frame" DataType="DT_WSTR" Length="255" />
				<Column Name="role_in_purchase_process" DataType="DT_WSTR" Length="255" />
				<Column Name="no_of_employees" DataType="DT_WSTR" Length="255" />
				<Column Name="comments" DataType="DT_WSTR" Length="4000" />
				<Column Name="custom_questions" DataType="DT_NTEXT" />
				<Column Name="status" DataType="DT_WSTR" Length="100" />
				<Column Name="create_time" DataType="DT_DBTIMESTAMP" />
				<Column Name="join_url" DataType="DT_WSTR" Length="2000" />
			</OutputColumns>
		</EndPoint>
		<EndPoint Name="list_past_meeting_registrants" Template="tp_Pagination" Label="Past Meeting" Url="/past_meetings/[$MeetingId$]" HelpLink="https://marketplace.zoom.us/docs/api-reference/zoom-api/methods/#operation/pastMeetingDetails"
				  Desc="Use this API to get information about a past meeting." Method="GET" >
			<Params>
				<Param Name="MeetingId" Template="tp_MeetingId" Type="Placeholder"
				  OptionsEndPoint="list_meetings"
                  OptionsEndPointLabelColumn="topic"
                  OptionsEndPointValueColumn="id"  />
			</Params>
			<OutputColumns>
				<Column Name="id" DataType="DT_I8" />
				<Column Name="host_id" DataType="DT_WSTR" Length="100" />
				<Column Name="type" DataType="DT_I8" />
				<Column Name="topic" DataType="DT_WSTR" Length="500" />
				<Column Name="user_name" DataType="DT_WSTR" Length="255" />
				<Column Name="user_email" DataType="DT_WSTR" Length="255" />
				<Column Name="start_time" DataType="DT_DBTIMESTAMP" />
				<Column Name="end_time" DataType="DT_DBTIMESTAMP" />
				<Column Name="duration" DataType="DT_I8" />
				<Column Name="total_minutes" DataType="DT_I8" />
				<Column Name="participants_count" DataType="DT_I8" />
				<Column Name="dept" DataType="DT_WSTR" Length="8" />
				<Column Name="source" DataType="DT_WSTR" Length="16" />
				<Column Name="uuid" DataType="DT_WSTR" Length="100" />
			</OutputColumns>
		</EndPoint>
		<EndPoint Name="list_registration_questions" Label="List Registration Questions" Url="/meetings/[$MeetingId$]/registrants/questions" HelpLink="https://marketplace.zoom.us/docs/api-reference/zoom-api/methods/#operation/meetingRegistrantsQuestionsGet"
				  Desc="List registration questions that will be displayed to users while registering for a meeting." Method="GET" >
			<Params>
				<Param Name="MeetingId" Template="tp_MeetingId" Type="Placeholder"
				  OptionsEndPoint="list_meetings"
                  OptionsEndPointLabelColumn="topic"
                  OptionsEndPointValueColumn="id"  />
			</Params>
			<OutputColumns>
				<Column Name="questions" DataType="DT_WSTR" Length="1000" />
				<Column Name="custom_questions" DataType="DT_NTEXT" />
			</OutputColumns>
		</EndPoint>
		<EndPoint Name="list_users" Template="tp_Pagination" Label="List Users" Url="/users" Method="GET"  Filter="$.users[*]" 
				  HelpLink="https://marketplace.zoom.us/docs/api-reference/zoom-api/methods/#operation/users" Desc="Use this API to list your account's users.'s users">
			<OutputColumns>
				<Column Name="id" DataType="DT_WSTR" Length="255" />
				<Column Name="first_name" DataType="DT_WSTR" Length="255" />
				<Column Name="last_name" DataType="DT_WSTR" Length="255" />
				<Column Name="email" DataType="DT_WSTR" Length="255" />
				<Column Name="type" DataType="DT_I8" />
				<Column Name="pmi" DataType="DT_I8" />
				<Column Name="timezone" DataType="DT_WSTR" Length="255" />
				<Column Name="verified" DataType="DT_I8" />
				<Column Name="dept" DataType="DT_WSTR" Length="255" />
				<Column Name="created_at" DataType="DT_DBTIMESTAMP" />
				<Column Name="last_login_time" DataType="DT_DBTIMESTAMP" />
				<Column Name="last_client_version" DataType="DT_WSTR" Length="255" />
				<Column Name="pic_url" DataType="DT_WSTR" Length="2000" />
				<Column Name="language" DataType="DT_WSTR" Length="255" />
				<Column Name="phone_number" DataType="DT_WSTR" Length="100" />
				<Column Name="status" DataType="DT_WSTR" Length="100" />
				<Column Name="role_id" DataType="DT_WSTR" Length="1000" />
			</OutputColumns>
		</EndPoint>
		<EndPoint Name="list_webinars" Template="tp_Pagination" Label="List Webinars" Url="/users/[$UserId$]/webinars" Method="GET" Filter="$.webinars[*]" 
				  HelpLink="https://marketplace.zoom.us/docs/api-reference/zoom-api/methods/#operation/webinars" Desc="Use this API to list all the webinars scheduled by or on-behalf a user (webinar host). For user-level apps, pass the me value instead of the userId parameter.">
			<Params>
				<Param Name="UserId" Template="tp_UserId" Type="Placeholder"
				  OptionsEndPoint="list_users"
                  OptionsEndPointLabelColumn="first_name"
                  OptionsEndPointValueColumn="id"/>
			</Params>
			<OutputColumns>
				<Column Name="id" DataType="DT_I8" />
				<Column Name="host_id" DataType="DT_WSTR" Length="255" />
				<Column Name="topic" DataType="DT_WSTR" Length="500" />
				<Column Name="type" DataType="DT_I8" />
				<Column Name="start_time" DataType="DT_DBTIMESTAMP" />
				<Column Name="duration" DataType="DT_I8" />
				<Column Name="timezone" DataType="DT_WSTR" Length="100" />
				<Column Name="created_at" DataType="DT_DBTIMESTAMP" />
				<Column Name="join_url" DataType="DT_WSTR" Length="1000" />
				<Column Name="uuid" DataType="DT_WSTR" Length="100" />
			</OutputColumns>
		</EndPoint>
		
		<EndPoint Name="get_webinar_settings" Label="Get Webinar Settings" Url="/webinars/[$WebinarId$]" Method="GET" 
				  HelpLink="https://marketplace.zoom.us/docs/api-reference/zoom-api/methods/#operation/webinar" 
				  Filter="$.settings" 
				  Desc="Use this API to get settings details of a scheduled webinar." >			  
			<Params>
				<Param Name="WebinarId" Template="tp_WebinarId" Type="Placeholder"
				  OptionsEndPoint="list_webinars"
                  OptionsEndPointLabelColumn="topic"
                  OptionsEndPointValueColumn="id"  />
			</Params>
			<OutputColumns>
				<Column Name="host_video" DataType="DT_BOOL" />
				<Column Name="panelists_video" DataType="DT_BOOL" />
				<Column Name="approval_type" DataType="DT_I8" />
				<Column Name="audio" DataType="DT_WSTR" Length="16" />
				<Column Name="auto_recording" DataType="DT_WSTR" Length="16" />
				<Column Name="enforce_login" DataType="DT_BOOL" />
				<Column Name="enforce_login_domains" DataType="DT_WSTR" Length="100" />
				<Column Name="alternative_hosts" DataType="DT_WSTR" Length="100" />
				<Column Name="alternative_host_update_polls" DataType="DT_BOOL" />
				<Column Name="close_registration" DataType="DT_BOOL" />
				<Column Name="show_share_button" DataType="DT_BOOL" />
				<Column Name="allow_multiple_devices" DataType="DT_BOOL" />
				<Column Name="practice_session" DataType="DT_BOOL" />
				<Column Name="hd_video" DataType="DT_BOOL" />
				<Column Name="question_answer" DataType="DT_BOOL" />
				<Column Name="registrants_confirmation_email" DataType="DT_BOOL" />
				<Column Name="on_demand" DataType="DT_BOOL" />
				<Column Name="request_permission_to_unmute_participants" DataType="DT_BOOL" />
				<Column Name="contact_name" DataType="DT_WSTR" Length="255" />
				<Column Name="contact_email" DataType="DT_WSTR" Length="255" />
				<Column Name="registrants_restrict_number" DataType="DT_I8" />
				<Column Name="registrants_email_notification" DataType="DT_BOOL" />
				<Column Name="post_webinar_survey" DataType="DT_BOOL" />
				<Column Name="meeting_authentication" DataType="DT_BOOL" />
				<Column Name="question_and_answer.enable" Label="question_and_answer_enable" DataType="DT_BOOL" />
				<Column Name="question_and_answer.allow_anonymous_questions" Label="question_and_answer_allow_anonymous_questions" DataType="DT_BOOL" />
				<Column Name="question_and_answer.answer_questions" Label="question_and_answer_answer_questions" DataType="DT_WSTR" Length="255" />
				<Column Name="question_and_answer.attendees_can_upvote" Label="question_and_answer_attendees_can_upvote" DataType="DT_BOOL" />
				<Column Name="question_and_answer.attendees_can_comment" Label="question_and_answer_attendees_can_comment" DataType="DT_BOOL" />
				<Column Name="hd_video_for_attendees" DataType="DT_BOOL" />
				<Column Name="send_1080p_video_to_attendees" DataType="DT_BOOL" />
				<Column Name="email_language" DataType="DT_WSTR" Length="255" />
				<Column Name="panelists_invitation_email_notification" DataType="DT_BOOL" />
				<Column Name="attendees_and_panelists_reminder_email_notification.enable" Label="attendees_and_panelists_reminder_email_notification_enable" DataType="DT_BOOL" />
				<Column Name="attendees_and_panelists_reminder_email_notification.type" Label="attendees_and_panelists_reminder_email_notification_type" DataType="DT_I8" />
				<Column Name="follow_up_attendees_email_notification.enable" Label="follow_up_attendees_email_notification_enable" DataType="DT_BOOL" />
				<Column Name="follow_up_attendees_email_notification.type" Label="follow_up_attendees_email_notification_type" DataType="DT_I8" />
				<Column Name="follow_up_absentees_email_notification.enable" Label="follow_up_absentees_email_notification_enable" DataType="DT_BOOL" />
				<Column Name="follow_up_absentees_email_notification.type" Label="follow_up_absentees_email_notification_type" DataType="DT_I8" />
				<Column Name="enable_session_branding" DataType="DT_BOOL" />
			</OutputColumns>
		</EndPoint>
		
		<EndPoint Name="get_webinar" Label="Get Webinar Settings By Id" Url="/webinars/[$WebinarId$]" Method="GET" 
		          HelpLink="https://marketplace.zoom.us/docs/api-reference/zoom-api/methods/#operation/webinar"
				  Desc="Use this API to get details of a scheduled webinar." >
			<Params>
				<Param Name="WebinarId" Template="tp_WebinarId" Type="Placeholder"
				  OptionsEndPoint="list_webinars"
                  OptionsEndPointLabelColumn="topic"
                  OptionsEndPointValueColumn="id"  />
			</Params>
			<OutputColumns>
				<Column Name="id" DataType="DT_I8" />
				<Column Name="host_id" DataType="DT_WSTR" Length="100" />
				<Column Name="host_email" DataType="DT_WSTR" Length="255" />
				<Column Name="topic" DataType="DT_WSTR" Length="255" />
				<Column Name="type" DataType="DT_I8" />
				<Column Name="start_time" DataType="DT_DBTIMESTAMP" />
				<Column Name="duration" DataType="DT_I8" />
				<Column Name="timezone" DataType="DT_WSTR" Length="100" />
				<Column Name="agenda" DataType="DT_WSTR" Length="1000" />
				<Column Name="created_at" DataType="DT_DBTIMESTAMP" />
				<Column Name="start_url" DataType="DT_WSTR" Length="4000" />
				<Column Name="join_url" DataType="DT_WSTR" Length="1000" />
				<Column Name="password" DataType="DT_WSTR" Length="100" />
				<Column Name="settings.host_video" Label="settings_host_video" DataType="DT_BOOL" />
				<Column Name="settings.panelists_video" Label="settings_panelists_video" DataType="DT_BOOL" />
				<Column Name="settings.approval_type" Label="settings_approval_type" DataType="DT_I8" />
				<Column Name="settings.audio" Label="settings_audio" DataType="DT_WSTR" Length="16" />
				<Column Name="settings.auto_recording" Label="settings_auto_recording" DataType="DT_WSTR" Length="100" />
				<Column Name="settings.enforce_login" Label="settings_enforce_login" DataType="DT_BOOL" />
				<Column Name="settings.enforce_login_domains" Label="settings_enforce_login_domains" DataType="DT_WSTR" Length="100" />
				<Column Name="settings.alternative_hosts" Label="settings_alternative_hosts" DataType="DT_WSTR" Length="100" />
				<Column Name="settings.alternative_host_update_polls" Label="settings_alternative_host_update_polls" DataType="DT_BOOL" />
				<Column Name="settings.close_registration" Label="settings_close_registration" DataType="DT_BOOL" />
				<Column Name="settings.show_share_button" Label="settings_show_share_button" DataType="DT_BOOL" />
				<Column Name="settings.allow_multiple_devices" Label="settings_allow_multiple_devices" DataType="DT_BOOL" />
				<Column Name="settings.practice_session" Label="settings_practice_session" DataType="DT_BOOL" />
				<Column Name="settings.hd_video" Label="settings_hd_video" DataType="DT_BOOL" />
				<Column Name="settings.question_answer" Label="settings_question_answer" DataType="DT_BOOL" />
				<Column Name="settings.registrants_confirmation_email" Label="settings_registrants_confirmation_email" DataType="DT_BOOL" />
				<Column Name="settings.on_demand" Label="settings_on_demand" DataType="DT_BOOL" />
				<Column Name="settings.request_permission_to_unmute_participants" Label="settings_request_permission_to_unmute_participants" DataType="DT_BOOL" />
				<Column Name="settings.contact_name" Label="settings_contact_name" DataType="DT_WSTR" Length="255" />
				<Column Name="settings.contact_email" Label="settings_contact_email" DataType="DT_WSTR" Length="255" />
				<Column Name="settings.registrants_restrict_number" Label="settings_registrants_restrict_number" DataType="DT_I8" />
				<Column Name="settings.registrants_email_notification" Label="settings_registrants_email_notification" DataType="DT_BOOL" />
				<Column Name="settings.post_webinar_survey" Label="settings_post_webinar_survey" DataType="DT_BOOL" />
				<Column Name="settings.meeting_authentication" Label="settings_meeting_authentication" DataType="DT_BOOL" />
				<Column Name="settings.question_and_answer.enable" Label="settings_question_and_answer_enable" DataType="DT_BOOL" />
				<Column Name="settings.question_and_answer.allow_anonymous_questions" Label="settings_question_and_answer_allow_anonymous_questions" DataType="DT_BOOL" />
				<Column Name="settings.question_and_answer.answer_questions" Label="settings_question_and_answer_answer_questions" DataType="DT_WSTR" Length="255" />
				<Column Name="settings.question_and_answer.attendees_can_upvote" Label="settings_question_and_answer_attendees_can_upvote" DataType="DT_BOOL" />
				<Column Name="settings.question_and_answer.attendees_can_comment" Label="settings_question_and_answer_attendees_can_comment" DataType="DT_BOOL" />
				<Column Name="settings.hd_video_for_attendees" Label="settings_hd_video_for_attendees" DataType="DT_BOOL" />
				<Column Name="settings.send_1080p_video_to_attendees" Label="settings_send_1080p_video_to_attendees" DataType="DT_BOOL" />
				<Column Name="settings.email_language" Label="settings_email_language" DataType="DT_WSTR" Length="100" />
				<Column Name="settings.panelists_invitation_email_notification" Label="settings_panelists_invitation_email_notification" DataType="DT_BOOL" />
				<Column Name="settings.attendees_and_panelists_reminder_email_notification.enable" Label="settings_attendees_and_panelists_reminder_email_notification_enable" DataType="DT_BOOL" />
				<Column Name="settings.attendees_and_panelists_reminder_email_notification.type" Label="settings_attendees_and_panelists_reminder_email_notification_type" DataType="DT_I8" />
				<Column Name="settings.follow_up_attendees_email_notification.enable" Label="settings_follow_up_attendees_email_notification_enable" DataType="DT_BOOL" />
				<Column Name="settings.follow_up_attendees_email_notification.type" Label="settings_follow_up_attendees_email_notification_type" DataType="DT_I8" />
				<Column Name="settings.follow_up_absentees_email_notification.enable" Label="settings_follow_up_absentees_email_notification_enable" DataType="DT_BOOL" />
				<Column Name="settings.follow_up_absentees_email_notification.type" Label="settings_follow_up_absentees_email_notification_type" DataType="DT_I8" />
				<Column Name="settings.enable_session_branding" Label="settings_enable_session_branding" DataType="DT_BOOL" />
				<Column Name="uuid" DataType="DT_WSTR" Length="100" />
			</OutputColumns>
		</EndPoint>
		<EndPoint Name="list_webinar_registrants" Template="tp_Pagination" Label="List Webinar Registrants" Url="/webinars/[$WebinarId$]/registrants" Method="GET" Filter="$.registrants[*]"
				  HelpLink="https://marketplace.zoom.us/docs/api-reference/zoom-api/methods/#operation/webinarRegistrants" Desc="Use this API to list all the users that have registered for a webinar.">
			<Params>
				<Param Name="WebinarId" Template="tp_WebinarId" Type="Placeholder"
				  OptionsEndPoint="list_webinars"
                  OptionsEndPointLabelColumn="topic"
                  OptionsEndPointValueColumn="id"  />
			</Params>
			<OutputColumns>
				<Column Name="id" DataType="DT_WSTR" Length="255" />
				<Column Name="first_name" DataType="DT_WSTR" Length="255" />
				<Column Name="last_name" DataType="DT_WSTR" Length="255" />
				<Column Name="email" DataType="DT_WSTR" Length="255" />
				<Column Name="address" DataType="DT_WSTR" Length="255" />
				<Column Name="city" DataType="DT_WSTR" Length="100" />
				<Column Name="country" DataType="DT_WSTR" Length="100" />
				<Column Name="zip" DataType="DT_WSTR" Length="100" />
				<Column Name="state" DataType="DT_WSTR" Length="100" />
				<Column Name="phone" DataType="DT_WSTR" Length="100" />
				<Column Name="industry" DataType="DT_WSTR" Length="100" />
				<Column Name="org" DataType="DT_WSTR" Length="255" />
				<Column Name="job_title" DataType="DT_WSTR" Length="255" />
				<Column Name="purchasing_time_frame" DataType="DT_WSTR" Length="255" />
				<Column Name="role_in_purchase_process" DataType="DT_WSTR" Length="255" />
				<Column Name="no_of_employees" DataType="DT_WSTR" Length="255" />
				<Column Name="comments" DataType="DT_WSTR" Length="4000" />
				<Column Name="custom_questions" DataType="DT_NTEXT" />
				<Column Name="status" DataType="DT_WSTR" Length="100" />
				<Column Name="create_time" DataType="DT_DBTIMESTAMP" />
				<Column Name="join_url" DataType="DT_WSTR" Length="2000" />
			</OutputColumns>
		</EndPoint>
	</EndPoints>
	<Tables>
		<Table Name="Users" SelectEndPoint="list_users"/>
		<Table Name="UserSettings" SelectEndPoint="get_settings"/>
		<Table Name="Meetings" SelectEndPoint="list_meetings" LookupEndPoint="get_meeting"/>
		<Table Name="MeetingRegistrants" SelectEndPoint="list_meeting_registrants"/>
		<Table Name="PastMeetingRegistrants" SelectEndPoint="list_past_meeting_registrants"/>
		<Table Name="RegistrationQuestions" SelectEndPoint="list_registration_questions"/>
		<Table Name="Webinars" SelectEndPoint="list_webinars" LookupEndPoint="get_webinar"/>
		<Table Name="WebinarSettings" SelectEndPoint="get_webinar_settings"/>
		<Table Name="WebinarRegistrants" SelectEndPoint="list_webinar_registrants"/>
	</Tables>

	<Examples>
		<Example Group="ODBC" Label="List Users" Code="SELECT * FROM Users" Desc="Lists all available Users for organization level" ></Example>
		<Example Group="ODBC" Label="Get Settings" Desc="Get the user settings by by user id" >
			<Code>
				<![CDATA[SELECT * FROM UserSettings
WITH(
  UserId='me' -- enter user id or email
)
--You can get UserId by selecting from 'list_users' endpoint and also this value available as dropdown value for UserId parameter.]]>
			</Code>
		</Example>
		<Example Group="ODBC" Label="List Meetings" Desc="List all the meetings for a selected User" Default="True">
			<Code>
				<![CDATA[SELECT *  FROM Meetings 
WITH(
  UserId ='me' -- enter user id or email
)
--You can get UserId by selecting from 'list_users' endpoint and also this value available as dropdown value for UserId parameter.]]>
			</Code>
		</Example>
		<Example Group="ODBC" Label="Get Meeting" Desc="Select a meeting from the list_meetings by providing meeting id">
			<Code>
				<![CDATA[SELECT * FROM Meetings Where id=1234
--You can get id by selecting from 'list_meetings' endpoint and also this value available as dropdown value for MeetingId parameter.]]>
			</Code>
		</Example>
		<Example Group="ODBC" Label="List Meeting Registrants" Desc="Select a meeting registants for the specific meeting id">
			<Code>
				<![CDATA[SELECT * FROM MeetingRegistrants
WITH(
  MeetingId='1234'
)
--You can get MeetingId by selecting from 'list_meetings' endpoint and also this value available as dropdown value for MeetingId parameter.]]>
			</Code>
		</Example>
		<Example Group="ODBC" Label="List Past Meeting Registrants" Desc="Select a past meeting registants for the specific meeting id">
			<Code>
				<![CDATA[SELECT * FROM PastMeetingRegistrants
				
			WITH(
					  MeetingId='123456'
				)
				--You can get MeetingId by selecting from 'list_meetings' endpoint and also this value available as dropdown value for MeetingId parameter.]]>
			</Code>
		</Example>
		<Example Group="ODBC" Label="List Registration Questions" Desc="Select a meeting registants questions for the specific meeting id">
			<Code>
				<![CDATA[SELECT * FROM RegistrationQuestions

				WITH(
					  MeetingId='123456'
				)
				--You can get MeetingId by selecting from 'list_meetings' endpoint and also this value available as dropdown value for MeetingId parameter.]]>
			</Code>
		</Example>
		<Example Group="ODBC" Label="List Webinars" Desc="Lists all available Webinars for a selected User with webinars access rights" >
			<Code>
				<![CDATA[SELECT *  FROM Webinars
				
				WITH(
					  UserId='test' -- enter user id or email
				)
				--You can get UserId by selecting from 'list_users' endpoint and also this value available as dropdown value for UserId parameter.]]>
			</Code>
		</Example>
		<Example Group="ODBC" Label="List Webinar Registrants" Desc="Select a webinar registants for the specific webinar id">
			<Code>
				<![CDATA[SELECT * FROM [WebinarRegistrants]
					WITH(
				 WebinarId='123456'
				)
				--You can get WebinarId by selecting from 'list_webinars' endpoint and also this value avialable as dropdown value for MeetingId parameter.]]>
			</Code>
		</Example>
		<Example Group="ODBC" Label="Get Webinar" Desc="Select a webinar from the list_webinars by providing webinar id">
			<Code>
				<![CDATA[SELECT * FROM Webinars Where id=1234
				--You can get id by selecting from 'list_webinars' endpoint and also this value available as dropdown value for WebinarId parameter.]]>
			</Code>
		</Example>
		<Example Group="ODBC" Label="Get Webinar Settings" Desc="Select a webinar from the list_webinars by providing webinar id">
			<Code>
				<![CDATA[SELECT * FROM WebinarSettings

					WITH(
						  WebinarId='85463711883'
					)
				--You can get WebinarId by selecting from 'list_webinars' endpoint and also this value available as dropdown value for WebinarId parameter.]]>
			</Code>
		</Example>
	</Examples>

</ApiConfig>