Projects
Get all projects data.
Select
The server will use 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 server.
- Status supports the '=' operator.
- PhaseId supports the '=' operator.
For example, the following query is processed server side:
SELECT * FROM Projects WHERE status = 'open' SELECT * FROM Projects WHERE phaseId = 1
INSERT
Insert can be executed by specifying the Title, BoardId and PhaseId columns. The columns that are not required can be inserted optionally.
INSERT INTO Projects (Title, BoardId, PhaseId) VALUES ('New Project', 3,1)
UPDATE
UPDATE can be executed by specifying the Id in the WHERE Clause. The columns that are not read-only can be Updated.
For example:
UPDATE Projects SET Title = 'Updated Project title' WHERE Id = 1
DELETE
Delete can be executed 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 |
The board id of the project. | |
| 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 |
The org id of the 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 |
The phase id of the project. |
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 |
| FilterId | Integer |
The ID of the Filter to use. |
| IncludeArchived | Boolean |
Include archived. |