Power BI Connector for FreshDesk

Build 20.0.7587

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 False

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 Bigint 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) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587