CallLogs
Returns all call logs 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.
For example, the following query is processed server side:
SELECT * FROM CallLogs WHERE Id = 'cf75de9e4cbcb4a33658ad40561e3230'
INSERT
Insert can be executed by specifying the Outcome, ToPhoneNumber, StartTime and EndTime columns. The columns that are not required can be inserted optionally.
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
Delete can be executed by specifying the Id in the WHERE Clause.
For example:
DELETE FROM CallLogs WHERE Id = '8381cea5da671fa16a1eb63af15e5ec4'
Columns
Name | Type | ReadOnly | Description |
Id [KEY] | String | True |
ID. |
ActivityId | Integer | False |
ActivityId. |
CompanyId | Integer | True |
CompanyId. |
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 |
HasRecording. |
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. |
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 |
LeadId | String |
Only used for insert. The ID of the lead the call log is associated with in UUID format (optional). |