Please enable JavaScript to view this site.

Navigation: Schema: ServiceLevelAgreementResults > Tables

ServiceLevelAgreementResults

Catalog: Autotask

Schema: ServiceLevelAgreementResults

This is a read-only table. The Autotask API may not support changing the data or the Invantive SQL driver for Autotask does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Autotask API.

Select Autotask API URL: /V1.0/ServiceLevelAgreementResults/query

Insert Autotask API URL: /V1.0/ServiceLevelAgreementResults/query

Update Autotask API URL: /V1.0/ServiceLevelAgreementResults/query

Delete Autotask API URL: /V1.0/ServiceLevelAgreementResults/query

Field Selection Method: NotRequired

Base Path: items[*]

Select Autotask API Operation: get /V1.0/ServiceLevelAgreementResults/query

Table Columns

The columns of the table ServiceLevelAgreementResults are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

firstResponseElapsedHours

double

First Response Elapsed Hours

 

firstResponseInitiatingResourceID

int32

First Response Initiating Resource ID

 

firstResponseResourceID

int32

First Response Resource ID

 

id

int64

ID

 

isFirstResponseMet

boolean

Is First Response Met

 

isResolutionMet

boolean

Is Resolution Met

 

isResolutionPlanMet

boolean

Is Resolution Plan Met

 

resolutionElapsedHours

double

Resolution Elapsed Hours

 

resolutionPlanElapsedHours

double

Resolution Plan Elapsed Hours

 

resolutionPlanResourceID

int32

Resolution Plan Resource ID

 

resolutionResourceID

int32

Resolution Resource ID

 

serviceLevelAgreementName

string

Service Level Agreement Name

 

soapParentPropertyId

int64

SOAP Parent Property ID

 

ticketID

int32

Ticket ID

 

 

21-06-2022 08:54 Version 22.1.46-BETA+3385