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

# uByExternalByExternalId: Discourse User by External ID

`read only` `REST`

- Katalog: `Discourse`
- Schema: `Users`
- Label: User 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 `uByExternalByExternalId` 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, `user.admin` |  |
| `user_avatar_template` | `varchar2` | Schablone für Benutzer-Avatare | [ ] | filters on the platform, writable, `user.avatar_template` |  |
| `user_badge_count` | `decimal` | Anzahl der Benutzerabzeichen | [ ] | filters on the platform, writable, `user.badge_count` |  |
| `user_can_edit` | `char` | Benutzer kann bearbeiten | [ ] | filters on the platform, writable, `user.can_edit` |  |
| `user_can_edit_email` | `char` | Der Benutzer kann die E-Mail bearbeiten | [ ] | filters on the platform, writable, `user.can_edit_email` |  |
| `user_can_edit_name` | `char` | Der Benutzer kann den Namen bearbeiten | [ ] | filters on the platform, writable, `user.can_edit_name` |  |
| `user_can_edit_username` | `char` | Der Benutzer kann seinen Benutzernamen bearbeiten | [ ] | filters on the platform, writable, `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, `user.can_send_private_message_to_user` |  |
| `user_can_send_private_messages` | `char` | Der Benutzer kann private Nachrichten versenden | [ ] | 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` | Benutzer erstellt am | [ ] | 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` | Benutzer-Kennung | [ ] | filters on the platform, writable, `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, `user.last_posted_at` |  |
| `user_last_seen_at` | `varchar2` | Benutzer zuletzt gesehen um | [ ] | filters on the platform, writable, `user.last_seen_at` |  |
| `user_moderator` | `char` | Benutzer-Moderator | [ ] | filters on the platform, writable, `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, `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, `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, `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, `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-D968"></a><a id="DCE-27.0-D969"></a><a id="DCE-27.0-D970"></a><a id="DCE-27.0-D971"></a><a id="DCE-27.0-D972"></a><a id="DCE-27.0-D973"></a><a id="DCE-27.0-D974"></a><a id="DCE-27.0-D975"></a><a id="DCE-27.0-D976"></a><a id="DCE-27.0-D977"></a><a id="DCE-27.0-D978"></a><a id="DCE-27.0-D979"></a><a id="DCE-27.0-D980"></a><a id="DCE-27.0-D981"></a><a id="DCE-27.0-D982"></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-D983"></a><a id="DCE-27.0-D984"></a><a id="DCE-27.0-D985"></a><a id="DCE-27.0-D1913"></a><a id="DCE-27.0-D1914"></a><a id="DCE-27.0-D1915"></a><a id="DCE-27.0-D1916"></a><a id="DCE-27.0-D1917"></a><a id="DCE-27.0-D1918"></a><a id="DCE-27.0-D1919"></a><a id="DCE-27.0-D1920"></a><a id="DCE-27.0-D1921"></a><a id="DCE-27.0-D1922"></a><a id="DCE-27.0-D1923"></a><a id="DCE-27.0-D1924"></a><a id="DCE-27.0-D1925"></a><a id="DCE-27.0-D1926"></a><a id="DCE-27.0-D1927"></a><a id="DCE-27.0-D1928"></a><a id="DCE-27.0-D1929"></a><a id="DCE-27.0-D1930"></a><a id="DCE-27.0-D1931"></a><a id="DCE-27.0-D1932"></a><a id="DCE-27.0-D1933"></a><a id="DCE-27.0-D1934"></a><a id="DCE-27.0-D1935"></a><a id="DCE-27.0-D1936"></a><a id="DCE-27.0-D1937"></a><a id="DCE-27.0-D1938"></a><a id="DCE-27.0-D1939"></a><a id="DCE-27.0-D1940"></a><a id="DCE-27.0-D1941"></a><a id="DCE-27.0-D1942"></a><a id="DCE-27.0-D1943"></a><a id="DCE-27.0-D1944"></a><a id="DCE-27.0-D1945"></a><a id="DCE-27.0-D1946"></a><a id="DCE-27.0-D1947"></a><a id="DCE-27.0-D1948"></a><a id="DCE-27.0-D1949"></a><a id="DCE-27.0-D1950"></a><a id="DCE-27.0-D1951"></a><a id="DCE-27.0-D1952"></a><a id="DCE-27.0-D1953"></a><a id="DCE-27.0-D1954"></a><a id="DCE-27.0-D1955"></a><a id="DCE-27.0-D1956"></a><a id="DCE-27.0-D1957"></a><a id="DCE-27.0-D1958"></a><a id="DCE-27.0-D1959"></a><a id="DCE-27.0-D1960"></a><a id="DCE-27.0-D1961"></a><a id="DCE-27.0-D1962"></a><a id="DCE-27.0-D1963"></a><a id="DCE-27.0-D1964"></a><a id="DCE-27.0-D1965"></a><a id="DCE-27.0-D1966"></a><a id="DCE-27.0-D1967"></a><a id="DCE-27.0-D1968"></a><a id="DCE-27.0-D1969"></a><a id="DCE-27.0-D1970"></a><a id="DCE-27.0-D1971"></a><a id="DCE-27.0-D1972"></a><a id="DCE-27.0-D1973"></a><a id="DCE-27.0-D1974"></a><a id="DCE-27.0-D1975"></a><a id="DCE-27.0-D1976"></a><a id="DCE-27.0-D1977"></a><a id="DCE-27.0-D1978"></a><a id="DCE-27.0-D1979"></a><a id="DCE-27.0-D1980"></a><a id="DCE-27.0-D1981"></a><a id="DCE-27.0-D1982"></a><a id="DCE-27.0-D1983"></a><a id="DCE-27.0-D1984"></a><a id="DCE-27.0-D1985"></a><a id="DCE-27.0-D1986"></a><a id="DCE-27.0-D1987"></a><a id="DCE-27.0-D1988"></a><a id="DCE-27.0-D1989"></a><a id="DCE-27.0-D1990"></a><a id="DCE-27.0-D1991"></a><a id="DCE-27.0-D1992"></a><a id="DCE-27.0-D1993"></a><a id="DCE-27.0-D1994"></a><a id="DCE-27.0-D1995"></a><a id="DCE-27.0-D1996"></a><a id="DCE-27.0-D1997"></a><a id="DCE-27.0-D1998"></a><a id="DCE-27.0-D1999"></a><a id="DCE-27.0-D2000"></a><a id="DCE-27.0-D2001"></a><a id="DCE-27.0-D2002"></a><a id="DCE-27.0-D2003"></a><a id="DCE-27.0-D2004"></a><a id="DCE-27.0-D2005"></a><a id="DCE-27.0-D2006"></a><a id="DCE-27.0-D2007"></a><a id="DCE-27.0-D2008"></a><a id="DCE-27.0-D2009"></a><a id="DCE-27.0-D2010"></a><a id="DCE-27.0-D2011"></a><a id="DCE-27.0-D2012"></a><a id="DCE-27.0-D2013"></a><a id="DCE-27.0-D2014"></a><a id="DCE-27.0-D2015"></a><a id="DCE-27.0-D2016"></a><a id="DCE-27.0-D2017"></a><a id="DCE-27.0-D2018"></a><a id="DCE-27.0-D2019"></a><a id="DCE-27.0-D2020"></a><a id="DCE-27.0-D2021"></a><a id="DCE-27.0-D2022"></a><a id="DCE-27.0-D2023"></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)
