BizTalk Adapter for Zendesk

Build 20.0.7587

SatisfactionRatings

Create and query Requests 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 SatisfactionRatings

SELECT * FROM SatisfactionRatings WHERE Id = '123'

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.

Insert

The TicketId and Score fields are required to insert. Creates a CSAT rating for solved tickets, or for tickets that were previously solved and then reopened. Allowed for an end user who requested the ticket.

INSERT INTO SatisfactionRatings(TicketId, Score) VALUES('12', 'good')

Columns

Name Type ReadOnly Description
Id [KEY] Long True

Automatically assigned upon creation.

TicketId Integer False

The id of ticket being rated.

Score String False

The rating: offered, unoffered, good or bad. When used in a filter it takes one of values: offered, unoffered, received, received_with_comment, received_without_comment, good, good_with_comment, good_without_comment, bad, bad_with_comment, bad_without_comment.

Comment String False

The comment received with this rating, if available.

Reason String False

The reason for a bad rating given by the requester in a follow-up question. Satisfaction reasons must be enabled.

AssigneeId Long True

The id of agent assigned to at the time of rating.

GroupId Long True

The id of group assigned to at the time of rating.

RequesterId Long True

The id of ticket requester submitting the rating.

CreatedAt Datetime True

The time the satisfaction rating got created.

UpdatedAt Datetime True

The time the satisfaction rating got updated.

Url String True

The API url of this rating.

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
StartTime Datetime

Time of the oldest satisfaction rating

EndTime Datetime

Time of the most recent satisfaction rating

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