steampipe plugin install theapsgroup/freshservicesteampipe plugin install theapsgroup/freshservice

Table: freshservice_ticket_conversation

Allows for obtaining information on conversations for a specific Ticket.

You MUST specify a ticket_id in the WHERE or JOIN clause.

Examples

select
  *
from
  freshservice_ticket_conversation
where
  ticket_id = 2010101010;

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
attachments	jsonb		Attachments associated with the conversation.
body	text		Content of the conversation in HTML.
body_text	text		Content of the conversation in plain text.
created_at	timestamp with time zone		Timestamp when the conversation was created.
id	bigint		ID of the conversation.
incoming	boolean		Set to true if a particular conversation should appear as being created from the outside (i.e., not through the web portal).
private	boolean		Set to true if private.
source	text		Denotes the type of the conversation.
support_email	text		Email address from which the reply is sent.
ticket_id	bigint	=	ID of the ticket to which this conversation belongs.
to_emails	jsonb		Email addresses of agents/requesters who need to be notified about this conversation.
updated_at	timestamp with time zone		Timestamp when the conversation was last updated.
user_id	bigint		User ID of the agent or requester who is adding the conversation.