Please enable JavaScript to view this site.

Navigation: Schema: Services > Tables

Services

Catalog: Autotask

Schema: Services

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/Services/query

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

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

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

Field Selection Method: NotRequired

Base Path: items[*]

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

Table Columns

The columns of the Table Services are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

billingCodeID

int32

Billing Code ID

 

createDate

datetime

Created

 

creatorResourceID

int32

Creator Resource ID

 

description

string

Description

 

id

int64

ID

 

invoiceDescription

string

Invoice Description

 

isActive

boolean

Is Active

 

lastModifiedDate

datetime

Last Modified

 

markupRate

double

Mark-up Rate

 

name

string

Name

 

periodType

int32

Period Type

 

serviceLevelAgreementID

int64

Service Level Agreement ID

 

unitCost

double

Unit Cost

 

unitPrice

double

Unit Price

 

updateResourceID

int32

Update Resource ID

 

vendorCompanyID

int32

Vendor Company ID

 

 

22-09-2022 21:52 Version 22.0.355-PROD+3587