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 connector.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 |