JDBC Driver for Zendesk

Build 24.0.8963

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 本製品.
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', '[email protected]', '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 = '[email protected]' 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 References Description
Id [KEY] Long True

Automatically assigned on creation.

UserId [KEY] Long False

Users.Id

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) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963