Activities
Get all Activities assigned to a particular User.
Select
The connector 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 connector.
- Id supports the '=' operator.
- OwnerId supports the '=' operator.
- DealId supports the '=' operator.
- LeadId supports the '=' operator.
- PersonId supports the '=' operator.
- OrgId supports the '=' operator.
- Done supports the '=' operator.
For example, the following query is processed server side:
SELECT * FROM Activities WHERE Id = 1 SELECT * FROM Activities WHERE done = 0 SELECT * FROM Activities WHERE OrgId = 3
INSERT
Insert can be executed by specifying the Subject column. The columns that are not required can be inserted optionally.
INSERT INTO Activities (Subject, Type) VALUES ('New Meeting', 'call')
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 Activities SET Subject = 'Updated activity title' WHERE Id = 1
DELETE
Delete can be executed by specifying the Id in the WHERE Clause.
For example:
DELETE FROM Activities WHERE Id = 1
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Integer | True |
The unique identifier of the activity. | |
| Subject | String | False |
Subject of the activity. | |
| PublicDescription | String | False |
Public description for the activity. | |
| Type | String | False |
Type of the activity. | |
| DueTime | Time | False |
The due time for the activity in HH:MM. | |
| Duration | Time | False |
The duration of the activity in HH:MM. | |
| AddTime | Datetime | True |
The date-time in which the activity was added. | |
| UpdateTime | Datetime | True |
The date-time in which the activity was updated. | |
| Busy | Boolean | False |
Whether the activity marks the assignee as busy or not in their calendar | |
| ConferenceMeetingClient | String | True |
The conference meeting client for the activity. | |
| ConferenceMeetingId | String | True |
The meeting id for the conference call. | |
| ConferenceMeetingUrl | String | True |
The url for the conference meeting. | |
| CreatorUserId | Integer | True |
The user id of the creator of the activity | |
| DealId | Integer | False |
The id of the deal corresponding to the activity | |
| Done | Boolean | False |
Whether the activity is done or not. | |
| DueDate | Date | False |
The due-date for the activity. | |
| IsDeleted | Boolean | True |
Whether the activity is deleted or not. | |
| LeadId | String | False |
The Id of the lead corresponding to the activity. | |
| LocationAggregate | String | False |
The location of the activity. | |
| MarkedAsDoneTime | Datetime | True |
The date-time in which the activity was marked as done. | |
| Note | String | False |
The note of the acitivity. | |
| OrgId | Integer | False |
The id of the organisation corresponding to the activity. | |
| OwnerId | Integer | False |
The id of the owner of the activity. | |
| ParticipantsAggregate | String | False |
The information regarding the participants of the acitivity. | |
| PersonId | Integer | False |
The id of the person linked to the activity. | |
| Priority | Integer | False |
The priority of the activity. | |
| ProjectId | String | False |
The id of the project linked to the acitivity. |
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. |