ActivityTypes

Returns all activity types defined in the Pipedrive account, including built-in and custom types.

Table-Specific Information

The provider uses the Pipedrive API to process WHERE clause conditions built with the following column and operator.

For example, the following query is processed server-side:

SELECT * FROM Activities WHERE Id = 9

The rest of the filter is executed client-side within the provider.

To execute an INSERT query, specify the Name and IconKey columns. You can also insert any optional columns.

For example:

INSERT INTO ActivityTypes (Color, IconKey, Name) VALUES ('black', 'sound', 'pvnactivity');

To execute an UPDATE query, specify the Id in the WHERE clause. You can update any columns that are not read-only.

For example:

UPDATE ActivityTypes SET IconKey = 'email' WHERE Id = 7

To execute a DELETE, specify the Id in the WHERE clause.

For example:

DELETE FROM ActivityTypes WHERE Id = 2


Name	Type	ReadOnly	References	Description
Id [KEY]	Integer	True		The unique identifier of the activity type.
ActiveFlag	Boolean	True		Indicates whether this activity type is active. When true, the type appears in activity type selection lists.
AddTime	Datetime	True		The date and time when this activity type was created.
Color	String	False		The color assigned to this activity type, expressed as a hexadecimal color code.
IconKey	String	False		The icon identifier that visually represents this activity type in the Pipedrive interface. The allowed values are task, email, meeting, deadline, call, lunch, calendar, downarrow, document, smartphone, camera, scissors, cogs, bubble, uparrow, checkbox, signpost, shuffle, addressbook, linegraph, picture, car, world, search, clip, sound, brush, key, padlock, pricetag, suitcase, finish, plane, loop, wifi, truck, cart, bulb, bell, presentation.
IsCustomFlag	Boolean	True		Indicates whether this activity type was created by a user rather than being a Pipedrive built-in type.
KeyString	String	True		The unique string key that identifies this activity type in API requests and filter parameters.
Name	String	False		The display name of the activity type.
OrderNr	Integer	False		The sort order position of this activity type within activity type selection lists.
UpdateTime	Datetime	True		The date and time when this activity type was last modified.