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

# uByExternal_UserFeatured_user_badge_idsByExternalId: Discourse User Featured User Badge IDs by External ID

`read only` `REST`

- Catalogo: `Discourse`
- Schema: `Users`
- Label: User Featured User Badge IDs by External ID

Get a single user by SSO external ID

È possibile solo recuperare i dati.

## Riepilogo

Get a single user by SSO external ID

## Codice sorgente dell'API

- Punto finale: `/u/by-external/{external_id}.json`
- Operazione: `get /u/by-external/{external_id}.json`

## Caratteristiche prestazionali

| Characteristic | Value |
|---|---:|
| Latenza media di accesso (ms) | 243 |
| Scrittura di righe al minuto | 219 |

Il risultato può essere memorizzato nella memoria cache sul client.

## Parametri

| Name | Tipo di dati | Required | Default | Documentation |
|---|---|:---:|---|---|
| `external_id` | `` | [x] |  |  |

## Colonne della tabella

Di seguito sono riportate le colonne della tabella `uByExternal_UserFeatured_user_badge_idsByExternalId`. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.

| Name | Tipo di dati | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `admin` | `char` | Administrator | [ ] | writable, `::ancestor.admin` |  |
| `avatar_template` | `varchar2` | Modello per avatar | [ ] | writable, `::ancestor.avatar_template` |  |
| `badge_count` | `decimal` | #Badges | [ ] | writable, `::ancestor.badge_count` |  |
| `can_edit` | `char` | È possibile modificare | [ ] | writable, `::ancestor.can_edit` |  |
| `can_edit_email` | `char` | È possibile modificare l'indirizzo e-mail | [ ] | writable, `::ancestor.can_edit_email` |  |
| `can_edit_name` | `char` | È possibile modificare il nome | [ ] | writable, `::ancestor.can_edit_name` |  |
| `can_edit_username` | `char` | È possibile modificare il nome utente | [ ] | writable, `::ancestor.can_edit_username` |  |
| `can_send_private_message_to_user` | `char` | È possibile inviare un messaggio privato a un utente | [ ] | writable, `::ancestor.can_send_private_message_to_user` |  |
| `can_send_private_messages` | `char` | È possibile inviare messaggi privati | [ ] | writable, `::ancestor.can_send_private_messages` |  |
| `card_badge` | `varchar2` | itgen_dce_card_badge | [ ] | writable | The JSON text of the nested object. |
| `created_at` | `varchar2` | Creato il | [ ] | writable, `::ancestor.created_at` |  |
| `custom_fields` | `varchar2` | Campi personalizzati | [ ] | writable | The JSON text of the nested object. |
| `id` | `decimal` | ID | [ ] | writable, `::ancestor.id` |  |
| `invited_by` | `varchar2` | Su invito di | [ ] | writable | The JSON text of the nested object. |
| `last_posted_at` | `varchar2` | Ultimo aggiornamento alle | [ ] | writable, `::ancestor.last_posted_at` |  |
| `last_seen_at` | `varchar2` | Visto l'ultima volta su | [ ] | writable, `::ancestor.last_seen_at` |  |
| `moderator` | `char` | Moderator | [ ] | writable, `::ancestor.moderator` |  |
| `name` | `varchar2` | Name | [ ] | writable | The JSON text of the nested object. |
| `pending_count` | `decimal` | Conteggio in sospeso | [ ] | writable, `::ancestor.pending_count` |  |
| `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` | Nome del gruppo primario | [ ] | writable | The JSON text of the nested object. |
| `profile_view_count` | `decimal` | Numero di views del profilo | [ ] | writable, `::ancestor.profile_view_count` |  |
| `title` | `varchar2` | Title | [ ] | writable | The JSON text of the nested object. |
| `trust_level` | `decimal` | Livello di fiducia | [ ] | writable, `::ancestor.trust_level` |  |
| `uploaded_avatar_id` | `varchar2` | ID dell'avatar caricato | [ ] | writable | The JSON text of the nested object. |
| `username` | `varchar2` | Nome Utente | [ ] | writable, `::ancestor.username` |  |
| `website_name` | `varchar2` | itgen_dce_website_name | [ ] | writable | The JSON text of the nested object. |


## Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver:

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

### Modifiche apportate a questa tabella, da 26.0 a 27.0

<a id="DCE-27.0-D986"></a><a id="DCE-27.0-D987"></a><a id="DCE-27.0-D988"></a><a id="DCE-27.0-D989"></a><a id="DCE-27.0-D990"></a><a id="DCE-27.0-D991"></a><a id="DCE-27.0-D992"></a><a id="DCE-27.0-D993"></a><a id="DCE-27.0-D994"></a><a id="DCE-27.0-D995"></a><a id="DCE-27.0-D996"></a><a id="DCE-27.0-D997"></a><a id="DCE-27.0-D998"></a><a id="DCE-27.0-D999"></a><a id="DCE-27.0-D1000"></a>

- `~` `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`)
- `~` `pending_count` (`database_data_type`: `decimal` &rarr; `int64`)
- `~` `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`)

<details>
<summary>

114 ulteriori modifiche

</summary>

<a id="DCE-27.0-D1001"></a><a id="DCE-27.0-D1002"></a><a id="DCE-27.0-D1003"></a><a id="DCE-27.0-D2024"></a><a id="DCE-27.0-D2025"></a><a id="DCE-27.0-D2026"></a><a id="DCE-27.0-D2027"></a><a id="DCE-27.0-D2028"></a><a id="DCE-27.0-D2029"></a><a id="DCE-27.0-D2030"></a><a id="DCE-27.0-D2031"></a><a id="DCE-27.0-D2032"></a><a id="DCE-27.0-D2033"></a><a id="DCE-27.0-D2034"></a><a id="DCE-27.0-D2035"></a><a id="DCE-27.0-D2036"></a><a id="DCE-27.0-D2037"></a><a id="DCE-27.0-D2038"></a><a id="DCE-27.0-D2039"></a><a id="DCE-27.0-D2040"></a><a id="DCE-27.0-D2041"></a><a id="DCE-27.0-D2042"></a><a id="DCE-27.0-D2043"></a><a id="DCE-27.0-D2044"></a><a id="DCE-27.0-D2045"></a><a id="DCE-27.0-D2046"></a><a id="DCE-27.0-D2047"></a><a id="DCE-27.0-D2048"></a><a id="DCE-27.0-D2049"></a><a id="DCE-27.0-D2050"></a><a id="DCE-27.0-D2051"></a><a id="DCE-27.0-D2052"></a><a id="DCE-27.0-D2053"></a><a id="DCE-27.0-D2054"></a><a id="DCE-27.0-D2055"></a><a id="DCE-27.0-D2056"></a><a id="DCE-27.0-D2057"></a><a id="DCE-27.0-D2058"></a><a id="DCE-27.0-D2059"></a><a id="DCE-27.0-D2060"></a><a id="DCE-27.0-D2061"></a><a id="DCE-27.0-D2062"></a><a id="DCE-27.0-D2063"></a><a id="DCE-27.0-D2064"></a><a id="DCE-27.0-D2065"></a><a id="DCE-27.0-D2066"></a><a id="DCE-27.0-D2067"></a><a id="DCE-27.0-D2068"></a><a id="DCE-27.0-D2069"></a><a id="DCE-27.0-D2070"></a><a id="DCE-27.0-D2071"></a><a id="DCE-27.0-D2072"></a><a id="DCE-27.0-D2073"></a><a id="DCE-27.0-D2074"></a><a id="DCE-27.0-D2075"></a><a id="DCE-27.0-D2076"></a><a id="DCE-27.0-D2077"></a><a id="DCE-27.0-D2078"></a><a id="DCE-27.0-D2079"></a><a id="DCE-27.0-D2080"></a><a id="DCE-27.0-D2081"></a><a id="DCE-27.0-D2082"></a><a id="DCE-27.0-D2083"></a><a id="DCE-27.0-D2084"></a><a id="DCE-27.0-D2085"></a><a id="DCE-27.0-D2086"></a><a id="DCE-27.0-D2087"></a><a id="DCE-27.0-D2088"></a><a id="DCE-27.0-D2089"></a><a id="DCE-27.0-D2090"></a><a id="DCE-27.0-D2091"></a><a id="DCE-27.0-D2092"></a><a id="DCE-27.0-D2093"></a><a id="DCE-27.0-D2094"></a><a id="DCE-27.0-D2095"></a><a id="DCE-27.0-D2096"></a><a id="DCE-27.0-D2097"></a><a id="DCE-27.0-D2098"></a><a id="DCE-27.0-D2099"></a><a id="DCE-27.0-D2100"></a><a id="DCE-27.0-D2101"></a><a id="DCE-27.0-D2102"></a><a id="DCE-27.0-D2103"></a><a id="DCE-27.0-D2104"></a><a id="DCE-27.0-D2105"></a><a id="DCE-27.0-D2106"></a><a id="DCE-27.0-D2107"></a><a id="DCE-27.0-D2108"></a><a id="DCE-27.0-D2109"></a><a id="DCE-27.0-D2110"></a><a id="DCE-27.0-D2111"></a><a id="DCE-27.0-D2112"></a><a id="DCE-27.0-D2113"></a><a id="DCE-27.0-D2114"></a><a id="DCE-27.0-D2115"></a><a id="DCE-27.0-D2116"></a><a id="DCE-27.0-D2117"></a><a id="DCE-27.0-D2118"></a><a id="DCE-27.0-D2119"></a><a id="DCE-27.0-D2120"></a><a id="DCE-27.0-D2121"></a><a id="DCE-27.0-D2122"></a><a id="DCE-27.0-D2123"></a><a id="DCE-27.0-D2124"></a><a id="DCE-27.0-D2125"></a><a id="DCE-27.0-D2126"></a><a id="DCE-27.0-D2127"></a><a id="DCE-27.0-D2128"></a><a id="DCE-27.0-D2129"></a><a id="DCE-27.0-D2130"></a><a id="DCE-27.0-D2131"></a><a id="DCE-27.0-D2132"></a><a id="DCE-27.0-D2133"></a><a id="DCE-27.0-D2134"></a>

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

</details>

[Tutte le sostituzioni del conducente, da 26.0 a 27.0](/it/release-notes/drivers?driver=discourse&step=26.0-to-27.0#discourse-26.0-to-27.0)
