uByExternal_UserFeatured_user_badge_idsByExternalId: Discourse User Featured User Badge IDs by External ID
read only REST
- Catalog:
Discourse - Schema:
Users - Label: User Featured User Badge IDs 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_UserFeatured_user_badge_idsByExternalId 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 |
|---|---|---|---|---|---|
admin |
char |
Administrator | writable, ::ancestor. |
||
avatar_ |
varchar2 |
Avatar Template | writable, ::ancestor. |
||
badge_ |
decimal |
#Badges | writable, ::ancestor. |
||
can_ |
char |
Can Edit | writable, ::ancestor. |
||
can_ |
char |
Can Edit Email | writable, ::ancestor. |
||
can_ |
char |
Can Edit Name | writable, ::ancestor. |
||
can_ |
char |
Can Edit Username | writable, ::ancestor. |
||
can_ |
char |
Can Send Private Message to User | writable, ::ancestor. |
||
can_ |
char |
Can Send Private Messages | writable, ::ancestor. |
||
card_ |
varchar2 |
itgen_dce_card_badge | writable | The JSON text of the nested object. | |
created_ |
varchar2 |
Created at | writable, ::ancestor. |
||
custom_ |
varchar2 |
Custom Fields | writable | The JSON text of the nested object. | |
id |
decimal |
ID | writable, ::ancestor. |
||
invited_ |
varchar2 |
Invited By | writable | The JSON text of the nested object. | |
last_ |
varchar2 |
Last Posted at | writable, ::ancestor. |
||
last_ |
varchar2 |
Last Seen at | writable, ::ancestor. |
||
moderator |
char |
Moderator | writable, ::ancestor. |
||
name |
varchar2 |
Name | writable | The JSON text of the nested object. | |
pending_ |
decimal |
Pending Count | writable, ::ancestor. |
||
primary_ |
varchar2 |
itgen_dce_primary_group_flair_bg_color | writable | The JSON text of the nested object. | |
primary_ |
varchar2 |
itgen_dce_primary_group_flair_color | writable | The JSON text of the nested object. | |
primary_ |
varchar2 |
itgen_dce_primary_group_flair_url | writable | The JSON text of the nested object. | |
primary_ |
varchar2 |
Primary Group Name | writable | The JSON text of the nested object. | |
profile_ |
decimal |
Profile View Count | writable, ::ancestor. |
||
title |
varchar2 |
Title | writable | The JSON text of the nested object. | |
trust_ |
decimal |
Trust Level | writable, ::ancestor. |
||
uploaded_ |
varchar2 |
Uploaded Avatar ID | writable | The JSON text of the nested object. | |
username |
varchar2 |
User Name | writable, ::ancestor. |
||
website_ |
varchar2 |
itgen_dce_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
~badge_count(database_data_type:decimal→int64)~badge_count(dotnet_data_type:decimal→int64)-card_badge-custom_fields~id(database_data_type:decimal→int64)~id(dotnet_data_type:decimal→int64)~pending_count(database_data_type:decimal→int64)~pending_count(dotnet_data_type:decimal→int64)-primary_group_flair_bg_color-primary_group_flair_color-primary_group_flair_url~profile_view_count(database_data_type:decimal→int64)~profile_view_count(dotnet_data_type:decimal→int64)~trust_level(database_data_type:decimal→int64)~trust_level(dotnet_data_type:decimal→int64)
114 more changes
~uploaded_avatar_id(database_data_type:varchar2→int64)~uploaded_avatar_id(dotnet_data_type:string→int64)-website_name+can_be_deleted(char)+can_change_bio(char)+can_change_location(char)+can_change_tracking_preferences(char)+can_change_website(char)+can_delete_all_posts(char)+can_edit_avatar(char)+can_ignore_user(char)+can_ignore_users(char)+can_mute_user(char)+can_mute_users(char)+can_pick_theme_with_custom_homepage(char)+can_upload_avatar(char)+can_upload_profile_header(char)+can_upload_user_card_background(char)+custom_fields_first_name(varchar2)+display_sidebar_tags(char)+featured_topic_fancy_title(varchar2)+featured_topic_id(int64)+featured_topic_posts_count(int64)+featured_topic_slug(varchar2)+featured_topic_title(varchar2)+flair_bg_color(varchar2)+flair_color(varchar2)+flair_group_id(int64)+flair_name(varchar2)+flair_url(varchar2)+has_title_badges(char)+ignored(char)+locale(varchar2)+mailing_list_posts_per_day(int64)+muted(char)+pending_posts_count(int64)+post_count(int64)+primary_group_id(int64)+recent_time_read(int64)+second_factor_backup_enabled(char)+second_factor_enabled(char)+selected_user_associated_account_id(int64)+staged(char)+system_avatar_template(varchar2)+system_avatar_upload_id(varchar2)+time_read(int64)+topic_count(int64)+use_logo_small_as_avatar(char)+user_api_keys(varchar2)+user_fields_1(varchar2)+user_fields_2(varchar2)+user_notification_schedule_day_0_end_time(int64)+user_notification_schedule_day_0_start_time(int64)+user_notification_schedule_day_1_end_time(int64)+user_notification_schedule_day_1_start_time(int64)+user_notification_schedule_day_2_end_time(int64)+user_notification_schedule_day_2_start_time(int64)+user_notification_schedule_day_3_end_time(int64)+user_notification_schedule_day_3_start_time(int64)+user_notification_schedule_day_4_end_time(int64)+user_notification_schedule_day_4_start_time(int64)+user_notification_schedule_day_5_end_time(int64)+user_notification_schedule_day_5_start_time(int64)+user_notification_schedule_day_6_end_time(int64)+user_notification_schedule_day_6_start_time(int64)+user_notification_schedule_enabled(char)+user_option_allow_private_messages(char)+user_option_auto_track_topics_after_msecs(int64)+user_option_automatically_translate(char)+user_option_automatically_unpin_topics(char)+user_option_bookmark_auto_delete_preference(int64)+user_option_color_scheme_id(varchar2)+user_option_composition_mode(int64)+user_option_dark_scheme_id(varchar2)+user_option_default_calendar(varchar2)+user_option_digest_after_minutes(int64)+user_option_dynamic_favicon(char)+user_option_email_digests(char)+user_option_email_in_reply_to(char)+user_option_email_level(int64)+user_option_email_messages_level(int64)+user_option_email_previous_replies(int64)+user_option_enable_allowed_pm_users(char)+user_option_enable_markdown_monospace_font(char)+user_option_enable_quoting(char)+user_option_enable_smart_lists(char)+user_option_enable_upcoming_change_available_notifications(char)+user_option_external_links_in_new_tab(char)+user_option_hide_presence(char)+user_option_hide_profile(char)+user_option_hide_profile_and_presence(char)+user_option_homepage_id(varchar2)+user_option_include_tl0_in_digests(char)+user_option_interface_color_mode(int64)+user_option_like_notification_frequency(int64)+user_option_mailing_list_mode(char)+user_option_mailing_list_mode_frequency(int64)+user_option_new_topic_duration_minutes(int64)+user_option_notification_level_when_replying(int64)+user_option_notify_on_linked_posts(char)+user_option_oldest_search_log_date(varchar2)+user_option_push_notification_level(varchar2)+user_option_send_shortcut(varchar2)+user_option_show_original_content(char)+user_option_sidebar_link_to_filtered_list(char)+user_option_sidebar_show_count_of_new_items(char)+user_option_skip_new_user_tips(char)+user_option_text_size(varchar2)+user_option_text_size_seq(int64)+user_option_theme_key_seq(int64)+user_option_timezone(varchar2)+user_option_title_count_mode(varchar2)+user_option_user_id(int64)+user_option_watched_precedence_over_muted(char)