# tickets_incremental: Freshdesk Tickets (Incremental) ## Documentation Tickets. - Catalog: `Freshdesk` - Schema: `Freshdesk` - Primary Keys: `id` - Label: Tickets (Incremental) Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `tickets_incremental` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `associated_tickets_count` | `int64` | Associated Tickets Count | ☐ | | | `cf_reference_number` | `decimal` | Reference Number | ☐ | Custom field #10000152167 of type custom_number. | | `company_id` | `int64` | Company ID | ☐ | | | `created_at` | `datetime` | Created at | ☐ | Date/time at which the record was created. | | `deleted` | `char` | Deleted | ☐ | Set as true if the ticket is deleted/trashed. Deleted tickets will not be considered in any views except 'deleted' filter. | | `description_html` | `varchar2` | Description (HTML) | ☐ | HTML content of the ticket. Description and description_html should not be passed together. | | `description_text` | `varchar2` | Description | ☐ | Plain text content of the ticket. | | `description` | `varchar2` | Description | ☐ | | | `due_by` | `datetime` | Due by | ☐ | Ticket due-by time. | | `email_config_id` | `int64` | Email Configuration ID | ☐ | ID of email config which is used for this ticket. | | `email` | `varchar2` | Email | ☐ | Email address of the requester. If no contact exists with this email address in Freshdesk, it will be added as a new contact. | | `facebook_id` | `varchar2` | Facebook ID | ☐ | Facebook ID of the requester. A contact should exist with this facebook_id in Freshdesk. | | `fr_due_by` | `datetime` | From Due by | ☐ | Timestamp that denotes when the first response is due. | | `fr_escalated` | `char` | From Escalated | ☐ | Set to true if the ticket has been escalated as the result of first response time being breached. | | `group_id` | `int64` | Group ID | ☐ | ID of Group to which the ticket is assigned. | | `id` | `int64` | ID | ☑ | Unique ID of the ticket. | | `internal_agent_id` | `int64` | Internal Agent ID | ☐ | | | `internal_group_id` | `int64` | Internal Group ID | ☐ | | | `is_escalated` | `char` | Is Escalated | ☐ | Set to true if an escalation was sent. | | `name` | `varchar2` | Name | ☐ | Name of the requester. | | `nr_due_by` | `datetime` | Due by (NR) | ☐ | | | `nr_escalated` | `char` | Escalated (NR) | ☐ | | | `phone` | `varchar2` | Phone | ☐ | Phone number of the requester. If no contact exists with this phone number in Freshdesk, it will be added as a new contact. If the phone number is set and the email address is not, then the name attribute is mandatory. | | `priority` | `int16` | Priority | ☐ | Priority of the ticket. | | `product_id` | `int64` | Product ID | ☐ | ID of the product to which the ticket is associated. | | `requester_id` | `varchar2` | Requester ID | ☐ | User-id of the requester. For existing contacts, requester_id can be passed instead of email. | | `responder_id` | `int64` | Responder ID | ☐ | ID of the agent to whom the ticket is assigned. | | `source` | `int16` | Source | ☐ | The channel through which the ticket was created. | | `spam` | `char` | Spam | ☐ | Set as true if the ticket is marked as spam. | | `stats_agent_responded_at` | `datetime` | Statistics Agent Responded at | ☐ | | | `stats_closed_at` | `datetime` | Statistics Closed at | ☐ | | | `stats_first_responded_at` | `datetime` | Statistics First Responded at | ☐ | | | `stats_pending_since` | `datetime` | Statistics Pending since | ☐ | | | `stats_reopened_at` | `datetime` | Statistisc Reopened at | ☐ | | | `stats_requester_responded_at` | `datetime` | Statistics Requester Responded at | ☐ | | | `stats_resolved_at` | `datetime` | Statistics Resolved at | ☐ | | | `stats_status_updated_at` | `datetime` | Statistics Status Updated at | ☐ | | | `status` | `int16` | Status | ☐ | Status of the ticket. | | `subject` | `varchar2` | Subject | ☐ | Ticket subject. | | `ticket_type` | `varchar2` | Ticket Type | ☐ | Type property field as defined in ticket fields. | | `to_emails` | `varchar2` | To Emails | ☐ | | | `twitter_id` | `varchar2` | Twitter ID | ☐ | Twitter handle of the requester. If no contact exists with this handle in Freshdesk, it will be added as a new contact. | | `type` | `varchar2` | Type | ☐ | Helps categorize the ticket according to the different kinds of issues your support team deals with. | | `updated_at` | `datetime` | Updated at | ☐ | Date/time at which the record was last updated. |