TicketConversations |
Catalogus: Freshdesk
Schema: Views
Dit is een alleen-lezen view. De Freshdesk API biedt mogelijk geen ondersteuning voor het wijzigen van de data of het Invantive SQL-stuurprogramma voor Freshdesk ondersteunt dit niet. In het laatste geval gebruikt u de tabel NativePlatformScalarRequests om gegevens te uploaden naar de Freshdesk-API.
View Kolommen
De kolommen van de view TicketConversations worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
---|---|---|---|---|
body_text |
string |
Body Text |
☐ |
Content of the conversation in plain text. |
body |
string |
Body |
☐ |
Content of the conversation in HTML. |
created_at |
datetime |
Created at |
☐ |
Date/time at which the record was created. |
from_email |
string |
From Email Address |
☐ |
|
id |
int64 |
ID |
☐ |
ID of the conversation. |
incoming |
boolean |
Incoming |
☐ |
Whether a particular conversation should appear as being created from outside (i.e., not through web portal). |
private |
boolean |
Private |
☐ |
Whether the note is private. |
source |
int64 |
Source |
☐ |
Type of the conversation. See ConversationSources. |
support_email |
string |
Support Email Address |
☐ |
Email address from which the reply is sent. For notes, this value will be null. |
ticket_email |
string |
☐ |
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 |
string |
Name |
☐ |
Name of the requester. |
ticket_subject |
string |
Subject |
☐ |
Ticket subject. |
updated_at |
datetime |
Updated at |
☐ |
Date/time at which the record was last updated. |
user_id |
int64 |
User ID |
☐ |
ID of the agent/user who is adding the conversation. |
10-12-2022 17:06 Versie 22.0.461-PROD+3719