JDBC Driver for Freshdesk

Build 22.0.8462

Conversations

Delete, and query from conversations table

Table Specific Information

Select

To query the Conversations table, TicketId should be mentioned in the WHERE clause. For example:

SELECT * FROM Conversations WHERE TicketId = 100

Note: The Conversations table can only be filtered on TicketId.

Delete

Following is an example of how to delete from the Conversations table:

DELETE FROM Conversations WHERE Id = 786

Columns

Name Type ReadOnly Description
Id [KEY] Bigint False

ID of the conversation.

Body String False

Content of the conversation in HTML.

BodyText String False

Content of the conversation.

FromEmail String False

Email address the message was sent from.

Incoming Boolean False

True if a particular conversation should appear as being created from outside (i.e., not through web portal)

Private Boolean False

True if the note is private

SupportEmail String False

Email address from which replies are sent.

Source Integer False

Denotes the type of conversation.

TicketId Integer False

Ticket id to which conversation is added.

ToEmailsAggregate String False

Email addresses of agents/users who need to be notified about this conversation

UserId Bigint False

ID of the agent who added conversation.

CreatedAt Datetime True

Conversation creation timestamp.

UpdatedAt Datetime True

Conversation updated timestamp.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462