JDBC Driver for Zendesk

Build 24.0.8963

Bookmarks

Create, Delete and Query the Bookmarks in Zendesk.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the 本製品.
SELECT * FROM Bookmarks

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.

Insert

The TicketId field is required to insert. Allowed for agents.

INSERT INTO Bookmarks (TicketId) VALUES ('4')

Delete

You must specify the Id of the Bookmark to delete it. Allowed for agents.

DELETE FROM Bookmarks WHERE Id = '19152874442641'

Columns

Name Type ReadOnly References Description
Id [KEY] Long True

Automatically assigned when the bookmark is created.

Ticket String True

The ticket object.

url String True

The API url of this bookmark.

CreatedAt Datetime True

The time the bookmark was created.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
TicketId Integer

The time the bookmark was created.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963