Excel Add-In for Freshdesk

Build 24.0.9060

BusinessHours

Query from BusinessHours table

Table Specific Information

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

Select

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

Columns

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 24.0.9060