Organizations

Get all organizations.

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.
OwnerId supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM Organizations WHERE Id = 1   
SELECT * FROM Organizations WHERE OwnerId = 1

INSERT

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

Insert into Organizations (Name, AddressAggregate) values ('[Sample] New Org 5', '[{\"label\": \"work\",\"value\": \"123 Elm Street, Springfield123\"}]')

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 Organizations SET Name = 'Updated Org name' WHERE Id = 1

DELETE

Delete can be executed 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 organisation.
Name	String	False		The name of the organization.
AddressAggregate	String	False		The address of the organisation.
Website	String	True		The website of the organization.
AddTime	Datetime	True		The date-time at which the organisation was added.
OwnerId	Integer	False		The id of the owner of the organisation.
AnnualRevenue	String	True		The annual revenue of the organisation.
CustomFields	String	True		The custom-fields for the organisation.
EmployeeCount	String	True		The count of employees in the organisation.
Industry	String	True		The industry corrsponding to the organisation.
IsDeleted	Boolean	True		Whether the organisation is deleted.
LabelIds	String	False		The array of label ids corresponding to the organisation.
LinkedIn	String	True		The linked-in 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 a more granular control over the tuples that are returned from the data source.


Name	Type	Description
FilterId	Integer	Filter Id