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 connector.

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.