CallLogs
Returns all call logs assigned to a particular user.
Table-Specific Information
SELECT
The provider uses the Pipedrive API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the provider.
| Column | Supported Operators |
| Id | = |
For example, the following query is processed server-side:
SELECT * FROM CallLogs WHERE Id = 'cf75de9e4cbcb4a33658ad40561e3230'
INSERT
Execute INSERT by specifying the Outcome, ToPhoneNumber, StartTime, and EndTime columns. You can also insert any columns that are not required.
INSERT INTO CallLogs (Outcome, StartTime, EndTime, Duration, FromPhoneNumber, ToPhoneNumber, UserId, OrgId) VALUES ('connected', '2021-12-15', '2021-12-16', '140', '984656646', '9846566456', '8230170', '6')
DELETE
Execute DELETE by specifying the Id in the WHERE clause.
For example:
DELETE FROM CallLogs WHERE Id = '8381cea5da671fa16a1eb63af15e5ec4'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
The unique identifier of the call log entry. | |
| ActivityId | Integer | False |
The ID of the activity this call log is linked to. | |
| CompanyId | Integer | True |
The ID of the company account this call log belongs to. | |
| DealId | Integer | False |
The ID of the Deal this call is associated with. | |
| Duration | String | False |
Call duration in seconds. | |
| EndTime | Datetime | False |
The date and time of the end of the call in UTC. Format: YYYY-MM-DD HH:MM:SS | |
| FromPhoneNumber | String | False |
The number that made the call. | |
| HasRecording | Boolean | True |
Indicates whether a recording of this call is available. | |
| Note | String | False |
Note for the call log in HTML format. | |
| OrgId | Integer | False |
The ID of the Organization this call is associated with. | |
| Outcome | String | False |
Describes the outcome of the call. The allowed values are connected, no_answer, left_message, left_voicemail, wrong_number, busy. | |
| PersonId | Integer | False |
The ID of the Person this call is associated with. | |
| StartTime | Datetime | False |
The date and time of the start of the call in UTC. Format: YYYY-MM-DD HH:MM:SS | |
| Subject | String | False |
Name of the activity this call is attached to. | |
| ToPhoneNumber | String | False |
The number called. | |
| UserId | Integer | False |
The ID of the owner of the call log. | |
| LeadId | String | False |
The ID of the lead the call log is associated with in UUID format. |