DealsParticipants

Get details of deals participants.

Select

The add-in 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 add-in.

Id supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM DealsParticipants WHERE Id = 9

INSERT

Insert can be executed by specifying the Content and PersonId columns. The columns that are not required can be inserted optionally. For example:

INSERT INTO DealsParticipants (Id, Personid) VALUES (4, 6)

DELETE

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

DELETE FROM DealsParticipants WHERE id = 14 AND ItemDealId = 17

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Integer	True		Id.
ActiveFlag	Boolean	True		ActiveFlag.
AddTime	Datetime	True		AddTime.
AddedByactiveFlag	Boolean	True		AddedByactiveFlag.
AddedByemail	String	True		AddedByemail.
AddedByhasPic	Integer	True		AddedByhasPic.
AddedByid	Integer	True		AddedByid.
AddedByname	String	True		AddedByname.
AddedBypicHash	String	True		AddedBypicHash.
AddedByvalue	Integer	True		Added_byvalue.
PersonActiveFlag	Boolean	True		PersonActiveFlag.
ActivitiesCount	Integer	True		ActivitiesCount.
PersonAddTime	Datetime	True		AddTime.
CcEmail	String	True		CcEmail.
ClosedDealsCount	Integer	True		ClosedDealsCount.
CompanyId	Integer	True		CompanyId.
DoneActivitiesCount	Integer	True		DoneActivitiesCount.
Email	String	True		Email.
EmailMessagesCount	Integer	True		EmailMessagesCount.
FilesCount	Integer	True		FilesCount.
FirstChar	String	True		FirstChar.
FirstName	String	True		FirstName.
FollowersCount	Integer	True		FollowersCount.
Personlabel	String	True		Personlabel.
LastActivityDate	Date	True		LastActivityDate.
LastActivityId	Integer	True		LastActivityId.
LastincomingMailTime	String	True		LastincomingMailTime.
Lastname	String	True		Lastname.
LastoutgoingMailTime	String	True		LastoutgoingMailTime.
LostdealsCount	Integer	True		LostdealsCount.
Name	String	True		Name.
NextActivityDate	Date	True		nextActivityDate.
NextActivityId	Integer	True		nextActivityId.
NextActivityTime	String	True		nextActivityTime.
NotesCount	Integer	True		NotesCount.
OpenDealsCount	Integer	True		OpenDealsCount.
OrgActiveFlag	Boolean	True		OrgActiveFlag.
OrgAddress	String	True		OrgAddress.
OrgCcEmail	String	True		OrgCcEmail.
OrgName	String	True		OrgName.
OrgownerId	Integer	True		OrgownerId.
OrgpeopleCount	Integer	True		OrgpeopleCount.
OrgId	Integer	True		OrgId.
OwnerActiveFlag	Boolean	True		OwnerActiveFlag.
OwnerEmail	String	True		OwnerEmail.
OwnerHasPic	Integer	True		OwnerHasPic.
OwnerId	Integer	True		OwnerId.
OwnerName	String	True		OwnerName.
OwnerPicHash	String	True		OwnerPicHash.
OwnerValue	Integer	True		OwnerValue.
ParticipantClosedDealsCount	Integer	True		ClosedDealsCount.
ParticipantOpenDealsCount	Integer	True		OpenDealsCount.
Phone	String	True		Phone.
PictureId	String	True		PictureId.
RelatedclosedDealsCount	Integer	True		RelatedclosedDealsCount.
RelatedlostDealsCount	Integer	True		RelatedlostDealsCount.
RelatedopenDealsCount	Integer	True		RelatedopenDealsCount.
RelatedwonDealsCount	Integer	True		RelatedwonDealsCount.
SyncNeeded	Boolean	True		SyncNeeded.
UndoneActivitiesCount	Integer	True		UndoneActivitiesCount.
UpdateTime	Datetime	True		UpdateTime.
VisibleTo	String	True		visibleTo.
WonDealsCount	Integer	True		WonDealsCount.
PersonIdActiveFlag	Boolean	True		PersonactiveFlag.
Personemail	String	True		Personemail.
Personname	String	True		Personname.
Personphone	String	True		Personphone.
PersonValues	Integer	False		PersonValues.
ItemDealId [KEY]	Integer	True	Deals.id	ItemDealId.
ItemTitle	String	True		ItemTitle.
ItemId	Integer	True		ItemId.
ItemType	String	True		ItemType.
PersonId	Integer	False	Persons.Id	Person Id.
PersonOrgName	String	True		Person OrgName.
PersonOwnerName	String	True		Person OwnerName.

Excel Add-In for Pipedrive

DealsParticipants

Select

INSERT

DELETE

Columns