Data Types

The following table contains information about the data types used in the web services (except where the data type format is obvious).

Data Type

Discussion

boolean

The possible values are the strings true and false.

date

The date format is yyyy-mm-dd. For example, 2004-12-26.

dateTime

The dateTime format is yyyy-mm-ddThh:MM:ss.fffffff<tzadjustment>

  • Note the letter T between 'dd' and 'hh'. It must be present between the date and time
  • .fffffff - fraction of a second - is optional
  • <tzadjustment> is optional and shows the hours relative to GMT
    • Time is GMT. For our servers that is currently -05:00 hours, but could change if the timezone setting of our servers change. 
    • For example the first two and last two examples represent the same time.
    • 2004-12-27T11:04:29.4370000*-05:00*
    • 2004-12-27T06:04:29.4370000
    • 2004-12-27T11:04:29*-05:00*
    • 2004-12-27T10:04:29

int

A signed integer internally represented by 32 bits

long

A signed integer internally represented by 64 bits

money

A decimal number with 4 places to the right of the decimal point.

float

A floating point number (internally represented by 4 bytes)

double

A double precision floating point number (internally 8 bytes)

ClientUdf

see below

ProjectUdf

see below

EngagementUdf

see below

ResourceUdf

see below


ClientUdf

Name

Data Type

Discussion

ClientId

int

Internal identifier

Name

string

UDF name

DataType

string

L=Text List
T=Text
I=Integer
Y=Yes/No
R=Resource
D=DateTime

StringValue

string

Value of the UDF if the type is Text or Text List. Resource's display name if the type is Resource.

IntValue

string

Value of UDF if the type is Integer. Resource's internal ID if the type is Resource.

DatetimeValue

dateTime

Value of UDF if the type is dateTime

ReferenceInfo

string

If the data type is Resource then this is the resource's ReferenceSystemId

ProjectUdf

Name

Data Type

Discussion

ProjectId

int

Internal identifier

Name

string

UDF name

DataType

string

L=Text List
T=Text
I=Integer
Y=Yes/No
R=Resource
D=DateTime

StringValue

string

Value of the UDF if the type is Text or Text List. Resource's display name if the type is Resource.

IntValue

string

Value of UDF if the type is Integer. Resource's internal ID if the type is Resource.

DatetimeValue

dateTime

Value of UDF if the type is dateTime

ReferenceInfo

string

If the data type is Resource then this is the resource's ReferenceSystemId


EngagementUdf

Name

Data Type

Discussion

EngagementId

int

Internal identifier

Name

string

UDF name

DataType

string

L=Text List
T=Text
I=Integer
Y=Yes/No
R=Resource
D=DateTime

StringValue

string

Value of the UDF if the type is Text or Text List. Resource's display name if the type is Resource.

IntValue

string

Value of UDF if the type is Integer. Resource's internal ID if the type is Resource.

DatetimeValue

dateTime

Value of UDF if the type is dateTime

ReferenceInfo

string

If the data type is Resource then this is the resource's ReferenceSystemId


ResourceUdf

Name

Data Type

Discussion

ResourceId

int

Internal identifier

Name

string

UDF name

DataType

string

L=Text List
T=Text
I=Integer
Y=Yes/No
R=Resource
D=DateTime

StringValue

string

Value of the UDF if the type is Text or Text List. Resource's display name if the type is Resource.

IntValue

string

Value of UDF if the type is Integer. Resource's internal ID if the type is Resource.

DatetimeValue

dateTime

Value of UDF if the type is dateTime

ReferenceInfo

string

If the data type is Resource then this is the resource's ReferenceSystemId