Persons

Get all persons.

Select

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

Id supports the '=' operator.
OwnerId supports the '=' operator.
OrgId supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM Persons WHERE Id = 1  
SELECT * FROM Persons WHERE OwnerId = 1 AND OrgId=2

INSERT

Insert can be executed by specifying the Name column. The columns that are not required can be inserted optionally.

Insert into Persons (Name) values ('New name 1')

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 Persons Set name='Updated name 1' where id=10

DELETE

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

DELETE FROM Persons where Id=10

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Integer	True		The unique identifier of the person
Name	String	False		The name of the person.
FirstName	String	True		The first name of the person.
LastName	String	True		The last name of the person.
EmailsAggregate	String	False		The array of email details.
PhonesAggregate	String	False		The array of phone details.
AddTime	Datetime	True		The date-time in which the persons data was added.
CustomFields	String	True		The custom-fields for the person.
IsDeleted	Boolean	True		Is the person data deleted.
LabelIds	String	False		The id of the label associated with the person.
OrgId	Integer	False		The id of the organisation associated with the person.
OwnerId	Integer	False		The id of the owner associated with the person data.
PictureId	String	True		The id of the picture associated with the person.
UpdateTime	Datetime	True		The date-time in which the persons data was updated.
VisibleTo	Integer	False		The visibility of the person.
NextActivityId	Integer	True		Next Activity Id.
LastActivityId	Integer	True		Last Activity Id.
OpenDealsCount	Integer	True		Open Deals Count.
RelatedOpenDealsCount	Integer	True		Related Open Deals Count.
ClosedDealsCount	Integer	True		Closed Deals Count.
RelatedClosedDealsCount	Integer	True		Related Closed Deals Count.
ParticipantOpenDealsCount	Integer	True		Participant Open Deals Count.
ParticipantClosedDealsCount	Integer	True		Participant Closed Deals Count.
EmailMessagesCount	Integer	True		Email Messages Count.
ActivitiesCount	Integer	True		Activities Count.
DoneActivitiesCount	Integer	True		Done Activities Count.
UndoneActivitiesCount	Integer	True		Undone Activities Count.
FilesCount	Integer	True		Files Count.
NotesCount	Integer	True		Notes Count.
FollowersCount	Integer	True		Followers Count.
WonDealsCount	Integer	True		Won Deals Count.
RelatedWonDealsCount	Integer	True		Related Won Deals Count.
LostDealsCount	Integer	True		Lost Deals Count.
RelatedLostDealsCount	Integer	True		Related Lost Deals Count.
LastIncomingMailTime	Datetime	True		Last Incoming Mail Time.
LastOutgoingMailTime	Datetime	True		Last Outgoing Mail Time.

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.


Name	Type	Description
FilterId	Integer	Filter Id