Filter expression to limit the response to only objects that match the expression. Check the value of a single field using operators such as equalto/like, or multiple fields using and/or. Query fields on related objects using the dot operator (for example, VENDOR.CREDITLIMIT on APBILL).
select
Required
sequence
The names of the fields that you want included in the response, and an optional aggregate function such as count or sum. Returning all fields is not supported.
orderby
Optional
object
Provide an order element with a field name and choose an ascending or descending sort order, for example: <order> <field>RECORDNO</field> <descending/> </order>
Set the caseinsensitive element to true for a case-insensitive query <caseinsensitive>true</caseinsensitive>
In a multi-entity company, set the showprivate element to true to query data in private entities: <showprivate>true</showprivate>
Specify the returnformat for the response: xml (default), json, or csv <returnformat>json</returnformat>
pagesize
Optional
integer
Maximum number of matching objects to return in the response, between 1 and 2000 items (Default: 100)
offset
Optional
integer
Point at which to start indexing into records (Default: 0)
Query and List Tasks (Legacy)
readByQuery
Parameters
Name
Required
Type
Description
object
Required
string
Use TASK
fields
Optional
string
Comma-separated list of fields on the object to list. For best performance and predictability, limit the number of fields. To return all fields, omit the element or provide * for the value.
query
Required
string
SQL-like query based on fields on the object. The following operators are supported: <, >, >=, <=, =, like, not like, in, not in, IS NOT NULL, IS NULL, AND, OR. Illegal XML characters must be properly encoded, and single quotes must be escaped with backslashes ('Jane\'s Deli'). Joins are not supported.
pagesize
Optional
integer
Custom page size between 1 and 1000 items (Default: 100)
query Fields
Name
Required
Type
Description
TASKSTATUS
Optional
string
Task status. Use N for Not Started, L for Planned, P for In Progress, C for Completed, or H for On Hold.
Get Task
read
Parameters
Name
Required
Type
Description
object
Required
string
Use TASK
keys
Required
string
Comma-separated list of department RECORDNO to get
fields
Optional
string
Comma-separated list of fields on the object to get. To return all fields, omit the element or provide * for the value. For best performance and predictability, limit the number of fields.
Task ID that is unique for the given project. Use 20 characters or fewer. (Default: record number)
PRODUCTIONUNITDESC
Optional
string
Production unit description, such as cubic yards or window assembly. Free form field with 30 or fewer characters.
PBEGINDATE
Optional
string
Planned begin date, which will default to the project begin date if one is set for the project. Set a different date using format mm/dd/yyyy.
PENDDATE
Optional
string
Planned end date, which will default to the project end date if one is set for the project. Set a different date using format mm/dd/yyyy.
CLASSID
Optional
string
Class ID
ITEMID
Optional
string
Item ID
BILLABLE
Optional
boolean
Billable. Use false for No, true for Yes. (Default: false)
DESCRIPTION
Optional
string
Description
ISMILESTONE
Optional
boolean
Milestone. Use false for No, true for Yes. (Default: false)
UTILIZED
Optional
boolean
Utilized. Use false for No, true for Yes. (Default: false)
PRIORITY
Optional
string
Priority
TASKNO
Optional
string
WBS code
TASKSTATUS
Required
string
Task status. Use Not Started, Planned, In Progress, Completed, or On Hold.
PARENTKEY
Optional
integer
Parent task RECORDNO
SUPDOCID
Optional
string
Attachments ID
BUDGETQTY
Optional
number
Planned duration
ESTQTY
Optional
number
Estimated duration
STATUS
Optional
string
Task status. Use active for Active otherwise use inactive for Inactive. (Default: active)
Create Task (Legacy)
create_task
Parameters
Name
Required
Type
Description
taskname
Required
string
Task name to create
projectid
Required
string
Project ID
pbegindate
Optional
object
Project begin date
penddate
Optional
object
Project end date
itemid
Optional
string
Item ID
billable
Optional
boolean
Billable. Use false for No, true for Yes. (Default: false)
taskdescription
Optional
string
Description
ismilestone
Optional
boolean
Milestone. Use false for No, true for Yes. (Default: false)
utilized
Optional
boolean
Utilized. Use false for No, true for Yes. (Default: false)
priority
Optional
string
Priority
taskno
Optional
string
WBS code
taskstatus
Optional
string
Task status
parentkey
Optional
integer
Parent task RECORDNO
parenttaskname
Optional
string
Parent task name
budgetqty
Optional
number
Planned duration
estqty
Optional
number
Estimated duration
timetype
Optional
string
Time type
customfields
Optional
array of customfield
Custom fields
classid
Optional
string
Class ID
supdocid
Optional
string
Attachments ID
dependentonkey
Optional
integer
Dependent on task RECORDNO
dependentonname
Optional
string
Dependent on task name
pbegindate
Name
Required
Type
Description
year
Required
string
Year yyyy
month
Required
string
Month mm
day
Required
string
Day dd
penddate
Name
Required
Type
Description
year
Required
string
Year yyyy
month
Required
string
Month mm
day
Required
string
Day dd
customfield
Name
Required
Type
Description
customfieldname
Optional
string
Custom field ID
customfieldvalue
Optional
varies
Custom field value. For a multi-pick-list custom field, implode multiple field values with #~#.
Update Task
You can update an existing task as described here. If you want to provide observed-percent-completed information for a task, see Task Observed Percent Completed.
update
Parameters
Name
Required
Type
Description
TASK
Required
object
Object to update
TASK
Name
Required
Type
Description
RECORDNO
Required
integer
Task RECORDNO to update
NAME
Optional
string
Task name
PBEGINDATE
Optional
string
Planned begin date, which will default to the project begin date if one is set for the project. Set a different date using format mm/dd/yyyy.
PENDDATE
Optional
string
Planned end date, which will default to the project end date if one is set for the project. Set a different date using format mm/dd/yyyy.
CLASSID
Optional
string
Class ID
ITEMID
Optional
string
Item ID
BILLABLE
Optional
boolean
Billable. Use false for No, true for Yes. (Default: false)
DESCRIPTION
Optional
string
Description
ISMILESTONE
Optional
boolean
Milestone. Use false for No, true for Yes. (Default: false)
UTILIZED
Optional
boolean
Utilized. Use false for No, true for Yes. (Default: false)
PRIORITY
Optional
string
Priority
TASKNO
Optional
string
WBS code
TASKSTATUS
Required
string
Task status. Use Not Started, Planned, In Progress, Completed, or On Hold.
PARENTKEY
Optional
integer
Parent task RECORDNO
SUPDOCID
Optional
string
Attachments ID
BUDGETQTY
Optional
number
Planned duration
ESTQTY
Optional
number
Estimated duration
STATUS
Optional
string
Task status. Use active for Active otherwise use inactive for Inactive (Default: active)
Update Task (Legacy)
update_task
Parameters
Name
Required
Type
Description
key
Required
integer
Task RECORDNO to update
taskname
Optional
string
Task name
projectid
Optional
string
Project ID
pbegindate
Optional
object
Project begin date
penddate
Optional
object
Project end date
itemid
Optional
string
Item ID
billable
Optional
boolean
Billable. Use false for No, true for Yes.
taskdescription
Optional
string
Description
ismilestone
Optional
boolean
Milestone. Use false for No, true for Yes.
utilized
Optional
boolean
Utilized. Use false for No, true for Yes.
priority
Optional
string
Priority
taskno
Optional
string
WBS code
taskstatus
Optional
string
Task status
parentkey
Optional
integer
Parent task RECORDNO
parenttaskname
Optional
string
Parent task name
budgetqty
Optional
number
Planned duration
estqty
Optional
number
Estimated duration
timetype
Optional
string
Time type
customfields
Optional
array of customfield
Custom fields
classid
Optional
string
Class ID
dependentonkey
Optional
integer
Dependent on task RECORDNO
dependentonname
Optional
string
Dependent on task name
pbegindate
Name
Required
Type
Description
year
Required
string
Year yyyy
month
Required
string
Month mm
day
Required
string
Day dd
penddate
Name
Required
Type
Description
year
Required
string
Year yyyy
month
Required
string
Month mm
day
Required
string
Day dd
customfield
Name
Required
Type
Description
customfieldname
Optional
string
Custom field ID
customfieldvalue
Optional
varies
Custom field value. For a multi-pick-list custom field, implode multiple field values with #~#.