Query TicketEvents in Zendesk.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the connector.

SELECT * FROM TicketEvents
SELECT * FROM TicketEvents WHERE StartTime = '2023-10-11'
SELECT * FROM TicketEvents WHERE StartTime = '2023-10-11' AND Include = true
SELECT * FROM TicketEvents WHERE Include = true

To get the TicketIds of deleted tickets run this query:

GETDELETED FROM TicketEvents

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any other search criteria will be ignored and an unfiltered response will be returned.

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	False		Automatically assigned when Ticket Event is created.
TicketId	Integer	False	Tickets.Id	The ticket Id.
ChildEvents	String	False		Array of the Child Events.
UpdaterId	Long	False		Updater Id.
Timestamp	String	False		Timestamp at which event is created.
Via	String	False		The medium through which event is created.
SystemClient	String	False		System client information.
SystemLocation	String	False		System location information.
SystemLatitude	String	False		System latitude information.
SystemLongitude	String	False		System longitude information.
EventType	String	False		Type of the Event.
CreatedAt	Datetime	False		When this record was created.
Metadata	String	False		The metadata of the event.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
StartTime	Datetime	The time to start the incremental export from. Must be at least one minute in the past. If not provided, it will take the starttime for the most recent minute.
Include	Boolean	If true, it will include the comments in the event stream. By default, value is false.