Zendesk への接続を追加

Zendesk への接続を追加するには：

1. アプリケーションコンソールで、接続ページに移動します。
2. 接続の追加パネルで、追加したい接続のアイコンを選択します。
3. Zendesk アイコンが利用できない場合は、Add More アイコンをクリックしてCData サイトからZendesk コネクタをダウンロードおよびインストールします。

必須プロパティについては、設定タブを参照してください。

通常必須ではない接続プロパティについては、高度な設定タブを参照してください。

Zendesk への接続

Zendesk に接続するには、https://{subdomain}.zendesk.com の形式でURL（Zendesk Support URL）を設定します。接続後、次のセクションの説明に従ってユーザー認証を行います。

また、TicketMetrics テーブルのアーカイブデータを扱うユーザーは、UseIncrementalAPI プロパティをTrue に設定する必要があります。

Zendesk への認証

Zendesk は、Zendesk インスタンスの設定に応じて、2種類の認証をサポートします。

API トークン認証

API トークン認証を使用する場合は、E メールアドレスとAPIToken を指定します。 AuthScheme をAPIToken に、User をE メールアドレスに設定し、Zendesk Support の管理画面で以下の設定を行います。

1. Token アクセスを有効にします。
2. Admin -> Channels-> API で、API トークンを管理します。一度にアクティブにできるトークンは1つだけです。トークンを削除すると、そのトークンは永久に無効化されます。

最後に、APIToken をアクティブなAPI トークンに設定します。

OAuth 認証

Zendesk はネットワーク経由で共有データにアクセスするすべてのインスタンスでOAuth 認証に対応しています。これは、Web、デスクトップ、ヘッドレスサーバーのいずれから認証する場合でも、 AuthScheme をOAuth に設定してカスタムOAuth アプリケーションを作成する必要があることを意味します。

以下のサブセクションでは、3つの一般的な認証フローでのZendesk への認証について詳しく説明します。

• デスクトップ：ユーザーのローカルマシン上でのサーバーへの接続で、テストやプロトタイピングによく使用されます。
• Web：共有ウェブサイト経由でデータにアクセスします。
• ヘッドレスサーバー：他のコンピュータやそのユーザーにサービスを提供する専用コンピュータで、モニタやキーボードなしで動作するように構成されています。

カスタムOAuth アプリケーションの作成については、カスタムOAuth アプリケーションの作成 を参照してください。 Zendesk で利用可能な接続文字列プロパティの全リストは、Connection を参照してください。

OAuth アクセストークンの自動リフレッシュ：

Sync App がOAuth アクセストークンを自動的にリフレッシュするようにするには、次のように設定します。

1. はじめてデータに接続する前に、次の接続プロパティを設定します。
   • InitiateOAuth = REFRESH。
   • OAuthClientId = アプリケーション設定のクライアントId。
   • OAuthClientSecret = アプリケーション設定のクライアントシークレット。
   • OAuthAccessToken = GetOAuthAccessToken によって返されたアクセストークン。
   • OAuthSettingsLocation = Sync App がOAuth 値を保存する場所のパス。これは接続間で維持されます。
2. その後のデータ接続では、以下を設定します。
   • InitiateOAuth
   • OAuthSettingsLocation

SSL コンフィギュレーションのカスタマイズ

デフォルトでは、Sync App はサーバーの証明書をシステムの信頼できる証明書ストアと照合してSSL/TLS のネゴシエーションを試みます。別の証明書を指定するには、利用可能なフォーマットについてSSLServerCert プロパティを参照してください。

Firewall またはProxy 経由の接続

HTTP プロキシ

Windows システムプロキシ経由の接続では、接続プロパティを追加で設定する必要はありません。他のプロキシに接続するには、ProxyAutoDetect をfalse に設定します。

さらに、HTTP プロキシへの認証には、ProxyServer とProxyPort に加えてProxyAuthScheme、ProxyUser、およびProxyPassword を設定します。

その他のプロキシ

次のプロパティを設定します。

• プロキシベースのファイヤーウォールを使用するには、FirewallType、FirewallServer、およびFirewallPort を設定します。
• 接続をトンネルするには、FirewallType をTUNNEL に設定します。
• 認証するには、FirewallUser とFirewallPassword を設定します。
• SOCKS プロキシへの認証には、さらにFirewallType をSOCKS5 に設定します。

このセクションでは、Zendesk Sync App の高度な機能を厳選して説明します。

ユーザー定義ビュー

Sync App はユーザー定義ビューの使用をサポートします。これは事前設定されたユーザー定義クエリによって内容が決定される仮想テーブルです。 このビューは、ドライバーに発行されるクエリを直接制御できない場合に有効です。 カスタムビューの作成と設定の概要については、ユーザー定義ビュー を参照してください。

SSL の設定

SSL の設定 を使用して、Sync App が証明書のネゴシエーションをどのように扱うかを調整します。さまざまな証明書形式を選択できます。詳しくは、「接続文字列オプション」にあるSSLServerCert プロパティを参照してください。

ファイアウォールとプロキシ

Windows プロキシとHTTP プロキシを含むファイアウォールとプロキシ に合致するようSync App を設定します。トンネル接続を設定することもできます。

クエリ処理

Sync App は、Zendesk にできるだけ多くのSELECT ステートメント処理をオフロードし、残りのクエリをクライアント側のインメモリで処理します。

詳しくは、クエリ処理 を参照してください。

ログ

CData ログを調整するために使用可能な設定の概要については、ログ を参照してください。基本的なロギングに必要なのは2つの接続プロパティだけですが、より詳細なロギングをサポートする多くの機能があり、LogModules 接続プロパティを使用してロギングする情報のサブセットを指定することができます。

SSL 設定のカスタマイズ

デフォルトでは、Sync App はサーバーとのTLS のネゴシエーションを試みます。サーバー証明書は、デフォルトのシステム信頼済み証明書ストアで検証されます。SSLServerCert 接続プロパティを使用して、証明書の検証方法をオーバーライドできます。

別の証明書を指定するには、SSLServerCert 接続プロパティを参照してください。

Firewall またはProxy 経由の接続

HTTP プロキシ

HTTP プロキシへの認証には、以下のように設定します。

• ProxyServer：HTTP トラフィックをルートするプロキシサーバーのホストネームもしくはIP アドレス。
• ProxyPort：プロキシサーバーが起動しているTCP ポート。
• ProxyAuthScheme：プロキシサーバーに対して認証する際にSync App が使用する認証方法。
• ProxyUser：プロキシサーバーに登録されているユーザーアカウントのユーザー名。
• ProxyPassword：ProxyUser に紐付けられたパスワード。

その他のプロキシ

次のプロパティを設定します。

• プロキシベースのファイヤーウォールを使用するには、FirewallType、FirewallServer、およびFirewallPort を設定します。
• 接続をトンネルするには、FirewallType をTUNNEL に設定します。
• 認証するには、FirewallUser とFirewallPassword を設定します。
• SOCKS プロキシへの認証には、さらにFirewallType をSOCKS5 に設定します。

CData Sync App は、Zendesk API のエンティティをテーブル、ビュー、およびストアドプロシージャにモデル化します。Tickets スキーマは、カスタムフィールドの変更を動的に反映します。その他のエンティティは、簡単なテキストベースのコンフィギュレーションファイルであるスキーマファイルにて定義されます。

クエリ処理の使用

Sync App は、Zendesk API にできるだけ多くのSELECT 構文処理をオフロードし、残りのクエリをSync App 内で処理します。次のセクションでは、API の制限と要件を説明します。

ストアドプロシージャ

ストアドプロシージャ は、データソースのファンクションライクなインターフェースです。これらを使用して、データソース内の情報を検索、更新、および変更できます。

Sync App はZendesk のデータを、標準のSQL ステートメントを使用してクエリできるリレーショナルデータベースのテーブルのリストとしてモデル化します。

Zendesk Connector for CData Sync テーブル

Name	Description
AccountSettings	Query and update Account Settings in Zendesk.
ArticleAttachments	Query and Delete Acticle Attachment in Zendesk.
ArticleComments	Create, Update, Delete and Query the Article Comments in Zendesk.
ArticleLabels	Create, delete, and query Article Labels in Zendesk.
Articles	Create, Update, Archive and query Acticles in Zendesk.
ArticleTranslations	Create, Update, Delete and Query the Translations for Articles in Zendesk.
Attributes	Create, Update, Delete and Query the Attributes in Zendesk. An attribute in Zendesk refers to a skill type. Skill types are categories of skills.
AttributeValues	Create, Update, Delete and Query the Attribute Values in Zendesk. An attribute value in this API refers to a skill. Skills are associated with an agent and determine the agent's suitability to solve a ticket.
Automations	Create, update, delete, and query Automations in Zendesk.
Bookmarks	Create, Delete and Query the Bookmarks in Zendesk.
Brands	Create, delete, update, and query Brands in Zendesk.
Categories	Create, update, delete, and query Categories in Zendesk.
CategoryTranslations	Create, Update, Delete and Query the Translations for Categories in Zendesk.
ContentSubscriptions	Create, Update, Delete and Query the Content Subscriptions in Zendesk. Users can subscribe to sections, articles, community posts, and community topics.
ContentTags	Create, Update, Delete and Query the Content Tags in Zendesk.
CustomAgentRoles	Create, Update, Delete and Query CustomAgentRoles in Zendesk.
CustomObjectFields	Defines the fields available for a custom object.
CustomObjects	Defines the custom objects available in the Zendesk account.
CustomTicketStatuses	Create, update, and query custom ticket statuses in zendesk.
GroupMemberships	Create, delete, and query Group Memberships in Zendesk.
Groups	Create, update, delete, and query Groups in Zendesk.
GroupSlaPolicies	Create, Update, Delete and Query Group SLA Policies in Zendesk.
Holidays	Create, update, delete, and query Schedules in Zendesk.
JiraLinks	View and create links between your Jira and Zendesk instances.
LegacyCustomObjects	Create, delete, update, and query Legacy Custom Objects in Zendesk.
Macros	Create, update, delete, and query Macros in Zendesk.
ManagementPermissionGroups	Create, Update, Delete and Query the Management Permission Groups in Zendesk. A management permission group defines which agents can create, update, archive, and publish articles. It consists of a set of privileges, each of which is mapped to a user segment. Agents receive whichever privileges are associated with the user segments they belong to.
OrganizationFields	Create, update, delete, and query Organization Fields in Zendesk.
OrganizationMemberships	Create, delete, and query Organization Memberships in Zendesk.
Organizations	Create, delete, update, and query Organizations in Zendesk.
OrganizationSubscriptions	Create, delete, and query Organization Subscriptions in Zendesk.
PostComments	Query, Insert, Update and Delete PostComments in Zendesk.
Posts	Query, Insert, Update and Delete Posts in Zendesk.
SatisfactionRatings	Create and query Requests in Zendesk.
Schedules	Create, update, delete and query Schedules in Zendesk.
Sections	Create, update, delete, and query Sections in Zendesk.
SectionTranslations	Create, Update, Delete and Query the Translations for Sections in Zendesk.
Sessions	Query and delete Sessions in Zendesk.
SharingAgreements	Create, update, delete, and query SharingAgreements in Zendesk.
SideConversations	Create, update and query Side Conversations in Zendesk.
SlaPolicies	Create, update, delete, and query SlaPolicies in Zendesk.
SupportAddresses	Create, update, delete, and query Support Addresses in Zendesk.
SuspendedTickets	Query and delete Suspended Tickets in Zendesk.
Targets	Create, Update, Delete and Query Targets in Zendesk.
TicketAudits	Query TicketAudits in Zendesk.
TicketComments	Query TicketComments belonging to a specified ticket in Zendesk.
TicketEvents	Query TicketEvents in Zendesk.
TicketFields	Create, update, delete, and query TicketFields in Zendesk.
TicketForms	Create, update, delete, and query Ticket Forms in Zendesk.
TicketMetricEvents	Queries TicketMetricEvents in Zendesk.
TicketMetrics	Query TicketMetrics in Zendesk.
Tickets	Create, update, delete, and query Tickets.
TicketSkips	Create and Query the TicketSkips in Zendesk. A skip is a record of when an agent skips over a ticket without responding to the end user. Skips are typically recorded while a play-only agent is in Guided mode.
Tickets_Collaborators	The Collaborator id of users currently CC'ed on the ticket.
Tickets_Followers	The ids of agents currently following the ticket.
Tickets_Followups	The ids of the followups created from ticket.
Tickets_SatisfactionRatings	The satisfaction rating of the ticket, if it exists, or the state of satisfaction.
Tickets_SharingAgreements	The sharing agreements used for ticket.
Tickets_Tags	The tags applied to the ticket.
Tickets_Viasources	List ViaSources for the Ticket.
Topics	Query, Insert, Update and Delete Topics in Zendesk.
Translations	Create, Update, Delete and Query the Translations in Zendesk. This table is deprecated, and is being replaced by the ArticleTranslations, CategoryTranslations, and SectionTranslations tables.
TriggerCategories	Create, update, delete, and query Trigger Categories in Zendesk.
Triggers	Create, update, delete, and query Triggers in Zendesk.
UserFields	Create, update, delete, and query User Fields.
UserIdentities	Create, update, delete, and query User Identities.
Users	Create, update, delete, and query Users in Zendesk.
UserSegments	Create, Update, Delete and Query the User Segments in Zendesk. A user segment defines who can view the content of a section or topic.
Views	Create, update, delete and query views in Zendesk.
Votes	Create, Delete and Query the Votes in Zendesk. Votes represents positive and negative opinions of users about articles, article comments, posts or post comments.

Query and update Account Settings in Zendesk.

Table Specific Information

Select

The Sync App executes all filters on this table client side.

Update

All fields that are not readonly (readonly="false" in the table) can be updated. Allowed for admins. For example:

UPDATE AccountSettings SET ActiveFeaturesCustomerSatisfaction = true

Columns

Name	Type	ReadOnly	References	Description
BrandingHeaderColor	String	False		HEX of the header color.
BrandingPageBackgroundColor	String	True		HEX of the page background color.
BrandingTabBackgroundColor	String	True		HEX of tab background color.
BrandingTextColor	String	True		HEX of the text color, usually matched to contrast well with header_color.
BrandingHeaderLogoUrl	String	True		The URL for the custom header logo.
BrandingFaviconUrl	String	True		The URL for the custom favicon.
AppsUse	Boolean	True		The account can use apps.
AppsCreatePrivate	Boolean	True		The account can create private apps.
TicketsCommentsPublicByDefault	Boolean	True		Comments from agents are public by default.
TicketsIsFirstCommentPrivateEnabled	Boolean	True		Allow first comment on tickets to be private.
TicketsListNewestCommentsFirst	Boolean	True		When viewing a ticket, show the newest comments and events first.
TicketsCollaboration	Boolean	True		CCs may be added to a ticket.
TicketsPrivateAttachments	Boolean	True		Users must login to access attachments.
TicketsEmailAttachments	Boolean	True		Attachments should be sent as real attachments when under the size limit.
TicketsAgentCollision	Boolean	True		Clients should provide an indicator when a ticket is being viewed by another agent.
TicketsMaximumPersonalViewsToList	Integer	True		Maximum number of personal Views clients should display in menus.
TicketsTagging	Boolean	True		Tickets may be tagged.
TicketsMarkdownTicketComments	Boolean	True		Whether agent comments should be processed with Markdown.
TicketsEmojiAutocompletion	Boolean	True		Whether agent comments should allow for Emoji rendering.
TicketsAgentTicketDeletion	Boolean	False		Whether agents can delete tickets.
ChatEnabled	Boolean	True		Chat is enabled.
ChatMaximumRequests	Integer	True		The maximum number of chat requests an agent may handle at one time.
ChatWelcomeMessage	String	True		The message automatically sent to end-users when they begin chatting with an agent.
TwitterShortenUrl	String	True		Possible values: always, optional, never.
GSuiteHasGoogleApps	Boolean	True		Whether has google apps.
GSuiteHasGoogleAppsAdmin	Boolean	False		Account has at least one G Suite admin.
VoiceEnabled	Boolean	True		Whether Voice is enabled.
VoiceMaintenance	Boolean	True		.
VoiceLogging	Boolean	True		.
VoiceOutboundEnabled	Boolean	True		.
VoiceAgentConfirmationWhenForwarding	Boolean	True		.
VoiceAgentWrapUpAfterCalls	Boolean	True		.
VoiceMaximumQueueSize	Integer	True		.
VoiceMaximumQueueWaitTime	Integer	True		.
VoiceOnlyDuringBusinessHours	Boolean	True		.
VoiceRecordingsPublic	Boolean	True		.
VocieUkMobileForwarding	Boolean	True		.
UsersTagging	Boolean	True		Users may be tagged.
UsersTimeZoneSelection	Boolean	True		Whether user can view time zone for profile.
UsersLanguageSelection	Boolean	True		Whether to display language drop down for a user.
UsersAgentCreatedWelcomeEmails	Boolean	True		Whether a user created by an agent receives a welcome email.
UsersEndUserPhoneNumberValidation	Boolean	False		Whether a user's phone number is validated.
GooddataAdvancedAnalytics_Enabled	Boolean	True		GoodData Advanced Analytics is enabled.
BrandsDefaultBrandId	Long	False		The id of the brand that is assigned to tickets by default.
BrandsRequireBrandOnNewTickets	Boolean	True		Require agents to select a brand before saving tickets.
StatisticsForum	Boolean	True		Allow users to view forum statistics.
StatisticsSearch	Boolean	True		Allow users to view search statistics.
BillingBackend	String	True		Backend Billing system either internal or zuora.
ActiveFeaturesOnHoldStatus	Boolean	True		Account can use status hold.
ActiveFeaturesUserTagging	Boolean	True		Enable user tags.
ActiveFeaturesTicketTagging	Boolean	True		Allow tagging tickets.
ActiveFeaturesTopicSuggestion	Boolean	True		Allow topic suggestions in tickets.
ActiveFeaturesVoice	Boolean	True		Voice support.
ActiveFeaturesFacebookLogin	Boolean	True		Facebook login.
ActiveFeaturesGoogleLogin	Boolean	True		Google login.
ActiveFeaturesTwitterLogin	Boolean	True		Twitter login.
ActiveFeaturesForumAnalytics	Boolean	True		Forum and search analytics.
ActiveFeaturesBusinessHours	Boolean	False		Business hours.
ActiveFeaturesAgentForwarding	Boolean	True		Agent forwarding.
ActiveFeaturesChat	Boolean	True		Chat.
ActiveFeaturesChatAboutMyTicket	Boolean	True		Chat about my ticket.
ActiveFeaturesCustomerSatisfaction	Boolean	False		Customer satisfaction.
ActiveFeaturesSatisfactionPrediction	Boolean	False		Satisfaction Prediction.
ActiveFeaturesCsatReasonCode	Boolean	True		Csat reason code.
ActiveFeaturesScreencasts	Boolean	True		.
ActiveFeaturesMarkdown	Boolean	True		Markdown in ticket comments.
ActiveFeaturesLanguageDetection	Boolean	True		Language detection.
ActiveFeaturesBccArchiving	Boolean	True		Account has a bcc_archive_address set.
ActiveFeaturesAllowCcs	Boolean	True		Allow ccs.
ActiveFeaturesAdvancedAnalytics	Boolean	True		Advanced analytics.
ActiveFeaturesInsights	Boolean	True		Insights.
ActiveFeaturesSandbox	Boolean	True		Account has a sandbox.
ActiveFeaturesSuspendedTicketNotification	Boolean	True		Suspended ticket notification.
ActiveFeaturesTwitter	Boolean	True		Account monitors at least one Twitter handle.
ActiveFeaturesFacebook	Boolean	True		Account is actively linked to at least one Facebook page.
ActiveFeaturesFeedbackTabs	Boolean	True		Feedback tab has been configured before.
ActiveFeaturesDynamicContents	Boolean	True		Account has at least one dynamic content.
ActiveFeaturesLightAgents	Boolean	True		Account has at least one light agent.
ActiveFeaturesTicketForms	Boolean	True		Ticket forms.
ActiveFeaturesUserOrgFields	Boolean	True		User org fields.
ActiveFeaturesIsAbusive	Boolean	True		Account exceeded trial limits.
ActiveFeaturesRichContentInEmails	Boolean	True		Account supports incoming HTML email.
ApiAcceptedApiAgreement	Boolean	False		Account has accepted the API agreement.
ApiPasswordAccess	Boolean	False		Allow the account to use the API with username/password.
APITokenAccess	Boolean	False		Allow the account to use the API with API tokens.
TicketFormsInstructions	String	False		.
RawTicketFormsInstructions	String	True		.
LotusPrefer	Boolean	True		Prefers the current version of Zendesk Support rather than Zendesk Classic.
RulesMacroMostUsed	Boolean	False		Display the most-used macros in the Apply macro list. Defaults to true.
RulesMacroOrder	String	False		Default macro display order. Possible values are alphabetical or position.
LimitsAttachmentSize	Integer	True		The maximum ticket attachment file size (in bytes).
MetricsAccountSize	String	True		An account size category computed from the number of billable agents.

Query and Delete Acticle Attachment in Zendesk.

Table Specific Information

Select

The following queries are processed server-side while other filters are processed client-side by the Sync App. Allowed for Agents and End users, as long as they can view the associated article.

SELECT * FROM ArticleAttachments WHERE ArticleId = '18214155815057'
SELECT * FROM ArticleAttachments WHERE Id = '18470148791057'
SELECT * FROM ArticleAttachments WHERE Id = '18470148791057' AND Locale='en-us' AND ArticleId = '18214155815057'

Delete

You must specify the Id of the ArticleAttachments to delete it. Allowed for agents.

DELETE FROM ArticleAttachments WHERE Id = '18460736594833'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		Assigned ID when the article attachment is created.
ArticleId	Long	True	Articles.Id	The associated article, if present.
Locale	String	True		The locale of translation that the attachment will be attached to and can only be set on inline attachments
ContentType	String	True		The file type. Example: image/png.
ContentUrl	String	True		URL where the attachment file can be downloaded.
CreatedAt	Datetime	True		The time the article attachment was created.
DisplayFileName	String	True		display_file_name.
FileName	String	True		The file name.
Inline	Boolean	True		The attached file is shown in the admin interface for inline attachments. Its URL can be referenced in the article's HTML body. Inline attachments are image files directly embedded in the article body. If false, the attachment is listed in the list of attachments. The default value is false.
RelativePath	String	True		relative_path.
Size	Integer	True		The attachment file size in bytes.
UpdatedAt	Datetime	True		The time the article attachment was last updated.
Url	String	True		The URL of the article attachment.
AttachmentsResponse	String	True		Content of the attachments.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
Base64EncodedResponse	Boolean	Raw response gets converted into base64encoded. デフォルト値はtrueです。

Create, Update, Delete and Query the Article Comments in Zendesk.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the Sync App.

SELECT * FROM ArticleComments WHERE UserId = '19128124956177'
SELECT * FROM ArticleComments WHERE ArticleId = '19206579478289'
SELECT * FROM ArticleComments WHERE ArticleId = '19206579478289' AND Locale = 'en-us'
SELECT * FROM ArticleComments WHERE ArticleId = '19206579478289' AND Id = '19244072685969'
SELECT * FROM ArticleComments WHERE ArticleId = '19206579478289' AND Id = '19244072685969' AND Locale = 'en-us'

Insert

The Locale, ArticleId and Body fields are required to insert. Allowed for End users.

INSERT INTO ArticleComments (ArticleId, Locale, Body, NotifySubscribers) VALUES ('19206579478289', 'en-us', 'Sample Comment Body', false)

Update

You must specify the ArticleId and Id of the comment to update. Allowed for Agents and the end user who created the comment.

UPDATE ArticleComments SET Body = 'Updated Comment' WHERE ArticleId = '19206579478289' AND Id = '19268721555473'

Delete

You must specify the Id of the Comment and ArticleId to delete it. Allowed for Agents and the end user who created the comment.

DELETE FROM ArticleComments WHERE ArticleId = '19206579478289' AND Id = '19269079247633'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		Automatically assigned when the comment is created.
AuthorId	Long	False		The id of the author of this comment. Writable on create by Help Center managers.
Body	String	False		The comment made by the author.
Locale	String	False		The locale in which this comment was made.
url	String	True		The API url of this comment.
HtmlUrl	String	True		The url at which the comment is presented in Help Center.
NonAuthorEditorId	Long	True		The user id of whoever performed the most recent (if any) non-author edit. A non-author edit consists of an edit make by a user other than the author that creates or updates the body or author_id. Note that only edits made after May 17, 2021 will be reflected in this field. If no non-author edits have occured since May 17, 2021, then this field will be null.
NonAuthorUpdatedAt	Datetime	True		When the comment was last edited by a non-author user.
SourceId	Long	True		The id of the item on which this comment was made.
SourceType	String	True		The type of the item on which this comment was made. Currently only supports 'Article'.
VoteCount	Integer	True		The total number of upvotes and downvotes.
VoteSum	Integer	True		The sum of upvotes (+1) and downvotes (-1), which may be positive or negative.
CreatedAt	Datetime	False		The time the comment was created. Writable on create by Help Center managers.
UpdatedAt	Datetime	True		The time at which the comment was last updated.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
ArticleId	Long	The Id of the Article.
UserId	Long	The Id of the User.
NotifySubscribers	Boolean	Supplying a notify_subscribers property with a value of false will prevent subscribers to the comment's article from receiving a comment creation email notification. This can be helpful when creating many comments at a time.

Create, delete, and query Article Labels in Zendesk.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the Sync App.

SELECT * FROM ArticleLabels WHERE Id = '10552059820828'
SELECT * FROM ArticleLabels WHERE ArticleId = '10480909113756'
SELECT * FROM ArticleLabels WHERE ArticleId = '10480909113756' AND Locale = 'en-us'

Insert

The ArticleId and Name columns are required to insert. All fields that are not readonly (readonly="false" in the table) are optional. Allowed for Agents.

INSERT INTO ArticleLabels (ArticleId, Name) VALUES (10480909113756, 'Test')

Delete

You must specify the Id of the ArticleLabel to delete it. Allowed for Agents.

DELETE FROM ArticleLabels WHERE Id = '10552125680668'
DELETE FROM ArticleLabels WHERE Id = '13647939064221' AND ArticleId = '10480909113756'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		Automatically assigned when the label is created.
Name	String	False		The actual name of the label.
CreatedAt	Datetime	True		The time at which the label was created.
UpdatedAt	Datetime	True		The time at which the label was last updated.
Url	String	True		The API url of this label.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
ArticleId	Long	The unique ID of the article.
Locale	String	The locale the item is displayed in.

Create, Update, Archive and query Acticles in Zendesk.

Table Specific Information

Select

The following queries are processed server-side while other filters are processed client-side within the Sync App.

SELECT * FROM Articles
SELECT * FROM Articles WHERE Id = '18467349573905'

Insert

The columns Locale, PermissionGroupId, Title, SectionId and UserSegmentId are required to insert. Allowed for agents.

INSERT INTO Articles(Locale, PermissionGroupId, Title, SectionId, UserSegmentId) VALUES('en-us', 18214159653905, 'The Title', 18214167902481, null)

Update

You must specify the Id of the Article to update it. It only update the article-level metadata such as its Promoted, Position, etc. It does not update translation properties such as the article's Title, Body, Locale, or Draft. Allowed for agents.

UPDATE Articles SET Promoted=true WHERE Id = '18460304837265'

Delete

You must specify the Id of the Article to archive it. You can restore the article using the Help Center user interface. Allowed for agents.

DELETE FROM Articles WHERE Id = 18467236423441

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		Automatically assigned when the article is created.
AuthorId	Long	True		The id of the user who wrote the article (set to the user who made the request on create by default).
Body	String	False		HTML body of the article. Unsafe tags and attributes may be removed before display. For a list of safe tags and attributes, see Allowing unsafe HTML in Help Center articles in Zendesk help.
CommentsDisabled	Boolean	False		True if comments are disabled; false otherwise.
CreatedAt	Datetime	True		The time the article was created.
Draft	Boolean	False		True if the translation for the current locale is a draft; false otherwise. false by default. Can be set when creating but not when updating. For updating, see Translations.
EditedAt	Datetime	True		The time the article was last edited in its displayed locale.
HtmlUrl	String	True		The url of the article in Help Center.
LabelNames	String	False		An array of label names associated with this article. By default no label names are used. Only available on certain plans.
Locale	String	False		The locale that the article is being displayed in.
Outdated	Boolean	True		Deprecated. Always false because the source translation is always the most up-to-date translation.
OutdatedLocales	String	True		Locales in which the article was marked as outdated.
PermissionGroupId	Long	False		The id of the permission group which defines who can edit and publish this article.
Position	Integer	False		The position of this article in the article list. 0 by default.
Promoted	Boolean	False		True if this article is promoted; false otherwise. false by default.
SectionId	Long	False		The id of the section to which this article belongs.
SourceLocale	String	True		The source (default) locale of the article.
Title	String	False		The title of the article.
UpdatedAt	Datetime	True		The time the article was last updated.
Url	String	True		The API url of the article.
UserSegmentId	Long	False		The id of the user segment which defines who can see this article. Set to null to make it accessible to everyone.
VoteCount	Integer	True		The total number of upvotes and downvotes.
VoteSum	Integer	True		The sum of upvotes (+1) and downvotes (-1), which may be positive or negative.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
CategoryId	Long	Id of the categories.
UserId	Long	Id of author.
StartTime	Datetime	Start Time.

Create, Update, Delete and Query the Translations for Articles in Zendesk.

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		Automatically assigned when a translation is created.
CreatedById	Long	True		The id of the user who created the translation.
UpdatedById	Long	True		The id of the user who last updated the translation.
ArticleId	Long	True	Articles.Id	The id of the article that has this translation.
Title	String	False		The title of the translation.
Body	String	False		HTML body of the translation. Empty by default.
Draft	Boolean	False		True if the translation is a draft; false otherwise. False by default.
HtmlUrl	String	True		The url of the translation in Help Center.
Locale	String	False		The locale of the translation.
Outdated	Boolean	False		True if the translation is outdated; false otherwise. False by default.
SourceType	String	True		The type of the item that has this translation. Can be article, section, or category.
Url	String	True		The API url of the translation.
CreatedAt	Datetime	True		The time at which the translation was created.
UpdatedAt	Datetime	True		The time at which the translation was last updated.

Create, Update, Delete and Query the Attributes in Zendesk. An attribute in Zendesk refers to a skill type. Skill types are categories of skills.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the Sync App.

SELECT * FROM Attributes WHERE Id = 'd5e889c8-6364-11ee-8493-6361d728a3c9'

Insert

The Name field is required to insert. Allowed for agents.

INSERT INTO Attributes (Name) VALUES ('Test')

Update

You must specify the Id of the Attribute to update. Allowed for admins.

UPDATE Attributes SET Name = 'CData' WHERE Id = 'd5e889c8-6364-11ee-8493-6361d728a3c9'

Delete

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

DELETE FROM Attributes WHERE Id = 'db70666a-6364-11ee-bfc8-7f3b952deb2c'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		Automatically assigned when an attribute is created.
Name	String	False		The name of the attribute.
url	String	True		URL of the attribute.
CreatedAt	Datetime	True		When this record was created.
UpdatedAt	Datetime	True		When this record was last updated.

Create, Update, Delete and Query the Attribute Values in Zendesk. An attribute value in this API refers to a skill. Skills are associated with an agent and determine the agent's suitability to solve a ticket.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the Sync App.

SELECT * FROM AttributeValues WHERE AttributeId = 'd5e889c8-6364-11ee-8493-6361d728a3c9'
SELECT * FROM AttributeValues WHERE AttributeId = 'd5e889c8-6364-11ee-8493-6361d728a3c9' AND Id = '5943809a-6f5d-4f6e-8669-e8a65bd3583b'

Insert

The AttributeId and Name fields are required to insert. Allowed for admins.

INSERT INTO AttributeValues (AttributeId, Name) VALUES ('d5e889c8-6364-11ee-8493-6361d728a3c9', 'TestValue')

Update

You must specify the AttributeId and Id of the AttributeValue to update. Allowed for admins.

UPDATE AttributeValues SET Name = 'CData' WHERE AttributeId = 'd5e889c8-6364-11ee-8493-6361d728a3c9' AND Id = '5943809a-6f5d-4f6e-8669-e8a65bd3583b'

Delete

You must specify the AttributeId and Id of the AttributeValue to delete it. Allowed for agents.

DELETE FROM AttributeValues WHERE AttributeId = 'db70666a-6364-11ee-bfc8-7f3b952deb2c' AND Id = '5943809a-6f5d-4f6e-8669-e8a65bd3583b'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		Automatically assigned when an attribute value is created.
AttributeId	String	False	Attributes.Id	The Attribute Id.
Name	String	False		The name of the attribute value.
url	String	True		URL of the attribute.
CreatedAt	Datetime	True		When this record was created.
UpdatedAt	Datetime	True		When this record was last updated.

Create, update, delete, and query Automations in Zendesk.

Table Specific Information

Select

The following queries are processed server side, while other filters are processed client side within the Sync App.

SELECT * FROM Automations WHERE Id = '123'

SELECT * FROM Automations ORDER BY Position 

SELECT * FROM Automations ORDER BY CreatedAt  

SELECT * FROM Automations ORDER BY UpdatedAt

Insert

The Title, ConditionsAll, and Actions fields are required to insert. Allowed for agents.

INSERT INTO Automations (Title, ConditionsAll, Actions) VALUES ('Roger Wilco II', '[{ \"field\": \"status\", \"operator\": \"is\",\"value\": \"open\" }, {\"field\": \"priority\", \"operator\": \"less_than\", \"value\": \"high\" }]', '[{\"field\": \"status\", \"value": \"solved\"}]')

Update

You must specify the Id of the automation to update. Title is required. Active and Position are optional. Updating an action updates the containing array, clearing the other actions. Include all your actions when updating any action. Allowed for agents.

UPDATE Automations SET Title = 'Roger Wilco III' WHERE Id = '123'

Delete

You must specify the Id of the automation to delete it. Allowed for agents.

DELETE FROM Automations WHERE Id = '123'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		Automatically assigned when created.
Title	String	False		The title of the automation.
Active	Boolean	False		Whether the automation is active.
Position	Integer	False		The position of the automation.
ConditionsAll	String	False		An object that describes the conditions under which the automation will execute.
ConditionsAny	String	False		An object that describes the conditions under which the automation will execute.
Actions	String	False		An object describing what the automation will do.
CreatedAt	Datetime	True		The time the automation was created.
UpdatedAt	Datetime	True		The time of the last update of the automation.

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 Sync App.

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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
TicketId	Integer	The time the bookmark was created.

Create, delete, update, and query Brands in Zendesk.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the Sync App.

SELECT * FROM Brands WHERE Id = '123'

Insert

The Name and Subdomain fields are required to insert. Allowed for admins.

INSERT INTO Brands (Name, Subdomain) VALUES ('Brand 1', 'brand1')

Update

You must specify the Id of the automation to update. Allowed for agents.

UPDATE Brands SET Name = 'Brand 2', Subdomain = 'brand2', HostMapping = 'brand2.com', Active = true  WHERE Id = '123'

Delete

You must specify the Id of the automation to delete it. Allowed for agents.

DELETE FROM Brands WHERE Id = '123'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	False		Automatically assigned when the brand is created.
Name	String	False		The name of the brand.
CreatedAt	Datetime	False		The time the brand was created.
UpdatedAt	Datetime	False		The time of the last update of the brand.
BrandUrl	String	False		The url of the brand.
HasHelpCenter	Boolean	False		If the brand has a Help Center.
HelpCenterState	String	False		The state of the Help Center: enabled, disabled, or restricted.
Active	Boolean	False		If the brand is set as active.
Default	Boolean	False		Is the brand the default brand for this account.
LogoId	Long	False		The id of logo image for this brand.
LogoUrl	String	False		The url of logo image for this brand.
LogoFileName	String	False		The name of logo image for this brand.
LogoContentUrl	String	False		The content url of logo image for this brand.
LogoMappedContentUrl	String	False		The mapped content url of logo image for this brand.
LogoContentType	String	False		The content type of logo image for this brand.
LogoSize	Integer	False		The size of logo image for this brand.
TicketFormIds	String	False		The ids of ticket forms that are available for use by a brand.
HostMapping	String	False		The hostmapping to this brand, if any (only admins view this key).
Subdomain	String	False		The subdomain of the brand.
SignatureTemplate	String	False		The signature template for a brand.
Url	String	False		The API url of this brand.

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

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the Sync App.

SELECT * FROM Categories WHERE Id = '13625378761117'
SELECT * FROM Categories WHERE Locale = 'en-us'
SELECT * FROM Categories WHERE Locale = 'en-us' AND Id = '13625378761117'

Insert

The Name field is required to insert. Allowed for Help Center managers.

INSERT INTO Categories (Name, Locale) VALUES ('Test CData', 'en-us')

Update

You must specify the Id of the Category to update. It only updates the category-level metadata such as Position, etc. It does not update category translation properties such as Name, Description, etc. All fields that are not readonly (readonly="false" in the table) are optional. Allowed for Help Center managers.

UPDATE Categories SET Position = 2 WHERE Id = '13626563785373'

Delete

You must specify the Id of the Category to delete it. Allowed for Help Center managers.

DELETE FROM Categories WHERE Id = '13626686793885'
DELETE FROM Categories WHERE Id = '13626686793885' AND Locale = 'en-us'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		Automatically assigned when creating categories.
Name	String	False		The name of the category.
Description	String	False		The description of the category.
Locale	String	False		The locale where the category is displayed.
CreatedAt	Datetime	True		The time at which the category was created.
UpdatedAt	Datetime	True		The time at which the category was last updated.
Url	String	True		The API url of this category.
HtmlUrl	String	True		The url of this category in Help Center.
Outdated	Boolean	True		Whether the category is out of date.
Position	Integer	False		The position of this category relative to other categories.
SourceLocale	String	True		The source (default) locale of the category.

Create, Update, Delete and Query the Translations for Categories in Zendesk.

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		Automatically assigned when a translation is created.
CreatedById	Long	True		The id of the user who created the translation.
UpdatedById	Long	True		The id of the user who last updated the translation.
CategoryId	Long	True	Categories.Id	The id of the item that has this translation.
Title	String	False		The title of the translation.
Body	String	False		HTML body of the translation. Empty by default.
Draft	Boolean	False		True if the translation is a draft; false otherwise. False by default.
HtmlUrl	String	True		The url of the translation in Help Center.
Locale	String	False		The locale of the translation.
Outdated	Boolean	False		True if the translation is outdated; false otherwise. False by default.
SourceType	String	True		The type of the item that has this translation. Can be article, section, or category.
Url	String	True		The API url of the translation.
CreatedAt	Datetime	True		The time at which the translation was created.
UpdatedAt	Datetime	True		The time at which the translation was last updated.

Create, Update, Delete and Query the Content Subscriptions in Zendesk. Users can subscribe to sections, articles, community posts, and community topics.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the Sync App.

The following queries list the content subscriptions of a given user. To list your own subscriptions, specify me as the user id.

SELECT * FROM ContentSubscriptions WHERE UserId = '19128124956177'
SELECT * FROM ContentSubscriptions WHERE UserId = 'me'

The following queries list the subscriptions to a given topic.

SELECT * FROM ContentSubscriptions WHERE TopicId = '19209878690449'
SELECT * FROM ContentSubscriptions WHERE TopicId = '19209878690449' AND Id = '19209922023185'

The following queries list the subscriptions to a given post.

SELECT * FROM ContentSubscriptions WHERE PostId = '19206579516945'
SELECT * FROM ContentSubscriptions WHERE PostId = '19206579516945' AND Id = '19210209123217'

The following queries list the subscriptions to a given section. Provide values for the SectionId and Locale.

SELECT * FROM ContentSubscriptions WHERE SectionId = '19206579484689' AND Locale = 'en-us'
SELECT * FROM ContentSubscriptions WHERE SectionId = '19206579484689' AND Locale = 'en-us' AND Id = '19210938828817'

The following queries list the subscriptions to a given article. Provide values for the ArticleId and Locale.

SELECT * FROM ContentSubscriptions WHERE ArticleId = '19206609899793' AND Locale = 'en-us'
SELECT * FROM ContentSubscriptions WHERE ArticleId = '19206609899793' AND Locale = 'en-us' AND Id = '19211885836945'

Insert

To create a Subscription for a given Topic, TopicId column is required. Allowed for End-users. Agents with the Help Center manager role can optionally supply a UserId value. If provided, the user associated with UserId will be subscribed to the topic.

INSERT INTO ContentSubscriptions (TopicId, IncludeComments) VALUES ('19209878690449', true)

To create a Subscription for a given Post, PostId column is required. Allowed for End-users. Agents with the Help Center manager role can optionally supply a UserId value. If provided, the user associated with UserId will be subscribed to the post.

INSERT INTO ContentSubscriptions (PostId, UserId) VALUES ('19206579516945', '19157178632977')

To create a Subscription for a given Section, SectionId, Locale and SourceLocale columns are required. Allowed for End-users. Agents with the Help Center manager role can optionally supply a UserId value. If provided, the user associated with UserId will be subscribed to the section.

INSERT INTO ContentSubscriptions (SectionId, Locale, SourceLocale) VALUES ('19206579484689', 'en-us', 'en-us')

To create a Subscription for a given Article, ArticleId, Locale and SourceLocale columns are required. Allowed for End-users. Agents with the Help Center manager role can optionally supply a UserId value. If provided, the user associated with UserId will be subscribed to the article.

INSERT INTO ContentSubscriptions (ArticleId, Locale, SourceLocale) VALUES ('19206609899793', 'en-us', 'en-us')

Update

Update can be perform only on Topic Subscription. The TopicId and Id of the Subscription are required to Update it. Allowed for End-users.

UPDATE ContentSubscriptions SET IncludeComments = false WHERE TopicId = '19209878690449' AND Id = '19209922023185'

Delete

To remove a subscription to a given topic, Id and TopicId columns are required. Allowed for End-users.

DELETE FROM ContentSubscriptions WHERE TopicId = '19209878690449' AND Id = '19209922023185'

To remove a subscription to a given post, Id and PostId columns are required. Allowed for End-users.

DELETE FROM ContentSubscriptions WHERE PostId = '19206579516945' AND Id = '19210420873745'

To remove the specified subscription from the specified section, Id, SectionId and Locale columns are required. Allowed for End-users.

DELETE FROM ContentSubscriptions WHERE SectionId = '19206579516945' AND Id = '19210420873745' AND Locale = 'en-us'

To remove the specified subscription from the specified article, Id, ArticleId and Locale columns are required. Allowed for End-users.

DELETE FROM ContentSubscriptions WHERE ArticleId = '19206609899793' AND Id = '19211885836945' AND Locale = 'en-us'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		Automatically assigned when the subscription is created.
UserId	String	False	Users.Id	The id of the user who has this subscription.
ContentId	Long	True		The id of the subscribed item.
ContentType	String	True		The type of the subscribed item.
IncludeComments	Boolean	False		Subscribe also to article comments/post comments. Only for section/topic subscriptions.
Locale	String	False		The locale of the subscribed item.
SourceLocale	String	False		Used only for Create Section Subscription and Create Article Subscription, where it's mandatory. Selects the locale of the content to be subscribed.
Url	String	True		The API url of the subscription.
CreatedAt	Datetime	True		The time at which the subscription was created.
UpdatedAt	Datetime	True		The time at which the subscription was last updated.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
TopicId	Long	Id of the Topic.
PostId	Long	Id of the Post.
SectionId	Long	Id of the Section.
ArticleId	Long	Id of the Article.

Create, Update, Delete and Query the Content Tags in Zendesk.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the Sync App.

SELECT * FROM ContentTags WHERE Id = '01HCCV8145J2MBX6XZ103G10CH'

Insert

The Name field is required to insert. Allowed for Guide managers and Guide agents.

INSERT INTO ContentTags (Name) VALUES ('Test')

Update

You must specify the Id of the ContentTag to update. Allowed for Guide managers.

UPDATE ContentTags SET Name = 'CData' WHERE Id = '01HCEJVFV4X9MA9D2SBC86FE5S'

Delete

You must specify the Id of the ContentTag to delete it. Allowed for Guide managers.

DELETE FROM ContentTags WHERE Id = '01HCEJVFV4X9MA9D2SBC86FE5S'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		Automatically assigned when the content tag is created.
Name	String	False		The name of the content tag.
CreatedAt	Datetime	True		When the content tag was created.
UpdatedAt	Datetime	True		When the content tag was last updated.

Create, Update, Delete and Query CustomAgentRoles in Zendesk.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the Sync App.

Allowed for Agents.

SELECT * FROM CustomAgentRoles

When Id is mention in the criteria, the query is allowed only for Administrators and Agents with the manage_roles permission.

SELECT * FROM CustomAgentRoles WHERE Id = '13575064971293'

Insert

The Name field is required to insert. Allowed for Administrators and Agents with the manage_roles permission.

INSERT INTO CustomAgentRoles (Name, Description, ConfigurationChatAccess, ConfigurationUserViewAccess) VALUES ('Test', 'Description', true, 'readonly')

Update

You must specify the Id of the CustomAgentRole to update it. All fields that are not readonly (readonly="false" in the table) are optional. Allowed for Administrators and Agents with the manage_roles permission.

UPDATE CustomAgentRoles SET Name = 'Updated Name', Description = 'Updated description', ConfigurationChatAccess = false, ConfigurationUserViewAccess = 'readonly' WHERE Id = '13575064971293'

Delete

You must specify the Id of the CustomAgentRole to delete it. Allowed for Administrators and Agents with the manage_roles permission.

DELETE FROM CustomAgentRoles WHERE Id = '13575064971293'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		Automatically assigned upon creation.
Name	String	False		Name of the custom role.
Description	String	False		A description of the role.
CreatedAt	Datetime	True		The time the record was created.
UpdatedAt	Datetime	True		The time the record was last updated.
ConfigurationChatAccess	Boolean	False		Boolean value that checks whether or not the agent has access to Chat.
ConfigurationEndUserProfileAccess	String	False		What the agent can do with end-user profiles. Allowed values are edit, edit-within-org, full, readonly.
ConfigurationForumAccess	String	False		The kind of access the agent has to Guide. Allowed values are edit-topics, full, readonly.
ConfigurationForumAccessRestrictedContent	Boolean	False		Configuration Forum Access Restricted Content.
ConfigurationMacroAccess	String	False		What the agent can do with macros. Allowed values are full, manage-group, manage-personal, readonly.
ConfigurationManageBusinessRules	Boolean	False		Whether or not the agent can create and manage schedules and view rules analysis.
ConfigurationManageDynamicContent	Boolean	False		Whether or not the agent can access dynamic content.
ConfigurationManageExtensionsAndChannels	Boolean	False		Whether or not the agent can manage channels and extensions.
ConfigurationManageFacebook	Boolean	False		Whether or not the agent can manage facebook pages.
ConfigurationOrganizationEditing	Boolean	False		Whether or not the agent can add or modify organizations.
ConfigurationReportAccess	String	False		What the agent can do with reports. Allowed values are full, none, readonly.
ConfigurationTicketAccess	String	False		What kind of tickets the agent can access. Allowed values are all, assigned-only, within-groups, within-groups-and-public-groups, within-organization.
ConfigurationTicketCommentAccess	String	False		What kind of tickets the agent can access. Allowed values are all, assigned-only, within-groups, within-groups-and-public-groups, within-organization.
ConfigurationTicketDeletion	Boolean	False		Whether or not the agent can delete tickets.
ConfigurationTicketMerge	Boolean	False		Whether or not the agent can merge tickets.
ConfigurationTicketTagEditing	Boolean	False		Whether or not the agent can edit ticket tags.
ConfigurationTwitterSearchAccess	Boolean	False		Configuration Twitter Search Access.
ConfigurationViewAccess	String	False		What the agent can do with views. Allowed values are full, manage-group, manage-personal, playonly, readonly.
ConfigurationUserViewAccess	String	False		What the agent can do with customer lists. Allowed values are full, manage-group, manage-personal, none, readonly.
ConfigurationAssignTicketsToAnyGroup	Boolean	False		Whether or not the agent can assign tickets to any group.
ConfigurationCustomObjects	String	False		A list of custom object keys mapped to JSON objects that define the agent's permissions (scopes) for each object. Allowed values: are read, update, delete, create. The read permission is required if any other scopes are specified.
ConfigurationEndUserListAccess	String	False		Whether or not the agent can view lists of user profiles. Allowed values are full, none.
ConfigurationExploreAccess	String	False		Allowed values are edit, full, none, readonly.
ConfigurationGroupAccess	Boolean	False		Whether or not the agent can add or modify groups.
ConfigurationLightAgent	Boolean	False		Configuration Light Agent.
ConfigurationManageAutomations	Boolean	False		Whether or not the agent can create and manage automations.
ConfigurationManageContextualWorkspaces	Boolean	False		Whether or not the agent can view, add, and edit contextual workspaces.
ConfigurationManageGroupMemberships	Boolean	False		Whether or not the agent can create and manage group memberships.
ConfigurationManageGroups	Boolean	False		Whether or not the agent can create and modify groups.
ConfigurationManageOrganizationFields	Boolean	False		Whether or not the agent can create and manage organization fields.
ConfigurationManageOrganizations	Boolean	False		Whether or not the agent can create and modify organizations.
ConfigurationManageRoles	String	False		Whether or not the agent can create and manage custom roles with the exception of the role they're currently assigned. Doesn't allow agents to update role assignments for other agents. Allowed values are all-except-self, none.
ConfigurationManageSkills	Boolean	False		Whether or not the agent can create and manage skills.
ConfigurationManageSlas	Boolean	False		Whether or not the agent can create and manage SLAs.
ConfigurationManageSuspendedTickets	Boolean	False		Whether or not the agent can manage suspended tickets.
ConfigurationManageTeamMembers	String	False		Whether or not the agent can manage team members. Allows agents to update role assignments for other agents. Allowed values are all-with-self-restriction, readonly, none.
ConfigurationManageTicketFields	Boolean	False		Whether or not the agent can create and manage ticket fields.
ConfigurationManageTicketForms	Boolean	False		Whether or not the agent can create and manage ticket forms.
ConfigurationManageTriggers	Boolean	False		Whether or not the agent can create and manage triggers.
ConfigurationManageUserFields	Boolean	False		Whether or not the agent can create and manage user fields.
ConfigurationModerateForums	Boolean	False		Configuration Moderate Forums.
ConfigurationOrganizationNotesEditing	Boolean	False		Whether or not the agent can add or modify organization notes.
ConfigurationSideConversationCreate	Boolean	False		Whether or not the agent can contribute to side conversations.
ConfigurationTicketEditing	Boolean	False		Whether or not the agent can edit ticket properties.
ConfigurationTicketRedaction	Boolean	False		Whether or not the agent can redact content from tickets. Only applicable to tickets permitted by ticket_access.
ConfigurationViewDeletedTickets	Boolean	False		Whether or not the agent can view deleted tickets.
ConfigurationVoiceAccess	Boolean	False		Whether or not the agent can answer and place calls to end users.
ConfigurationVoiceDashboardAccess	Boolean	False		Whether or not the agent can view details about calls on the Talk dashboard.
RoleType	Integer	True		The user's role id. It is 0 for a custom agent.
TeamMemberCount	Integer	True		The number of team members assigned to this role.

Defines the fields available for a custom object.

Table-Specific Information

Custom objects are configured using the CustomObjects and CustomObjectFields tables. The CustomObjects table essentially allows you to list and create custom objects, while the CustomObjectFields table allows you to query and modify the fields of the custom objects. Records within these custom objects are then queried and modified via tables with the "CustomObject_" prefix (see Working with Custom Object Records in CustomObjects).

Select

The ParentKey column is required to query the fields for a custom object.

SELECT * FROM CustomObjectFields WHERE ParentKey='Devices'

Insert

You must specify the ParentKey, Key, Title, and Type columns for each field inserted into a custom object.

Insert INTO CustomObjectFields (ParentKey, Key, Title, Type) values ('Devices', 'DeviceType', 'DeviceType', 'text')

Data Types for Inserting Custom Object Fields

Data types supported by the Custom Objects API include Text, TextArea, Checkbox, Date, Decimal, Dropdown, Integer, Lookup, Multiselect, and Regexp. Some data types require additional information, including Regexp, Dropdown, Lookup, and Multiselect.

Insert INTO CustomObjectFields (ParentKey, Key, Title, Description, Type) values ('Devices', 'TextType', 'TextType', 'Text type', 'Text')
Insert INTO CustomObjectFields (ParentKey, Key, Title, Description, Type) values ('Devices', 'TextareaType', 'TextareaType', 'Textarea type', 'Textarea')
Insert INTO CustomObjectFields (ParentKey, Key, Title, Description, Type) values ('Devices', 'CheckboxType', 'CheckboxType', 'Checkbox type', 'Checkbox')
Insert INTO CustomObjectFields (ParentKey, Key, Title, Description, Type) values ('Devices', 'DateType', 'DateType', 'Date type', 'Date')
Insert INTO CustomObjectFields (ParentKey, Key, Title, Description, Type) values ('Devices', 'IntegerType', 'IntegerType', 'Integer type', 'Integer')
Insert INTO CustomObjectFields (ParentKey, Key, Title, Description, Type) values ('Devices', 'DecimalType', 'DecimalType', 'Decimal type', 'Decimal')
Insert INTO CustomObjectFields (ParentKey, Key, Title, Description, Type, RegexpForValidation) values ('Devices', 'RegexpType', 'RegexpType', 'Regexp type', 'Regexp', '\b[0-9]{3}-[0-9]{2}-[0-9]{4}\b')
Insert INTO CustomObjectFields (ParentKey, Key, Title, Description, Type, CustomFieldOptions) values ('Devices', 'DropdownType', 'DropdownType', 'Dropdown type', 'Dropdown', '[{\"name\": \"options-1\", \"value\": \"option-1\"}]')
Insert INTO CustomObjectFields (ParentKey, Key, Title, Description, Type, RelationshipTargetType) values ('Devices', 'LookupType', 'LookupType', 'Lookup type', 'Lookup', 'zen:user')
Insert INTO CustomObjectFields (ParentKey, Key, Title, Description, Type, CustomFieldOptions) values ('Devices', 'MultiselectType', 'MultiselectType', 'Multiselect type', 'Multiselect', '[{\"name\\\": \"options-1\", \"value\": \"option-1\"}]')

Update

You must specify the ParentKey and Key columns to update a custom object field.

Update CustomObjectFields SET description='Updated description' WHERE ParentKey='Devices' AND Key='OSType'

Delete

You must specify the ParentKey and Key columns to delete a custom object field.

Delete FROM CustomObjectFields WHERE ParentKey='Devices' AND Key='OSType'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	False		Automatically assigned upon creation.
Key [KEY]	String	False		A unique key that identifies this custom field. This is used for updating the field and referencing in placeholders. The key must consist of only letters, numbers, and underscores. It can't be only numbers.
Active	Boolean	False		If true, this field is available for use.
ParentKey	String	False		The CustomObject Key which this field belongs to.
Description	String	False		User-defined description of this field's purpose.
RawDescription	String	False		The dynamic content placeholder, if present, or the description value, if not.
Title	String	False		The title of the custom field.
RawTitle	String	False		The dynamic content placeholder, if present, or the title value, if not.
Type	String	False		The custom field type: checkbox, date, decimal, dropdown, integer, lookup, multiselect, regexp, text, or textarea.
CreatedAt	String	False		The time of the last update of the ticket field.
Position	Long	False		Ordering of the field relative to other fields.
Properties	String	False		A set of properties which describe the standard::name field's autonumbering and uniqueness behavior. Autonumbering and uniqueness can't be used together.
RegexpForValidation	String	False		Regular expression field only. The validation pattern for a field value to be deemed valid.
RelationshipFilter	String	False		A filter definition that allows your autocomplete to filter down results.
RelationshipTargetType	String	False		A representation of what type of object the field references. Options are zen:user, zen:organization, zen:ticket, zen:article, and zen:custom_object:{key} where key is a custom object key.
System	Boolean	False		If true, only active and position values of this field can be changed.
Tag	String	False		Optional for custom field of type checkbox; not applicable otherwise.
CustomFieldOptions	String	False		Required and presented for a custom field of type dropdown. Each option is represented by an object with a name and value property.
UpdatedAt	String	False		The time of the last update of the ticket field.
Url	String	False		The URL for this resource.

Defines the custom objects available in the Zendesk account.

Table-Specific Information

Custom objects are configured using the CustomObjects and CustomObjectFields tables. The CustomObjects table essentially allows you to list and create custom objects, while the CustomObjectFields table allows you to query and modify the fields of the custom objects. Records within these custom objects are then queried and modified via tables with the "CustomObject_" prefix (see Working with Custom Object Records).

Tip: If custom objects are already defined in the Zendesk UI, you can query and modify records directly in the CustomObject_Name tables without needing to configure the corresponding tables.

Select

The following query shows all custom objects available in the account:

SELECT * FROM CustomObjects

Insert

You must specify the Key, Title, and TitlePluralized columns in order to create a new custom object.

Insert into CustomObjects (Key, Title, TitlePluralized, Description) values ('Devices', 'Device', 'Devices', 'Devices available')

Update

You must specify the Key column to update a custom object.

Update CustomObjects SET Description='Devices available in central office' WHERE Key='Devices'

Delete

You must specify the Key column to delete a custom object.

Delete FROM CustomObjects WHERE Key='Devices'

Working with Custom Object Records

Records within the custom objects are queried and modified via tables with the "CustomObject_" prefix. For example, a custom object within Zendesk named "Devices" will have the name "CustomObject_Devices". The columns available for the custom object are observable and modified via the CustomObjectFields table.

Select Custom Object Records

SELECT * FROM CustomObject_Devices

Insert Custom Object Records

You must specify a Name for each record within a custom object. Name and Description are standard columns available in all custom object tables. In the example below, the Units column is specific to this custom object and would be specified in the CustomObjectFields table.

Insert into CustomObject_Devices (Name, Description, Units) values ('WinPCs', 'Windows machines', 10)

Update Custom Object Records

You must specify the Id of a record to perform updates, which is a standard column across all custom object records.

Update CustomObject_Devices SET Description='Windows machines in storage' WHERE Id='01KE84AVNNH93GXYSCE6H0V74R'

Delete Custom Object Records

You must specify the Id of a record to delete it.

Delete FROM CustomObject_Devices WHERE Id='01KE84AVNNH93GXYSCE6H0V74R'

Columns

Name	Type	ReadOnly	References	Description
Key [KEY]	String	False		A user-defined unique identifier. Writable on create only.
Title	String	False		User defined display name for the object.
TitlePluralized	String	False		User defined pluralized version of the object's title.
RawTitle	String	False		The dynamic content placeholder, if present, or the Title value, if not.
RawTitlePluralized	String	False		The dynamic content placeholder, if present, or the RawTitlePluralized value, if not.
Description	String	False		User defined description of the object.
RawDescription	String	False		The dynamic content placeholder, if present, or the RawDescription value, if not.
CreatedAt	Datetime	False		The time the object type was created.
CreatedBy	Long	False	Users.Id	Id of a user who created the object.
CreatedVia	String	False		Source from which the object was created
UpdatedAt	Datetime	False		The time of the last update of the object.
UpdatedBy	Long	False	Users.Id	Id of the last user who updated the object.
AllowsAttachments	Boolean	False		If true, file attachments can be added to the object's records.
AllowsPhotos	Boolean	False		If true, photos can be uploaded to the records of the object.
IncludeInListView	Boolean	False		A flag setting the visibility of the object in the agent's list view.
Url	String	False		Direct link to the specific custom object.

Create, update, and query custom ticket statuses in zendesk.

Table Specific Information

Select

The following queries are processed server-side, while other filters are processed client-side in the Sync App.

SELECT * FROM CustomTicketStatuses WHERE Id = 9930628462492

Insert

INSERT INTO CustomTicketStatuses (active,agentlabel,description,enduserdescription,enduserlabel,statuscategory) VALUES ('true', 'Try to Respond quickly', 'Customer needs a response quickly', 'Your ticket is being responded to', 'Urgent processing', 'open')

Update

UPDATE CustomTicketStatuses SET description = 'Customer needs a response quickly.' WHERE Id = 9930628462492

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		Automatically assigned when the custom ticket status is created.
Active	Boolean	False		If true, the custom status is set to active, If false, the custom status is set to inactive.
URL	String	True		The label displayed to agents. Maximum length is 48 characters.
AgentLabel	String	False		The label displayed to agents. Maximum length is 48 characters.
Default	Boolean	False		If true, the custom status is set to default. If false, the custom status is set to non-default.
Description	String	False		The description of when the user should select this custom ticket status.
StatusCategory	String	False		The status category the custom ticket status belongs to. 使用できる値は次のとおりです。new, open, hold, pending, solved
EndUserLabel	String	False		The label displayed to end users. Maximum length is 48 characters.
EndUserDescription	String	False		The description displayed to end users.
RawAgentLabel	String	True		The dynamic content placeholder. If the dynamic content placeholder is not available, this is the agent_label value.
RawDescription	String	True		The dynamic content placeholder. If the dynamic content placeholder is not available, this is the raw_description value.
RawEndUserLabel	String	True		The dynamic content placeholder. If the dynamic content placeholder is not available, this is the raw_end_user_label value.
RawEndUserDescription	String	True		The dynamic content placeholder. If the dynamic content placeholder is not available, this is the raw_end_user_description value.
CreatedAt	Datetime	True		The date and time the custom ticket status was created.
UpdatedAt	Datetime	True		The time of the last update of the ticket field.

Create, delete, and query Group Memberships in Zendesk.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the Sync App.

SELECT * FROM GroupMemberships WHERE Id = '123'

SELECT * FROM GroupMemberships WHERE UserId = '123'

SELECT * FROM GroupMemberships WHERE GroupId = '123'

Insert

The UserId and GroupId fields are required to insert (assigns an agent to a given group). Allowed for admins.

INSERT INTO GroupMemberships (UserId, GroupId) VALUES ('72', '88')

Delete

You must specify the Id of the membership to delete it (immediately removes a user from a group and schedules a job to unassign all working tickets that are assigned to the given user and group combination). Allowed for admins.

DELETE FROM GroupMemberships WHERE Id = '123'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		Automatically assigned when the ticket is created.
UserId	Long	False	Users.Id	The id of an agent.
GroupId	Long	False	Groups.Id	The id of a group.
Default	Boolean	False		If true, tickets assigned directly to the agent will assume this membership's group.
CreatedAt	Datetime	True		The time the membership was created.
UpdatedAt	Datetime	True		The time of the last update of the membership.
Url	String	True		The API url of this record.

Create, update, delete, and query Groups in Zendesk.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the Sync App.

SELECT * FROM Groups WHERE Id = '123'

SELECT * FROM Groups WHERE UserId = '123'

Insert

The Name field is required to insert. Allowed for admins.

INSERT INTO Groups (Name) VALUES ('My Group')

Update

You must specify the Id of the group to update it. All fields that are not readonly (readonly="false" in the table) are optional. Allowed for admins.

UPDATE Groups SET Name = 'Interesting Group' WHERE Id = '123'

Delete

You must specify the Id of the group to delete it. Note that you cannot delete the default group of the account. Allowed for admins.

DELETE FROM Groups WHERE Id = '123'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		Automatically assigned when the ticket is created.
Name	String	False		The name of the group.
CreatedAt	Datetime	True		The time the group was created.
UpdatedAt	Datetime	True		The time of the last update of the group.
Deleted	Boolean	True		Deleted groups get marked as such.
Url	String	True		The API url of this group.
UserId	Long	False		The user id used to query groups.

Create, Update, Delete and Query Group SLA Policies in Zendesk.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the Sync App.

SELECT * FROM GroupSlaPolicies

SELECT * FROM GroupSlaPolicies WHERE Id = '01HXV0PT0DMK4MTFNK9Y6ENFJA'

Insert

The Title and Filter fields are required to insert. Allowed for admins.

INSERT INTO GroupSlaPolicies (Title, Description, Position, Filter) VALUES('Title test', 'desc' ,3, '{"all":[{"field":"group_id","operator":"includes","value":[9634300495132]}]}

Update

You must specify the Id of the GroupSlaPolicy to update. Allowed for admins.

UPDATE GroupSlaPolicies SET Title = 'Updated title' WHERE Id = '01HXV6JCGCDZGJ851VPQZWMG1E'

Delete

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

DELETE FROM GroupSlaPolicies WHERE Id = '01HXV6JCGCDZGJ851VPQZWMG1E'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		Automatically assigned when created.
Title	String	False		The title of the Group SLA policy.
Position	Integer	False		Position of the Group SLA policy. This position determines the order in which policies are matched to tickets. If not specified, the Group SLA policy is added at the last position.
Description	String	False		The description of the Group SLA policy.
PolicyMetrics	String	False		Array of policy metric objects.
CreatedAt	Datetime	True		The time the Group SLA policy was created.
UpdatedAt	Datetime	True		The time of the last update of the Group SLA policy.
Filter	String	False		An object that describes the conditions a ticket must match for a Group SLA policy to be applied to the ticket.
Url	String	True		URL of the Group SLA policy record.

Create, update, delete, and query Schedules in Zendesk.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the Sync App.

SELECT * FROM Holidays WHERE ScheduleId = '123'

SELECT * FROM Holidays WHERE ScheduleId = '123' AND Id = '456'

Insert

The ScheduleId, Name, StartDate and EndDate fields are required to insert. Allowed for admins.

INSERT INTO Holidays (ScheduleId, Name, StartDate, EndDate) VALUES ('360000022454', 'Christmas', '2016-12-25', '2016-12-25')

Update

You must specify the ScheduleId and Id of the holiday to update.Allowed for admins.

UPDATE Holidays SET Name = 'Christmas', StartDate = '2018-12-25', EndDate = '2018-12-25'  WHERE ScheduleId = '123' AND Id = '456'

Delete

You must specify the ScheduleId and Id of the holiday to delete it. Allowed for admins.

DELETE FROM Holidays WHERE ScheduleId = '123' AND Id = '456'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		Automatically assigned upon creation.
ScheduleId	Long	False	Schedules.Id	Id of the schedule the holiday belongs to.
Name	String	False		Name of the holiday.
StartDate	Date	False		Time when the holiday starts.
EndDate	Date	False		Time when the holiday ends.

View and create links between your Jira and Zendesk instances.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the Sync App.

SELECT * FROM JiraLinks WHERE Id = 123
SELECT * FROM JiraLinks WHERE TicketId = 123
SELECT * FROM JiraLinks WHERE IssueId = 123

Insert

The Name and Subdomain fields are required to insert. Allowed for admins.

INSERT INTO JiraLinks (TicketId, IssueId, IssueKey) VALUES (1, 1, 'TP-1')

Delete

You must specify the Id of the automation to delete it. Allowed for agents.

DELETE FROM JiraLinks WHERE Id = 123

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Integer	True		Automatically assigned when the link is created.
TicketId	Integer	False	Tickets.Id	The id of the Zendesk ticket.
IssueId	Integer	False		The id of the Jira issue.
IssueKey	String	False		The key for the Jira issue.
CreatedAt	Datetime	True		The time at which the link was created.
UpdatedAt	Datetime	True		The time at which the link was last updated.

Create, delete, update, and query Legacy Custom Objects in Zendesk.

The legacy custom objects API is deprecated and has limited access. Accounts not already using the legacy API cannot start using it. Beginning January 2026, accounts already utilizing the legacy API will no longer be able to create new objects. Beginning June 2026, the legacy API will be sunset entirely.

Select

The LegacyCustomObjects table supports the ObjectName column in the WHERE clause. This table supports the following operator: '='. For example:

SELECT * FROM LegacyCustomObjects WHERE ObjectName = 'house'

Insert

You can insert any field into the LegacyCustomObjects table that is not read-only. To insert Properties details for a custom object, use the #TEMP table to insert the fields of the property. The fields of the Property are present in the LegacyCustomObjectField view. For Example:

INSERT INTO LegacyCustomObjectField#TEMP (FieldName, Type, Description, Required) VALUES ('NumOfRooms', 'integer', 'The number of rooms.', true)
INSERT INTO LegacyCustomObjectField#TEMP (FieldName, Type, Description, Required) VALUES ('NumOfBaths', 'integer', 'The number of baths.', true)
INSERT INTO LegacyCustomObjectField#TEMP (FieldName, Type, Description, Required) VALUES ('Balcony', 'boolean', 'Whether or not balcony is there.', true)
INSERT INTO LegacyCustomObjectField#TEMP (FieldName, Type, Description) VALUES ('PropertyAge', 'string', 'Old or new construction.')
INSERT INTO LegacyCustomObjects (ObjectName, Properties) VALUES ('house', LegacyCustomObjectField#TEMP)

Update

You can update only Properties column in the LegacyCustomObjects Table. To update the properties details for a custom object, Use the #TEMP table to insert the fields of the property. The fields of the Property is present in LegacyCustomObjectField view.

INSERT INTO LegacyCustomObjectField#TEMP (FieldName, Type, Description, Required) VALUES ('CarParking', 'string', 'Whether or not car parking is available', true)");
INSERT INTO LegacyCustomObjectField#TEMP (FieldName, Required) VALUES ('balcony', false)");
UPDATE LegacyCustomObjects SET Properties = 'LegacyCustomObjectField#TEMP' WHERE ObjectName = 'house'");

Delete

To delete a Custom Object, the ObjectName is required.

DELETE FROM LegacyCustomObjects WHERE ObjectName = 'house'

Columns

Name	Type	ReadOnly	References	Description
ObjectName [KEY]	String	False		A user-defined unique identifier. Writable on create only.
CreatedAt	Datetime	True		The time the object type was created.
UpdatedAt	Datetime	True		The time of the last update of the object type.
Version	String	False		The version of this schema.
Properties	String	False		A description of the object record, up to a maximum of 32 KB.

Create, update, delete, and query Macros in Zendesk.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the Sync App.

SELECT * FROM Macros WHERE Id = '123'

SELECT * FROM Macros WHERE Active = true

SELECT * FROM Macros ORDER BY CreatedAt

SELECT * FROM Macros ORDER BY UpdateddAt

Insert

The Title and Actions fields are required to insert. Allowed for agents.

INSERT INTO Macros (Title, Actions) VALUES ('Roger Wilco II', '[{\"field\": \"status\", \"value": \"solved\"}]')

Update

You must specify the Id of the macro to update. Updating an action updates the containing array, clearing the other actions. Include all your actions when updating any action.Allowed for agents.

UPDATE Macros SET Title = 'Roger Wilco III' WHERE Id = '123'

Delete

You must specify the Id of the macro to delete it. Allowed for agents.

DELETE FROM Macros WHERE Id = '123'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	False		Automatically assigned when created.
Title	String	False		The title of the macro.
Actions	String	False		An object describing what the macro will do.
Active	Boolean	False		Useful for determining if the macro should be displayed.Only active macros if true, inactive macros if false.
Description	String	False		The description of the macro.
Position	Integer	False		The position of the macro.
Restrictions	String	False		Who may access this macro. Will be null when everyone in the account can access it.
CreatedAt	Datetime	False		The time the macro was created.
UpdatedAt	Datetime	False		The time of the last update of the macro.
Access	String	False		Only macros with given access. Possible values are personal, shared, or account.
Category	String	False		Only macros within given category.
GroupId	Long	False	Groups.Id	Only macros belonging to given group.
OnlyViewable	Boolean	False		Only macros that can be applied to tickets if true, All macros the current user can manage if false. Defaults to false.
Attachments	String	False		An array of macro attachment IDs to be associated with the macro, used in Insertion

Create, Update, Delete and Query the Management Permission Groups in Zendesk. A management permission group defines which agents can create, update, archive, and publish articles. It consists of a set of privileges, each of which is mapped to a user segment. Agents receive whichever privileges are associated with the user segments they belong to.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the Sync App.

SELECT * FROM ManagementPermissionGroups WHERE Id = '19162149101585'

Insert

The Name column is required to insert. All fields that are not readonly (readonly="false" in the table) are optional for insert. Allowed for Help Center managers.

INSERT INTO ManagementPermissionGroups (Name, Edit) VALUES ('Test', '19162093613969, 19236810082193')

Update

You must specify the Id of the ManagementPermissionGroup to update. All fields that are not readonly (readonly="false" in the table) are optional for insert. Allowed for Help Center managers.

UPDATE ManagementPermissionGroups SET Name = 'UpdatedName' WHERE Id = '19239392699537'

Delete

You must specify the Id of the ManagementPermissionGroup to delete it. Allowed for Help Center managers.

DELETE FROM ManagementPermissionGroups WHERE Id = '19239392699537'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		Automatically assigned when the permission group is created.
BuiltIn	Boolean	True		Whether the permission group is built-in. Built-in permission groups cannot be modified.
Name	String	False		Permission group name.
Edit	String	False		The ids of user segments that have edit privileges. For insertion and updation provide these values separated by comma.
Publish	String	False		The ids of user segments that have publish privileges. For insertion and updation provide these values separated by comma.
CreatedAt	Datetime	True		When the permission group was created.
UpdatedAt	Datetime	True		When the permission group was last updated.

Create, update, delete, and query Organization Fields in Zendesk.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the Sync App.

SELECT * FROM OrganizationFields WHERE Id = '123'

Insert

The Type, Title, and Key fields are required to insert. The types of custom fields that can be created are the following: text (default when no Type is specified), textarea, checkbox, date, integer, decimal, and regex (when Type is regex, RegexpForValidation is required too). Allowed for admins.

INSERT INTO OrganizationFields (Type, Title, Key) VALUES ('text', 'Support description', 'support_description')

You can also create Lookup Relationships. A lookup relationship field is a custom field whose type is "lookup". This type of custom field gives you the ability to create a relationship from a source object to a target object. To create a lookup relationship fields, Type, Key and RelationshipTargetType columns are required. The Type column value must be "lookup". A suitable combination of Field, Operator and Value is required for insertion in RelationshipFilterAll and RelationshipFilterAny. Here is a list of the possible combinations: "https://developer.zendesk.com/documentation/ticketing/reference-guides/conditions-reference/#shared-conditions".

INSERT INTO OrganizationFieldsRelationshipFilterAll#temp (Field, Operator, Value) VALUES ('status', 'less_than', 'solved')
INSERT INTO OrganizationFieldsRelationshipFilterAny#temp (Field, Operator, Value) VALUES ('status', 'less_than', 'solved')
INSERT INTO OrganizationFields (Type, Title, Key, RelationshipTargetType, RelationshipFilterAll, RelationshipFilterAny) VALUES ('lookup', 'Support description', 'support_description5', 'zen:ticket', 'OrganizationFieldsRelationshipFilterAll#temp', 'OrganizationFieldsRelationshipFilterAny#temp')

Update

You must specify the Id of the organization field to update. All fields that are not readonly (readonly="false" in the table) are optional. Allowed for admins.

UPDATE OrganizationFields SET Title = 'Updated title' WHERE Id = '123'

Delete

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

DELETE FROM OrganizationFields WHERE Id = '123'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	False		Automatically assigned upon creation.
Key	String	False		A unique key that identifies this custom field. Required on create.This is used for updating the field and referencing in placeholders. After a field is created, you cannot change its key.
Type	String	False		Type of the custom field: checkbox, date, decimal, dropdown, integer, regexp, text, or textarea. After a field is created, you cannot change its type.
Title	String	False		The title of the custom field.
RawTitle	String	False		The dynamic content placeholder, if present, or the title value, if not.
Description	String	False		User-defined description of this field s purpose.
RawDescription	String	False		The dynamic content placeholder, if present, or the description value, if not.
Position	Integer	False		Ordering of the field relative to other fields.
Active	Boolean	False		If true, this field is available for use.
System	Boolean	False		If true, only active and position values of this field can be changed.
RegexpForValidation	String	False		Regular expression field only. The validation pattern for a field value to be deemed valid.
CreatedAt	Datetime	False		The time the ticket field was created.
UpdatedAt	Datetime	False		The time of the last update of the ticket field.
Tag	String	False		Optional for custom field of type checkbox; not presented otherwise.
CustomFieldOptions	String	False		Required and presented for a custom field of type dropdown.
Url	String	False		The URL for this resource.
RelationshipFilterAll	String	False		A filter definition that allows your autocomplete to filter down results with Logical AND.
RelationshipFilterAny	String	False		A filter definition that allows your autocomplete to filter down results with Logical OR.
RelationshipTargetType	String	False		A representation of what type of object the field references. Options are zen:user, zen:organization, zen:ticket, or zen:custom_object:CUSTOM_OBJECT_KEY. For example zen:custom_object:apartment.

Create, delete, and query Organization Memberships in Zendesk.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the Sync App.

SELECT * FROM OrganizationMemberships WHERE Id = '123'

SELECT * FROM OrganizationMemberships WHERE UserId = '123'

SELECT * FROM OrganizationMemberships WHERE OrganizationId = '123'

Insert

The The UserId and OrganizationId fields are required to insert (assigns a user to a given organization). Allowed for agents.

INSERT INTO OrganizationMemberships (UserId, OrganizationId) VALUES ('772', '881')

Delete

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

DELETE FROM OrganizationMemberships WHERE Id = '123'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		Automatically assigned when the membership is created.
OrganizationId	Long	False	Organizations.Id	The ID of the organization associated with this user, in this membership.
UserId	Long	False	Users.Id	The ID of the user for whom this memberships belongs.
Default	Boolean	False		Denotes whether this is the default organization membership for the user. If false, returns null.
CreatedAt	Datetime	False		When this record was created.
UpdatedAt	Datetime	False		When this record last got updated.
Url	String	False		The url of this resource.

Create, delete, update, and query Organizations in Zendesk.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the Sync App.

SELECT * FROM Organizations WHERE Id = '123'

SELECT * FROM Organizations WHERE Id IN ('123', '456')

SELECT * FROM Organizations WHERE UserId = '123'

Insert

The Name field is required to insert. Allowed for admins. Note: You must provide a unique name for each organization. Normally the system does not allow records to be created with identical names. However, a race condition can occur if you make two or more identical POSTs very close to each other, causing the records to have identical organization names.

INSERT INTO Organizations (Name) VALUES ('My Organization')

To create many organizations see the Batch Processing section for an example.

Update

You must specify the Id of the organization to update it. All fields that are not readonly (readonly="false" in the table) are optional. Allowed for admins.

UPDATE Organizations SET Notes = 'Something interesting' WHERE Id = '123'

To make the same change to multiple organizations, use the following Sql statement:

UPDATE Organizations SET Notes = 'Something interesting' WHERE Id IN ('123', '456')

To make different changes to multiple organizations, see Batch Processing for an example.

Delete

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

DELETE FROM Organizations WHERE Id = '123'

You can delete many organizations simultaneously by providing their ids:

DELETE FROM Organizations WHERE Id IN ('123', '456')

You can also delete many organizations simultaneously by using Batch Processing.

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		Automatically assigned when the ticket is created.
Name	String	False		A unique name for the organization.
GroupId	Long	False	Groups.Id	New tickets from users in this organization are automatically put in this group.
ExternalId	String	False		A unique external id to associate organizations to an external record.
CreatedAt	Datetime	True		The time the organization was created.
UpdatedAt	Datetime	True		The time of the last update of the organization.
DomainNames	String	False		An array of domain names associated with this organization.
Details	String	False		Any details obout the organization, such as the address.
Notes	String	False		Any notes you have about the organization.
SharedTickets	Boolean	False		End users in this organization are able to see tickets of each other.
SharedComments	Boolean	False		End users in this organization are able to see comments on tickets of each other.
Tags	String	False		The tags of the organization.
Url	String	True		The URL for this resource.
UserId	Long	False		The user id used to query organizations.

Create, delete, and query Organization Subscriptions in Zendesk.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the Sync App.

SELECT * FROM OrganizationSubscriptions WHERE Id = '123'

SELECT * FROM OrganizationSubscriptions WHERE UserId = '123'

SELECT * FROM OrganizationSubscriptions WHERE OrganizationId = '123'

Insert

The UserId and OrganizationId fields are required to insert. End users can only subscribe to shared organizations in which they're members. Allowed for agents and end users.

INSERT INTO OrganizationSubscriptions (UserId, OrganizationId) VALUES ('772', '881')

Delete

You must specify the Id of the subscription to delete it. Allowed for agents and end users.

DELETE FROM OrganizationSubscriptions WHERE Id = '123'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		Organization subscription id.
OrganizationId	Long	False	Organizations.Id	.
UserId	Long	False		.
CreatedAt	Datetime	True		.
Url	String	True		The url of this resource.

Query, Insert, Update and Delete PostComments in Zendesk.

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		Automatically assigned when the comment is created.
Url	String	True		The API url of the comment.
HtmlUrl	String	True		The community url of the comment.
Body	String	False		The comment made by the author.
AuthorId	Long	True		The id of the author of the comment. *Writable on create by Help Center managers.
PostId	Long	True	Posts.Id	The id of the post on which the comment was made.
Official	Boolean	False		Whether the comment is marked as official.
VoteSum	Integer	True		The sum of upvotes (+1) and downvotes (-1), which may be positive or negative.
VoteCount	Integer	True		The total number of upvotes and downvotes.
CreatedAt	Datetime	True		The time the post was created.
UpdatedAt	Datetime	True		The time of the last update of the post.

Query, Insert, Update and Delete Posts in Zendesk.

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		Automatically assigned when the post is created.
Url	String	True		The API url of the post.
HtmlUrl	String	True		The community url of the post.
Title	String	False		The title of the post.
Details	String	False		The details of the post.
AuthorId	Long	True		The id of the author of the post. *Writable on create by Help Center managers.
Pinned	Boolean	False		When true, pins the post to the top of its topic.
Featured	Boolean	False		Whether the post is featured.
Closed	Boolean	False		Whether further comments are allowed.
Status	String	False		The status of the post. Possible filter values include planned, not_planned, completed, answered or none.
VoteSum	Integer	True		The sum of upvotes (+1) and downvotes (-1), which may be positive or negative.
VoteCount	Integer	True		The total number of upvotes and downvotes.
CommentCount	Integer	True		The number of comments on the post.
FollowerCount	Integer	True		The number of followers of the post.
TopicId	Long	False	Topics.Id	The id of the topic that the post belongs to.
CreatedAt	Datetime	True		The time the post was created.
UpdatedAt	Datetime	True		The time of the last update of the post.

Create and query Requests in Zendesk.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the Sync App.

SELECT * FROM SatisfactionRatings WHERE Id = '123'

Insert

The TicketId and Score fields are required to insert. Creates a CSAT rating for solved tickets, or for tickets that were previously solved and then reopened. Allowed for an end user who requested the ticket.

INSERT INTO SatisfactionRatings (TicketId, Score) VALUES ('12', 'good')

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	False		Automatically assigned upon creation.
TicketId	Integer	False	Tickets.Id	The id of ticket being rated.
Score	String	False		The rating: offered, unoffered, good or bad. When used in a filter it takes one of values: offered, unoffered, received, received_with_comment, received_without_comment, good, good_with_comment, good_without_comment, bad, bad_with_comment, bad_without_comment.
Comment	String	False		The comment received with this rating, if available.
Reason	String	False		The reason for a bad rating given by the requester in a follow-up question. Satisfaction reasons must be enabled.
AssigneeId	Long	False	Users.Id	The id of agent assigned to at the time of rating.
GroupId	Long	False	Groups.Id	The id of group assigned to at the time of rating.
RequesterId	Long	False	Users.Id	The id of ticket requester submitting the rating.
CreatedAt	Datetime	False		The time the satisfaction rating got created.
UpdatedAt	Datetime	False		The time the satisfaction rating got updated.
Url	String	False		The API url of this rating.
StartTime	Datetime	False		Time of the oldest satisfaction rating.
EndTime	Datetime	False		Time of the most recent satisfaction rating.

Create, update, delete and query Schedules in Zendesk.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the Sync App.

SELECT * FROM Schedules WHERE Id = '123'

Insert

The Name and TimeZone fields are required to insert. Allowed for admins.

INSERT INTO Schedules (Name, TimeZone) VALUES ('test', 'Eastern Time (US & Canada)')

Update

You must specify the Id of the schedule to update. Allowed for admins.

UPDATE Schedules SET Name = 'EMEA', TimeZone = 'London' WHERE Id = '123'

You can update the intervals of a Schedule by issuing a separate Update statement.

UPDATE Schedules SET Intervals = '[{\"start_time\": 3420, \"end_time\": 3900}]' WHERE Id = '123'

Delete

You must specify the Id of the macro to delete it. Allowed for agents.

DELETE FROM Schedules WHERE Id = '123'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		Automatically assigned upon creation.
Name	String	False		Name of the schedule.
TimeZone	String	False		Time zone of the schedule.
Intervals	String	False		Array of intervals for the schedule.
CreatedAt	Datetime	True		Time the schedule was created.
UpdatedAt	Datetime	True		Time the schedule was last updated.

Create, update, delete, and query Sections in Zendesk.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the Sync App.

SELECT * FROM Sections WHERE Id = '13647896255645'
SELECT * FROM Sections WHERE Locale = 'en-us'
SELECT * FROM Sections WHERE Locale = 'en-us' AND Id = '13647896255645'
SELECT * FROM Sections WHERE CategoryId = '13625283663133'
SELECT * FROM Sections WHERE Locale = 'en-us' AND CategoryId = '13625283663133'

Insert

The Name and CategoryId columns are required to insert. All fields that are not readonly (readonly="false" in the table) are optional. Allowed for Agents.

INSERT INTO Sections (Name, CategoryId) VALUES ('Test CData', '13626588262429')

Update

You must specify the Id of the Section to update. It updates the section-level data such as Name, Description, Position, CategoryId, ParentSectionId and ThemeTemplate. All fields that are not readonly (readonly="false" in the table) are optional. Allowed for Help Center managers.

UPDATE Sections SET Name = 'UpdatedName' WHERE Id = '13647896255645'

Delete

You must specify the Id of the Section to delete it. Allowed for Help Center managers.

DELETE FROM Sections WHERE Id = '13647939064221'
DELETE FROM Sections WHERE Id = '13647939064221' AND Locale = 'en-us'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		Automatically assigned when creating subscriptions.
CategoryId	Long	False	Categories.Id	The id of the category to which this section belongs.
Name	String	False		The name of the section.
Description	String	False		The description of the section.
Locale	String	False		The locale in which the section is displayed.
ParentSectionId	Long	False		The id of the section to which this section belongs. Only writable for Guide Enterprise customers.
CreatedAt	Datetime	True		The time at which the section was created.
UpdatedAt	Datetime	True		The time at which the section was last updated.
Url	String	True		The API url of this section.
HtmlUrl	String	True		The url of this section in Help Center.
Outdated	Boolean	True		Whether the section is out of date.
Position	Integer	False		The position of this section in the section list. Used when sorting is set to manual. By default the section is added to the end of the list.
SourceLocale	String	True		The source (default) locale of the section.
ThemeTemplate	String	False		The theme template name used to display this section in Help Center.
Sorting	String	False		The type of sorting.

Create, Update, Delete and Query the Translations for Sections in Zendesk.

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		Automatically assigned when a translation is created.
CreatedById	Long	True		The id of the user who created the translation.
UpdatedById	Long	True		The id of the user who last updated the translation.
SectionId	Long	True	Sections.Id	The id of the item that has this translation.
Title	String	False		The title of the translation.
Body	String	False		HTML body of the translation. Empty by default.
Draft	Boolean	False		True if the translation is a draft; false otherwise. False by default.
HtmlUrl	String	True		The url of the translation in Help Center.
Locale	String	False		The locale of the translation.
Outdated	Boolean	False		True if the translation is outdated; false otherwise. False by default.
SourceType	String	True		The type of the item that has this translation. Can be article, section, or category.
Url	String	True		The API url of the translation.
CreatedAt	Datetime	True		The time at which the translation was created.
UpdatedAt	Datetime	True		The time at which the translation was last updated.

Query and delete Sessions in Zendesk.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the Sync App.

SELECT * FROM Sessions WHERE Userid = '123'

Delete

You must specify the UserId and Id of the session to delete it. Allowed for admins, agents, end users.

DELETE FROM Sessions WHERE Userid = '123' AND Id = '456'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		Automatically assigned when the session is created.
UserId	Long	True	Users.Id	The id of the user.
AuthenticatedAt	Datetime	True		When the session was created.
LastSeenAt	Datetime	True		The last approximate time this session was seen. This does not update on every request.
Url	String	True		The API URL of this session.

Create, update, delete, and query SharingAgreements in Zendesk.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the Sync App.

SELECT * FROM SharingAgreements WHERE Id = '123'

Insert

The RemoteSubdomain field is required to insert. Allowed for agents.

INSERT INTO SharingAgreements (RemoteSubdomain) VALUES ('Foo')

Update

You must specify the Id of the SharingAgreement to update. Only Status is allowed to be updated. Allowed for agents.

UPDATE SharingAgreements SET Status = 'accepted' WHERE Id = '123'

Delete

You must specify the Id of the SharingAgreement to delete it. Allowed for agents.

DELETE FROM SharingAgreements WHERE Id = '123'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		Automatically assigned upon creation.
Name	String	False		Name of this sharing agreement.
Type	String	False		Can be one of the following: 'inbound', 'outbound'.
Status	String	False		Can be one of the following: 'accepted', 'declined', 'pending', 'inactive'.
PartnerName	String	False		Can be one of the following: 'jira', null.
RemoteSubdomain	String	False		Subdomain of the remote account or null if not associated with an account.
CreatedAt	Datetime	True		The time the record was created.

Create, update and query Side Conversations in Zendesk.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the Sync App.

At least TicketId is required in order to retrieve the SideConversations.

SELECT * FROM SideConversations WHERE TicketId = 1
SELECT * FROM SideConversations WHERE TicketId = 1 AND Id = '5d133b65-576c-11ee-bcb2-bdce8f618e59'

Insert

The Columns TicketId, Subject, PreviewText and Participants are required to insert. Allowed for Agents.

INSERT INTO SideConversationParticipants#temp (Email,Name) VALUES ('[email protected]', 'someone')
INSERT INTO SideConversations (TicketId, Subject, PreviewText, Participants) VALUES (1, 'Test Subject', 'Test Body', 'SideConversationParticipants#temp')

You can also reply to a side conversation. The Columns Id, TicketId, Subject, PreviewText and Participants are required for Reply on a particular SideConversation. Allowed for Agents.

INSERT INTO SideConversationParticipants#temp (Email,Name) VALUES ('[email protected]', 'someone')
INSERT INTO SideConversations (Id, TicketId, Subject, PreviewText, Participants) VALUES ('5d133b65-576c-11ee-bcb2-bdce8f618e59', 2, 'Test Reply', 'Body for Reply message', 'SideConversationParticipants#temp')

Update

You must specify the TicketId and Id of the SideConversation to update. It only updates the State and Subject columns. All fields that are not readonly (readonly="false" in the table) are optional. Allowed for Agents.

UPDATE SideConversations SET State = 'open' WHERE Id = '5d133b65-576c-11ee-bcb2-bdce8f618e59' AND TicketId = 1

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	False		Automatically assigned when the side conversation is created.
TicketId	Integer	False	Tickets.Id	The parent ticket id of the side conversation.
ExternalIds	String	False		A key-value store of metadata. All values must be strings.
Subject	String	False		The subject of the side conversation.
CreatedAt	Datetime	True		The time the side conversation was created.
UpdatedAt	Datetime	True		The time the side conversation was created.
MessageAddedAt	Datetime	True		The time of the last message on the side conversation.
Participants	String	False		An array of participants in the side conversation.
PreviewText	String	False		A plain text text describing the side conversation.
State	String	False		The state of the side conversation.
StateUpdatedAt	Datetime	True		The time of the update of the state of the side conversation.
Url	String	True		The API url of the side conversation.

Create, update, delete, and query SlaPolicies in Zendesk.

Table Specific Information

Select

The following queries are processed server-side while other filters are processed client-side within the Sync App.

SELECT * FROM SlaPolicies
SELECT * FROM SlaPolicies WHERE Id = '18393257431953'

Insert

The Title field and atleast one field from either FilterAll or FilterAny is required to insert. A suitable combination of Field, Operator and Value is required for insertion in FilterAll and FilterAny. Here is a list of the possible combinations: "https://developer.zendesk.com/documentation/ticketing/reference-guides/conditions-reference/#shared-conditions". Allowed for admins.

INSERT INTO SlaPoliciesFilterAll#temp(Field, Operator, Value) VALUES('type', 'is', 'incident')
INSERT INTO SlaPoliciesFilterAny#temp(Field, Operator, Value) VALUES('type', 'is', 'problem')
INSERT INTO SlaPolicies(Title, Description, FilterAll, FilterAny) values('Test', 'This is the test description', 'SlaPoliciesFilterAll#temp', 'SlaPoliciesFilterAny#temp')

Update

You must specify the Id of the SlaPolicies to update it. FilterAll and FilterAny aggregate columns support duplicate values in the object, so in order to update these fields, you must specifty the whole aggregate object. All fields that are not readonly (readonly="false" in the table) are optional. Allowed for admins.

INSERT INTO SlaPoliciesFilterAll#temp(Field, Operator, Value) Values('type', 'is', 'task')
INSERT INTO SlaPoliciesFilterAll#temp(Field, Operator, Value) Values('type', 'is', 'incident')
INSERT INTO SlaPoliciesFilterAll#temp(Field, Operator, Value) Values('group_id', 'is', '18285074736529')
UPDATE SlaPolicies SET Title='Updated Title', FilterAll='SlaPoliciesFilterAll#temp' WHERE Id = '18393257431953'

Delete

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

DELETE FROM SlaPolicies WHERE Id=18392949131793

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		Automatically assigned.
Title	String	False		The title of the SLA policy.
Description	String	False		The description of the SLA policy.
CreatedAt	Datetime	True		When this locale was created.
UpdatedAt	Datetime	True		When this locale was last updated.
Position	Integer	True		Position of the SLA policy, determines the order they will be matched. If not specified, SLA Policy is added as the last position.
FilterAll	String	False		An object that describes the conditions that a ticket must match in order for an SLA policy to be applied to that ticket.
FilterAny	String	False		An object that describes the conditions that a ticket must match in order for an SLA policy to be applied to that ticket.
PolicyMetrics	String	False		An object that describes the metric targets for each value of the priority field.

Create, update, delete, and query Support Addresses in Zendesk.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the Sync App.

SELECT * FROM SupportAddresses WHERE Id = '123'

Insert

The Email field is required to insert (only adding a Zendesk support address to your account is supported). To add a Zendesk address, use the following syntax: {local-part}@{accountname}.zendesk.com. Example: '[email protected]'. The local-part can be anything you like. Allowed for admins.

INSERT INTO SupportAddresses  (Email) VALUES ('[email protected]')

Update

You must specify the Id of the support address to update. Allowed for admins.

UPDATE SupportAddresses SET Name = 'Sales' WHERE Id = '123'

Delete

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

DELETE FROM SupportAddresses WHERE Id = '123'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		Automatically assigned when created.
Name	String	False		The name for the address.
Email	String	False		The email address (not updateable).
CreatedAt	Datetime	True		The time the brand was created.
UpdatedAt	Datetime	True		The time of the last update of the brand.
Default	Boolean	False		Whether the address is the account's default support address.
BrandId	Long	False	Brands.Id	The id of the brand.
ForwardingStatus	String	True		Possible values: unknown, waiting, verified, or failed.
SpfStatus	String	True		Possible values: unknown, verified, failed.

Query and delete Suspended Tickets in Zendesk.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the Sync App.

SELECT * FROM SuspendedTickets WHERE Id = '123'

SELECT * FROM SuspendedTickets ORDER BY AuthorEmail

SELECT * FROM SuspendedTickets ORDER BY Cause

SELECT * FROM SuspendedTickets ORDER BY Subject

SELECT * FROM SuspendedTickets ORDER BY CreatedAt

Delete

You must specify the Id of the suspended ticket to delete it. Allowed for unrestricted agents.

DELETE FROM SuspendedTickets WHERE Id = '123'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		Automatically assigned when the ticket is created.
TicketId	Integer	True	Tickets.Id	The ticket ID this suspended email is associated with, if available.
MessageId	String	True		The ID of the email, if available.
BrandId	Long	True	Brands.Id	The id of the brand this ticket is associated with - only applicable for enterprise accounts.
Recipient	String	True		The original recipient e-mail address of the ticket.
Subject	String	True		The value of the subject field for this ticket.
Content	String	True		The content that was flagged.
AuthorId	Long	True		The id of author.
AuthorName	String	True		The name of author.
AuthorEmail	String	True		The email of author.
Cause	String	True		Why the ticket was suspended.
CreatedAt	Datetime	True		When this record was created.
UpdatedAt	Datetime	True		When this record last got updated.
ViaChannel	String	True		.
ViaSourceFromId	Long	True		.
ViaSourceFromTitle	String	True		.
ViaSourceTo	String	True		.
ViaSourceRel	String	True		.
Url	String	True		The API url of this ticket.