Please enable JavaScript to view this site.

Navigation: Schema: Phases > Tables

Phases

Catalog: Autotask

Schema: Phases

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

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

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

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

Field Selection Method: NotRequired

Base Path: items[*]

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

Table Columns

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

Name

Data Type

Label

Required

Documentation

createDate

datetime

Created

 

creatorResourceID

int32

Creator Resource ID

 

description

string

Description

 

dueDate

datetime

Due Date

 

estimatedHours

double

Estimated Hours

 

externalID

string

External ID

 

id

int64

ID

 

isScheduled

boolean

Is Scheduled

 

lastActivityDateTime

datetime

Last Activity Date/Time

 

parentPhaseID

int32

Parent Phase ID

 

phaseNumber

string

Phase Number

 

projectID

int32

Project ID

 

soapParentPropertyId_body_canReduce

boolean

 

 

soapParentPropertyId_body_nodeType

string

 

 

soapParentPropertyId_body_type

string

 

 

soapParentPropertyId_canReduce

boolean

 

 

soapParentPropertyId_name

string

 

 

soapParentPropertyId_nodeType

string

 

 

soapParentPropertyId_returnType

string

 

 

soapParentPropertyId_tailCall

boolean

 

 

soapParentPropertyId_type

string

 

 

startDate

datetime

Start Date

 

title

string

Title

 

 

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