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. 使用できる値は次のとおりです。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 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。