invantive documentation
Forum di supporto InvantiveAccedi / Registrati

Posts: Discourse Posts

insert REST

  • Catalogo: Discourse
  • Schema: Posts
  • Label: Posts

Get a list of the latest posts across topics

È possibile recuperare e modificare i dati utilizzando insert.

Get a list of the latest posts across topics

Codice sorgente dell'API

  • Punto finale: /posts.json
  • Operazione: get /posts.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.

Colonne della tabella

Di seguito sono riportate le colonne della tabella Posts. 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
accepted_answer char Risposta accettata filters on the platform, writable, accepted_answer
action_code varchar2 Codice azione filters on the platform, writable, action_code
admin char Administrator filters on the platform, writable, admin
avatar_template varchar2 Modello per avatar filters on the platform, writable, avatar_template
avg_time varchar2 itgen_dce_avg_time writable The JSON text of the nested object.
bookmarked char Bookmarked filters on the platform, writable, bookmarked
can_accept_answer char È possibile accettare la risposta filters on the platform, writable, can_accept_answer
can_delete char Può eliminare filters on the platform, writable, can_delete
can_edit char È possibile modificare filters on the platform, writable, can_edit
can_recover varchar2 È possibile recuperare writable The JSON text of the nested object.
can_unaccept_answer char È possibile rifiutare una risposta? filters on the platform, writable, can_unaccept_answer
can_view_edit_history char Può visualizzare la cronologia delle modifiche filters on the platform, writable, can_view_edit_history
can_vote char Può votare filters on the platform, writable, can_vote
can_wiki char È possibile convertire in formato wiki filters on the platform, writable, can_wiki
category_id decimal ID categoria filters on the platform, writable, category_id
cooked varchar2 Cooked filters on the platform, writable, cooked
created_at varchar2 Creato il filters on the platform, writable, created_at
deleted_at varchar2 Eliminato alle writable The JSON text of the nested object.
display_username varchar2 Visualizza nome utente filters on the platform, writable, display_username
edit_reason varchar2 Motivo della modifica writable The JSON text of the nested object.
hidden char Hidden filters on the platform, writable, hidden
id decimal ID filters on the platform, writable, id
incoming_link_count decimal #Link in entrata filters on the platform, writable, incoming_link_count
moderator char Moderator filters on the platform, writable, moderator
name varchar2 Name filters on the platform, writable, name
notice_type varchar2 Tipo di avviso filters on the platform, writable, notice.type
post_number decimal Numero del post filters on the platform, writable, post_number
post_type decimal Tipo di post filters on the platform, writable, post_type
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.
quote_count decimal #Quotes filters on the platform, writable, quote_count
raw varchar2 Raw filters on the platform, writable, raw
readers_count int32 Il numero dei lettori filters on the platform, writable, readers_count
reads decimal #Reads filters on the platform, writable, reads
reply_count decimal #Replies filters on the platform, writable, reply_count
reply_to_post_number varchar2 Rispondi al post numero writable The JSON text of the nested object.
reply_to_user_avatar_template varchar2 Risposta al modello di avatar dell'utente filters on the platform, writable, reply_to_user.avatar_template
reply_to_user_username varchar2 Rispondi all'utente [Nome utente] filters on the platform, writable, reply_to_user.username
reviewable_score_count int32 Numero di punteggi valutabili filters on the platform, writable, reviewable_score_count
reviewable_score_pending_count int32 Punteggio soggetta a revisione - Numero in attesa di conferma filters on the platform, writable, reviewable_score_pending_count
score decimal Score filters on the platform, writable, score
staff char Staff filters on the platform, writable, staff
static_doc char Documento statico filters on the platform, writable, static_doc
title_is_group char Titolo: Gruppo filters on the platform, writable, title_is_group
topic_html_title varchar2 Titolo HTML dell'argomento filters on the platform, writable, topic_html_title
topic_id decimal ID argomento filters on the platform, writable, topic_id
topic_slug varchar2 Slug dell'argomento filters on the platform, writable, topic_slug
topic_title varchar2 Titolo dell'argomento filters on the platform, writable, topic_title
trust_level decimal Livello di fiducia filters on the platform, writable, trust_level
updated_at varchar2 Aggiornato il filters on the platform, writable, updated_at
user_deleted char Utente eliminato filters on the platform, writable, user_deleted
user_id decimal ID Utente filters on the platform, writable, user_id
user_title varchar2 Titolo utente writable The JSON text of the nested object.
username varchar2 Nome Utente filters on the platform, writable, username
version decimal Version filters on the platform, writable, version
via_email char Via e-mail filters on the platform, writable, via_email
wiki char Wiki filters on the platform, writable, wiki
yours char Yours filters on the platform, writable, yours

Chiavi

Key Column Si riferisce a Kind Description
Posts_category_id_cnd category_id Categories.id Candidate Not stated by Discourse; found on the data of the smoke forum on 2026-10-31, where every filled value is in the referenced table.

Riferito da

Note di rilascio

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

Modifiche apportate a questa tabella, da 26.0 a 27.0

  • - avg_time
  • ~ can_recover (database_data_type: varchar2 → char)
  • ~ can_recover (dotnet_data_type: string → boolean)
  • ~ category_id (database_data_type: decimal → int64)
  • ~ category_id (dotnet_data_type: decimal → int64)
  • ~ id (database_data_type: decimal → int64)
  • ~ id (dotnet_data_type: decimal → int64)
  • ~ incoming_link_count (database_data_type: decimal → int64)
  • ~ incoming_link_count (dotnet_data_type: decimal → int64)
  • ~ post_number (database_data_type: decimal → int64)
  • ~ post_number (dotnet_data_type: decimal → int64)
  • ~ post_type (database_data_type: decimal → int64)
  • ~ post_type (dotnet_data_type: decimal → int64)
  • - primary_group_flair_bg_color
  • - primary_group_flair_color

42 ulteriori modifiche

Discourse.Posts.Posts: modifiche al tipo

Il tipo di Discourse.Posts.Posts cambia da tabella a tabella.

Cosa fare

Verificare le istruzioni, le Views e gli script che la utilizzano prima dell’aggiornamento.

  • può interrompere un'istruzione
  • table → tablefunction
  • importanza 3
Il parametro "before" viene aggiunto a Discourse.Posts.Posts

Facoltativo.

  • importanza 2

  • - primary_group_flair_url
  • ~ quote_count (database_data_type: decimal → int64)
  • ~ quote_count (dotnet_data_type: decimal → int64)
  • ~ readers_count (database_data_type: int32 → int64)
  • ~ readers_count (dotnet_data_type: int32 → int64)
  • ~ reads (database_data_type: decimal → int64)
  • ~ reads (dotnet_data_type: decimal → int64)
  • ~ reply_count (database_data_type: decimal → int64)
  • ~ reply_count (dotnet_data_type: decimal → int64)
  • ~ reviewable_score_count (database_data_type: int32 → int64)
  • ~ reviewable_score_count (dotnet_data_type: int32 → int64)
  • ~ reviewable_score_pending_count (database_data_type: int32 → int64)
  • ~ reviewable_score_pending_count (dotnet_data_type: int32 → int64)
  • - static_doc
  • ~ topic_id (database_data_type: decimal → int64)
  • ~ topic_id (dotnet_data_type: decimal → int64)
  • ~ trust_level (database_data_type: decimal → int64)
  • ~ trust_level (dotnet_data_type: decimal → int64)
  • ~ user_id (database_data_type: decimal → int64)
  • ~ user_id (dotnet_data_type: decimal → int64)
  • ~ version (database_data_type: decimal → int64)
  • ~ version (dotnet_data_type: decimal → int64)
  • + archetype (varchar2)
  • + auto_track (char)
  • + can_see_hidden_post (char)
  • + category (int32)
  • + embed_url (varchar2)
  • + excerpt (varchar2)
  • + external_id (varchar2)
  • + flair_bg_color (varchar2)
  • + flair_color (varchar2)
  • + flair_group_id (varchar2)
  • + flair_name (varchar2)
  • + flair_url (varchar2)
  • + post_url (varchar2)
  • + posts_count (int64)
  • + reviewable_id (varchar2)
  • + target_recipients (varchar2)
  • + title (varchar2)
  • + truncated (char)

Tutte le sostituzioni del conducente, da 26.0 a 27.0