FireDAC Components for FreshDesk

Build 21.0.7930

CannedResponses

Create, update and query from CannedResponses table

Table Specific Information

Note: Only users with admin privileges can access the following Table.

Select

To query the CannedResponses table, FolderId should be mentioned in the WHERE clause. For example:

SELECT * FROM CannedResponses WHERE FolderId = 100

Insert

FolderId, Visibility, Title and ContentHTML are mandatory columns for Inserting into CannedResponses tables. For example:

INSERT INTO CannedResponses (Title, ContentHTML, Visibility, FolderId) VALUES (Sample response, 'this is also a new sample response', 0, 100)

Update

Following is an example to update a row in CannedResponses table:

UPDATE CannedResponses SET Title = 'Updated title' WHERE Id = 100

Columns

Name Type ReadOnly Description
Id [KEY] Bigint False

ID of the canned response.

Content String True

Plaintext version of the canned response content.

ContentHTML String False

HTML version of the canned response content.

Title String False

Title of the canned response.

FolderId Bigint False

Id of CannedResponseFolder containing this canned response.

Visibility Int False

Denotes the visibility of the canned response. Possible values are: 0- If it is visible to all agents, 1- If it is personal.

CreatedAt Datetime True

Canned response creation timestamp.

UpdatedAt Datetime True

Canned response updated timestamp.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930