JDBC Driver for Freshdesk

Build 22.0.8462


Query from roles table

Table Specific Information


The driver 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 driver. For example, the following query is processed server side:

SELECT * FROM Roles WHERE Id = 100

Note: Only users with admin privileges can access the following Table. Following is an example of selecting a role:


Name Type ReadOnly Description
Id [KEY] Bigint False

Role ID.

Description String False

Description of the role.

Name String False

Name of the role.

Default Boolean False

Indicates if role is default.

CreatedAt Datetime True

Role creation timestamp.

UpdatedAt Datetime True

Role updated timestamp.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462