EndPoint Read Ticket Metrics

Contents

Name

get_ticket_metrics

Returns a list of tickets with their metrics. [API reference]

Parameter	Label	Required	Options	Description
PageSize	Records Per Page (Max 100)	NO

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
id	`DT_I8`	`bigint`		False
ticket_id	`DT_I4`	`int`		False
created_at	`DT_DBTIMESTAMP`	`datetime`		False
updated_at	`DT_DBTIMESTAMP`	`datetime`		False
group_stations	`DT_I4`	`int`		False
assignee_stations	`DT_I4`	`int`		False
reopens	`DT_I4`	`int`		False
replies	`DT_I4`	`int`		False
assignee_updated_at	`DT_DBTIMESTAMP`	`datetime`		False
requester_updated_at	`DT_DBTIMESTAMP`	`datetime`		False
status_updated_at	`DT_DBTIMESTAMP`	`datetime`		False
initially_assigned_at	`DT_DBTIMESTAMP`	`datetime`		False
assigned_at	`DT_DBTIMESTAMP`	`datetime`		False
solved_at	`DT_DBTIMESTAMP`	`datetime`		False
latest_comment_added_at	`DT_DBTIMESTAMP`	`datetime`		False
reply_time_in_minutes.calendar	`DT_I4`	`int`		False
reply_time_in_minutes.business	`DT_I4`	`int`		False
first_resolution_time_in_minutes.calendar	`DT_I4`	`int`		False
first_resolution_time_in_minutes.business	`DT_I4`	`int`		False
full_resolution_time_in_minutes.calendar	`DT_I4`	`int`		False
full_resolution_time_in_minutes.business	`DT_I4`	`int`		False
agent_wait_time_in_minutes.calendar	`DT_I4`	`int`		False
agent_wait_time_in_minutes.business	`DT_I4`	`int`		False
requester_wait_time_in_minutes.calendar	`DT_I4`	`int`		False
requester_wait_time_in_minutes.business	`DT_I4`	`int`		False
on_hold_time_in_minutes.calendar	`DT_I4`	`int`		False
on_hold_time_in_minutes.business	`DT_I4`	`int`		False
url	`DT_WSTR`	`nvarchar(1000)`	1000	False

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.