JDBC Driver for Pipedrive

Build 22.0.8462

CallLogs

Returns all call logs assigned to a particular user.

Select

The driver 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 driver.

  • 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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462