---
title: "uByExternal_User_badgesByExternalId (Discourse)"
description: "User Badges by External ID"
language: de
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/de/datamodels/discourse/Discourse.Users.uByExternal_User_badgesByExternalId
original: https://documentation.invantive.eu/en/datamodels/discourse/Discourse.Users.uByExternal_User_badgesByExternalId
updated: 2026-11-16T20:47:53Z
license: https://documentation.invantive.eu/de/
---

# uByExternal_User_badgesByExternalId: Discourse User Badges by External ID

`read only` `REST`

- Katalog: `Discourse`
- Schema: `Users`
- Label: User Badges by External ID

Get a single user by SSO external ID

Es können nur Daten abgerufen werden.

## Zusammenfassung

Get a single user by SSO external ID

## API-Quelle

- Endpunkt: `/u/by-external/{external_id}.json`
- Operation: `get /u/by-external/{external_id}.json`

## Leistungsmerkmale

| Characteristic | Value |
|---|---:|
| Durchschnittliche Zugriffsverzögerung (ms) | 243 |
| Zeilen pro Minute schreiben | 219 |

Das Ergebnis kann auf dem Client im Cache zwischengespeichert werden.

## Parameter

| Name | Datentyp | Required | Default | Documentation |
|---|---|:---:|---|---|
| `external_id` | `` | [x] |  |  |

## Tabellenspalten

Die Spalten der Tabelle `uByExternal_User_badgesByExternalId` sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.

| Name | Datentyp | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `user_admin` | `char` | Benutzerverwaltung | [ ] | filters on the platform, writable, `::ancestor.user.admin` |  |
| `user_avatar_template` | `varchar2` | Schablone für Benutzer-Avatare | [ ] | filters on the platform, writable, `::ancestor.user.avatar_template` |  |
| `user_badge_count` | `decimal` | Anzahl der Benutzerabzeichen | [ ] | filters on the platform, writable, `::ancestor.user.badge_count` |  |
| `user_can_edit` | `char` | Benutzer kann bearbeiten | [ ] | filters on the platform, writable, `::ancestor.user.can_edit` |  |
| `user_can_edit_email` | `char` | Der Benutzer kann die E-Mail bearbeiten | [ ] | filters on the platform, writable, `::ancestor.user.can_edit_email` |  |
| `user_can_edit_name` | `char` | Der Benutzer kann den Namen bearbeiten | [ ] | filters on the platform, writable, `::ancestor.user.can_edit_name` |  |
| `user_can_edit_username` | `char` | Der Benutzer kann seinen Benutzernamen bearbeiten | [ ] | filters on the platform, writable, `::ancestor.user.can_edit_username` |  |
| `user_can_send_private_message_to_user` | `char` | Ein Benutzer kann einem anderen Benutzer eine private Nachricht senden | [ ] | filters on the platform, writable, `::ancestor.user.can_send_private_message_to_user` |  |
| `user_can_send_private_messages` | `char` | Der Benutzer kann private Nachrichten versenden | [ ] | filters on the platform, writable, `::ancestor.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` | Benutzer erstellt am | [ ] | filters on the platform, writable, `::ancestor.user.created_at` |  |
| `user_custom_fields` | `varchar2` | itgen_dce_user_custom_fields | [ ] | writable | The JSON text of the nested object. |
| `user_id` | `decimal` | Benutzer-Kennung | [ ] | filters on the platform, writable, `::ancestor.user.id` |  |
| `user_invited_by` | `varchar2` | Benutzer eingeladen von | [ ] | writable | The JSON text of the nested object. |
| `user_last_posted_at` | `varchar2` | Benutzer hat zuletzt gepostet am | [ ] | filters on the platform, writable, `::ancestor.user.last_posted_at` |  |
| `user_last_seen_at` | `varchar2` | Benutzer zuletzt gesehen um | [ ] | filters on the platform, writable, `::ancestor.user.last_seen_at` |  |
| `user_moderator` | `char` | Benutzer-Moderator | [ ] | filters on the platform, writable, `::ancestor.user.moderator` |  |
| `user_name` | `varchar2` | Benutzername | [ ] | writable | The JSON text of the nested object. |
| `user_pending_count` | `decimal` | Anzahl der ausstehenden Benutzer | [ ] | filters on the platform, writable, `::ancestor.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` | Name der primären Benutzergruppe | [ ] | writable | The JSON text of the nested object. |
| `user_profile_view_count` | `decimal` | Anzahl der Views des Benutzerprofils | [ ] | filters on the platform, writable, `::ancestor.user.profile_view_count` |  |
| `user_title` | `varchar2` | Titel des Benutzers | [ ] | writable | The JSON text of the nested object. |
| `user_trust_level` | `decimal` | Vertrauensstufe des Benutzers | [ ] | filters on the platform, writable, `::ancestor.user.trust_level` |  |
| `user_uploaded_avatar_id` | `varchar2` | Vom Benutzer hochgeladene Avatar-ID | [ ] | writable | The JSON text of the nested object. |
| `user_username` | `varchar2` | Benutzername | [ ] | filters on the platform, writable, `::ancestor.user.username` |  |
| `user_website_name` | `varchar2` | itgen_dce_user_website_name | [ ] | writable | The JSON text of the nested object. |


## Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert:

- [Discourse](/de/release-notes/drivers?driver=discourse)

### Änderungen an dieser Tabelle, 26.0 bis 27.0

<a id="DCE-27.0-D1033"></a><a id="DCE-27.0-D1034"></a><a id="DCE-27.0-D1035"></a><a id="DCE-27.0-D1036"></a><a id="DCE-27.0-D1037"></a><a id="DCE-27.0-D1038"></a><a id="DCE-27.0-D1039"></a><a id="DCE-27.0-D1040"></a><a id="DCE-27.0-D1041"></a><a id="DCE-27.0-D1042"></a><a id="DCE-27.0-D1043"></a><a id="DCE-27.0-D1044"></a><a id="DCE-27.0-D1045"></a><a id="DCE-27.0-D1046"></a><a id="DCE-27.0-D1047"></a>

- `~` `user_badge_count` (`database_data_type`: `decimal` &rarr; `int64`)
- `~` `user_badge_count` (`dotnet_data_type`: `decimal` &rarr; `int64`)
- `-` `user_card_badge`
- `-` `user_custom_fields`
- `~` `user_id` (`database_data_type`: `decimal` &rarr; `int64`)
- `~` `user_id` (`dotnet_data_type`: `decimal` &rarr; `int64`)
- `~` `user_pending_count` (`database_data_type`: `decimal` &rarr; `int64`)
- `~` `user_pending_count` (`dotnet_data_type`: `decimal` &rarr; `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` &rarr; `int64`)
- `~` `user_profile_view_count` (`dotnet_data_type`: `decimal` &rarr; `int64`)
- `~` `user_trust_level` (`database_data_type`: `decimal` &rarr; `int64`)
- `~` `user_trust_level` (`dotnet_data_type`: `decimal` &rarr; `int64`)

<details>
<summary>

114 weitere Änderungen

</summary>

<a id="DCE-27.0-D1048"></a><a id="DCE-27.0-D1049"></a><a id="DCE-27.0-D1050"></a><a id="DCE-27.0-D2264"></a><a id="DCE-27.0-D2265"></a><a id="DCE-27.0-D2266"></a><a id="DCE-27.0-D2267"></a><a id="DCE-27.0-D2268"></a><a id="DCE-27.0-D2269"></a><a id="DCE-27.0-D2270"></a><a id="DCE-27.0-D2271"></a><a id="DCE-27.0-D2272"></a><a id="DCE-27.0-D2273"></a><a id="DCE-27.0-D2274"></a><a id="DCE-27.0-D2275"></a><a id="DCE-27.0-D2276"></a><a id="DCE-27.0-D2277"></a><a id="DCE-27.0-D2278"></a><a id="DCE-27.0-D2279"></a><a id="DCE-27.0-D2280"></a><a id="DCE-27.0-D2281"></a><a id="DCE-27.0-D2282"></a><a id="DCE-27.0-D2283"></a><a id="DCE-27.0-D2284"></a><a id="DCE-27.0-D2285"></a><a id="DCE-27.0-D2286"></a><a id="DCE-27.0-D2287"></a><a id="DCE-27.0-D2288"></a><a id="DCE-27.0-D2289"></a><a id="DCE-27.0-D2290"></a><a id="DCE-27.0-D2291"></a><a id="DCE-27.0-D2292"></a><a id="DCE-27.0-D2293"></a><a id="DCE-27.0-D2294"></a><a id="DCE-27.0-D2295"></a><a id="DCE-27.0-D2296"></a><a id="DCE-27.0-D2297"></a><a id="DCE-27.0-D2298"></a><a id="DCE-27.0-D2299"></a><a id="DCE-27.0-D2300"></a><a id="DCE-27.0-D2301"></a><a id="DCE-27.0-D2302"></a><a id="DCE-27.0-D2303"></a><a id="DCE-27.0-D2304"></a><a id="DCE-27.0-D2305"></a><a id="DCE-27.0-D2306"></a><a id="DCE-27.0-D2307"></a><a id="DCE-27.0-D2308"></a><a id="DCE-27.0-D2309"></a><a id="DCE-27.0-D2310"></a><a id="DCE-27.0-D2311"></a><a id="DCE-27.0-D2312"></a><a id="DCE-27.0-D2313"></a><a id="DCE-27.0-D2314"></a><a id="DCE-27.0-D2315"></a><a id="DCE-27.0-D2316"></a><a id="DCE-27.0-D2317"></a><a id="DCE-27.0-D2318"></a><a id="DCE-27.0-D2319"></a><a id="DCE-27.0-D2320"></a><a id="DCE-27.0-D2321"></a><a id="DCE-27.0-D2322"></a><a id="DCE-27.0-D2323"></a><a id="DCE-27.0-D2324"></a><a id="DCE-27.0-D2325"></a><a id="DCE-27.0-D2326"></a><a id="DCE-27.0-D2327"></a><a id="DCE-27.0-D2328"></a><a id="DCE-27.0-D2329"></a><a id="DCE-27.0-D2330"></a><a id="DCE-27.0-D2331"></a><a id="DCE-27.0-D2332"></a><a id="DCE-27.0-D2333"></a><a id="DCE-27.0-D2334"></a><a id="DCE-27.0-D2335"></a><a id="DCE-27.0-D2336"></a><a id="DCE-27.0-D2337"></a><a id="DCE-27.0-D2338"></a><a id="DCE-27.0-D2339"></a><a id="DCE-27.0-D2340"></a><a id="DCE-27.0-D2341"></a><a id="DCE-27.0-D2342"></a><a id="DCE-27.0-D2343"></a><a id="DCE-27.0-D2344"></a><a id="DCE-27.0-D2345"></a><a id="DCE-27.0-D2346"></a><a id="DCE-27.0-D2347"></a><a id="DCE-27.0-D2348"></a><a id="DCE-27.0-D2349"></a><a id="DCE-27.0-D2350"></a><a id="DCE-27.0-D2351"></a><a id="DCE-27.0-D2352"></a><a id="DCE-27.0-D2353"></a><a id="DCE-27.0-D2354"></a><a id="DCE-27.0-D2355"></a><a id="DCE-27.0-D2356"></a><a id="DCE-27.0-D2357"></a><a id="DCE-27.0-D2358"></a><a id="DCE-27.0-D2359"></a><a id="DCE-27.0-D2360"></a><a id="DCE-27.0-D2361"></a><a id="DCE-27.0-D2362"></a><a id="DCE-27.0-D2363"></a><a id="DCE-27.0-D2364"></a><a id="DCE-27.0-D2365"></a><a id="DCE-27.0-D2366"></a><a id="DCE-27.0-D2367"></a><a id="DCE-27.0-D2368"></a><a id="DCE-27.0-D2369"></a><a id="DCE-27.0-D2370"></a><a id="DCE-27.0-D2371"></a><a id="DCE-27.0-D2372"></a><a id="DCE-27.0-D2373"></a><a id="DCE-27.0-D2374"></a>

- `~` `user_uploaded_avatar_id` (`database_data_type`: `varchar2` &rarr; `int64`)
- `~` `user_uploaded_avatar_id` (`dotnet_data_type`: `string` &rarr; `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`)

</details>

[Alle Treiberwechsel, 26.0 bis 27.0](/de/release-notes/drivers?driver=discourse&step=26.0-to-27.0#discourse-26.0-to-27.0)
