Skip to main content

effective_hours_of_operations

Creates, updates, deletes, gets or lists an effective_hours_of_operations resource.

Overview

Nameeffective_hours_of_operations
TypeResource
Idaws.connect.effective_hours_of_operations

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
effective_hours_of_operation_listarrayInformation about the effective hours of operations.
effective_override_hours_listarrayInformation about override configurations applied to the base hours of operation to calculate the effective hours. For more information about how override types are applied, see Build your list of overrides in the Administrator Guide.
time_zonestringThe time zone for the hours of operation.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
get_effective_hours_of_operationsselectinstance_id, hours_of_operation_id, fromDate, toDate, regionGet the hours of operations with the effective override applied.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
fromDatestringThe date from when the hours of operation are listed.
hours_of_operation_idstringThe identifier for the hours of operation.
instance_idstringThe identifier of the Connect Customer instance.
regionstringAWS region (default: us-east-1)
toDatestringThe date until when the hours of operation are listed.

SELECT examples

Get the hours of operations with the effective override applied.

SELECT
effective_hours_of_operation_list,
effective_override_hours_list,
time_zone
FROM aws.connect.effective_hours_of_operations
WHERE instance_id = '{{ instance_id }}' -- required
AND hours_of_operation_id = '{{ hours_of_operation_id }}' -- required
AND fromDate = '{{ fromDate }}' -- required
AND toDate = '{{ toDate }}' -- required
AND region = '{{ region }}' -- required
;