BizTalk Adapter for Zendesk

Build 20.0.7587

Views

Query and delete Views in Zendesk.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side by the adapter. Allowed for agents.

SELECT * FROM Views

SELECT * FROM Views WHERE Id = '123'

SELECT * FROM Views WHERE GroupId = '123'

SELECT * FROM Views WHERE Access = 'Shared'

SELECT * FROM Views WHERE Active = true

SELECT * FROM Views Order By CreatedAt

SELECT * FROM Views Order By UpdatedAt

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.

Delete

You must specify the Id of the view to delete it. Allowed for agents.

DELETE FROM Views WHERE Id='123'

Columns

Name Type ReadOnly Description
Id [KEY] Long True

Automatically assigned when the ticket is created.

Title String False

The title of the view.

Active Boolean False

Useful for determining if the view should be displayed.

SlaId Long True

If the view is for an SLA, shows the id.

RestrictionId Long False

The id of the restricion (who may access this account. Will be null when everyone in the account can access it).

RestrictionType String False

The type of the restricion (who may access this account. Will be null when everyone in the account can access it).

Position Integer False

The position of the view.

ExecutionGroupBy String False

Execution is an object describing how the view should be executed.

ExecutionGroupOrder String False

Execution is an object describing how the view should be executed.

ExecutionSortBy String False

Execution is an object describing how the view should be executed.

ExecutionSortOrder String False

Execution is an object describing how the view should be executed.

ExecutionGroup String False

Execution is an object describing how the view should be executed.

ExecutionSort String False

Execution is an object describing how the view should be executed.

ExecutionColumns String False

Execution is an object describing how the view should be executed.

ExecutionFields String False

Execution is an object describing how the view should be executed.

ExecutionCustomFields String False

Execution is an object describing how the view should be executed.

ConditionsAll String False

Logical AND. Tickets must fulfill all of the conditions to be considered matching.Conditions is an object describing how the view is constructed.

ConditionsAny String False

Logical OR. Tickets may satisfy any of the conditions to be considered matching.Conditions is an object describing how the view is constructed.

CreatedAt Datetime True

The time the view was created.

UpdatedAt Datetime True

The time of the last update of the view.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
Access String

Only views with given access. May be personal, shared, or account

GroupId Integer

The group id the view belongs to. Used to query the table

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