BizTalk Adapter for Zendesk

Build 20.0.7587

UserIdentities

Create, update, delete, and query User Identities.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the adapter.
SELECT * FROM UserIdentities

SELECT * FROM UserIdentities WHERE UserId = '123'

SELECT * FROM UserIdentities WHERE UserId = '123' AND Id='345'
You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause an error.

Insert

The Type, Value, and UserId fields are required to insert. Allowed for agents.

INSERT INTO UserIdentities(Type, Value, UserId) VALUES('email', 'someone@example.com', '123')

Update

You must specify the Id of the identity and UserId to update. Allowed for agents. Update allows you to do the following: Set the specified identity as verified (but you cannot unverify a verified identity). Note: Primary should be true.

UPDATE UserIdentities SET Verified=true WHERE UserId = '123' AND Id = '456'

Update the value of the specified identity:

UPDATE UserIdentities SET Value='foo@bar.com' WHERE UserId = '123' AND Id = '456'

Delete

You must specify the Id of the identity and UserId to delete an user identity. Users must have at least one identity after deletion. Allowed for agents.

DELETE FROM UserIdentities WHERE UserId = '123' AND Id = '456'

Columns

Name Type ReadOnly Description
Id [KEY] Long True

Automatically assigned on creation.

UserId Long False

The id of the user.

Type String False

One of email, twitter, facebook, google, or phone_number.

Value String False

The identifier for this identity, such as an email address.

Verified Boolean False

If the identity has been verified.

Primary Boolean True

If the identity is the primary identity. Writable only when creating, not when updating.

CreatedAt Datetime True

The time the ticket field was created.

UpdatedAt Datetime True

The time of the last update of the ticket field.

UndeliverableCount Integer True

The time of the last update of the ticket field.

DeliverableState String True

The time of the last update of the ticket field.

Url String True

The URL for this resource.

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