Power BI Connector for Pipedrive

Build 24.0.9060

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060