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

# uByExternal_UserGroupsByExternalId: Discourse User Groups by External ID

`read only` `REST`

- Catalogue : `Discourse`
- Schéma : `Users`
- Label: User Groups by External ID

Get a single user by SSO external ID

Permet uniquement de récupérer des données.

## Résumé

Get a single user by SSO external ID

## Source de l'API

- Point de terminaison : `/u/by-external/{external_id}.json`
- Opération : `get /u/by-external/{external_id}.json`

## Caractéristiques de performance

| Characteristic | Value |
|---|---:|
| Latence moyenne d'accès (ms) | 243 |
| Nombre d'enregistrements écrits par minute | 219 |

Le résultat peut être mis en cache côté client.

## Paramètres

| Name | Type de données | Required | Default | Documentation |
|---|---|:---:|---|---|
| `external_id` | `` | [x] |  |  |

## Colonnes de table

Les colonnes de la table `uByExternal_UserGroupsByExternalId` sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.

| Name | Type de données | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `admin` | `char` | Administrator | [ ] | writable, `::ancestor.admin` |  |
| `alias_level` | `decimal` | Niveau d'Alias | [ ] | writable, `alias_level` |  |
| `automatic` | `char` | Automatic | [ ] | writable, `automatic` |  |
| `automatic_membership_email_domains` | `varchar2` | Domaines utilisés pour les e-mails d'adhésion automatiques | [ ] | writable | The JSON text of the nested object. |
| `automatic_membership_retroactive` | `char` | Adhésion automatique avec effet rétroactif | [ ] | writable, `automatic_membership_retroactive` |  |
| `avatar_template` | `varchar2` | Modèle d'avatar | [ ] | writable, `::ancestor.avatar_template` |  |
| `badge_count` | `decimal` | #Badges | [ ] | writable, `::ancestor.badge_count` |  |
| `can_edit` | `char` | peut modifier | [ ] | writable, `::ancestor.can_edit` |  |
| `can_edit_email` | `char` | Possibilité de modifier l'adresse e-mail | [ ] | writable, `::ancestor.can_edit_email` |  |
| `can_edit_name` | `char` | Possibilité de modifier le nom | [ ] | writable, `::ancestor.can_edit_name` |  |
| `can_edit_username` | `char` | Possibilité de modifier le nom d'utilisateur | [ ] | writable, `::ancestor.can_edit_username` |  |
| `can_send_private_message_to_user` | `char` | Possibilité d'envoyer un message privé à un utilisateur | [ ] | writable, `::ancestor.can_send_private_message_to_user` |  |
| `can_send_private_messages` | `char` | Peut envoyer des messages privés | [ ] | writable, `::ancestor.can_send_private_messages` |  |
| `card_badge` | `varchar2` | itgen_dce_card_badge | [ ] | writable | The JSON text of the nested object. |
| `created_at` | `varchar2` | Créé le | [ ] | writable, `::ancestor.created_at` |  |
| `custom_fields` | `varchar2` | Champs personnalisés | [ ] | writable | The JSON text of the nested object. |
| `flair_bg_color` | `varchar2` | Couleur d'arrière-plan de Flair | [ ] | writable | The JSON text of the nested object. |
| `flair_color` | `varchar2` | Couleur Flair | [ ] | writable | The JSON text of the nested object. |
| `flair_url` | `varchar2` | URL Flair | [ ] | writable | The JSON text of the nested object. |
| `grant_trust_level` | `varchar2` | Niveau de la subvention fiduciaire | [ ] | writable | The JSON text of the nested object. |
| `has_messages` | `char` | Contient des messages | [ ] | writable, `has_messages` |  |
| `id` | `decimal` | ID | [ ] | writable, `id` |  |
| `id_2` | `decimal` | ID 2 | [ ] | writable, `::ancestor.id` |  |
| `invited_by` | `varchar2` | À l'invitation de | [ ] | writable | The JSON text of the nested object. |
| `is_member` | `char` | Est membre | [ ] | writable, `is_member` |  |
| `last_posted_at` | `varchar2` | Dernière mise à jour le | [ ] | writable, `::ancestor.last_posted_at` |  |
| `last_seen_at` | `varchar2` | Dernière vue à | [ ] | writable, `::ancestor.last_seen_at` |  |
| `mentionable` | `char` | Mentionable | [ ] | writable, `mentionable` |  |
| `moderator` | `char` | Moderator | [ ] | writable, `::ancestor.moderator` |  |
| `name` | `varchar2` | Name | [ ] | writable, `name` |  |
| `name_2` | `varchar2` | Nom 2 | [ ] | writable | The JSON text of the nested object. |
| `notification_level` | `varchar2` | Niveau de notification | [ ] | writable | The JSON text of the nested object. |
| `pending_count` | `decimal` | Nombre en attente | [ ] | writable, `::ancestor.pending_count` |  |
| `primary_group` | `char` | Groupe primaire | [ ] | writable, `primary_group` |  |
| `primary_group_flair_bg_color` | `varchar2` | itgen_dce_primary_group_flair_bg_color | [ ] | writable | The JSON text of the nested object. |
| `primary_group_flair_color` | `varchar2` | itgen_dce_primary_group_flair_color | [ ] | writable | The JSON text of the nested object. |
| `primary_group_flair_url` | `varchar2` | itgen_dce_primary_group_flair_url | [ ] | writable | The JSON text of the nested object. |
| `primary_group_name` | `varchar2` | Nom du groupe principal | [ ] | writable | The JSON text of the nested object. |
| `profile_view_count` | `decimal` | Nombre de vues du profil | [ ] | writable, `::ancestor.profile_view_count` |  |
| `title` | `varchar2` | Title | [ ] | writable | The JSON text of the nested object. |
| `title_2` | `varchar2` | Titre 2 | [ ] | writable | The JSON text of the nested object. |
| `trust_level` | `decimal` | Niveau de confiance | [ ] | writable, `::ancestor.trust_level` |  |
| `uploaded_avatar_id` | `varchar2` | Identifiant de l'avatar téléchargé | [ ] | writable | The JSON text of the nested object. |
| `user_count` | `decimal` | #Users | [ ] | writable, `user_count` |  |
| `username` | `varchar2` | Nom d'Utilisateur | [ ] | writable, `::ancestor.username` |  |
| `visible` | `char` | Visible | [ ] | writable, `visible` |  |
| `website_name` | `varchar2` | itgen_dce_website_name | [ ] | writable | The JSON text of the nested object. |


## Notes de Version

Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :

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

### Modifications apportées à cette table, 26.0 à 27.0

<a id="DCE-27.0-D1004"></a><a id="DCE-27.0-D1005"></a><a id="DCE-27.0-D1006"></a><a id="DCE-27.0-D1007"></a><a id="DCE-27.0-D1008"></a><a id="DCE-27.0-D1009"></a><a id="DCE-27.0-D1010"></a><a id="DCE-27.0-D1011"></a><a id="DCE-27.0-D1012"></a><a id="DCE-27.0-D1013"></a><a id="DCE-27.0-D1014"></a><a id="DCE-27.0-D1015"></a><a id="DCE-27.0-D1016"></a><a id="DCE-27.0-D1017"></a><a id="DCE-27.0-D1018"></a>

- `-` `alias_level`
- `-` `automatic_membership_email_domains`
- `-` `automatic_membership_retroactive`
- `~` `badge_count` (`database_data_type`: `decimal` &rarr; `int64`)
- `~` `badge_count` (`dotnet_data_type`: `decimal` &rarr; `int64`)
- `-` `card_badge`
- `-` `custom_fields`
- `~` `id` (`database_data_type`: `decimal` &rarr; `int64`)
- `~` `id` (`dotnet_data_type`: `decimal` &rarr; `int64`)
- `~` `id_2` (`database_data_type`: `decimal` &rarr; `int64`)
- `~` `id_2` (`dotnet_data_type`: `decimal` &rarr; `int64`)
- `-` `is_member`
- `-` `mentionable`
- `-` `notification_level`
- `~` `pending_count` (`database_data_type`: `decimal` &rarr; `int64`)

<details>
<summary>

143 modifications supplémentaires

</summary>

<a id="DCE-27.0-D1019"></a><a id="DCE-27.0-D1020"></a><a id="DCE-27.0-D1021"></a><a id="DCE-27.0-D1022"></a><a id="DCE-27.0-D1023"></a><a id="DCE-27.0-D1024"></a><a id="DCE-27.0-D1025"></a><a id="DCE-27.0-D1026"></a><a id="DCE-27.0-D1027"></a><a id="DCE-27.0-D1028"></a><a id="DCE-27.0-D1029"></a><a id="DCE-27.0-D1030"></a><a id="DCE-27.0-D1031"></a><a id="DCE-27.0-D1032"></a><a id="DCE-27.0-D2135"></a><a id="DCE-27.0-D2136"></a><a id="DCE-27.0-D2137"></a><a id="DCE-27.0-D2138"></a><a id="DCE-27.0-D2139"></a><a id="DCE-27.0-D2140"></a><a id="DCE-27.0-D2141"></a><a id="DCE-27.0-D2142"></a><a id="DCE-27.0-D2143"></a><a id="DCE-27.0-D2144"></a><a id="DCE-27.0-D2145"></a><a id="DCE-27.0-D2146"></a><a id="DCE-27.0-D2147"></a><a id="DCE-27.0-D2148"></a><a id="DCE-27.0-D2149"></a><a id="DCE-27.0-D2150"></a><a id="DCE-27.0-D2151"></a><a id="DCE-27.0-D2152"></a><a id="DCE-27.0-D2153"></a><a id="DCE-27.0-D2154"></a><a id="DCE-27.0-D2155"></a><a id="DCE-27.0-D2156"></a><a id="DCE-27.0-D2157"></a><a id="DCE-27.0-D2158"></a><a id="DCE-27.0-D2159"></a><a id="DCE-27.0-D2160"></a><a id="DCE-27.0-D2161"></a><a id="DCE-27.0-D2162"></a><a id="DCE-27.0-D2163"></a><a id="DCE-27.0-D2164"></a><a id="DCE-27.0-D2165"></a><a id="DCE-27.0-D2166"></a><a id="DCE-27.0-D2167"></a><a id="DCE-27.0-D2168"></a><a id="DCE-27.0-D2169"></a><a id="DCE-27.0-D2170"></a><a id="DCE-27.0-D2171"></a><a id="DCE-27.0-D2172"></a><a id="DCE-27.0-D2173"></a><a id="DCE-27.0-D2174"></a><a id="DCE-27.0-D2175"></a><a id="DCE-27.0-D2176"></a><a id="DCE-27.0-D2177"></a><a id="DCE-27.0-D2178"></a><a id="DCE-27.0-D2179"></a><a id="DCE-27.0-D2180"></a><a id="DCE-27.0-D2181"></a><a id="DCE-27.0-D2182"></a><a id="DCE-27.0-D2183"></a><a id="DCE-27.0-D2184"></a><a id="DCE-27.0-D2185"></a><a id="DCE-27.0-D2186"></a><a id="DCE-27.0-D2187"></a><a id="DCE-27.0-D2188"></a><a id="DCE-27.0-D2189"></a><a id="DCE-27.0-D2190"></a><a id="DCE-27.0-D2191"></a><a id="DCE-27.0-D2192"></a><a id="DCE-27.0-D2193"></a><a id="DCE-27.0-D2194"></a><a id="DCE-27.0-D2195"></a><a id="DCE-27.0-D2196"></a><a id="DCE-27.0-D2197"></a><a id="DCE-27.0-D2198"></a><a id="DCE-27.0-D2199"></a><a id="DCE-27.0-D2200"></a><a id="DCE-27.0-D2201"></a><a id="DCE-27.0-D2202"></a><a id="DCE-27.0-D2203"></a><a id="DCE-27.0-D2204"></a><a id="DCE-27.0-D2205"></a><a id="DCE-27.0-D2206"></a><a id="DCE-27.0-D2207"></a><a id="DCE-27.0-D2208"></a><a id="DCE-27.0-D2209"></a><a id="DCE-27.0-D2210"></a><a id="DCE-27.0-D2211"></a><a id="DCE-27.0-D2212"></a><a id="DCE-27.0-D2213"></a><a id="DCE-27.0-D2214"></a><a id="DCE-27.0-D2215"></a><a id="DCE-27.0-D2216"></a><a id="DCE-27.0-D2217"></a><a id="DCE-27.0-D2218"></a><a id="DCE-27.0-D2219"></a><a id="DCE-27.0-D2220"></a><a id="DCE-27.0-D2221"></a><a id="DCE-27.0-D2222"></a><a id="DCE-27.0-D2223"></a><a id="DCE-27.0-D2224"></a><a id="DCE-27.0-D2225"></a><a id="DCE-27.0-D2226"></a><a id="DCE-27.0-D2227"></a><a id="DCE-27.0-D2228"></a><a id="DCE-27.0-D2229"></a><a id="DCE-27.0-D2230"></a><a id="DCE-27.0-D2231"></a><a id="DCE-27.0-D2232"></a><a id="DCE-27.0-D2233"></a><a id="DCE-27.0-D2234"></a><a id="DCE-27.0-D2235"></a><a id="DCE-27.0-D2236"></a><a id="DCE-27.0-D2237"></a><a id="DCE-27.0-D2238"></a><a id="DCE-27.0-D2239"></a><a id="DCE-27.0-D2240"></a><a id="DCE-27.0-D2241"></a><a id="DCE-27.0-D2242"></a><a id="DCE-27.0-D2243"></a><a id="DCE-27.0-D2244"></a><a id="DCE-27.0-D2245"></a><a id="DCE-27.0-D2246"></a><a id="DCE-27.0-D2247"></a><a id="DCE-27.0-D2248"></a><a id="DCE-27.0-D2249"></a><a id="DCE-27.0-D2250"></a><a id="DCE-27.0-D2251"></a><a id="DCE-27.0-D2252"></a><a id="DCE-27.0-D2253"></a><a id="DCE-27.0-D2254"></a><a id="DCE-27.0-D2255"></a><a id="DCE-27.0-D2256"></a><a id="DCE-27.0-D2257"></a><a id="DCE-27.0-D2258"></a><a id="DCE-27.0-D2259"></a><a id="DCE-27.0-D2260"></a><a id="DCE-27.0-D2261"></a><a id="DCE-27.0-D2262"></a><a id="DCE-27.0-D2263"></a>

- `~` `pending_count` (`dotnet_data_type`: `decimal` &rarr; `int64`)
- `-` `primary_group_flair_bg_color`
- `-` `primary_group_flair_color`
- `-` `primary_group_flair_url`
- `~` `profile_view_count` (`database_data_type`: `decimal` &rarr; `int64`)
- `~` `profile_view_count` (`dotnet_data_type`: `decimal` &rarr; `int64`)
- `~` `trust_level` (`database_data_type`: `decimal` &rarr; `int64`)
- `~` `trust_level` (`dotnet_data_type`: `decimal` &rarr; `int64`)
- `~` `uploaded_avatar_id` (`database_data_type`: `varchar2` &rarr; `int64`)
- `~` `uploaded_avatar_id` (`dotnet_data_type`: `string` &rarr; `int64`)
- `~` `user_count` (`database_data_type`: `decimal` &rarr; `int64`)
- `~` `user_count` (`dotnet_data_type`: `decimal` &rarr; `int64`)
- `-` `visible`
- `-` `website_name`
- `+` `allow_membership_requests` (`char`)
- `+` `bio_cooked` (`varchar2`)
- `+` `bio_excerpt` (`varchar2`)
- `+` `bio_raw` (`varchar2`)
- `+` `can_admin_group` (`char`)
- `+` `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_see_members` (`char`)
- `+` `can_upload_avatar` (`char`)
- `+` `can_upload_profile_header` (`char`)
- `+` `can_upload_user_card_background` (`char`)
- `+` `custom_fields_first_name` (`varchar2`)
- `+` `default_notification_level` (`int64`)
- `+` `display_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_2` (`varchar2`)
- `+` `flair_color_2` (`varchar2`)
- `+` `flair_group_id` (`int64`)
- `+` `flair_name` (`varchar2`)
- `+` `flair_url_2` (`varchar2`)
- `+` `full_name` (`varchar2`)
- `+` `has_title_badges` (`char`)
- `+` `ignored` (`char`)
- `+` `incoming_email` (`varchar2`)
- `+` `locale` (`varchar2`)
- `+` `mailing_list_posts_per_day` (`int64`)
- `+` `members_visibility_level` (`int64`)
- `+` `membership_request_template` (`varchar2`)
- `+` `mentionable_level` (`int64`)
- `+` `messageable_level` (`int64`)
- `+` `muted` (`char`)
- `+` `pending_posts_count` (`int64`)
- `+` `post_count` (`int64`)
- `+` `primary_group_id` (`int64`)
- `+` `public_admission` (`char`)
- `+` `public_exit` (`char`)
- `+` `publish_read_state` (`char`)
- `+` `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`)
- `+` `visibility_level` (`int64`)

</details>

[Toutes les modifications apportées au chauffeur, 26.0 à 27.0](/fr/release-notes/drivers?driver=discourse&step=26.0-to-27.0#discourse-26.0-to-27.0)
