Tasks

Returns all tasks within projects, including completion status, due dates, assignees, and parent-child task relationships.

Table-Specific Information

SELECT

The provider uses the Pipedrive API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the provider.


Column	Supported Operators
Id	=
AssigneeId	=
ParentTaskId	=
ProjectId	=
Done	=

For example, the following queries are processed server-side:

SELECT * FROM Tasks WHERE Id = 1
SELECT * FROM Tasks WHERE done = 0
SELECT * FROM Tasks WHERE ParentTaskId = 3

INSERT

Execute INSERT by specifying the Title and ProjectId columns. You can also insert any columns that are not required.

INSERT INTO Tasks (Title, ProjectId) VALUES ('New task', 3)

UPDATE

Execute UPDATE by specifying the Id in the WHERE clause. All columns that are not read-only can be updated. For example:

UPDATE Tasks SET Title = 'Updated task title' WHERE Id = 1

DELETE

Execute DELETE by specifying the Id in the WHERE clause. For example:

DELETE FROM Tasks WHERE Id = 1

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Integer	True		The unique identifier of the task.
Title	String	False		The title of the task.
Description	String	False		The description of the task.
Done	Integer	False		Indicates whether the task has been completed. Set to 1 for done, 0 for not done.
DueDate	Date	False		Due date of the task.
AddTime	Datetime	True		The date when the task was added.
AssigneeId	Integer	False		The id of the assignee of the task.
CreatorId	Integer	True		The id of the creator of the task.
MarkedAsDoneTime	Datetime	True		The time when the task was marked as done.
ParentTaskId	Integer	False		Unique identifier of the parent task, used to establish subtask relationships.
ProjectId	Integer	False		The id of the corresponding project.
UpdateTime	Datetime	True		The date-time when the task was updated.