Cmdlets for Freshdesk

Build 23.0.8839


Create, update and query from CannedResponses table

Table Specific Information

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


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

SELECT * FROM CannedResponses WHERE FolderId = 100


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)


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

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


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) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839