Buckets:

Jamesbrendamour
/

sage-dev-docs

Files

xet

Jamesbrendamour/sage-dev-docs / api /project-resource-mgmt /tasks.md

Jamesbrendamour

12 days ago

preview code

download

raw

13.9 kB

metadata

title: Tasks | Sage Intacct Developer
url: https://developer.intacct.com/api/project-resource-mgmt/tasks/

Tasks | Sage Intacct Developer

Get Task Object Definition
Query and List Tasks
Query and List Tasks (Legacy)
Get Task
Create Task
Create Task (Legacy)
Update Task
Update Task (Legacy)
Delete Task
Delete Task (Legacy)

A task is a unit of work to be performed for a project.

Get Task Object Definition

`lookup`

List all the fields and relationships for the task object:

<lookup>
    <object>TASK</object>
</lookup>

Parameters

Name	Required	Type	Description
object	Required	string	Use `TASK`

Query and List Tasks

`query`

List the task IDs of tasks for the given project:

<query>
    <object>TASK</object>
    <select>
        <field>TASKID</field>
        <field>PROJECTID</field>
    </select>
    <filter>
        <equalto>
            <field>PROJECTID</field>
            <value>20-002</value>
        </equalto>
    </filter>
</query>

Parameters

Name	Required	Type	Description
object	Required	string	Use `TASK`
filter	Optional	object	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>`
options	Optional	object	Query options: * 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`

<readByQuery>
    <object>TASK</object>
    <fields>*</fields>
    <query></query>
    <pagesize>100</pagesize>
</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`

<read>
    <object>TASK</object>
    <keys>1</keys>
    <fields>*</fields>
</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.
returnFormat	Optional	string	Data format for the response body: * `xml` (default) * `json` * `csv`

Create Task

History

Release	Changes
2020 Release 1	Added STANDARDTASKID
2019 Release 1	Added TASKID

`create`

<create>
    <TASK>
        <NAME>hello world</NAME>
        <PROJECTID>P1234</PROJECTID>
        <TASKID>Prep-01</TASKID>
        <TASKSTATUS>In Progress</TASKSTATUS>
    </TASK>
</create>

Parameters

Name	Required	Type	Description
TASK	Required	object	Object to create

TASK

Name	Required	Type	Description
NAME	Required	string	Task name to create
PROJECTID	Required	string	Project ID
STANDARDTASKID	Optional	string	ID of a standard task to use
TASKID	Optional	string	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`

<create_task>
    <taskname>hello world</taskname>
    <projectid>P1234</projectid>
</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`

<update>
    <TASK>
        <RECORDNO>10</RECORDNO>
        <PROJECTID>P1234</PROJECTID>
    </TASK>
</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`

<update_task key="10">
    <projectid>P1234</projectid>
</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 `#~#`.

Delete Task

`delete`

<delete>
    <object>TASK</object>
    <keys>112</keys>
</delete>

Parameters

Name	Required	Type	Description
object	Required	string	Use `TASK`
keys	Required	string	Comma-separated list of task `RECORDNO` to delete

Delete Task (Legacy)

`delete_task`

<delete_task key="10"></delete_task>

Parameters

Name	Required	Type	Description
key	Required	integer	Task `RECORDNO` to delete

Provide feedback

Xet Storage Details

Size:: 13.9 kB
Xet hash:: 138efa65004acf5ceefa112d3aee442d7a04a498845944e79d6ac6df0cad59b3

Xet efficiently stores files, intelligently splitting them into unique chunks and accelerating uploads and downloads. More info.