invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

TicketConversations: Freshdesk

read only

  • Catalogus: Freshdesk
  • Schema: Views

Kan alleen gegevens ophalen.

Tabelkolommen

De kolommen van de tabel TicketConversations worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

Name Datatype Label Required Marks Documentation
body varchar2 Body Content of the conversation in HTML.
body_text varchar2 Hoofdtekst Content of the conversation in plain text.
created_at datetime Aangemaakt op Date/time at which the record was created.
from_email varchar2 Van E-mailadres
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.Zie ConversationSources.
support_email varchar2 Ondersteuning E-mailadres 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 Bijgewerkt op Date/time at which the record was last updated.
user_id int64 Gebruikers-ID ID of the agent/user who is adding the conversation.

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: