JDBC Driver for Zendesk

Build 24.0.8963

Targets

Create, Update, Delete and Query Targets in Zendesk.

Table Specific Information

Select

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

SELECT * FROM Targets WHERE Id = '13957230417180'

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 Type, Title, Email and Subjects fields are required to insert. Allowed for admins.

INSERT INTO Targets (Type, Title, Email, Subject) VALUES ('email_target', 'YM_title', '[email protected]', 'This Subject is for Testing')

Update

You must specify the Type and Id of the Target to update. Allowed for admins.

UPDATE Targets SET Email = '[email protected]', Type = 'email_target'  WHERE Id = '18958433666450'

Delete

You must specify the Id of the Target to delete it. Allowed for admins.

DELETE FROM Targets WHERE Id = '13957990475420'

Columns

Name Type ReadOnly References Description
Id [KEY] Long True

Automatically assigned when Target is created.

Type String False

A pre-defined target, such as basecamp_target.

Title String False

A name for the target.

Active Boolean False

Whether or not the target is activated.

Email String False

Email.

Subject String False

Subject of the email.

Url String True

Url.

CreatedAt Datetime True

The time the target was created.

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