invantive documentation
Invantive SupportforenAnmelden / Eintragen

TicketConversations: Freshdesk

read only

  • Katalog: Freshdesk
  • Schema: Views

Es können nur Daten abgerufen werden.

Tabellenspalten

Die Spalten der Tabelle TicketConversations 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
body varchar2 Body Content of the conversation in HTML.
body_text varchar2 Haupttext Content of the conversation in plain text.
created_at datetime Erstellt bei Date/time at which the record was created.
from_email varchar2 Absenderadresse
id int64 ID ID of the conversation.
incoming char Incoming Whether a particular conversation should appear as being created from outside (i.e., not through web portal).
last_edited_at datetime itgen_freshdesk_last_edited_at
last_edited_at_user_id int64 itgen_freshdesk_last_edited_at_user_id
private char Private Whether the note is private.
source int64 Source Type of the conversation.Siehe ConversationSources.
support_email varchar2 Support E-Mail-Adresse Email address from which the reply is sent.For notes, this value will be null.
ticket_email varchar2 Email Email address of the requester.If no contact exists with this email address in Freshdesk, it will be added as a new contact.
ticket_id int64 Ticket-ID ID of the ticket to which this conversation is being added.
ticket_name varchar2 Name Name of the requester.
ticket_subject varchar2 Subject Ticket subject.
updated_at datetime Aktualisiert am Date/time at which the record was last updated.
user_id int64 Benutzer-Kennung ID of the agent/user who is adding the conversation.

Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: