---
title: "uByExternal_User_badgesByExternalId (Discourse)"
description: "User Badges by External ID"
language: es
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/es/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/es/
---

# uByExternal_User_badgesByExternalId: Discourse User Badges by External ID

`read only` `REST`

- Catálogo: `Discourse`
- Esquema: `Users`
- Label: User Badges by External ID

Get a single user by SSO external ID

Solo puede recuperar datos.

## Resumen

Get a single user by SSO external ID

## Fuente de la API

- Punto final: `/u/by-external/{external_id}.json`
- Operación: `get /u/by-external/{external_id}.json`

## Características de rendimiento

| Characteristic | Value |
|---|---:|
| Latencia media de acceso (ms) | 243 |
| Escribir filas por minuto | 219 |

El resultado se puede almacenar en la Caché del cliente.

## Parámetros

| Name | Tipo de Datos | Required | Default | Documentation |
|---|---|:---:|---|---|
| `external_id` | `` | [x] |  |  |

## Columnas de la Tabla

A continuación se muestran las columnas de la tabla `uByExternal_User_badgesByExternalId`. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.

| Name | Tipo de Datos | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `user_admin` | `char` | Administración de usuarios | [ ] | filters on the platform, writable, `::ancestor.user.admin` |  |
| `user_avatar_template` | `varchar2` | Plantilla de avatar de usuario | [ ] | filters on the platform, writable, `::ancestor.user.avatar_template` |  |
| `user_badge_count` | `decimal` | Recuento de insignias de usuario | [ ] | filters on the platform, writable, `::ancestor.user.badge_count` |  |
| `user_can_edit` | `char` | El usuario puede editar | [ ] | filters on the platform, writable, `::ancestor.user.can_edit` |  |
| `user_can_edit_email` | `char` | El usuario puede editar el correo electrónico | [ ] | filters on the platform, writable, `::ancestor.user.can_edit_email` |  |
| `user_can_edit_name` | `char` | El usuario puede editar el nombre | [ ] | filters on the platform, writable, `::ancestor.user.can_edit_name` |  |
| `user_can_edit_username` | `char` | El usuario puede editar su nombre de usuario | [ ] | filters on the platform, writable, `::ancestor.user.can_edit_username` |  |
| `user_can_send_private_message_to_user` | `char` | Un usuario puede enviar un mensaje privado a otro usuario | [ ] | filters on the platform, writable, `::ancestor.user.can_send_private_message_to_user` |  |
| `user_can_send_private_messages` | `char` | El usuario puede enviar mensajes privados | [ ] | 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` | Usuario creado el | [ ] | 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` | Identificación de Usuario | [ ] | filters on the platform, writable, `::ancestor.user.id` |  |
| `user_invited_by` | `varchar2` | Usuario invitado por | [ ] | writable | The JSON text of the nested object. |
| `user_last_posted_at` | `varchar2` | Última publicación del usuario el | [ ] | filters on the platform, writable, `::ancestor.user.last_posted_at` |  |
| `user_last_seen_at` | `varchar2` | Última vez que se vio al usuario a las | [ ] | filters on the platform, writable, `::ancestor.user.last_seen_at` |  |
| `user_moderator` | `char` | Usuario moderador | [ ] | filters on the platform, writable, `::ancestor.user.moderator` |  |
| `user_name` | `varchar2` | Nombre de Usuario | [ ] | writable | The JSON text of the nested object. |
| `user_pending_count` | `decimal` | Recuento de usuarios pendientes | [ ] | 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` | Nombre del grupo principal del usuario | [ ] | writable | The JSON text of the nested object. |
| `user_profile_view_count` | `decimal` | Número de vistas al perfil de usuario | [ ] | filters on the platform, writable, `::ancestor.user.profile_view_count` |  |
| `user_title` | `varchar2` | Título de usuario | [ ] | writable | The JSON text of the nested object. |
| `user_trust_level` | `decimal` | Nivel de confianza del usuario | [ ] | filters on the platform, writable, `::ancestor.user.trust_level` |  |
| `user_uploaded_avatar_id` | `varchar2` | ID del avatar subido por el usuario | [ ] | writable | The JSON text of the nested object. |
| `user_username` | `varchar2` | Nombre de Usuario | [ ] | 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. |


## Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador:

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

### Modificaciones de esta tabla, De 26.0 a 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 cambios más

</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>

[Todos los cambios del conductor, De 26.0 a 27.0](/es/release-notes/drivers?driver=discourse&step=26.0-to-27.0#discourse-26.0-to-27.0)
