uByExternal_User_badgesByExternalId: Discourse User Badges by External ID
read only REST
- Catalog:
Discourse - Schema:
Users - Label: User Badges 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_ |
`` |
Table Columns
The columns of the table uByExternal_User_badgesByExternalId 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_ |
char |
User Admin | filters on the platform, writable, ::ancestor. |
||
user_ |
varchar2 |
User Avatar Template | filters on the platform, writable, ::ancestor. |
||
user_ |
decimal |
User Badge Count | filters on the platform, writable, ::ancestor. |
||
user_ |
char |
User Can Edit | filters on the platform, writable, ::ancestor. |
||
user_ |
char |
User Can Edit Email | filters on the platform, writable, ::ancestor. |
||
user_ |
char |
User Can Edit Name | filters on the platform, writable, ::ancestor. |
||
user_ |
char |
User Can Edit Username | filters on the platform, writable, ::ancestor. |
||
user_ |
char |
User Can Send Private Message to User | filters on the platform, writable, ::ancestor. |
||
user_ |
char |
User Can Send Private Messages | filters on the platform, writable, ::ancestor. |
||
user_ |
varchar2 |
itgen_dce_user_card_badge | writable | The JSON text of the nested object. | |
user_ |
varchar2 |
User Created at | filters on the platform, writable, ::ancestor. |
||
user_ |
varchar2 |
itgen_dce_user_custom_fields | writable | The JSON text of the nested object. | |
user_ |
decimal |
User ID | filters on the platform, writable, ::ancestor. |
||
user_ |
varchar2 |
User Invited By | writable | The JSON text of the nested object. | |
user_ |
varchar2 |
User Last Posted at | filters on the platform, writable, ::ancestor. |
||
user_ |
varchar2 |
User Last Seen at | filters on the platform, writable, ::ancestor. |
||
user_ |
char |
User Moderator | filters on the platform, writable, ::ancestor. |
||
user_ |
varchar2 |
User Name | writable | The JSON text of the nested object. | |
user_ |
decimal |
User Pending Count | filters on the platform, writable, ::ancestor. |
||
user_ |
varchar2 |
itgen_dce_user_primary_group_flair_bg_color | writable | The JSON text of the nested object. | |
user_ |
varchar2 |
itgen_dce_user_primary_group_flair_color | writable | The JSON text of the nested object. | |
user_ |
varchar2 |
itgen_dce_user_primary_group_flair_url | writable | The JSON text of the nested object. | |
user_ |
varchar2 |
User Primary Group Name | writable | The JSON text of the nested object. | |
user_ |
decimal |
User Profile View Count | filters on the platform, writable, ::ancestor. |
||
user_ |
varchar2 |
User Title | writable | The JSON text of the nested object. | |
user_ |
decimal |
User Trust Level | filters on the platform, writable, ::ancestor. |
||
user_ |
varchar2 |
User Uploaded Avatar ID | writable | The JSON text of the nested object. | |
user_ |
varchar2 |
User Name | filters on the platform, writable, ::ancestor. |
||
user_ |
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)