JDBC Driver for Zendesk

Build 22.0.8462

Sessions

Query and delete Sessions 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 Sessions

SELECT * FROM Sessions WHERE Userid = '123'

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.

Delete

You must specify the UserId and Id of the session to delete it. Allowed for admins, agents, end users.

DELETE FROM Sessions WHERE Userid = '123' AND Id = '456'

Columns

Name Type ReadOnly References Description
Id [KEY] Long True

Automatically assigned when the session is created.

UserId Long True

Users.Id

The id of the user.

AuthenticatedAt Datetime True

When the session was created.

LastSeenAt Datetime True

The last approximate time this session was seen. This does not update on every request.

Url String True

The API URL of this session.

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