Create, delete, update, and query Organizations in Zendesk.
Table Specific Information
SelectThe following queries are processed server side while other filters are processed client side within the adapter.
SELECT * FROM Organizations SELECT * FROM Organizations WHERE Id = '123' SELECT * FROM Organizations WHERE Id IN ('123','456') SELECT * FROM Organizations WHERE UserId = '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.
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.
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.
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.
Automatically assigned when the ticket is created.
A unique name for the organization.
New tickets from users in this organization are automatically put in this group.
A unique external id to associate organizations to an external record.
The time the organization was created.
The time of the last update of the organization.
An array of domain names associated with this organization.
Any details obout the organization, such as the address.
Any notes you have about the organization.
End users in this organization are able to see tickets of each other.
End users in this organization are able to see comments on tickets of each other.
The tags of the organization.
The URL for this resource.
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
The user id used to query organizations