Tableau Connector for Freshdesk

Build 23.0.8770

Skills

Create, update, delete, and query from skills table

Table Specific Information

Select

Following is an example to select all entries from Skills table:

SELECT * FROM Skills

You can also select a specific entry from Skills table:

SELECT * FROM Skills WHERE Id = 73000001322

Insert

Name is mandatory for creating a new skill. Following is an example of creating a new skill:

INSERT INTO Skills (Name) VALUES ('Example')

Update

Following is an example of how to update a skill:

UPDATE Skills SET Name = 'New name' WHERE Id = 73000001322

Delete

Following is an example of how to delete from Skills table:

DELETE FROM Skills WHERE Id = 73000001322

Columns

Name Type ReadOnly Description
Id [KEY] Bigint False

ID of the skill.

Name String False

Name of the skill.

Rank String True

Position/Rank of the skill.

Agents String False

Agents associated with the skill.

MatchType String True

Match type for conditions.

Conditions String False

Conditions of the skill.

CreatedAt Datetime True

Skills creation timestamp.

UpdatedAt Datetime True

Skills updated timestamp.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8770