BizTalk Adapter for Zendesk

Build 20.0.7587

SupportAddresses

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

SELECT * FROM SupportAddresses WHERE Id = '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 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: 'sales-team@omniwear.zendesk.com'. The local-part can be anything you like. Allowed for admins.

INSERT INTO SupportAddresses  (Email) VALUES ('sales-team@omniwear.zendesk.com')

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

The id of the brand.

ForwardingStatus String True

Possible values: unknown, waiting, verified, or failed.

SpfStatus String True

Possible values: unknown, verified, failed.

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