Activities
Returns all activities assigned to the current user, including calls, meetings, tasks, and other scheduled interactions linked to deals, leads, persons, and organizations.
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 | = |
| OwnerId | = |
| DealId | = |
| LeadId | = |
| PersonId | = |
| OrgId | = |
| Done | = |
| UpdateTime | =,<,<=,>,>= |
For example, the following queries are processed server-side:
SELECT * FROM Activities WHERE Id = 1
SELECT * FROM Activities WHERE done = 0
SELECT * FROM Activities WHERE OrgId = 3
Insert
Execute INSERT by specifying the Subject column. You can also insert any optional columns.
INSERT INTO Activities (Subject, Type) VALUES ('New Meeting', 'call')
Update
Execute UPDATE by specifying the Id in the WHERE clause. You can update any columns that are not read-only.
For example:
UPDATE Activities SET Subject = 'Updated activity title' WHERE Id = 1
Delete
Execute DELETE 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 |
The subject line or title of the activity. | |
| PublicDescription | String | False |
A publicly visible description of the activity, shown to all participants. | |
| Type | String | False |
The type of the activity, such as call, meeting, task, or email. | |
| DueTime | Time | False |
The due time for the activity in HH:MM format. | |
| Duration | Time | False |
The duration of the activity in HH:MM format. | |
| AddTime | Datetime | True |
The date and time at which the activity was created. | |
| UpdateTime | Datetime | True |
The date and time at which the activity was last updated. | |
| Busy | Boolean | False |
Indicates whether the activity marks the assignee as busy in their calendar. | |
| ConferenceMeetingClient | String | True |
The name of the conference meeting client used for the activity, such as Zoom or Google Meet. | |
| ConferenceMeetingId | String | True |
The unique identifier of the conference call meeting. | |
| ConferenceMeetingUrl | String | True |
The URL used to join the conference meeting. | |
| CreatorUserId | Integer | True |
The unique identifier of the user who created the activity. | |
| DealId | Integer | False |
The unique identifier of the deal linked to the activity. | |
| Done | Boolean | False |
Indicates whether the activity has been marked as completed. | |
| DueDate | Date | False |
The date on which the activity is due. | |
| IsDeleted | Boolean | True |
Indicates whether the activity has been deleted. | |
| LeadId | String | False |
The unique identifier of the lead linked to the activity. | |
| LocationAggregate | String | False |
The physical or virtual location where the activity takes place. | |
| MarkedAsDoneTime | Datetime | True |
The date and time at which the activity was marked as completed. | |
| Note | String | False |
Additional notes or details recorded against the activity. | |
| OrgId | Integer | False |
The unique identifier of the organization linked to the activity. | |
| OwnerId | Integer | False |
The unique identifier of the user who owns the activity. | |
| ParticipantsAggregate | String | False |
A JSON aggregate containing details of the persons participating in the activity. | |
| PersonId | Integer | True |
The unique identifier of the person linked to the activity. | |
| Priority | Integer | False |
The priority level assigned to the activity. | |
| ProjectId | String | False |
The unique identifier of the project linked to the activity. | |
| AttendeesAggregate | String | False |
A JSON aggregate containing details of the attendees invited to the activity. |
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. |