SSIS Components for Zendesk

Build 24.0.9060

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 component.
SELECT * FROM Bookmarks

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

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
TicketId Integer

The time the bookmark was created.

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