Endpoint

Read Ticket Metrics

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`

If the column you are looking for is missing, consider customizing Zendesk Connector.

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.

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

Zendesk

Read Ticket Metrics

Zendesk

Read Ticket Metrics

Use these SQL queries in your ODBC application data source:

SELECT * FROM get_ticket_metrics

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM get_ticket_metrics';

EXEC (@MyQuery) AT [LS_TO_ZENDESK_IN_GATEWAY];