CallLogs
Returns all call logs assigned to a particular user.
Select
The 本製品 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 本製品.
- 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. 使用できる値は次のとおりです。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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
LeadId | String |
Only used for insert. The ID of the lead the call log is associated with in UUID format (optional). |