Tasks
Holds to-do items linked to records, with due dates, reminders, and priority levels.
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 |
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 |
Subject or title of the task. |
| DueDate | Date | False |
Due date by which the task should be completed. |
| ContactName_Id | String | False |
Identifier of the contact associated with the task. |
| ContactName_Name | String | True |
Name of the contact associated with the task. |
| RelatedTo_Id | String | False |
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, such as Not Started or Completed. |
| Priority | String | False |
Priority level of the task, such as High, Medium, or Low. |
| ClosedTime | Datetime | True |
Date and time when the task was marked as completed. |
| SendNotificationEmail | Bool | False |
Indicates whether an email notification is sent for the task. |
| Repeat_Id | String | False |
Identifier of the repeat schedule for the task, if applicable. |
| Repeat_Name | String | True |
Name of the repeat schedule for the task. |
| Reminder_Id | String | False |
Identifier of the reminder configuration for the task. |
| Reminder_Name | String | True |
Name of the reminder configuration for the task. |
| CreatedBy_Id | String | False |
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 |
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 from editing. |
| LastActivityTime | Datetime | False |
Timestamp of the most recent activity on the task. |
| ModuleName | String | False |
Name of the module this task belongs to. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| DuplicateCheckFields | String |
Field or fields used to check for duplicates during an upsert operation. The REST API supports multiple fields; the BULK API supports only one. |
| Trigger | String |
Specifies whether automation rules are triggered when the task is inserted into the CRM account. |
| CustomViewId | Long |
Custom view identifier used to filter this record. Applicable only when the useCOQL parameter is set to false. |