Organizations

Get details of organizations

Select

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

Id supports the '=' operator.
FirstChar supports the '=' operator.
FilterId supports the '=' operator.
UserId supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM Organizations WHERE Id = 14

SELECT * FROM Organizations WHERE FirstChar = 'c'

SELECT * FROM Organizations WHERE FilterId = 1
 
SELECT * FROM Organizations WHERE UserId = 1

INSERT

Insert can be executed by specifying the Name columns.The columns that are not read-only can be inserted. Following is an example of how to insert into this table.

INSERT INTO Organizations (name) VALUES ('testpankaj')

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 = 'test123' WHERE Id = 2495

DELETE

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

DELETE FROM Organizations WHERE id = 15

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Integer	True	Id
ActiveFlag	Boolean	True	ActiveFlag
ActivitiesCount	Integer	True	ActivitiesCount
AddTime	Datetime	False	Optional creation date time of the organization in UTC. Requires admin user API token. Format: YYYY-MM-DD HH:MM:SS
Address	String	True	Address
AdminArealevel1	String	True	AdminArealevel1
AdminArealevel2	String	True	AdminArealevel2
Country	String	True	Country
FormattedAddress	String	True	FormattedAddress
Locality	String	True	Locality
PostalCode	String	True	PostalCode
Route	String	True	Route
StreetNumber	String	True	StreetNumber
Sublocality	String	True	Sublocality
Subpremise	String	True	Subpremise
CcEmail	String	True	CcEmail
CustomeField	String	True	CustomeField you will get the result of this column only when criteria filter title is used
ClosedDealsCount	Integer	True	ClosedDealsCount
CompanyId	Integer	True	CompanyId
CountryCode	String	True	CountryCode
DoneActivitiesCount	Integer	True	DoneActivitiesCount
EmailMessagesCount	Integer	True	EmailMessagesCount
FilesCount	Integer	True	FilesCount
FirstChar	String	True	FirstChar
FollowersCount	Integer	True	FollowersCount
Label	Integer	True	Label
LastActivityDate	Date	True	LastActivityDate
LastActivityId	Integer	True	LastActivityId
LostDealsCount	Integer	True	LostDealsCount
Name	String	False	Name
NextActivityDate	Date	True	NextActivityDate
NextActivityId	Integer	True	NextActivityId
NextActivityTime	Time	True	NextActivityTime
NotesCount	Integer	True	NotesCount
OpenDealsCount	Integer	True	OpenDealsCount
Owneractive_flag	Boolean	True	Owneractive_flag
OwnerEmail	String	True	OwnerEmail
OwnerHasPic	Integer	True	OwnerHasPic
OwnerId	Integer	False	OwnerId
OwnerName	String	True	OwnerName
OwnerPicHash	String	True	OwnerPicHash
OwnerIdValue	Integer	True	OwnerIdValue
OwnerName	String	True	OwnerName
PeopleCount	Integer	True	PeopleCount
PictureActiveFlag	Boolean	True	PictureActiveFlag
PictureAddTime	Datetime	True	PictureAddTime
PictureAddedByUserId	Integer	True	PictureAddedByUserId
PictureItemId	Integer	True	PictureItemId
PictureItemType	String	True	PictureItemType
Picture128	String	True	Picture128
Picture512	String	True	Picture512
PictureUpdateTime	String	True	PictureUpdateTime
PictureIid	Integer	True	PictureIid
RelatedClosedDealsCount	Integer	True	RelatedClosedDealsCount
RelatedLostDealsCount	Integer	True	RelatedLostDealsCount
RelatedOpenDealsCount	Integer	True	RelatedOpenDealsCount
RelatedWonDealsCount	Integer	True	RelatedWonDealsCount
Type	String	True	Type you will get the result of this column only when criteria filter title is used
UndoneActivitiesCount	Integer	True	UndoneActivitiesCount
UpdateTime	Datetime	True	UpdateTime
VisibleTo	Integer	False	Visibility of the organization The allowed values are 1, 3, 5, 7.
WonDealsCount	Integer	True	WonDealsCount

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
UserId	Integer	User Id
FilterId	Integer	Filter Id