BizTalk Adapter for Zendesk

Build 20.0.7587

OrganizationSubscriptions

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 adapter.
SELECT * FROM OrganizationSubscriptions

SELECT * FROM OrganizationSubscriptions WHERE Id = '123'

SELECT * FROM OrganizationSubscriptions WHERE UserId = '123'

SELECT * FROM OrganizationSubscriptions WHERE OrganizationId = '123'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any other search criteria will be ignored and an unfiltered response will be returned.

Insert

The 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 Description
Id [KEY] Long True

Organization subscription id.

OrganizationId Long False

.

UserId Long False

.

CreatedAt Datetime True

.

Url String True

The url of this resource.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587