ADO.NET Provider for Zendesk

Build 26.0.9655

PositivelyRatedTicketsThisWeek

Returns tickets that received positive satisfaction ratings during the current week.

Columns

Name Type References Description
Id [KEY] Integer The unique Id automatically assigned when the ticket is created.
Subject String The value of the subject field for this ticket. When used in WHERE clause: The text in the ticket's subject
RawSubject String The dynamic content placeholder, if present, or the subject value, if not.
Description String The first comment on the ticket. When used in WHERE clause: The text in the ticket's description and comments
Type String The type of this ticket. Possible values: problem, incident, question or task.
Priority String The urgency with which the ticket should be addressed. Possible values: urgent, high, normal, low.
Status String The state of the ticket. Possible values: new, open, pending, hold, solved, closed.
Recipient String The original recipient e-mail address of the ticket.
HasIncidents Boolean Indicates whether this ticket has been marked as a problem.
DueAt Datetime If this is a ticket of type task it has a due date. Due date format uses ISO 8601 format.
RequesterId Long

Users.Id

The user who requested this ticket.
SubmitterId Long

Users.Id

The user who submitted the ticket. The submitter always becomes the author of the first comment on the ticket.
AssigneeId Long

Users.Id

The agent currently assigned to the ticket.
OrganizationId String

Organizations.Id

The organization of the requester. You can only specify the ID of an organization associated with the requester.
GroupId Long

Groups.Id

The Id of the group to which the ticket is assigned.
CollaboratorIds String The Ids of users currently CC'd on the ticket.
FollowerIds String The Ids of agents currently following the ticket.
ForumTopicId Long

Topics.Id

The topic this ticket originated from, if any.
ProblemId Integer

Tickets.Id

For tickets of type incident, the ID of the problem the incident is linked to.
ExternalId String An Id you can use to link Zendesk Support tickets to local records.
FollowupIds String Closed tickets only. The Ids of the follow-ups created from this ticket.
TicketFormId Long

TicketForms.Id

Enterprise only. The Id of the ticket form to render for the ticket.
BrandId Long

Brands.Id

Enterprise only. The Id of the brand this ticket is associated with.
Tags String The array of tags applied to this ticket.
ViaChannel String This tells you how the ticket or event was created. Examples: web, mobile, rule, system.
ViaSource String The source of the ticket.
SatisfactionRating String The satisfaction rating of the ticket, if it exists, or the state of satisfaction, 'offered' or 'unoffered'.
SharingAgreementIds String The Ids of the sharing agreements used for this ticket.
AllowChannelback Boolean Indicates whether channelback is enabled. Only applicable for channels framework tickets.
IsPublic Boolean Indicates whether any comments on the ticket are public.
CreatedAt Datetime The date and time when this record was created.
UpdatedAt Datetime The date and time when this record was last updated.
Url String The API url of this ticket.
Assignee String The assigned agent or other entity. You can specify 'none', 'me', user name (full name or partial), email address, user ID, or phone number
GroupName String The name of the group to which the ticket is assigned.
Requester String The ticket requester. You can specify 'none', 'me', user name (full name or partial), email address, user ID, or phone number.
Submitter String The ticket submitter. This may be different than the requester if the ticket was submitted by an agent on behalf of the requester. You can specify 'none', 'me', user name (full name or partial), email address, user ID, or phone number. .
Brand String Search for a specific Brand on a ticket.
Commenter String People who have added comments to tickets. You can specify 'none', 'me', user name (full name or partial), email address, user ID, or phone number.
Cc String People who have been CC'd on tickets. You can specify 'none', 'me', user name (full name or partial), email address, user ID, or phone number.
AllowAttachments Boolean Indicates whether agents have permission to add attachments to a comment. Defaults to true.
CustomStatusId Long The custom ticket status id of the ticket.
EmailCcIds String An array of objects that represent agent or end users email CCs to add or delete from the ticket.
FromMessagingChannel Boolean Indicates whether the ticket's via type is a messaging channel.
ResultType String The type of the search result.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9655