Organizations
Get all organizations.
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 | = |
| UpdateTime | =,<,<=,>,>= |
For example, the following queries are processed server-side:
SELECT * FROM Organizations WHERE Id = 1
SELECT * FROM Organizations WHERE OwnerId = 1
INSERT
Execute INSERT by specifying the Name column. All columns that are not required are optional.
For example:
INSERT INTO Organizations (Name, AddressAggregate) VALUES ('[Sample] New Org 5', '[{\"label\": \"work\",\"value\": \"123 Elm Street, Springfield123\"}]')
UPDATE
Execute UPDATE by specifying the Id in the WHERE clause. All columns that are not read-only can be updated.
For example:
UPDATE Organizations SET Name = 'Updated Org name' WHERE Id = 1
DELETE
Execute DELETE by specifying the Id in the WHERE clause.
For example:
DELETE FROM Organizations WHERE Id = 1
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Integer | True |
The unique identifier of the organization. | |
| Name | String | False |
The name of the organization. | |
| AddressAggregate | String | False |
The address of the organization. | |
| Website | String | True |
The website of the organization. | |
| AddTime | Datetime | False |
The date-time at which the organization was added. | |
| OwnerId | Integer | False |
The Id of the owner of the organization. | |
| AnnualRevenue | String | True |
The annual revenue of the organization. | |
| CustomFields | String | True |
The custom-fields for the organization. | |
| EmployeeCount | String | True |
The count of employees in the organization. | |
| Industry | String | True |
The industry corresponding to the organization. | |
| IsDeleted | Boolean | True |
Indicates whether the organization is deleted. | |
| LabelIds | String | False |
The array of label Ids corresponding to the organization. | |
| String | True |
The LinkedIn Id corresponding to the organization. | ||
| UpdateTime | Datetime | True |
The last updated date and time of the organization. | |
| VisibleTo | Integer | False |
The visibility of the organization. | |
| 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. | |
| EmailMessagesCount | Integer | True |
Email Messages Count. | |
| PeopleCount | Integer | True |
People 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. |
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. |