invantive documentation
Invantive Support ForumsLog In / Sign Up

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_text varchar2 Body Text Content of the conversation in plain text.
created_at datetime Created at Date/time at which the record was created.
from_email 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_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. See ConversationSources.
support_email varchar2 Support Email Address 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 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.

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: