Cmdlets for Freshdesk

Build 23.0.8839


Query from BusinessHours table

Table Specific Information

Note: Only users with admin privileges can access the following Table.


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

SELECT * FROM BusinessHours

You can also select a specific entry from BusinessHours table:

SELECT * FROM BusinessHours WHERE Id = 100


Name Type ReadOnly Description
Id [KEY] Bigint False

Business hour ID.

Description String True

Description of the business hour.

Name String True

Name of the business hour.

IsDefault Boolean True

True if this is the default business hour.

TimeZone String True

Denotes the time zone of the business hour.

business_hours String True

Collection of start time and end time of days of a week.

CreatedAt Datetime True

Business hour creation timestamp.

UpdatedAt Datetime True

Business hour updated timestamp.

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