Activities

[DEPRICATED endpoint, use Activities in PipedriveV2 instead.]Returns all activities assigned to a user, including scheduled calls, meetings, tasks, and their associated deals, persons, and organizations.

Table-Specific Information

SELECT

The provider uses 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 provider.


Column	Supported Operators
Id	=
Done	=
Type	=, IN
UserId	=
FilterId	=
StartDate	=
EndDate	=

For example, the following queries are 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

Columns that are not read-only can be inserted. The following example shows how to insert into these tables and how to insert attendee data using a temporary 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

Execute UPDATE by specifying the Id in the WHERE clause. All columns that are not read-only can be updated. For example:

UPDATE Activities SET DealId = 2 WHERE Id = 245

DELETE

Execute DELETE specifying the Id in the WHERE clause. For example:

DELETE FROM Activities WHERE Id = 246

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Integer	True		Activity Id.
ActiveFlag	Boolean	True		Indicates whether the activity is currently active.
AddTime	Datetime	True		Date and time when the activity was created.
AssignedToUserId	Integer	True		Unique identifier of the user the activity is assigned to.
Attendees	String	False		Attendees of the Activity This can be either your existing Pipedrive contacts or an external email address.
BusyFlag	Boolean	False		Set the Activity as Busy or Free. The allowed values are true, false. The default value is true.
CalendarSync	String	True		Context data included when the activity is synced to an external calendar.
CompanyId	Integer	True		Unique identifier of the company account this activity belongs to.
MeetingClient	String	True		Name of the video conferencing client used for the activity, for example Google Meet or Zoom.
MeetingId	String	True		Unique identifier of the video conference meeting linked to the activity.
MeetingUrl	String	True		URL to join the video conference meeting linked to the activity.
CreatedByUserId	Integer	True		Unique identifier of the user who created the activity.
DealDropboxBcc	String	True		BCC email address for the deal associated with this activity, used to log emails to the deal record.
DealId	Integer	False	Deals.Id	The ID of the Deal this Activity is associated with.
DealTitle	String	True		Title of the deal associated with the activity.
Done	Boolean	False		Whether the Activity is done or not 0 = Not done 1 = Done If omitted returns both Done and Not done activities. The allowed values are 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	False		Duration of the Activity Format HH:MM
FileCleanName	String	True		Display name of the file attached to the activity, with special characters removed.
FileId	String	True	Files.Id	Unique identifier of the file attached to the activity.
FileUrl	String	True		Download URL of the file attached to the activity.
GcalEventId	String	True		Unique identifier of the Google Calendar event linked to this activity.
GoogleCalendarEtag	String	True		ETag of the Google Calendar event, used to detect changes during synchronization.
GoogleCalendarId	String	True		Unique identifier of the Google Calendar where this activity is synced.
LastNotificationTime	Datetime	True		Date and time when the last reminder notification was sent for this activity.
LastNotificationUserId	Integer	True		Unique identifier of the user who received the last reminder notification for this activity.
LeadId	String	False	Leads.Id	Unique identifier of the lead this activity is associated with.
Location	String	False		The address of the Activity.
AdminAreaLevel1	String	True		First-level administrative area (for example, state or province) of the activity location.
AdminAreaLevel2	String	True		Second-level administrative area (for example, county or district) of the activity location.
LocationCountry	String	True		Country component of the activity location address.
FormattedAddress	String	True		Complete formatted address of the activity location as returned by the geocoding service.
LocationLat	Double	True		Latitude coordinate of the activity location.
LocationLocality	String	True		City or locality component of the activity location address.
LocationLong	Double	True		Longitude coordinate of the activity location.
PostalCode	String	True		Postal or ZIP code component of the activity location address.
LocationRoute	String	True		Street name (route) component of the activity location address.
StreetNumber	String	True		Street number component of the activity location address.
Sublocality	String	True		Sublocality (for example, neighborhood or borough) component of the activity location address.
Subpremise	String	True		Subpremise (for example, suite or unit number) component of the activity location address.
MarkedAsDoneTime	Datetime	True		Date and time when the activity was marked as done.
Note	String	False		Note of the Activity HTML format.
NotificationLanguageId	Integer	True		Language identifier used for sending notifications related to this activity.
OrgId	Integer	False		The ID of the Organization this Activity is associated with.
OrgName	String	True		Name of the organization this activity is associated with.
OwnerName	String	True		Full name of the user who owns the activity.
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		BCC email address for the person associated with this activity, used to log emails to their record.
PersonId	Integer	False	Persons.Id	The ID of the Person this Activity is associated with.
PersonName	String	True		Full name of the person this activity is associated with.
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		Unique identifier of the master recurring activity this instance belongs to.
RecRule	String	True		Recurrence rule defining the schedule pattern for repeating activities, in iCalendar RRULE format.
RecRuleExtension	String	True		Extended recurrence rule data for recurring activities, supplementing the primary recurrence rule.
ReferenceId	Integer	True		Unique identifier of the external reference object linked to this activity.
ReferenceType	String	True		Type of the external reference object linked to this activity, for example deal or person.
Series	String	True		Series data for recurring activities, describing how the instances relate to each other.
SourceTimezone	String	True		Timezone identifier of the source system where the activity was originally created.
Subject	String	False		Subject of the Activity. The default value is Call.
Type	String	False		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. The default value is Call.
UpdateTime	Datetime	True		Date and time when the activity was last updated.
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	Users.Id	Unique identifier of the user the activity belongs to. Filters activities returned by this user.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.


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.

ADO.NET Provider for Pipedrive