TicketConversations: Freshdesk
read only
- Catalog:
Freshdesk - Schema:
Views
Can only retrieve data.
Table Columns
The columns of the table TicketConversations are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
body |
varchar2 |
Body | Content of the conversation in HTML. | ||
body_ |
varchar2 |
Body Text | Content of the conversation in plain text. | ||
created_ |
datetime |
Created at | Date/time at which the record was created. | ||
from_ |
varchar2 |
From Email Address | |||
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. See ConversationSources. | ||
support_ |
varchar2 |
Support Email Address | 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 |
Updated at | Date/time at which the record was last updated. | ||
user_ |
int64 |
User ID | ID of the agent/user who is adding the conversation. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: