Projects
Returns all projects, including their status, assigned board and phase, linked deals and organizations, and timeline dates.
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 |
| Status | = |
| PhaseId | = |
For example, the following queries are processed server-side:
SELECT * FROM Projects WHERE status = 'open'
SELECT * FROM Projects WHERE phaseId = 1
INSERT
Execute INSERT by specifying the Title, BoardId, and PhaseId columns. You can also insert any columns that are not required.
INSERT INTO Projects (Title, BoardId, PhaseId) VALUES ('New Project', 3,1)
UPDATE
Execute UPDATE by specifying the Id in the WHERE clause. All columns that are not read-only can be updated.
For example:
UPDATE Projects SET Title = 'Updated Project title' WHERE Id = 1
DELETE
Execute DELETE by specifying the Id in the WHERE clause.
For example:
DELETE FROM Projects WHERE Id = 1
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Integer | True |
The unique identifier of the project. | |
| Title | String | False |
The title of the project. | |
| Description | String | False |
The description of the project. | |
| Status | String | False |
The status of the project. | |
| AddTime | Datetime | True |
The date-time when the project was added. | |
| StartDate | Date | False |
The date when the project was started. | |
| UpdateTime | Datetime | True |
The date-time when the project was updated. | |
| ArchiveTime | Datetime | True |
The date-time when the project was archived. | |
| StatusChangeTime | Datetime | True |
The date-time when the status of the project was changed. | |
| BoardId | Integer | False |
Unique identifier of the board this project is assigned to. | |
| DealIds | String | False |
The deal ids linked to the project. | |
| EndDate | Date | False |
The end date for the project. | |
| LabelsAggregate | String | False |
The labels linked to the project. | |
| OrgId | Integer | False |
Unique identifier of the organization linked to this project. | |
| OwnerId | Integer | False |
The id of the owner of the project. | |
| PersonId | Integer | False |
The id of the person linked to the project. | |
| PhaseId | Integer | False |
Unique identifier of the phase this project is currently in. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description |
| FilterId | Integer |
The ID of the Filter to use. |
| IncludeArchived | Boolean |
Include archived. |