ODBC Driver for Pipedrive

Build 24.0.9062

Activities

Get all Activities assigned to a particular User.

Select

The 本製品 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 本製品.

  • Id supports the '=' operator.
  • Done supports the '=' operator.
  • Type supports the '=, IN' operators.
  • UserId supports the '=' operator.
  • FilterId supports the '=' operator.
  • StartDate supports the '=' operator.
  • EndDate supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM Activities WHERE Id = 246

SELECT * FROM Activities WHERE Done = 0

SELECT * FROM  Activities WHERE Type IN ('deadline', 'call')

SELECT * FROM  Activities WHERE EndDate = '2021-12-24'
 
SELECT * FROM  Activities WHERE UserId = 8230170

INSERT

The columns that are not read-only can be inserted. Following is an example of how to insert into this table.

INSERT INTO ActivitiesAttendees#TEMP (EmailAddress) VALUES ('[email protected]')
INSERT INTO Activities (DueDate, DueTime, Duration, Dealid, Attendees) VALUES ('1994-10-12', '10:20', '02:00', 1, 'ActivitiesAttendees#TEMP')

UPDATE

UPDATE can be executed by specifying the Id in the WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE Activities SET DealId = 2 WHERE Id = 245

DELETE

DELETE can be executed by specifying the Id in the WHERE Clause. For example:

DELETE FROM Activities WHERE Id = 246

Columns

Name Type ReadOnly Description
Id [KEY] Integer True

Activity Id.

ActiveFlag Boolean True

ActiveFlag.

AddTime Datetime True

AddTime.

AssignedToUserId Integer True

AssignedToUserId.

Attendees String False

Attendees of the Activity This can be either your existing Pipedrive contacts or an external email address.

BusyFlag Boolean True

Set the Activity as Busy or Free.

使用できる値は次のとおりです。true, false

デフォルト値はtrueです。

CalendarSync String True

CalendarSync.

CompanyId Integer True

CompanyId.

MeetingClient String True

MeetingClient.

MeetingId String True

MeetingId.

MeetingUrl String True

MeetingUrl.

CreatedByUserId Integer True

CreatedByUserId.

DealDropboxBcc String True

DealDropboxBcc.

DealId Integer False

The ID of the Deal this Activity is associated with.

DealTitle String True

DealTitle.

Done Boolean True

Whether the Activity is done or not 0 = Not done 1 = Done If omitted returns both Done and Not done activities.

使用できる値は次のとおりです。0, 1

DueDate Date False

Due date of the Activity Format YYYY-MM-DD

DueTime Time False

Due time of the Activity in UTC Format HH:MM

Duration Time True

Duration of the Activity Format HH:MM

FileCleanName String True

FileCleanName.

FileId String True

FileId.

FileUrl String True

FileUrl.

GcalEventId String True

GcalEventId.

GoogleCalendarEtag String True

GoogleCalendarEtag.

GoogleCalendarId String True

GoogleCalendarId.

LastNotificationTime Datetime True

LastNotificationTime.

LastNotificationUserId Integer True

LastNotificationUserId.

LeadId String True

LeadId.

Location String False

The address of the Activity.

AdminAreaLevel1 String True

AdminAreaLevel1.

AdminAreaLevel2 String True

AdminAreaLevel2.

LocationCountry String True

LocationCountry.

FormattedAddress String True

FormattedAddress.

LocationLat Double True

LocationLat.

LocationLocality String True

LocationLocality.

LocationLong Double True

LocationLong.

PostalCode String True

PostalCode.

LocationRoute String True

LocationRoute.

StreetNumber String True

StreetNumber.

Sublocality String True

Sublocality.

Subpremise String True

Subpremise.

MarkedAsDoneTime Datetime True

MarkedAsDoneTime.

Note String False

Note of the Activity HTML format.

NotificationLanguageId Integer True

NotificationLanguageId.

OrgId Integer False

The ID of the Organization this Activity is associated with.

OrgName String True

OrgName.

OwnerName String True

OwnerName.

Participants String False

List of multiple Persons participants this Activity is associated with If omitted single participant from person_id field is used.

PersonDropboxBcc String True

PersonDropboxBcc.

PersonId Integer False

The ID of the Person this Activity is associated with.

PersonName String True

PersonName.

PublicDescription String False

Additional details about the Activity that is synced to your external calendar Unlike the note added to the Activity the description is publicly visible to any guests added to the Activity.

RecMasterActivityId String True

RecMasterActivityId.

RecRule String True

RecRule.

RecRuleExtension String True

RecRuleExtension.

ReferenceId Integer True

ReferenceId.

ReferenceType String True

ReferenceType.

Series String True

Series.

SourceTimezone String True

SourceTimezone.

Subject String False

Subject of the Activity.

デフォルト値はCallです。

Type String True

Type of the Activity This is in correlation with the key_string parameter of ActivityTypes When value for type is not set, it will be given a default value Call.

デフォルト値はCallです。

UpdateTime Datetime True

UpdateTime.

UpdateUserId Integer True

The ID of the User whose Activities will be fetched If omitted the User associated with the API token will be used If 0 Activities for all company Users will be fetched based on the permission sets.

UserId Integer False

UserId.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
FilterId Integer

The ID of the Filter to use.

StartDate String

Use the Activity due date where you wish to begin fetching Activities from Insert due date in YYYY-MM-DD format.

EndDate String

Use the Activity due date where you wish to stop fetching Activities from Insert due date in YYYY-MM-DD format.

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