Execute View

GET {{baseUrl}}/api/v2/views/:view_id/execute?sort_by=<string>&sort_order=<string>

Returns the column titles and the rows of the specified view.

The columns array lists the view's column titles and includes only views parameters.

The rows array lists the values of each column for each ticket and includes parameters from both views and tickets. Though not displayed in the view, a partial ticket object is included with each row object.

Note: To get the full ticket objects for a specified view, use List Tickets from a View.

This endpoint is rate limited to 5 requests per minute, per view, per agent.

The view execution system is designed for periodic rather than high-frequency API usage. In particular, views called very frequently may be cached by Zendesk. This means that the API client will still receive a result, but that result may have been computed at any time within the last 10 minutes.

Zendesk recommends using the Incremental Ticket Export endpoint to get the latest changes. You can call it more often, and it returns all the tickets that changed since the last poll. For details and rate limits, see Incremental Exports.

View output sorting can be controlled by passing the sort_by and sort_order parameters in the format described in the table in Preview Views.

Allowed For

  • Agents

Request Params

KeyDatatypeRequiredDescription
sort_bystringThe ticket field used for sorting. This will either be a title or a custom field id.
sort_orderstringThe direction the tickets are sorted. May be one of 'asc' or 'desc'

HEADERS

KeyDatatypeRequiredDescription
Acceptstring

RESPONSES

status: OK

{&quot;columns&quot;:[{&quot;id&quot;:&quot;locale&quot;,&quot;title&quot;:&quot;Locale&quot;},{&quot;id&quot;:5,&quot;title&quot;:&quot;Account&quot;}],&quot;groups&quot;:[],&quot;rows&quot;:[{&quot;group&quot;:1,&quot;locale&quot;:&quot;en-US&quot;,&quot;ticket&quot;:{}}],&quot;view&quot;:{&quot;id&quot;:25}}