Returns support addresses used for receiving and sending email in Zendesk Support.

Table-Specific Information

Select

The following query is processed server-side while other filters are processed client-side within the provider.

SELECT * FROM SupportAddresses WHERE Id = '123'

Insert

The Email column is required to insert.

Note that 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.

• For example, [email protected]. The "local-part" can be anything you want.

This operation is allowed for logged-in users with the "admin" role only.

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

Update

You must specify the Id of the support address to update. This operation is allowed for logged-in users with the "admin" role only.

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

Delete

You must specify the Id of the support address to delete it. This operation is allowed for logged-in users with the "admin" role only.

DELETE FROM SupportAddresses WHERE Id = '123'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		The unique Id of the support address, 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 support address was created.
UpdatedAt	Datetime	True		The time of the last update of the support address.
Default	Boolean	False		Indicates whether the address is the account's default support address.
BrandId	Long	False	Brands.Id	The Id of the brand associated with the support address.
ForwardingStatus	String	True		Possible values: unknown, waiting, verified, or failed.
SpfStatus	String	True		Possible values: unknown, verified, failed.