Query ActivityStreams 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 ActivityStream WHERE Id = '123'

SELECT * FROM ActivityStream WHERE Since = '2017-02-15 10:15:25'

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	References	Description
Id [KEY]	Long		Automatically assigned upon creation.
Title	String		Description of this activity.
Verb	String		The type of activity. Can be tickets.assignment, tickets.comment, or tickets.priority_increase.
UserId	Long	Users.Id	The user this activity pertains to.
ActorId	Long	Users.Id	The user this activity pertains to.
CreatedAt	Datetime		When this locale was created.
UpdatedAt	Datetime		When this locale last got updated.
Url	String		The API url of this activity.