# UsersByUserIdSettings Retrieve a user's settings Retrieve a user's settings - Catalog: `Zoom` - Schema: `Users` - Select Zoom API URL: `/users/{userId}/settings` - Insert Zoom API URL: `/users/{userId}/settings` - Update Zoom API URL: `/users/{userId}/settings` - Delete Zoom API URL: `/users/{userId}/settings` - Field Selection Method: NotRequired - Select Zoom API Operation: `get /users/{userId}/settings` This is a read-only table function. The Zoom API may not support changing the data or the Invantive SQL driver for Zoom does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Zoom API. ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `login_type` | `string` | ☐ | | Values: 0, 1, 99, 100, 101. | | `userId` | `string` | ☑ | | The user ID or email address | ## Columns of Table Function The columns of the table function `UsersByUserIdSettings` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `email_notification_alternative_host_reminder` | `boolean` | | ☐ | When an alternative host is set or removed from a meeting | | `email_notification_cancel_meeting_reminder` | `boolean` | | ☐ | When a meeting is cancelled | | `email_notification_jbh_reminder` | `boolean` | | ☐ | When attendees join meeting before host | | `feature_cn_meeting` | `boolean` | | ☐ | CN meeting feature | | `feature_in_meeting` | `boolean` | | ☐ | IN meeting feature | | `feature_large_meeting_capacity` | `int64` | | ☐ | Large meeting capacity, can be 100, 200, 300 or 500, depends on if having related large meeting capacity plan subscription or not | | `feature_large_meeting` | `boolean` | | ☐ | Large meting feature | | `feature_meeting_capacity` | `int64` | | ☐ | User’s meeting capacity | | `feature_webinar_capacity` | `int64` | | ☐ | Webinar capacity, can be 100, 500, 1000, 3000, 5000 or 10000, depends on if having related webinar capacity plan subscription or not | | `feature_webinar` | `boolean` | | ☐ | Webinar feature | | `in_meeting_allow_live_streaming` | `boolean` | | ☐ | Allow live streaming | | `in_meeting_annotation` | `boolean` | | ☐ | Annotation | | `in_meeting_attendee_on_hold` | `boolean` | | ☐ | Allow host to put attendee on hold | | `in_meeting_attention_tracking` | `boolean` | | ☐ | Attention tracking | | `in_meeting_auto_saving_chat` | `boolean` | | ☐ | Auto saving chats | | `in_meeting_breakout_room` | `boolean` | | ☐ | Breakout room | | `in_meeting_chat` | `boolean` | | ☐ | Chat | | `in_meeting_closed_caption` | `boolean` | | ☐ | Closed caption | | `in_meeting_co_host` | `boolean` | | ☐ | Co-host | | `in_meeting_custom_live_streaming` | `boolean` | | ☐ | Custom live streaming | | `in_meeting_custom_service_instructions` | `string` | | ☐ | Custom service instructions | | `in_meeting_e2e_encryption` | `boolean` | | ☐ | End-to-end encryption | | `in_meeting_entry_exit_chime` | `string` | | ☐ | Play sound on join/leave | | `in_meeting_far_end_camera_control` | `boolean` | | ☐ | Far end camera control | | `in_meeting_feedback` | `boolean` | | ☐ | Feedback to Zoom | | `in_meeting_file_transfer` | `boolean` | | ☐ | File transfer | | `in_meeting_group_hd` | `boolean` | | ☐ | Group HD video | | `in_meeting_non_verbal_feedback` | `boolean` | | ☐ | Non-verbal feedback | | `in_meeting_polling` | `boolean` | | ☐ | Polling | | `in_meeting_private_chat` | `boolean` | | ☐ | Private chat | | `in_meeting_record_play_voice` | `boolean` | | ☐ | Record and play their own voice | | `in_meeting_remote_control` | `boolean` | | ☐ | Remote control | | `in_meeting_remote_support` | `boolean` | | ☐ | Remote support | | `in_meeting_share_dual_camera` | `boolean` | | ☐ | Share dual camera (Deprecated) | | `in_meeting_virtual_background` | `boolean` | | ☐ | Virtual background | | `in_meeting_waiting_room` | `boolean` | | ☐ | Waiting room | | `in_meeting_workplace_by_facebook` | `boolean` | | ☐ | Workplace by facebook | | `recording_auto_delete_cmr_days` | `int64` | | ☐ | A specified number of days of auto delete cloud recordings | | `recording_auto_delete_cmr` | `boolean` | | ☐ | Auto delete cloud recordings | | `recording_auto_recording` | `string` | | ☐ | Automatic recording | | `recording_cloud_recording` | `boolean` | | ☐ | Cloud recording | | `recording_local_recording` | `boolean` | | ☐ | Local recording | | `recording_record_audio_file` | `boolean` | | ☐ | Record an audio only file | | `recording_record_gallery_view` | `boolean` | | ☐ | Record the gallery view | | `recording_record_speaker_view` | `boolean` | | ☐ | Record the active speaker view | | `recording_recording_audio_transcript` | `boolean` | | ☐ | Audio transcript | | `recording_save_chat_text` | `boolean` | | ☐ | Save chat text from the meeting | | `recording_show_timestamp` | `boolean` | | ☐ | Show timestamp on video | | `schedule_meeting_audio_type` | `string` | | ☐ | Determine how participants can join the audio portion of the meeting | | `schedule_meeting_force_pmi_jbh_password` | `boolean` | | ☐ | Require a password for Personal Meetings if attendees can join before host | | `schedule_meeting_host_video` | `boolean` | | ☐ | Host video | | `schedule_meeting_join_before_host` | `boolean` | | ☐ | Join before host | | `schedule_meeting_participants_video` | `boolean` | | ☐ | Participants video | | `schedule_meeting_pstn_password_protected` | `boolean` | | ☐ | Generate and require password for participants joining by phone | | `telephony_audio_conference_info` | `string(2048)` | | ☐ | 3rd party audio conference info | | `telephony_show_international_numbers_link` | `boolean` | | ☐ | Show international numbers link on the invitation email | | `telephony_third_party_audio` | `boolean` | | ☐ | 3rd party audio conference |