BizTalk Adapter for Zendesk

Build 20.0.7587

ActivityStream

Query ActivityStreams 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 ActivityStream

SELECT * FROM ActivityStream WHERE Id = '123'

SELECT * FROM ActivityStream WHERE Since = '2017-02-15 10:15:25'

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.

Columns

Name Type Description
Id [KEY] Long Automatically assigned upon creation.
Title String Description of this activity.
Verb String The type of activity. Can be tickets.assignment, tickets.comment, or tickets.priority_increase.
UserId Long The user this activity pertains to.
ActorId Long The user this activity pertains to.
CreatedAt Datetime When this locale was created.
UpdatedAt Datetime When this locale last got updated.
Url String The API url of this activity.

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