JDBC Driver for Pipedrive

Build 22.0.8462

DealsUpdates

Get details of deals updates.

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.

  • DealId supports the '=' operator.
  • AllChanges supports the '=' operator.
  • Items supports the '=,IN' operators.

For example, the following query is processed server side:

SELECT * FROM DealsUpdates WHERE DealId = 3 
SELECT * FROM DealsUpdates WHERE DealId = 246 AND AllChanges = 1
SELECT * FROM DealsUpdates WHERE DealId = 246 AND Items IN ('activity' ,'call')

Columns

Name Type Description
id Integer Id.
AccountId String AccountId.
ActiveFlag Boolean ActiveFlag.
AddTime Datetime AddTime.
AdditionalData String AdditionalData.
AssignedToUserId Integer AssignedToUserId.
Attachments String Attachments.
Attendees String Attendees.
Bcc String Bcc.
BodyUrl String BodyUrl.
BusyFlag Boolean BusyFlag.
IncludeContext String IncludeContext.
Cc String Cc.
ChangeSource String ChangeSource.
UserAgent String UserAgent.
CompanyId Integer CompanyId.
MeetingClient String MeetingClient.
MeetingId String MeetingId.
MeetingUrl String MeetingUrl.
CreatedByUserId Integer CreatedByUserId.
DealDropboxBcc String DealDropboxBcc.
DealId Integer DealId.
DealTitle String DealTitle.
DeletedFlag Integer DeletedFlag.
Done Boolean Done.
Draft String Draft.
DraftFlag Integer DraftFlag.
DueDate Date DueDate.
DueTime Time DueTime.
Duration Time Duration.
ExternalDeletedFlag Integer ExternalDeletedFlag.
FieldKey String FieldKey.
CleanName String CleanName.
FileId String FileId.
Url String Url.
From String From.
GcalEventId String GcalEventId.
GoogleCalendarEtag String GoogleCalendarEtag.
GoogleCalendarId String GoogleCalendarId.
AttachmentsFlag Integer AttachmentsFlag.
BodyFlag Integer BodyFlag.
InlineAttachmentsFlag Integer InlineAttachmentsFlag.
RealAttachmentsFlag Integer RealAttachmentsFlag.
IsBulkUpdateFlag String IsBulkUpdateFlag.
ItemId Integer ItemId.
ItemType String ItemType.
NotificationTime Datetime NotificationTime.
NotificationUserId Integer NotificationUserId.
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.
LogTime Datetime LogTime.
TrackingEnabledFlag Integer TrackingEnabledFlag.
MailThreadId Integer MailThreadId.
MailTrackingStatus String MailTrackingStatus.
MarkedAsDoneTime Datetime MarkedAsDoneTime.
MessageTime String MessageTime.
MuaMessageId String MuaMessageId.
NewValue String NewValue.
Note String Note.
LanguageId Integer LanguageId.
NylasId String NylasId.
OldValue Integer OldValue.
OrgId Integer OrgId.
OrgName String OrgName.
OwnerName String OwnerName.
Participants String Participants.
PersonDropboxBcc String PersonDropboxBcc.
PersonId Integer PersonId.
PersonName String PersonName.
PublicDescription String PublicDescription.
ReadFlag Integer ReadFlag.
RecActivityId String RecActivityId.
RecRule String RecRule.
RecRuleExtension String RecRuleExtension.
ReferenceId Integer ReferenceId.
ReferenceType String ReferenceType.
S3Bucket String S3Bucket.
S3BucketPath String S3BucketPath.
SentFlag Integer SentFlag.
SentFromPipedriveFlag Integer SentFromPipedriveFlag.
Series String Series.
SmartBccFlag Integer SmartBccFlag.
Snippet String Snippet.
SourceTimezone String SourceTimezone.
Subject String Subject.
SyncedFlag Integer SyncedFlag.
TemplateId String TemplateId.
Timestamp Datetime Timestamp.
To String To.
Type String Type.
UpdateTime Datetime UpdateTime.
UpdateUserId Integer UpdateUserId.
UserId Integer UserId.
WriteFlag Boolean WriteFlag.
Object String Object.

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
AllChanges String Whether to show custom field updates or not.

The allowed values are 1.

Items String Item specific updates.

The allowed values are activity, plannedActivity, note, file, change, deal, follower, participant, mailMessage, mailMessageWithAttachment, invoice, activityFile, document.

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