Create and query Requests in Zendesk.
Table Specific Information
SelectThe 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.
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')
Automatically assigned upon creation.
The id of ticket being rated.
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.
The comment received with this rating, if available.
The reason for a bad rating given by the requester in a follow-up question. Satisfaction reasons must be enabled.
The id of agent assigned to at the time of rating.
The id of group assigned to at the time of rating.
The id of ticket requester submitting the rating.
The time the satisfaction rating got created.
The time the satisfaction rating got updated.
The API url of this rating.
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.
Time of the oldest satisfaction rating
Time of the most recent satisfaction rating