Returns targets, including type, title, activation status, and contact details.

Table-Specific Information

Select

The following query is processed server-side while other filters are processed client-side within the provider.

SELECT * FROM Targets WHERE Id = '13957230417180'

Insert

The Type, Title, Email, and Subjects columns are required to insert. This operation is allowed for logged-in users with the "admin" role only.

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. This operation is allowed for logged-in users with the "admin" role only.

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

Delete

You must specify the Id of the target to delete it. This operation is allowed for logged-in users with the "admin" role only.

DELETE FROM Targets WHERE Id = '13957990475420'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		The unique Id automatically assigned when the target is created.
Type	String	False		The pre-defined target type, such as basecamp_target.
Title	String	False		The name of the target.
Active	Boolean	False		Indicates whether the target is active.
Email	String	False		The email address for the target.
Subject	String	False		The subject of the email sent to the target.
Url	String	True		The API URL of this target.
CreatedAt	Datetime	True		The date and time when the target was created.