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_ |
varchar2 |
Hoofdtekst | Content of the conversation in plain text. | ||
created_ |
datetime |
Aangemaakt op | Date/time at which the record was created. | ||
from_ |
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_ |
datetime |
itgen_freshdesk_last_edited_at | |||
last_ |
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_ |
varchar2 |
Ondersteuning E-mailadres | Email address from which the reply is sent.For notes, this value will be null. | ||
ticket_ |
varchar2 |
Email address of the requester.If no contact exists with this email address in Freshdesk, it will be added as a new contact. | |||
ticket_ |
int64 |
Ticket ID | ID of the ticket to which this conversation is being added. | ||
ticket_ |
varchar2 |
Name | Name of the requester. | ||
ticket_ |
varchar2 |
Subject | Ticket subject. | ||
updated_ |
datetime |
Bijgewerkt op | Date/time at which the record was last updated. | ||
user_ |
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: