JDBC Driver for Pipedrive

Build 22.0.8462

OrganizationsUpdates

Get details of organizations 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.

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

For example, the following query is processed server side:

SELECT * FROM OrganizationsUpdates WHERE OrgId = 246 

SELECT * FROM OrganizationsUpdates WHERE OrgId = 10 AND AllChanges = 1

SELECT * FROM OrganizationsUpdates WHERE OrgId = 10 AND Items IN ('activity','plannedActivity')

Columns

Name Type Description
Id [KEY] Integer Id.
ActiveFlag Boolean ActiveFlag.
ActivityId String ActivityId.
AddTime Datetime AddTime.
NewValueFormatted String NewValueFormatted.
OldValueFormatted String OldValueFormatted.
AssignedToUserId Integer AssignedToUserId.
Attendees String Attendees.
BusyFlag Boolean BusyFlag.
IncludeContext String IncludeContext.
ChangeSource String ChangeSource.
User_agent String User_agent.
Cid String Cid.
CompanyId Integer CompanyId.
ConferenceMeetingClient String ConferenceMeetingClient.
ConferenceMeetingId String ConferenceMeetingId.
ConferenceMeetingUrl String ConferenceMeetingUrl.
CreatedByUserId Integer CreatedByUserId.
DealDropboxBcc String DealDropboxBcc.
DealId Integer DealId.
DealName String DealName.
DealTitle String DealTitle.
Description String Description.
Done Boolean Done.
DueDate Date DueDate.
DueTime Time DueTime.
Duration Time Duration.
FieldKey String FieldKey.
FileCleanName String FileCleanName.
FileId String FileId.
FileUrl String FileUrl.
FileName String FileName.
FileSize Integer FileSize.
FileType String FileType.
GcalEventId String GcalEventId.
GoogleCalendarEtag String GoogleCalendarEtag.
GoogleCalendarId String GoogleCalendarId.
InlineFlag Boolean InlineFlag.
IsBulkUpdateFlag String IsBulkUpdateFlag.
ItemId Integer ItemId.
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.
LogId String LogId.
LogTime Datetime LogTime.
MessageId String MessageId.
TemplateId String TemplateId.
MarkedAsDoneTime Datetime MarkedAsDoneTime.
Name String Name.
NewValue String NewValue.
Note String Note.
NotificationLanguageId Integer NotificationLanguageId.
OldValue Integer OldValue.
OrgId Integer OrgId.
OrgName String OrgName.
OwnerName String OwnerName.
Participants String Participants.
PeopleName String PeopleName.
PersonDropboxBcc String PersonDropboxBcc.
PersonId Integer PersonId.
PersonName String PersonName.
ProductId String ProductId.
ProductName String ProductName.
PublicDescription String PublicDescription.
RecActivityId String RecActivityId.
RecRule String RecRule.
RecRuleExtension String RecRuleExtension.
ReferenceId Integer ReferenceId.
ReferenceType String ReferenceType.
RemoteId String RemoteId.
RemoteLocation String RemoteLocation.
S3Bucket String S3Bucket.
Series String Series.
Sourcetimezone String Sourcetimezone.
Subject String Subject.
Type String Type.
UpdateTime Datetime UpdateTime.
UpdateUserId Integer UpdateUserId.
Url String Url.
UserId Integer UserId.
Object String Object.
Timestamp Datetime Timestamp.

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