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 component.

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.