JDBC Driver for Zendesk

Build 22.0.8462

ActivityStream

Query ActivityStreams in Zendesk.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the driver.
SELECT * FROM ActivityStream

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462