---
title: "Tickets (Autotask)"
description: "itgen_autotask_tickets_plural"
language: en
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/it/datamodels/autotask/Autotask.Tickets.Tickets
original: https://documentation.invantive.eu/en/datamodels/autotask/Autotask.Tickets.Tickets
updated: 2024-06-10T18:39:25Z
license: https://documentation.invantive.eu/it/
---

# Tickets: Autotask itgen_autotask_tickets_plural

`read only` `REST`

- Catalog: `Autotask`
- Schema: `Tickets`
- Label: itgen_autotask_tickets_plural

Can only retrieve data.

## API Source

- Endpoint: `/V1.0/Tickets/query`
- Operation: `get /V1.0/Tickets/query`

## Table Columns

The columns of the table `Tickets` 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 | Marks | Documentation |
|---|---|---|:---:|---|---|
| `apiVendorID` | `int32` | API Vendor ID | [ ] |  |  |
| `assignedResourceID` | `int32` | Assigned Resource ID | [ ] |  |  |
| `assignedResourceRoleID` | `int32` | Assigned Resource Role ID | [ ] |  |  |
| `billingCodeID` | `int32` | Billing Code ID | [ ] |  |  |
| `changeApprovalBoard` | `int32` | Change Approval Board | [ ] |  |  |
| `changeApprovalStatus` | `int32` | Change Approval Status | [ ] |  |  |
| `changeApprovalType` | `int32` | Change Approval Type | [ ] |  |  |
| `changeInfoField1` | `varchar2` | Change Information Field 1 | [ ] |  |  |
| `changeInfoField2` | `varchar2` | Change Information Field 2 | [ ] |  |  |
| `changeInfoField3` | `varchar2` | Change Information Field 3 | [ ] |  |  |
| `changeInfoField4` | `varchar2` | Change Information Field 4 | [ ] |  |  |
| `changeInfoField5` | `varchar2` | Change Information Field 5 | [ ] |  |  |
| `companyID` | `int32` | Company ID | [ ] |  |  |
| `companyLocationID` | `int32` | Company Location ID | [ ] |  |  |
| `completedByResourceID` | `int32` | Completed by Resource ID | [ ] |  |  |
| `completedDate` | `datetime` | Completion Date | [ ] |  |  |
| `configurationItemID` | `int32` | Configuration Item ID | [ ] |  |  |
| `contactID` | `int32` | Contact ID | [ ] |  |  |
| `contractID` | `int32` | Contract ID | [ ] |  |  |
| `contractServiceBundleID` | `int64` | Contract Service Bundle ID | [ ] |  |  |
| `contractServiceID` | `int64` | Contract Service ID | [ ] |  |  |
| `createDate` | `datetime` | Created | [ ] |  |  |
| `createdByContactID` | `int32` | Created by Contact ID | [ ] |  |  |
| `creatorResourceID` | `int32` | Creator Resource ID | [ ] |  |  |
| `creatorType` | `int32` | Creator Type | [ ] |  |  |
| `currentServiceThermometerRating` | `int32` | Current Service Thermometer Rating | [ ] |  |  |
| `description` | `varchar2` | Description | [ ] |  |  |
| `dueDateTime` | `datetime` | Due Date/Time | [ ] |  |  |
| `estimatedHours` | `double` | Estimated Hours | [ ] |  |  |
| `externalID` | `varchar2` | External ID | [ ] |  |  |
| `firstResponseAssignedResourceID` | `int32` | First Response Assigned Resource ID | [ ] |  |  |
| `firstResponseDateTime` | `datetime` | First Response Date/Time | [ ] |  |  |
| `firstResponseDueDateTime` | `datetime` | First Response Due Date/Time | [ ] |  |  |
| `firstResponseInitiatingResourceID` | `int32` | First Response Initiating Resource ID | [ ] |  |  |
| `hoursToBeScheduled` | `double` | Hours to be Scheduled | [ ] |  |  |
| `id` | `int64` | ID | [ ] |  |  |
| `impersonatorCreatorResourceID` | `int32` | Imperonsator Creator Resource ID | [ ] |  |  |
| `isAssignedToComanaged` | `char` | Is Assigned to Co-managed | [ ] |  |  |
| `issueType` | `int32` | Issue Type | [ ] |  |  |
| `isVisibleToComanaged` | `char` | Is Visible to Co-managed | [ ] |  |  |
| `lastActivityDate` | `datetime` | Last Activity Date | [ ] |  |  |
| `lastActivityPersonType` | `int32` | Last Acitvity Person Type | [ ] |  |  |
| `lastActivityResourceID` | `int32` | Last Activity Resource ID | [ ] |  |  |
| `lastCustomerNotificationDateTime` | `datetime` | Last Customer Notification Date/Time | [ ] |  |  |
| `lastCustomerVisibleActivityDateTime` | `datetime` | Last Customer Visible Activity Date/Time | [ ] |  |  |
| `lastTrackedModificationDateTime` | `datetime` | Last Tracked Modification Date/Time | [ ] |  |  |
| `monitorID` | `int64` | Monitor ID | [ ] |  |  |
| `monitorTypeID` | `int32` | Monitor Type ID | [ ] |  |  |
| `opportunityID` | `int32` | Opportunity ID | [ ] |  |  |
| `organizationalLevelAssociationID` | `int32` | Organisational Level Association ID | [ ] |  |  |
| `previousServiceThermometerRating` | `int32` | Previous Service Thermometer Rating | [ ] |  |  |
| `priority` | `int32` | Priority | [ ] |  |  |
| `problemTicketId` | `int32` | Problem Ticket ID | [ ] |  |  |
| `projectID` | `int32` | Project ID | [ ] |  |  |
| `purchaseOrderNumber` | `varchar2` | Purchase Order Number | [ ] |  |  |
| `queueID` | `int32` | Queue ID | [ ] |  |  |
| `resolution` | `varchar2` | Resolution | [ ] |  |  |
| `resolutionPlanDateTime` | `datetime` | Resolution Plan Date/Time | [ ] |  |  |
| `resolutionPlanDueDateTime` | `datetime` | Resolution Plan Due Date/Time | [ ] |  |  |
| `resolvedDateTime` | `datetime` | Resolved Date/Time | [ ] |  |  |
| `resolvedDueDateTime` | `datetime` | Resolved Due Date/Time | [ ] |  |  |
| `rmaStatus` | `int32` | RMA status | [ ] |  |  |
| `rmaType` | `int32` | RMA Type | [ ] |  |  |
| `rmmAlertID` | `varchar2` | Alert ID | [ ] |  |  |
| `serviceLevelAgreementHasBeenMet` | `char` | Service Level Agreement has been Met | [ ] |  |  |
| `serviceLevelAgreementID` | `int32` | Service Level Agreement ID | [ ] |  |  |
| `serviceLevelAgreementPausedNextEventHours` | `double` | Service Level Agreement Paused next Event Hours | [ ] |  |  |
| `serviceThermometerTemperature` | `int32` | Service Thermometer Temperature | [ ] |  |  |
| `source` | `int32` | Source | [ ] |  |  |
| `status` | `int32` | Status | [ ] |  |  |
| `subIssueType` | `int32` | Sub-issue Type | [ ] |  |  |
| `ticketCategory` | `int32` | Ticket Category | [ ] |  |  |
| `ticketNumber` | `varchar2` | Ticket Number | [ ] |  |  |
| `ticketType` | `int32` | Ticket Type | [ ] |  |  |
| `title` | `varchar2` | Title | [ ] |  |  |



## Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver:

- [Autotask](/it/release-notes/drivers?driver=autotask)
