ADO.NET Provider for FreshDesk

Build 20.0.7587

Groups

Create, update, delete, and query from groups table

Table Specific Information

Select

The {i will use the FreshDesk API to process WHERE clause conditions built with the following columns and operators. Most of the columns support server side filtering with the following operators: = > < <= >= AND OR. The rest of the filter is executed client side within the {i. For example, the following query is processed server side:

SELECT * FROM Groups WHERE Id = 100

Note: Only users with admin privileges can access this Table.

Insert

Name is a mandatory column for inserting into Groups table. For example:

INSERT INTO Groups (Name, Description, AutoTicketAssign) VALUES ('Example', 'Example Description...', false)

Update

Following is an example of how to update a group:

UPDATE Groups SET Description = 'New description...' WHERE Id = 100

Delete

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

DELETE FROM Groups WHERE Id = 786

Columns

Name Type ReadOnly Description
Id [KEY] Bigint False

ID of the group.

BusinessHourId Bigint False

Unique ID of the business hour of the group.

AutoTicketAssign Boolean False

Automatic ticket assignment enabled or not.

Description String False

Description of the group.

EscalateTo Bigint False

ID of user to whom an escalation email is sent.

Name String False

Name of the group.

UnassignedFor String False

Time after which escalation email is sent.

CreatedAt Datetime True

Group created timestamp.

AgentIdsAggregate String False

IDs of the agents in the group.

UpdatedAt Datetime True

Group updated timestamp.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587