JDBC Driver for Zendesk

Build 23.0.8839

TriggerCategories

Create, update, delete, and query Trigger Categories in Zendesk.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the 本製品.
SELECT * FROM TriggerCategories
SELECT * FROM TriggerCategories WHERE Id = '10498753811996'

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 Name field is required to insert.

INSERT INTO TriggerCategories (Name, Position) VALUES ('Test CData', 2)

Update

You must specify the Id of the TriggerCategory to update. All fields that are not readonly (readonly="false" in the table) are optional.

UPDATE TriggerCategories SET Name = 'Updated Test' WHERE Id = '10498983125788'

Delete

You must specify the Id of the TriggerCategory to delete it.

DELETE FROM TriggerCategories WHERE Id = '10498983125788'

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Automatically assigned when creating trigger categories.

Name String False

The name of the trigger category.

Position Integer False

The position of the trigger category.

CreatedAt Datetime True

The time at which the trigger category was created.

UpdatedAt Datetime True

The time at which the trigger category was last updated.

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