Persons
Get all persons.
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 | = |
| OwnerId | = |
| OrgId | = |
| DealId | = |
| UpdateTime | =,<,<=,>,>= |
For example, the following queries are processed server-side:
SELECT * FROM Persons WHERE Id = 1
SELECT * FROM Persons WHERE OwnerId = 1 AND OrgId = 2
SELECT * FROM Persons WHERE DealId = 1
INSERT
Execute INSERT by specifying the Name column. All columns that are not required are optional.
For example:
INSERT INTO Persons (Name) VALUES ('New name 1')
UPDATE
Execute UPDATE by specifying the Id in the WHERE clause. All columns that are not read-only can be updated.
For example:
UPDATE Persons SET Name = 'Updated name 1' WHERE Id = 10
DELETE
Execute DELETE 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 | False |
The date-time at which the person's data was added. | |
| CustomFields | String | False |
The custom-fields for the person. | |
| IsDeleted | Boolean | True |
Indicates whether the person's data is deleted. | |
| LabelIds | String | False |
The Id of the label associated with the person. | |
| OrgId | Integer | False |
The Id of the organization 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 at which the person's 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 more granular control over the data returned from the data source.
| Name | Type | Description |
| FilterId | Integer |
Filter Id. |
| DealId | Integer |
The Id of the deal corresponding to the activity |