Tasks

Create, update, delete, and query information regarding tasks.

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	False	The unique identifier for this record.
TaskOwner_Id	String	False	The Id of the owner of the task.
TaskOwner_FirstName	String	False	The First Name of the owner of the task.
TaskOwner_LastName	String	False	The Last Name of the owner of the task.
Subject	String	False	The subject of the task.
DueDate	Date	False	The date when this task is due.
ContactName_Id	String	False	The Id of the contact of the task.
RelatedTo_Id	String	False	The Id of the object related to the task.
Status	String	False	The status of the task.
Priority	String	False	The priority of the task.
CreatedBy_Id	String	False	The Id of the User who created the record.
Tag	String	False	A list of tags related to this record.
SendNotificationEmail	Bool	False	Whether a notification email should be sent for this task or not.
ModifiedBy_Id	String	False	The Id of the User who modified the record.
ModifiedBy_FirstName	String	False	The First Name of the User who modified the record.
ModifiedBy_LastName	String	False	The Last Name of the User who modified the record.
CreatedTime	Datetime	False	The time when the record was created.
ModifiedTime	Datetime	False	The time when the record was modified.
Repeat	String	False	If this task is recurring or not.
ClosedTime	Datetime	False	The time when this task closes.
Description	String	False	The description of the tax.
ModuleName	String	False	The name of the module this task belongs to.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
DuplicateCheckFields	String	The field/s to be used for checking in an upsert.
CustomViewId	Long	The custom view Id to be used for filtering this record. Will work when useCOQL=false.

SSIS Components for Zoho CRM