JDBC Driver for Pipedrive

Build 22.0.8462

OrganizationsActivities

Get details of organizations activities.

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.
  • Done supports the '=' operator.
  • Exclude supports the '=,IN' operators.

For example, the following query is processed server side:

SELECT * FROM OrganizationsActivities WHERE Id = 246 
SELECT * FROM OrganizationsActivities WHERE Id = 246 AND done = 0
SELECT * FROM OrganizationsActivities WHERE Id = 246 AND Exclude IN ('240','241')

Columns

Name Type Description
Id [KEY] Integer Id.
ActiveFlag Boolean ActiveFlag.
AddTime Datetime AddTime.
AssignedTouserId Integer AssignedTouserId.
Attendees String Attendees.
BusyFlag Boolean BusyFlag.
IncludeContext String IncludeContext.
CompanyId Integer CompanyId.
MeetingClient String MeetingClient.
MeetingId String MeetingId.
MeetingUrl String MeetingUrl.
CreatedByUserId Integer CreatedByUserId.
DealDropboxBcc String DealDropboxBcc.
DealId Integer DealId.
DealTitle String DealTitle.
Done Boolean Done.
DueDate Date DueDate.
DueTime Time DueTime.
Duration Time Duration.
FileCleanName String FileCleanName.
FileId String FileId.
FileUrl String FileUrl.
GcaleventId String GcaleventId.
GoogleCalendarEtag String GoogleCalendarEtag.
GoogleCalendarId String GoogleCalendarId.
LastNotificationTime Datetime LastNotificationTime.
LastNotificationUserId Integer LastNotificationUserId.
LeadId String LeadId.
Location String Location.
AdminAreaLevel1 String AdminAreaLevel1.
AdminAreaLevel2 String AdminAreaLevel2.
Country String Country.
FormattedAddress String FormattedAddress.
Lat Double Lat.
Locality String Locality.
Long Double Long.
PostalCode String PostalCode.
Route String Route.
StreetNumber String StreetNumber.
Sublocality String Sublocality.
Subpremise String Subpremise.
MarkedAsDoneTime Datetime MarkedAsDoneTime.
Note String Note.
NotificationLanguageId Integer NotificationLanguageId.
OrgId Integer OrgId.
OrgName String OrgName.
OwnerName String OwnerName.
Participants String Participants.
PersonDropboxBcc String PersonDropboxBcc.
PersonId Integer PersonId.
PersonName String PersonName.
PublicDescription String PublicDescription.
MasterActivityId String MasterActivityId.
Rule String Rule.
RuleExtension String RuleExtension.
ReferenceId Integer ReferenceId.
ReferenceType String ReferenceType.
Series String Series.
SourceTimezone String SourceTimezone.
Subject String Subject.
Type String Type.
UpdateTime Datetime UpdateTime.
UpdateUserId Integer UpdateUserId.
UserId Integer UserId.

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
Exclude String A comma-separated string of activity IDs to exclude from result.

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