Zendesk Connector
Documentation
Version: 9
Documentation

EndPoint Read Ticket Metrics


Name

get_ticket_metrics

Description

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

Parameters

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

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
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

Input Columns

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.

Examples

SSIS

Use Zendesk Connector in API Source component to read data or in API Destination component to read/write data:

Read Ticket Metrics using API Source

Zendesk
Read Ticket Metrics
SSIS API Source - Read from table or endpoint

Read Ticket Metrics using API Destination

Zendesk
Read Ticket Metrics
SSIS API Destination - Access table or endpoint