DealsParticipants

Get details of deals participants.

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.

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	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	Integer	True	ItemDealId.
ItemTitle	String	True	ItemTitle.
ItemId	Integer	True	ItemId.
ItemType	String	True	ItemType.

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.