Zendesk Connector
Documentation
Version: 9
Documentation

EndPoint Read Tickets Count (All)


Name

get_tickets_count

Description

Returns an approximate count of tickets in the account. If the count exceeds 100,000, it is updated every 24 hours. The count[refreshed_at] property is a timestamp that indicates when the count was last updated. Note: When the count exceeds 100,000, count[refreshed_at] may occasionally be null. This indicates that the count is being updated in the background, and count[value] is limited to 100,000 until the update is complete. [API reference]

Parameters

Parameter Label Required Options Description
There are no parameters

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
value DT_I8 bigint False
refreshed_at DT_DBTIMESTAMP datetime 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 Tickets Count (All) using API Source

Zendesk
Read Tickets Count (All)
SSIS API Source - Read from table or endpoint

Read Tickets Count (All) using API Destination

Zendesk
Read Tickets Count (All)
SSIS API Destination - Access table or endpoint

ODBC application

Use these SQL queries in your ODBC application data source:

Get total tickets count

SELECT * FROM get_tickets_count

SQL Server

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

Get total tickets count

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

EXEC (@MyQuery) AT [LINKED_SERVER_TO_ZENDESK_IN_DATA_GATEWAY];