Tasks
Stores task records linked to CRM entities, including priority, due date, and reminder settings.
Table-Specific Information
Select
This table supports COQL for filtering, meaning that most filters comparing columns to values are submitted server-side.
Insert
INSERT INTO Tasks(Subject, Status) VALUES ('Finish sending emails to potential leads.', 'Created')
INSERT INTO Tasks(Subject, Status, ModuleName) VALUES ('Finish sending emails to potential leads.', 'Created', 'Contacts')
INSERT INTO Tasks(Subject, Status, ModuleName, RelatedTo_Id) VALUES ('Finish sending emails to potential leads.', 'Created', 'Contacts', '2788704000120533263')
Required fields: Subject, ModuleName if RelatedTo_Id is specified.
Any field which is not read-only (ReadOnly = false in the table below) can be inserted.
Delete
You must specify the Id in the WHERE clause when executing a delete against this table.
DELETE FROM Tasks WHERE Id = '3152079000000153079'
Update
You must specify the Id in the WHERE clause when executing an update against this table.
UPDATE Tasks SET Status = 'In progress' WHERE Id = '3152079000000492026'
Required fields: Id.
Any field which is not read-only (ReadOnly = false in the table below) can be updated.
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | True |
Unique identifier for the task. |
| TaskOwner_Id | String | False |
Unique identifier of the user who owns the task. |
| TaskOwner_FirstName | String | True |
First name of the task owner. |
| TaskOwner_LastName | String | True |
Last name of the task owner. |
| TaskOwner_Email | String | True |
Email address of the task owner. |
| TaskOwner_Name | String | True |
Full name of the task owner. |
| Subject | String | False |
Title or subject of the task. |
| DueDate | Date | False |
Date by which the task should be completed. |
| ContactName_Id | String | False |
Unique identifier of the contact linked to the task. |
| ContactName_Name | String | True |
Full name of the contact linked to the task. |
| RelatedTo_Id | String | False |
Unique identifier of the related record, such as a deal or account. |
| RelatedTo_Name | String | True |
Name of the related record, such as a deal or account. |
| Status | String | False |
Current status of the task. |
| Priority | String | False |
Priority level of the task. |
| ClosedTime | Datetime | True |
Date and time when the task was marked as completed. |
| SendNotificationEmail | Bool | False |
Indicates whether a notification email is sent when the task is assigned. |
| Repeat_Id | String | False |
Unique identifier of the recurring task pattern, if any. |
| Repeat_Name | String | True |
Name or description of the recurring task pattern, if any. |
| Reminder_Id | String | False |
Unique identifier of the reminder associated with the task. |
| Reminder_Name | String | True |
Name or description of the task reminder. |
| CreatedBy_Id | String | False |
Unique identifier of the user who created the task. |
| CreatedBy_FirstName | String | True |
First name of the user who created the task. |
| CreatedBy_LastName | String | True |
Last name of the user who created the task. |
| CreatedBy_Email | String | True |
Email address of the user who created the task. |
| CreatedBy_Name | String | True |
Full name of the user who created the task. |
| ModifiedBy_Id | String | False |
Unique identifier of the user who last modified the task. |
| ModifiedBy_FirstName | String | True |
First name of the user who last modified the task. |
| ModifiedBy_LastName | String | True |
Last name of the user who last modified the task. |
| ModifiedBy_Email | String | True |
Email address of the user who last modified the task. |
| ModifiedBy_Name | String | True |
Full name of the user who last modified the task. |
| CreatedTime | Datetime | False |
Date and time when the task was created. |
| ModifiedTime | Datetime | False |
Date and time when the task was last modified. |
| Tag | String | False |
Tags associated with the task. |
| Description | String | False |
Detailed description of the task. |
| Locked | Bool | True |
Indicates whether the task is locked for editing. |
| LastActivityTime | Datetime | False |
Timestamp of the last recorded activity related to the task. |
| ModuleName | String | False |
Name of the module that contains the task. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| DuplicateCheckFields | String |
Field or fields used to detect duplicate tasks when performing an upsert. Multiple fields are supported by the REST API, but only one is supported by the BULK API. |
| Trigger | String |
Specifies whether to trigger associated automation rules when inserting a task into the CRM account. |
| CustomViewId | Long |
ID of the custom view used to filter this task. This works only when the useCOQL parameter is false. |