JDBC Driver for Zendesk

Build 22.0.8462

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 driver.
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 References Description
Id [KEY] Long False

Automatically assigned upon creation.

TicketId Integer False

Tickets.Id

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 False

Users.Id

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

GroupId Long False

Groups.Id

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

RequesterId Long False

Users.Id

The id of ticket requester submitting the rating.

CreatedAt Datetime False

The time the satisfaction rating got created.

UpdatedAt Datetime False

The time the satisfaction rating got updated.

Url String False

The API url of this rating.

StartTime Datetime False

Time of the oldest satisfaction rating

EndTime Datetime False

Time of the most recent satisfaction rating

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462