# Zendesk: Ticket Enriched
## Description
* Each record represents a Zendesk ticket, enriched with data about it's tags, assignees, requester, submitter, organization and group.
## Supported Data Sources
* 
Zendesk Support
## Columns
| Type | Name | Description |
| -------- | -------------------------------------- | ------------------------------------------------------------------------------------------------------------- |
| INTEGER | ticket\_id | Automatically assigned when the ticket is created |
| DATETIME | \_fivetran\_synced | |
| INTEGER | assignee\_id | The agent currently assigned to the ticket |
| INTEGER | brand\_id | Enterprise only. The id of the brand this ticket is associated with |
| DATETIME | created\_at | When this record was created |
| DATETIME | updated\_at | When this record last got updated |
| STRING | description | Read-only first comment on the ticket |
| DATETIME | due\_at | If this is a ticket of type "task" it has a due date. Due date format uses ISO 8601 format. |
| INTEGER | group\_id | The group this ticket is assigned to |
| STRING | external\_id | The external id of the ticket |
| BOOLEAN | is\_public | Is true if any comments are public, false otherwise |
| INTEGER | organization\_id | The organization of the requester |
| STRING | priority | The urgency with which the ticket should be addressed, possible values are urgent, high, normal and low |
| STRING | recipient | The original recipient e-mail address of the ticket |
| INTEGER | requester\_id | The user who requested this ticket |
| STRING | status | The state of the ticket, possible values are new, open, pending, hold, solved and closed |
| STRING | subject | The value of the subject field for this ticket |
| INTEGER | problem\_id | The reference to the problem if the ticket is listed as a problem |
| INTEGER | submitter\_id | The user who submitted the ticket. The submitter always becomes the author of the first comment on the ticket |
| INTEGER | ticket\_form\_id | Enterprise only. The id of the ticket form to render for the ticket |
| STRING | type | The type of this ticket, possible values are problem, incident, question or task |
| STRING | url | The API url of this ticket |
| STRING | created\_channel | The channel the ticket was created from |
| INTEGER | source\_from\_id | The channel the ticket was created from |
| STRING | source\_from\_title | The channel the ticket was created from |
| STRING | source\_rel | The rel the ticket was created from |
| STRING | source\_to\_address | The address of the source the ticket was created from |
| STRING | source\_to\_name | The name of the source the ticket was created from |
| BOOLEAN | is\_incident | Boolean indicating whether the ticket is listed as an incident |
| STRING | ticket\_brand\_name | The brand name of with the ticket |
| STRING | ticket\_tags | A list of all tags assigned to this ticket |
| STRING | ticket\_form\_name | The form name of the ticket |
| INTEGER | ticket\_total\_satisfaction\_scores | The total number of satisfaction scores the ticket received. |
| STRING | ticket\_first\_satisfaction\_score | The first satisfaction score the ticket received. |
| STRING | ticket\_satisfaction\_score | The latest satisfaction score the ticket received. |
| STRING | ticket\_satisfaction\_comment | The ticket satisfaction comment |
| STRING | ticket\_satisfaction\_reason | The ticket satisfaction reason |
| BOOLEAN | is\_good\_to\_bad\_satisfaction\_score | Boolean indicating if the ticket had a satisfaction score went from good to bad. |
| BOOLEAN | is\_bad\_to\_good\_satisfaction\_score | Boolean indicating if the ticket had a satisfaction score went from bad to good. |
| STRING | ticket\_organization\_domain\_names | The organization associated with the ticket domain names |
| STRING | requester\_organization\_domain\_names | The ticket requesters organization domain names |
| STRING | requester\_external\_id | The ticket requester external id |
| DATETIME | requester\_created\_at | The date the ticket requester was created |
| DATETIME | requester\_updated\_at | The date the ticket requester was last updated |
| STRING | requester\_role | The role of the user who requested this ticket |
| STRING | requester\_email | The email of the user who requested this ticket |
| STRING | requester\_name | The name of the user who requested this ticket |
| BOOLEAN | is\_requester\_active | Boolean indicating whether the requester is currently active |
| STRING | requester\_locale | The locale of the ticket requester |
| STRING | requester\_time\_zone | The timezone of the ticket requester |
| INTEGER | requester\_ticket\_update\_count | The number of times the requester has updated the ticket |
| DATETIME | requester\_ticket\_last\_update\_at | The last date the requester updated the ticket |
| DATETIME | requester\_last\_login\_at | The last login of the ticket requester |
| INTEGER | requester\_organization\_id | The organization id of the ticket requester |
| STRING | requester\_organization\_name | The organization name of the ticket requester |
| STRING | requester\_organization\_tags | The organization tags of the ticket requester |
| STRING | requester\_organization\_external\_id | The organization external id of the ticket requester |
| DATETIME | requester\_organization\_created\_at | The date the ticket requesters organization was created |
| DATETIME | requester\_organization\_updated\_at | The date the ticket requesters organization was last updated |
| STRING | submitter\_external\_id | The ticket submitter external id |
| STRING | submitter\_role | The role of the user who submitted the ticket. |
| BOOLEAN | is\_agent\_submitted | Boolean indicating if the submitter has an agent role |
| STRING | submitter\_email | The email of the user who submitted the ticket. |
| STRING | submitter\_name | The name of the user who submitted the ticket. |
| BOOLEAN | is\_submitter\_active | Boolean indicating if the ticket submitter is active |
| STRING | submitter\_locale | The locale of the ticket submitter |
| STRING | submitter\_time\_zone | The time zone of the ticket submitter |
| STRING | assignee\_external\_id | The external id of the ticket assignee |
| STRING | assignee\_role | The role of the agent currently assigned to the ticket |
| STRING | assignee\_email | The email of the agent currently assigned to the ticket |
| STRING | assignee\_name | The name of the agent currently assigned to the ticket |
| BOOLEAN | is\_assignee\_active | Boolean indicating if the ticket assignee is active |
| STRING | assignee\_locale | The locale of the ticket assignee |
| STRING | assignee\_time\_zone | The time zone of the ticket assignee |
| INTEGER | assignee\_ticket\_update\_count | The number of times the ticket assignee has updated the ticket |
| DATETIME | assignee\_ticket\_last\_update\_at | The last date the ticket assignee updated the ticket |
| DATETIME | assignee\_last\_login\_at | The date the ticket assignee last logged in |
| STRING | group\_name | The name of the group this ticket is assigned to |
| STRING | organization\_name | The name of the organization of the requester |
| STRING | requester\_tag | The tags associated with the ticket requester. |
| STRING | submitter\_tag | The tags associated with the ticket submitter. |
| STRING | assignee\_tag | The tags associated with the ticket assignee. |
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://endash-guidance-docs.gitbook.io/cigro-data-templates/data-model-templates/zendesk-ticket-enriched.md?ask=
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.