BizTalk Adapter for Zendesk

Build 20.0.7587

UserRelatedInformation

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

SELECT * FROM UserRelatedInformation WHERE UserId = '123'

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.

Columns

Name Type Description
UserId Long The id of the user.
AssignedTickets Integer Count of assigned tickets.
RequestedTickets Integer Count of requested tickets.
CcdTickets Integer Count of collaborated tickets.
OrganizationSubscriptions Integer Count of organization subscriptions.
Topics Integer Count of topics (Web portal only).
TopicComments Integer Count of comments on topics (Web portal only).
Votes Integer Count of votes (Web portal only).
Subscriptions Integer Count of subscriptions (Web portal only).
EntrySubscriptions Integer Count of entry subscriptions (Web portal only).
ForumSubscriptions Integer Count of forum subscriptions (Web portal only).

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