invantive documentation
Invantive Support ForumsLog In / Sign Up

uByExternalByExternalId: Discourse User by External ID

read only REST

  • Catalog: Discourse
  • Schema: Users
  • Label: User by External ID

Get a single user by SSO external ID

Can only retrieve data.

Summary

Get a single user by SSO external ID

API Source

  • Endpoint: /u/by-external/{external_id}.json
  • Operation: get /u/by-external/{external_id}.json

Performance Characteristics

Characteristic Value
Average access latency (ms) 243
Write rows per minute 219

The result can be cached on the client.

Parameters

Name Data Type Required Default Documentation
external_id ``

Table Columns

The columns of the table uByExternalByExternalId are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
user_admin char User Admin filters on the platform, writable, user.admin
user_avatar_template varchar2 User Avatar Template filters on the platform, writable, user.avatar_template
user_badge_count decimal User Badge Count filters on the platform, writable, user.badge_count
user_can_edit char User Can Edit filters on the platform, writable, user.can_edit
user_can_edit_email char User Can Edit Email filters on the platform, writable, user.can_edit_email
user_can_edit_name char User Can Edit Name filters on the platform, writable, user.can_edit_name
user_can_edit_username char User Can Edit Username filters on the platform, writable, user.can_edit_username
user_can_send_private_message_to_user char User Can Send Private Message to User filters on the platform, writable, user.can_send_private_message_to_user
user_can_send_private_messages char User Can Send Private Messages filters on the platform, writable, user.can_send_private_messages
user_card_badge varchar2 itgen_dce_user_card_badge writable The JSON text of the nested object.
user_created_at varchar2 User Created at filters on the platform, writable, user.created_at
user_custom_fields varchar2 itgen_dce_user_custom_fields writable The JSON text of the nested object.
user_id decimal User ID filters on the platform, writable, user.id
user_invited_by varchar2 User Invited By writable The JSON text of the nested object.
user_last_posted_at varchar2 User Last Posted at filters on the platform, writable, user.last_posted_at
user_last_seen_at varchar2 User Last Seen at filters on the platform, writable, user.last_seen_at
user_moderator char User Moderator filters on the platform, writable, user.moderator
user_name varchar2 User Name writable The JSON text of the nested object.
user_pending_count decimal User Pending Count filters on the platform, writable, user.pending_count
user_primary_group_flair_bg_color varchar2 itgen_dce_user_primary_group_flair_bg_color writable The JSON text of the nested object.
user_primary_group_flair_color varchar2 itgen_dce_user_primary_group_flair_color writable The JSON text of the nested object.
user_primary_group_flair_url varchar2 itgen_dce_user_primary_group_flair_url writable The JSON text of the nested object.
user_primary_group_name varchar2 User Primary Group Name writable The JSON text of the nested object.
user_profile_view_count decimal User Profile View Count filters on the platform, writable, user.profile_view_count
user_title varchar2 User Title writable The JSON text of the nested object.
user_trust_level decimal User Trust Level filters on the platform, writable, user.trust_level
user_uploaded_avatar_id varchar2 User Uploaded Avatar ID writable The JSON text of the nested object.
user_username varchar2 User Name filters on the platform, writable, user.username
user_website_name varchar2 itgen_dce_user_website_name writable The JSON text of the nested object.

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

Changes of This Table, 26.0 to 27.0

  • ~ user_badge_count (database_data_type: decimal → int64)
  • ~ user_badge_count (dotnet_data_type: decimal → int64)
  • - user_card_badge
  • - user_custom_fields
  • ~ user_id (database_data_type: decimal → int64)
  • ~ user_id (dotnet_data_type: decimal → int64)
  • ~ user_pending_count (database_data_type: decimal → int64)
  • ~ user_pending_count (dotnet_data_type: decimal → int64)
  • - user_primary_group_flair_bg_color
  • - user_primary_group_flair_color
  • - user_primary_group_flair_url
  • ~ user_profile_view_count (database_data_type: decimal → int64)
  • ~ user_profile_view_count (dotnet_data_type: decimal → int64)
  • ~ user_trust_level (database_data_type: decimal → int64)
  • ~ user_trust_level (dotnet_data_type: decimal → int64)

114 more changes

  • ~ user_uploaded_avatar_id (database_data_type: varchar2 → int64)
  • ~ user_uploaded_avatar_id (dotnet_data_type: string → int64)
  • - user_website_name
  • + user_can_be_deleted (char)
  • + user_can_change_bio (char)
  • + user_can_change_location (char)
  • + user_can_change_tracking_preferences (char)
  • + user_can_change_website (char)
  • + user_can_delete_all_posts (char)
  • + user_can_edit_avatar (char)
  • + user_can_ignore_user (char)
  • + user_can_ignore_users (char)
  • + user_can_mute_user (char)
  • + user_can_mute_users (char)
  • + user_can_pick_theme_with_custom_homepage (char)
  • + user_can_upload_avatar (char)
  • + user_can_upload_profile_header (char)
  • + user_can_upload_user_card_background (char)
  • + user_custom_fields_first_name (varchar2)
  • + user_display_sidebar_tags (char)
  • + user_featured_topic_fancy_title (varchar2)
  • + user_featured_topic_id (int64)
  • + user_featured_topic_posts_count (int64)
  • + user_featured_topic_slug (varchar2)
  • + user_featured_topic_title (varchar2)
  • + user_flair_bg_color (varchar2)
  • + user_flair_color (varchar2)
  • + user_flair_group_id (int64)
  • + user_flair_name (varchar2)
  • + user_flair_url (varchar2)
  • + user_has_title_badges (char)
  • + user_ignored (char)
  • + user_locale (varchar2)
  • + user_mailing_list_posts_per_day (int64)
  • + user_muted (char)
  • + user_pending_posts_count (int64)
  • + user_post_count (int64)
  • + user_primary_group_id (int64)
  • + user_recent_time_read (int64)
  • + user_second_factor_backup_enabled (char)
  • + user_second_factor_enabled (char)
  • + user_selected_user_associated_account_id (int64)
  • + user_staged (char)
  • + user_system_avatar_template (varchar2)
  • + user_system_avatar_upload_id (varchar2)
  • + user_time_read (int64)
  • + user_topic_count (int64)
  • + user_use_logo_small_as_avatar (char)
  • + user_user_api_keys (varchar2)
  • + user_user_fields_1 (varchar2)
  • + user_user_fields_2 (varchar2)
  • + user_user_notification_schedule_day_0_end_time (int64)
  • + user_user_notification_schedule_day_0_start_time (int64)
  • + user_user_notification_schedule_day_1_end_time (int64)
  • + user_user_notification_schedule_day_1_start_time (int64)
  • + user_user_notification_schedule_day_2_end_time (int64)
  • + user_user_notification_schedule_day_2_start_time (int64)
  • + user_user_notification_schedule_day_3_end_time (int64)
  • + user_user_notification_schedule_day_3_start_time (int64)
  • + user_user_notification_schedule_day_4_end_time (int64)
  • + user_user_notification_schedule_day_4_start_time (int64)
  • + user_user_notification_schedule_day_5_end_time (int64)
  • + user_user_notification_schedule_day_5_start_time (int64)
  • + user_user_notification_schedule_day_6_end_time (int64)
  • + user_user_notification_schedule_day_6_start_time (int64)
  • + user_user_notification_schedule_enabled (char)
  • + user_user_option_allow_private_messages (char)
  • + user_user_option_auto_track_topics_after_msecs (int64)
  • + user_user_option_automatically_translate (char)
  • + user_user_option_automatically_unpin_topics (char)
  • + user_user_option_bookmark_auto_delete_preference (int64)
  • + user_user_option_color_scheme_id (varchar2)
  • + user_user_option_composition_mode (int64)
  • + user_user_option_dark_scheme_id (varchar2)
  • + user_user_option_default_calendar (varchar2)
  • + user_user_option_digest_after_minutes (int64)
  • + user_user_option_dynamic_favicon (char)
  • + user_user_option_email_digests (char)
  • + user_user_option_email_in_reply_to (char)
  • + user_user_option_email_level (int64)
  • + user_user_option_email_messages_level (int64)
  • + user_user_option_email_previous_replies (int64)
  • + user_user_option_enable_allowed_pm_users (char)
  • + user_user_option_enable_markdown_monospace_font (char)
  • + user_user_option_enable_quoting (char)
  • + user_user_option_enable_smart_lists (char)
  • + user_user_option_enable_upcoming_change_available_notifications (char)
  • + user_user_option_external_links_in_new_tab (char)
  • + user_user_option_hide_presence (char)
  • + user_user_option_hide_profile (char)
  • + user_user_option_hide_profile_and_presence (char)
  • + user_user_option_homepage_id (varchar2)
  • + user_user_option_include_tl0_in_digests (char)
  • + user_user_option_interface_color_mode (int64)
  • + user_user_option_like_notification_frequency (int64)
  • + user_user_option_mailing_list_mode (char)
  • + user_user_option_mailing_list_mode_frequency (int64)
  • + user_user_option_new_topic_duration_minutes (int64)
  • + user_user_option_notification_level_when_replying (int64)
  • + user_user_option_notify_on_linked_posts (char)
  • + user_user_option_oldest_search_log_date (varchar2)
  • + user_user_option_push_notification_level (varchar2)
  • + user_user_option_send_shortcut (varchar2)
  • + user_user_option_show_original_content (char)
  • + user_user_option_sidebar_link_to_filtered_list (char)
  • + user_user_option_sidebar_show_count_of_new_items (char)
  • + user_user_option_skip_new_user_tips (char)
  • + user_user_option_text_size (varchar2)
  • + user_user_option_text_size_seq (int64)
  • + user_user_option_theme_key_seq (int64)
  • + user_user_option_timezone (varchar2)
  • + user_user_option_title_count_mode (varchar2)
  • + user_user_option_user_id (int64)
  • + user_user_option_watched_precedence_over_muted (char)

All changes of the driver, 26.0 to 27.0