Power BI Connector for FreshDesk

Build 20.0.7587

Roles

Query from roles 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 Roles WHERE Id = 100

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

Columns

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