Establishing a Connection

Create a connection to Pipedrive by navigating to the Connections page in the Sync App application and selecting the corresponding icon in the Add Connections panel. If the Pipedrive icon is not available, click the Add More icon to download and install the Pipedrive connector from the CData site.

Required properties are listed under the Settings tab. The Advanced tab lists connection properties that are not typically required.

Connecting to PipeDrive

There are several authentication methods available for connecting to Pipedrive: Basic and OAuth.

Basic

Begin by obtaining an API token:

Click on the the account name (on the top right) on PipeDrive.
Click on Company Settings, Then Click on Personal Preferences -> API -> Generate Token.
Note the API token.
Note the CompanyDomain ,which is visible in the PipeDrive HomePage URL.

Set the following to authenticate to Pipedrive

APIToken: Set to the noted API token.
CompanyDomain: Set to the noted company domain from the developer sandbox URL.
AuthScheme: Set to 'Basic'.

to your login credentials. The API Token can be found in PipeDrive by going to account name (on the top right) >Company settings > Personal preferences > API.

OAuth

If you do not have access to the user name and password or do not want to require them, use the OAuth user consent flow. See Using OAuth Authentication for an authentication guide.

Data Model

Overview

This section shows the available API objects and provides more information on executing SQL to Pipedrive APIs.

Key Features

The Sync App models Pipedrive entities like documents, folders, and groups as relational views, allowing you to write SQL to query Pipedrive data.
Stored procedures allow you to execute operations to Pipedrive
Live connectivity to these objects means any changes to your Pipedrive account are immediately reflected when using the Sync App.

Views

Views describes the available views. Views are statically defined to model Pipedrive entities such as Currencies, DealsPersons, and ProductsFiles.

Tables

Tables describes the available tables. Tables are statically defined to model Pipedrive entities such as Activities, Users, and Leads.

Stored Procedures

Stored Procedures are function-like interfaces to Pipedrive. Stored procedures allow you to execute operations to Pipedrive, including downloading documents and moving envelopes.

Tables

The Sync App models the data in Pipedrive into a list of tables that can be queried using standard SQL statements.

Generally, querying Pipedrive tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. These types of situations are clearly documented at the top of the table page linked below.

Pipedrive Connector for CData Sync Tables


Name	Description
Activities	Get all Activities assigned to a particular User.
ActivityTypes	Get all ActivityTypes.
CallLogs	Returns all call logs assigned to a particular user.
DealFields	Returns data about all deal fields.
Deals	Get all deals
DealsFollowers	Get details of deals followers.
DealsParticipants	Get details of deals participants.
DealsProducts	Get details of deals products.
Files	Returns data about all files.
Filters	Returns data about all filters.
Goals	Goals help your team meet your sales targets.
LeadLabels	Returns details of all Lead Labels.
Leads	Returns lead data.
Notes	Returns all notes.
OrganizationFields	Returns data about all organization fields.
OrganizationRelationships	Gets all of the relationships.
Organizations	Get details of organizations
OrganizationsFollowers	Get details of organizations followers.
OrganizationsInternal	Get details of organizations.
PersonFields	Returns data about all person fields.
PersonFollowers	Get details of persons followers.
Persons	Get all details of persons
PersonsInternal	Get all details of persons.
Pipelines	Get all Pipelines.
ProductFields	Returns data about all product fields.
Products	Get details of Products
ProductsFollowers	Get details of products followers.
Roles	Returns all the role.
RolesAssignments	List assignments for a role.
RolesSetting	Returns all the roles settings.
Stages	Returns data about all stages.
Subscriptions	Returns details of an installment or a recurring Subscription
Teams	Returns data about teams within the company
TeamsUsers	Usage information for the operation TeamsUsers.rsd.
Users	Returns data about all users within the company

Activities

Get all Activities assigned to a particular User.

Select

The Sync App 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 Sync App.

Id supports the '=' operator.
Done supports the '=' operator.
Type supports the '=, IN' operators.
UserId supports the '=' operator.
FilterId supports the '=' operator.
StartDate supports the '=' operator.
EndDate supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM Activities WHERE Id = 246

SELECT * FROM Activities WHERE Done = 0

SELECT * FROM  Activities WHERE Type IN ('deadline','call')

SELECT * FROM  Activities WHERE EndDate = '2021-12-24'
 
SELECT * FROM  Activities WHERE UserId = 8230170

INSERT

The columns that are not read-only can be inserted. Following is an example of how to insert into this table.

INSERT INTO ActivitiesAttendees#TEMP (EmailAddress) VALUES ('[email protected]')
INSERT INTO Activities (DueDate,DueTime,Duration,Dealid,Attendees) VALUES ('1994-10-12','10:20','02:00',1,'ActivitiesAttendees#TEMP')

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 Activities SET DealId = 2 WHERE Id = 245

DELETE

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

DELETE FROM Activities WHERE Id = 246

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Integer	True	Activity Id.
ActiveFlag	Boolean	True	ActiveFlag.
AddTime	Datetime	True	AddTime.
AssignedToUserId	Integer	True	AssignedToUserId.
Attendees	String	False	Attendees of the Activity This can be either your existing Pipedrive contacts or an external email address.
BusyFlag	Boolean	True	Set the Activity as Busy or Free. The allowed values are true, false. The default value is true.
CalendarSync	String	True	CalendarSync.
CompanyId	Integer	True	CompanyId.
MeetingClient	String	True	MeetingClient.
MeetingId	String	True	MeetingId.
MeetingUrl	String	True	MeetingUrl.
CreatedByUserId	Integer	True	CreatedByUserId.
DealDropboxBcc	String	True	DealDropboxBcc.
DealId	Integer	False	The ID of the Deal this Activity is associated with.
DealTitle	String	True	DealTitle.
Done	Boolean	True	Whether the Activity is done or not 0 = Not done 1 = Done If omitted returns both Done and Not done activities. The allowed values are 0, 1.
DueDate	Date	False	Due date of the Activity Format YYYY-MM-DD
DueTime	Time	False	Due time of the Activity in UTC Format HH:MM
Duration	Time	True	Duration of the Activity Format HH:MM
FileCleanName	String	True	FileCleanName.
FileId	String	True	FileId.
FileUrl	String	True	FileUrl.
GcalEventId	String	True	GcalEventId.
GoogleCalendarEtag	String	True	GoogleCalendarEtag.
GoogleCalendarId	String	True	GoogleCalendarId.
LastNotificationTime	Datetime	True	LastNotificationTime.
LastNotificationUserId	Integer	True	LastNotificationUserId.
LeadId	String	True	LeadId.
Location	String	False	The address of the Activity.
AdminAreaLevel1	String	True	AdminAreaLevel1.
AdminAreaLevel2	String	True	AdminAreaLevel2.
LocationCountry	String	True	LocationCountry.
FormattedAddress	String	True	FormattedAddress.
LocationLat	Double	True	LocationLat.
LocationLocality	String	True	LocationLocality.
LocationLong	Double	True	LocationLong.
PostalCode	String	True	PostalCode.
LocationRoute	String	True	LocationRoute.
StreetNumber	String	True	StreetNumber.
Sublocality	String	True	Sublocality.
Subpremise	String	True	Subpremise.
MarkedAsDoneTime	Datetime	True	MarkedAsDoneTime.
Note	Html	False	Note of the Activity HTML format.
NotificationLanguageId	Integer	True	NotificationLanguageId.
OrgId	Integer	False	The ID of the Organization this Activity is associated with.
OrgName	String	True	OrgName.
OwnerName	String	True	OwnerName.
Participants	String	False	List of multiple Persons participants this Activity is associated with If omitted single participant from person_id field is used.
PersonDropboxBcc	String	True	PersonDropboxBcc.
PersonId	Integer	False	The ID of the Person this Activity is associated with.
PersonName	String	True	PersonName.
PublicDescription	String	False	Additional details about the Activity that is synced to your external calendar Unlike the note added to the Activity the description is publicly visible to any guests added to the Activity.
RecMasterActivityId	String	True	RecMasterActivityId.
RecRule	String	True	RecRule.
RecRuleExtension	String	True	RecRuleExtension.
ReferenceId	Integer	True	ReferenceId.
ReferenceType	String	True	ReferenceType.
Series	String	True	Series.
SourceTimezone	String	True	SourceTimezone.
Subject	String	False	Subject of the Activity. The default value is Call.
Type	String	True	Type of the Activity This is in correlation with the key_string parameter of ActivityTypes When value for type is not set, it will be given a default value Call. The default value is Call.
UpdateTime	Datetime	True	UpdateTime.
UpdateUserId	Integer	True	The ID of the User whose Activities will be fetched If omitted the User associated with the API token will be used If 0 Activities for all company Users will be fetched based on the permission sets.
UserId	Integer	False	UserId.

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	The ID of the Filter to use.
StartDate	String	Use the Activity due date where you wish to begin fetching Activities from Insert due date in YYYY-MM-DD format.
EndDate	String	Use the Activity due date where you wish to stop fetching Activities from Insert due date in YYYY-MM-DD format.

ActivityTypes

Get all ActivityTypes.

Select

The Sync App 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 Sync App.

Id supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM Activities WHERE Id = 9

INSERT

Insert can be executed by specifying the Name and IconKey columns. The columns that are not required can be inserted optionally. For example:

INSERT INTO ActivityTypes (Name,IconKey,color,IsCustomFlag,KeyString) VALUES ('test42','task','FFFFFF','true','call')

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 ActivityTypes SET IconKey = 'email' WHERE id = 7

DELETE

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

DELETE FROM ActivityTypes WHERE Id = 2

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Integer	True	The ID of the ActivityType.
ActiveFlag	Boolean	True	ActiveFlag.
AddTime	Datetime	True	AddTime.
Color	String	False	A designated color for the ActivityType in 6-character HEX format.
IconKey	String	False	Icon graphic to use for representing this activity type. The allowed values are task, email, meeting, deadline, call, lunch, calendar, downarrow, document, smartphone, camera, scissors, cogs, bubble, uparrow, checkbox, signpost, shuffle, addressbook, linegraph, picture, car, world, search, clip, sound, brush, key, padlock, pricetag, suitcase, finish, plane, loop, wifi, truck, cart, bulb, bell, presentation.
IsCustomFlag	Boolean	True	IsCustomFlag.
KeyString	String	True	KeyString.
Name	String	False	The name of the ActivityType.
OrderNr	Integer	False	An order number for this ActivityType. Order numbers should be used to order the types in the ActivityType selections.
UpdateTime	Datetime	True	UpdateTime.

CallLogs

Returns all call logs assigned to a particular user.

Select

The Sync App 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 Sync App.

Id supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM CallLogs WHERE Id = 'cf75de9e4cbcb4a33658ad40561e3230'

INSERT

Insert can be executed by specifying the Outcome, ToPhoneNumber, StartTime and EndTime columns. The columns that are not required can be inserted optionally.

INSERT INTO CallLogs (Outcome,StartTime,EndTime,Duration,FromPhoneNumber,ToPhoneNumber,UserId,OrgId) VALUES ('connected','2021-12-15','2021-12-16','140','984656646','9846566456','8230170','6')

DELETE

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

DELETE FROM CallLogs WHERE Id = '8381cea5da671fa16a1eb63af15e5ec4'

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	True	ID.
ActivityId	Integer	False	ActivityId.
CompanyId	Integer	True	CompanyId.
DealId	Integer	False	The ID of the Deal this call is associated with.
Duration	String	False	Call duration in seconds.
EndTime	Datetime	False	The date and time of the end of the call in UTC. Format: YYYY-MM-DD HH:MM:SS
FromPhoneNumber	String	False	The number that made the call.
HasRecording	Boolean	True	HasRecording.
Note	String	False	Note for the call log in HTML format.
OrgId	Integer	False	The ID of the Organization this call is associated with.
Outcome	String	False	Describes the outcome of the call. The allowed values are connected, no_answer, left_message, left_voicemail, wrong_number, busy.
PersonId	Integer	False	The ID of the Person this call is associated with.
StartTime	Datetime	False	The date and time of the start of the call in UTC. Format: YYYY-MM-DD HH:MM:SS
Subject	String	False	Name of the activity this call is attached to.
ToPhoneNumber	String	False	The number called.
UserId	Integer	False	The ID of the owner of the call log.

DealFields

Returns data about all deal fields.

Select

The Sync App 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 Sync App.

Id supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM DealFields WHERE Id = 12478

INSERT

Insert can be executed by specifying the Name and IconKey columns. The columns that are not required can be inserted optionally. For example:

INSERT INTO DealFields (Name, AddVisibleFlag, FieldType) VALUES ('test43','false','address')

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 DealFields SET Name = 'test44' WHERE Id = '12500'

DELETE

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

DELETE FROM DealFields WHERE Id = 12500

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Integer	True	ID of the field.
ActiveFlag	Boolean	True	Whether the field is available in 'add new' modal or not (both in web and mobile app). The default value is true.
AddTime	Datetime	True	AddTime.
AddVisibleFlag	Boolean	False	AddVisibleFlag.
BulkEditAllowed	Boolean	True	BulkEditAllowed.
DetailsVisibleFlag	Boolean	True	DetailsVisibleFlag.
EditFlag	Boolean	True	EditFlag.
FieldType	String	False	Type of the field. The allowed values are address, date, daterange, double, enum, monetary, org, people, phone, set, text, time, timerange, user, varchar, varchar_auto, visible_to.
FilteringAllowed	Boolean	True	FilteringAllowed.
ImportantFlag	Boolean	True	ImportantFlag.
IndexVisibleFlag	Boolean	True	IndexVisibleFlag.
Key	String	True	Key.
LastUpdatedByUserId	String	True	LastUpdatedByUserId.
MandatoryFlag	Boolean	True	MandatoryFlag.
Name	String	False	Name of the field.
Options	String	False	Options.
OrderNr	Integer	True	OrderNr.
SearchableFlag	Boolean	True	SearchableFlag.
SortableFlag	Boolean	True	SortableFlag.
UpdateTime	Datetime	True	UpdateTime.

Deals

Get all deals

Select

The Sync App 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 Sync App.

Id supports the '=' operator.
StageId supports the '=' operator.
Status supports the '=' operator.
Title supports the 'LIKE' operator.
FilterId supports the '=' operator.
UserId supports the '=' operator.
PersonId supports the '=' operator.
OrgId supports the '=' operator.
OwnedByYou supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM Deals WHERE Id = 14

SELECT * FROM Deals WHERE StageId = 1

SELECT * FROM Deals WHERE  Status = 'Open'

SELECT * FROM Deals WHERE  Title LIKE '%Cdata1%'

SELECT * FROM Deals WHERE FilterId = 1

SELECT * FROM Deals WHERE FilterId = 1
 
SELECT * FROM Deals WHERE OrgId = 1       

SELECT * FROM Deals WHERE OwnedByYou = 1

INSERT

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

INSERT INTO Deals (title,PersonId) VALUES ('tetsptest',6203)

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 Deals SET Title = 'test' WHERE id = 15

DELETE

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

DELETE FROM Deals WHERE id = 15

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Integer	True	Deals id
Active	Boolean	True	Active
ActivitiesCount	Integer	True	Activities Count
AddTime	Datetime	False	AddTime
CcEmail	String	True	Cc Email
CloseTime	String	True	Close Time
CreatorActiveFlag	Boolean	True	Creator ActiveFlag
CreatorEmail	String	True	Creator Email
CreatorHasPic	Boolean	True	Creator HasPic
CreatorId	Integer	True	Creator Id
CreatorName	String	True	Creator Name
CreatorPicHash	String	True	CreatorPicHash
Creatorvalue	Integer	True	Creatorvalue
Currency	String	False	Currency
CustomeField	String	True	CustomeField you will get the result of this column only when criteria filter title is used
Deleted	Boolean	True	Deleted
DoneActivitiesCount	Integer	True	Done Activities Count
EmailMessagesCount	Integer	True	Email Messages Count
ExpectedCloseDate	Date	False	Expected Close Date
FilesCount	Integer	True	Files Count
FirstWonTime	Datetime	True	First Won Time
FollowersCount	Integer	True	Followers Count
FormattedValue	String	True	Formatted Value
FormattedWeightedValue	String	True	Formatted Weighted Value
Label	String	True	Label
LastActivityDate	String	True	Last Activity Date
LastActivityId	String	True	Last Activity Id
LastIncomingMailTime	Datetime	True	Last Incoming MailTime
LastOutgoingMailTime	Datetime	True	Last OutgoingMail Time
LostReason	String	False	Lost Reason
LostTime	String	True	Lost Time
NextActivityDate	Date	True	Next Activity Date
NextActivityDuration	Time	True	Next Activity Duration
NextActivityId	Integer	True	Next Activity Id
NextActivityNote	String	True	Next Activity Note
NextActivitySubject	String	True	Next Activity Subject
NextActivityTime	Time	True	Next Activity Time
NextActivityType	String	True	Next Activity Type
NotesCount	Integer	True	NotesCount
Notes	String	True	Notes
OrgHidden	Boolean	True	Org Hidden
OrgActiveFlag	Boolean	True	Org ActiveFlag
OrgAddress	String	True	Org Address
OrgCcEmail	String	True	Org CcEmail
OrgName	String	True	Org Name
OrgOwnerId	Integer	True	Org OwnerId
OrgPeopleCount	Integer	True	Org PeopleCount
OrgValue	Integer	True	Org Value
OrgName	String	True	Org Name
OwnerName	String	True	Owner Name
OwnerId	String	True	Owner Id you will get the result of this column only when criteria filter title is used
ParticipantsCount	Integer	True	Participants Count
PersonHidden	Boolean	True	Person Hidden
PersonActiveFlag	Boolean	True	Person Active Flag
PersonEmail	String	True	Person Email
PersonName	String	True	Person Name
PersonPhone	String	True	Person Phone
Personvalue	Integer	True	Personvalue
PersonName	String	True	PersonName
PipelineId	Integer	True	PipelineId
Probability	String	True	Probability
ProductsCount	Integer	True	Products Count
RottenTime	String	True	RottenTime
ResultScore	String	True	Result score you will get the result of this column only when criteria filter title is used
StageChangeTime	Datetime	True	Stage Change Time
StageId	Integer	True	StageId
StageName	String	True	StageName
StageOrderNr	Integer	True	Stage OrderNr
Status	String	False	Status The allowed values are open, won, lost, deleted, all_not_deleted. The default value is all_not_deleted.
Title	String	False	Title
Type	String	True	Type you will get the result of this column only when criteria filter title is used
UndoneActivitiesCount	Integer	True	Undone Activities Count
UpdateTime	Datetime	True	Update Time
UserActiveFlag	Boolean	True	User ActiveFlag
UserEmail	String	True	User Email
UserHasPic	Boolean	True	User HasPic
UserId	Integer	False	User Id
UserName	String	True	User Name
UserPicHash	String	True	User PicHash
Uservalue	Integer	True	User value
Value	Integer	False	Value of the deal The default value is 0.
VisibleTo	String	False	Visibility of the deal The allowed values are 1, 3, 5, 7.
WeightedValue	Integer	True	Visible To
WeightedValueCurrency	String	True	Weighted Value Currency
OrderOfStages	Integer	True	you will get the result of this column only when criteria filter id is used
AverageTimeToWonY	Integer	True	you will get the result of this column only when criteria filter id is used
AverageTimeToWonM	Integer	True	you will get the result of this column only when criteria filter id is used
AverageTimeToWond	Integer	True	you will get the result of this column only when criteria filter id is used
AverageTimeToWonh	Integer	True	you will get the result of this column only when criteria filter id is used
AverageTimeToWons	Integer	True	you will get the result of this column only when criteria filter id is used
AverageTimeToWoni	Integer	True	you will get the result of this column only when criteria filter id is used
AverageTotalSeconds	Integer	True	you will get the result of this column only when criteria filter id is used
AverageStageProgress	Integer	True	you will get the result of this column only when criteria filter id is used
AgeY	Integer	True	you will get the result of this column only when criteria filter id is used
AgeM	Integer	True	you will get the result of this column only when criteria filter id is used
Aged	Integer	True	you will get the result of this column only when criteria filter id is used
Ageh	Integer	True	you will get the result of this column only when criteria filter id is used
Ages	Integer	True	you will get the result of this column only when criteria filter id is used
Agei	Integer	True	you will get the result of this column only when criteria filter id is used
AgeTotalSeconds	Integer	True	you will get the result of this column only when criteria filter id is used

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
OwnedByYou	Integer	Owned By You The allowed values are 0, 1.
PersonId	Integer	Person Id
OrgId	Integer	Org Id

DealsFollowers

Get details of deals followers.

Select

The Sync App 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 Sync App.

Id supports the '=' operator.

For example, the following query is processed server side:

    SELECT * FROM DealsFollowers WHERE Id = 2

INSERT

Insert can be executed by specifying the Name and IconKey columns. The columns that are not required can be inserted optionally. For example:

INSERT INTO DealsFollowers (userid,id) VALUES (8230170,8)

DELETE

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

DELETE FROM DealsFollowers WHERE Id = 1 AND Dealid = 1

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Integer	True	Id.
AddTime	Datetime	True	AddTime.
PersonId	Integer	True	Person Id.
UserId	Integer	False	User Id.
DealId	Integer	True	Deal Id.

DealsParticipants

Get details of deals participants.

Select

The Sync App 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 Sync App.

Id supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM DealsParticipants WHERE Id = 9

INSERT

Insert can be executed by specifying the Content and PersonId columns. The columns that are not required can be inserted optionally. For example:

INSERT INTO DealsParticipants (Id,Personid) VALUES (4,6)

DELETE

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

DELETE FROM DealsParticipants WHERE id = 14 AND ItemDealId = 17

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Integer	True	Id.
ActiveFlag	Boolean	True	ActiveFlag.
AddTime	Datetime	True	AddTime.
AddedByactiveFlag	Boolean	True	AddedByactiveFlag.
AddedByemail	String	True	AddedByemail.
AddedByhasPic	Integer	True	AddedByhasPic.
AddedByid	Integer	True	AddedByid.
AddedByname	String	True	AddedByname.
AddedBypicHash	String	True	AddedBypicHash.
AddedByvalue	Integer	True	Added_byvalue.
PersonActiveFlag	Boolean	True	PersonActiveFlag.
ActivitiesCount	Integer	True	ActivitiesCount.
PersonAddTime	Datetime	True	AddTime.
CcEmail	String	True	CcEmail.
ClosedDealsCount	Integer	True	ClosedDealsCount.
CompanyId	Integer	True	CompanyId.
DoneActivitiesCount	Integer	True	DoneActivitiesCount.
Email	String	True	Email.
EmailMessagesCount	Integer	True	EmailMessagesCount.
FilesCount	Integer	True	FilesCount.
FirstChar	String	True	FirstChar.
FirstName	String	True	FirstName.
FollowersCount	Integer	True	FollowersCount.
Personlabel	String	True	Personlabel.
LastActivityDate	Date	True	LastActivityDate.
LastActivityId	Integer	True	LastActivityId.
LastincomingMailTime	String	True	LastincomingMailTime.
Lastname	String	True	Lastname.
LastoutgoingMailTime	String	True	LastoutgoingMailTime.
LostdealsCount	Integer	True	LostdealsCount.
Name	String	True	Name.
NextActivityDate	Date	True	nextActivityDate.
NextActivityId	Integer	True	nextActivityId.
NextActivityTime	String	True	nextActivityTime.
NotesCount	Integer	True	NotesCount.
OpenDealsCount	Integer	True	OpenDealsCount.
OrgActiveFlag	Boolean	True	OrgActiveFlag.
OrgAddress	String	True	OrgAddress.
OrgCcEmail	String	True	OrgCcEmail.
OrgName	String	True	OrgName.
OrgownerId	Integer	True	OrgownerId.
OrgpeopleCount	Integer	True	OrgpeopleCount.
OrgId	Integer	True	OrgId.
OwnerActiveFlag	Boolean	True	OwnerActiveFlag.
OwnerEmail	String	True	OwnerEmail.
OwnerHasPic	Integer	True	OwnerHasPic.
OwnerId	Integer	True	OwnerId.
OwnerName	String	True	OwnerName.
OwnerPicHash	String	True	OwnerPicHash.
OwnerValue	Integer	True	OwnerValue.
ParticipantClosedDealsCount	Integer	True	ClosedDealsCount.
ParticipantOpenDealsCount	Integer	True	OpenDealsCount.
Phone	String	True	Phone.
PictureId	String	True	PictureId.
RelatedclosedDealsCount	Integer	True	RelatedclosedDealsCount.
RelatedlostDealsCount	Integer	True	RelatedlostDealsCount.
RelatedopenDealsCount	Integer	True	RelatedopenDealsCount.
RelatedwonDealsCount	Integer	True	RelatedwonDealsCount.
SyncNeeded	Boolean	True	SyncNeeded.
UndoneActivitiesCount	Integer	True	UndoneActivitiesCount.
UpdateTime	Datetime	True	UpdateTime.
VisibleTo	String	True	visibleTo.
WonDealsCount	Integer	True	WonDealsCount.
PersonIdActiveFlag	Boolean	True	PersonactiveFlag.
Personemail	String	True	Personemail.
Personname	String	True	Personname.
Personphone	String	True	Personphone.
PersonValues	Integer	False	PersonValues.
ItemDealId	Integer	True	ItemDealId.
ItemTitle	String	True	ItemTitle.
ItemId	Integer	True	ItemId.
ItemType	String	True	ItemType.

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
PersonId	Integer	Person Id.

DealsProducts

Get details of deals products.

Select

The Sync App 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 Sync App.

Id supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM DealsProducts WHERE Id = 9

INSERT

Insert can be executed by specifying the Content and PersonId columns. The columns that are not required can be inserted optionally. For example:

INSERT INTO DealsProducts (DealId,ProductId,ItemPrice,quantity) VALUES (2,2,20000,1)

UPDATE

Update can be executed by specifying the Id and Dealid in the WHERE Clause. The columns that are not read-only can be Updated. For example:

Update DealsProducts SET quantity = 20 WHERE id = 15 AND Dealid = 2

DELETE

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

DELETE FROM DealsProducts WHERE id = 15 AND Dealid = 2

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Integer	True	Id.
ActiveFlag	Boolean	True	ActiveFlag.
AddTime	Datetime	True	AddTime.
Comments	String	False	Any textual comment associated with this product-deal attachment.
Currency	String	True	Currency.
DealId	Integer	True	Deal id.
DiscountPercentage	Double	True	Discount %. The default value is 0.
Duration	Integer	True	Duration of the product. The default value is 1.
DurationUnit	String	True	DurationUnit.
EnabledFlag	Boolean	False	Whether the product is enabled on the deal or not. The allowed values are 0, 1.
ItemPrice	Integer	False	Price at which this product will be added to the deal.
LastEdit	String	True	LastEdit.
Name	String	True	Name.
OrderNr	Integer	True	OrderNr.
ProductActiveFlag	Boolean	True	Product ActiveFlag.
ProductAddTime	Datetime	True	Product AddTime.
Category	String	True	Category.
code	String	True	Code.
description	String	True	Description.
FilesCount	String	True	FilesCount.
FirstChar	String	True	FirstChar.
ProductsId	Integer	True	ProductsId.
ProductName	String	True	ProductName.
OwnerActiveFlag	Boolean	True	OwnerActiveFlag.
OwnerEmail	String	True	OwnerEmail.
OwnerHasPic	Boolean	True	OwnerHasPic.
OwnerId	Integer	True	OwnerId.
OwnerName	String	True	OwnerName.
OwnerPicHash	String	True	OwnerPicHash.
OwnerValue	Integer	True	OwnerValue.
EURCost	Integer	True	EURCost.
EURCurrency	String	True	EURCurrency.
EURId	Integer	True	EURId.
EUROverheadCost	Integer	True	EUROverheadCost.
EURPrice	Integer	True	EURPrice.
EURProductId	Integer	True	EURProductId.
Selectable	Boolean	True	selectable.
ProductTax	Integer	True	ProductTax.
unit	String	True	unit.
UpdateTime	Datetime	True	UpdateTime.
VisibleTo	String	True	VisibleTo.
ProductId	Integer	False	ID of the product that will be attached.
VariationId	String	False	ID of the product variation.
Quantity	Integer	False	How many items of this product will be added to the deal.
QuantityFormatted	String	True	QuantityFormatted.
Sum	Double	True	Sum.
SumFormatted	String	True	SumFormatted.
SumNoDiscount	Integer	True	SumNoDiscount.
Tax	Integer	False	Tax percentage. The default value is 0.

Files

Returns data about all files.

Select

The Sync App 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 Sync App.

Id supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM Files WHERE Id = 400

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 Files SET Name = 'Updating PipeDrive Pipelines1' WHERE Id = 405

DELETE

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

DELETE FROM Files WHERE Id = 400

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Integer	True	ID of the file.
ActiveFlag	Boolean	True	ActiveFlag.
ActivityId	String	True	ID of the activity to associate file.
AddTime	Datetime	True	AddTime.
Cid	String	True	Cid.
DealId	String	True	ID of the deal to associate file.
DealName	String	True	DealName.
Description	String	False	Description of the file.
FileName	String	True	FileName.
FileSize	Integer	True	FileSize.
FileType	String	True	FileType.
InlineFlag	Boolean	True	InlineFlag.
LogId	String	True	LogId.
MailMessageId	String	True	MailMessageId.
MailTemplateId	String	True	MailTemplateId.
Name	String	False	Visible name of the file.
OrgId	String	True	ID of the organization to associate file.
OrgName	String	True	OrgName.
PersonId	Integer	True	ID of the person to associate file.
PersonName	String	True	PersonName.
ProductId	String	True	ID of the product to associate file.
ProductName	String	True	ProductName.
RemoteId	String	True	RemoteId.
RemoteLocation	String	True	RemoteLocation.
S3Bucket	String	True	S3Bucket.
UpdateTime	Datetime	True	UpdateTime.
Url	String	True	Url.
UserId	Integer	True	UserId.

Filters

Returns data about all filters.

Select

The Sync App 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 Sync App.

Id supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM Filters WHERE Id = 39

INSERT

Insert can be executed by specifying the Name, Conditions and Type columns. The columns that are not required can be inserted optionally. For example:

INSERT INTO Filters (Name,Conditions,Type) VALUES ('Indias Filter','{"glue": "and","conditions": [{"glue": "and","conditions": [{"object": "organization","field_id": "4020"}]}]}','deals')

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 Filters SET Name = 'Updating Pipedrive filters', Conditions = '{"glue": "and","conditions": [{"glue": "or","conditions": [{"object": "organization123","field_id": "4021"}]}]}' WHERE Id = 39

DELETE

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

DELETE FROM Filters WHERE Id = 10

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Integer	True	The ID of the filter.
ActiveFlag	Boolean	True	ActiveFlag.
AddTime	Datetime	True	AddTime.
CustomViewId	String	True	CustomViewId.
Name	String	False	The name of the filter.
TemporaryFlag	String	True	TemporaryFlag.
Type	String	False	The types of filters to fetch. The allowed values are deals, org, people, products, activity.
UpdateTime	String	True	UpdateTime.
UserId	Integer	True	UserId.
VisibleTo	Integer	True	VisibleTo.

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
Conditions	String	The conditions of the filter as a JSON object.

Goals

Goals help your team meet your sales targets.

Select

The Sync App 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 Sync App.

Id supports the '=' operator.
Title supports the '=' operator.
Name supports the '=' operator.
Type supports the '=' operator.
Title supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM Goals WHERE id = 'c924154b747f214228a906d3de079801' AND DurationEnd = '2022-02-03' AND DurationStart = '2022-01-01'

SELECT * FROM Goals WHERE Title = 'test'

SELECT * FROM Goals WHERE Type = 'test'

SELECT * FROM Goals WHERE TypeName = 'test'

INSERT

Insert can be executed by specifying the Content and PersonId columns. The columns that are not required can be inserted optionally. For example:

INSERT INTO Goals (Title, AssigneeId,AssigneeType,DurationStart,DurationEnd,Target,CurrencyId,TrackingMetric,Iterval,TypeName,PipelineId) VALUES ('test',13815887,'person' ,'2022-01-21','2022-02-03',50,1,'sum','monthly','deals_started','null')

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 Goals SET title = 'test' WHERE id = 'c924154b747f214228a906d3de079801'

DELETE

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

DELETE FROM Goals WHERE id = 'c924154b747f214228a906d3de079801'

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	True	Id.
AssigneeId	Integer	False	ID of the user who's goal to fetch.
AssigneeType	String	False	Type of the goal's assignee. If provided, everyone's goals will be returned. The allowed values are person, team, company.
DurationEnd	Date	False	End date of the period for which to find goals.
DurationStart	Date	False	Start date of the period for which to find goals.
Target	Integer	False	Numeric value of the outcome. If provided, everyone's goals will be returned.
CurrencyId	String	False	Numeric value of the outcome. If provided, everyone's goals will be returned.
TrackingMetric	String	False	Tracking metric of the expected outcome of the goal. If provided, everyone's goals will be returned.
Interval	String	False	Interval of the goal. The allowed values are weekly, monthly, quarterly, yearly.
IsActive	Boolean	False	Whether goal is active or not. The default value is true.
OwnerId	Integer	True	OwnerId.
ReportIds	String	True	ReportIds.
Title	String	False	Title of the goal.
TypeName	String	False	Type of the goal. If provided, everyone's goals will be returned. The allowed values are deals_won, deals_progressed, activities_completed, activities_added, deals_started.
PipelineId	String	False	ID of the pipeline.
ActivityTypeId	String	False	ID of the activity_type.

LeadLabels

Returns details of all Lead Labels.

Select

The Sync App 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 Sync App.

Id supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM LeadLabels

INSERT

Insert can be executed by specifying the Name and Color columns. The columns that are not required can be inserted optionally. For example:

INSERT INTO LeadLabels (Name,Color) VALUES ('BangaloreCdataIndia123','blue')

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 LeadLabels SET Name = 'I am updating content' WHERE id ='28093520-743a-11ec-96e6-031cfba07e9a'

DELETE

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

DELETE FROM LeadLabels WHERE Id = '28093520-743a-11ec-96e6-031cfba07e9a'

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	True	The ID of the Lead Label.
AddTime	Datetime	True	AddTime.
Color	String	False	The color of the label. The allowed values are green, blue, red, yellow, purple, gray.
Name	String	False	The name of the Lead Label.
UpdateTime	Datetime	True	UpdateTime.

Leads

Returns lead data.

Select

The Sync App 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 Sync App.

Id supports the '=' operator.
SearchByEmail supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM Leads

SELECT * FROM Leads WHERE Id = 'a300ea00-5d6c-11ec-9270-93cbb0be1eed'

SELECT * FROM Leads WHERE SearchByEmail = 'all'

INSERT

Insert can be executed by specifying the Title column. The columns that are not required can be inserted optionally. For example:

INSERT INTO Leads (Title,Personid,Visibleto,ExpectedCloseDate) VALUES ('CData123',1,1,'2022-01-01')

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 Leads SET Title = 'CdataIndia' WHERE Id = 'bf1bb1e0-6e13-11ec-b981-a127469657bd'

DELETE

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

DELETE FROM Leads WHERE Id = 'bf1bb1e0-6e13-11ec-b981-a127469657bd'

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	True	The ID of the Lead.
Addtime	Datetime	True	Addtime.
CcEmail	String	True	Ccemail.
CreatorId	Integer	True	Creatorid.
ExpectedCloseDate	String	False	The date of when the Deal which will be created from the Lead is expected to be closed.
Isarchived	Boolean	True	A flag indicating whether the Lead is archived or not.
Labelids	String	False	The IDs of the Lead Labels which will be associated with the Lead.
NextactivityId	Integer	True	Nextactivityid.
OrganizationId	String	False	The ID of an Organization which this Lead will be linked to.
OwnerId	Integer	False	The ID of the User which will be the owner of the created Lead.
PersonId	Integer	False	The ID of a Person which this Lead will be linked to.
Sourcename	String	False	Sourcename.
Title	String	False	The name of the Lead.
Updatetime	Datetime	True	UpdateTime.
Amount	Integer	False	The potential value of the Lead.
Currency	String	True	The currency value of the Lead.
Visibleto	String	False	Visibility of the Lead. The allowed values are 1, 3, 5, 7.
Wasseen	Boolean	False	A flag indicating whether the Lead was seen by someone in the Pipedrive UI.

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

SearchByEmail

Integer

Filtering based on archived status of a Lead. If not provided, All is used.

The allowed values are archived, not_archived, all.

The default value is all.

Notes

Returns all notes.

Select

The Sync App 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 Sync App.

Id supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM Notes WHERE Id = 9

INSERT

Insert can be executed by specifying the Content and PersonId columns. The columns that are not required can be inserted optionally. For example:

INSERT INTO Notes (ActiveFlag,Content,PersonId,AddTime) VALUES ('true','this is frist notes','8','2021-12-31')

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 Notes SET Content = 'I am updating content' WHERE id = 7

DELETE

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

DELETE FROM Notes WHERE Id = 5

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Integer	True	ID of the note.
ActiveFlag	Boolean	False	ActiveFlag.
AddTime	Datetime	False	AddTime.
Content	String	False	Content.
DealTitle	String	True	DealTitle.
DealId	Integer	False	The ID of the deal which notes to fetch.
LastUpdateUserId	Integer	True	LastUpdateUserId.
LeadId	String	False	The ID of the lead which notes to fetch.
OrgId	Integer	False	The ID of the organization which notes to fetch.
OrganizationName	String	True	OrganizationName.
PersonName	String	True	PersonName.
PersonId	Integer	False	The ID of the person whose notes to fetch.
PinnedToDealFlag	Boolean	False	If set, then results are filtered by note to deal pinning state. The allowed values are 0, 1.
PinnedToLeadFlag	Boolean	False	If set, then results are filtered by note to lead pinning state. The allowed values are 0, 1.
PinnedToOrganizationFlag	Boolean	False	If set, then results are filtered by note to organization pinning state. The allowed values are 0, 1.
PinnedToPersonFlag	Boolean	False	If set, then results are filtered by note to person pinning state. The allowed values are 0, 1.
UpdateTime	Datetime	True	UpdateTime.
UserEmail	String	True	UserEmail.
UserIconUrl	String	True	UserIconUUserNamerl.
UserIsYou	Boolean	True	UserIsYouUserName.
UserName	String	True	UserName.
UserId	Integer	True	The ID of the user whose notes to fetch.

OrganizationFields

Returns data about all organization fields.

Select

The Sync App 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 Sync App.

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

For example, the following query is processed server side:

SELECT * FROM OrganizationRelationships WHERE id = 2

INSERT

Insert can be executed by specifying the Type, RelOwnerOrgId and RelLinkedOrgId columns. The columns that are not required can be inserted optionally. For example:

INSERT INTO OrganizationRelationships (Type,RelOwnerOrgId,RelLinkedOrgId) values('parent','8230170','8230170')

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 OrganizationRelationships SET Type = 'related' WHERE id = 2

DELETE

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

DELETE FROM OrganizationRelationships WHERE Id = 2

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Integer	True	ID of the field.
ActiveFlag	Boolean	True	ActiveFlag.
AddTime	Datetime	True	AddTime.
AddVisibleFlag	Boolean	False	Whether the field is available in 'add new' modal or not. The default value is true.
BulkEditAllowed	Boolean	True	BulkEditAllowed.
DetailsVisibleFlag	Boolean	True	DetailsVisibleFlag.
EditFlag	Boolean	True	EditFlag.
FieldType	String	False	Type of the field. The allowed values are address, date, daterange, double, enum, monetary, org, people, phone, set, text, time, timerange, user, varchar, varchar_auto, visible_to.
FilteringAllowed	Boolean	True	FilteringAllowed.
ImportantFlag	Boolean	True	ImportantFlag.
IndexVisibleFlag	Boolean	True	IndexVisibleFlag.
Key	String	True	Key.
LastUpdatedByUserId	String	True	LastUpdatedByUserId.
MandatoryFlag	Boolean	True	MandatoryFlag.
Name	String	False	Name of the field.
Options	String	False	Options.
OrderNr	Integer	True	OrderNr.
SearchableFlag	Boolean	True	SearchableFlag.
SortableFlag	Boolean	True	SortableFlag.
UpdateTime	Datetime	True	UpdateTime.

OrganizationRelationships

Gets all of the relationships.

Select

The Sync App 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 Sync App.

Id supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM OrganizationRelationships WHERE Id = 9

INSERT

Insert can be executed by specifying the Content and PersonId columns. The columns that are not required can be inserted optionally. For example:

INSERT INTO OrganizationRelationships (type,RelOwnerOrgId,RelLinkedOrgId) VALUES ('parent',2,3)

UPDATE

Update can be executed by specifying the Id and Dealid in the WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE OrganizationRelationships SET type = 'parent' WHERE Id = 10

DELETE

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

DELETE FROM OrganizationRelationships  WHERE Id = 10

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Integer	True	ID of the organization relationship.
ActiveFlag	Boolean	True	ActiveFlag.
AddTime	Datetime	True	AddTime.
CalculatedRelatedOrgId	Integer	False	CalculatedRelatedOrgId.
CalculatedType	String	False	CalculatedType.
RelLinkedOrgIdActiveFlag	Boolean	False	RelLinkedOrgIdActiveFlag.
RelLinkedOrgIdAddress	String	False	RelLinkedOrgIdAddress.
RelLinkedOrgIdCcEmail	String	False	RelLinkedOrgIdCcEmail.
RelLinkedOrgIdname	String	False	RelLinkedOrgIdname.
RelLinkedOrgIdownerId	Integer	False	RelLinkedOrgIdownerId.
RelLinkedOrgIdPeopleCount	Integer	False	RelLinkedOrgIdPeopleCount.
RelLinkedOrgIdvalue	Integer	False	RelLinkedOrgIdvalue.
RelOwnerOrgIdActiveFlag	Boolean	False	RelOwnerOrgIdActiveFlag.
RelOwnerOrgIdAddress	String	False	RelOwnerOrgIdAddress.
RelOwnerOrgIdCcEmail	String	False	RelOwnerOrgIdCcEmail.
RelOwnerOrgIdName	String	False	RelOwnerOrgIdName.
RelOwnerOrgIdOwnerId	Integer	False	RelOwnerOrgIdOwnerId.
RelOwnerOrgIdPeopleCount	Integer	False	RelOwnerOrgIdPeopleCount.
OrgId	Integer	False	RelOwnerOrgIdValue.
RelatedOrganizationName	String	False	RelatedOrganizationName.
Type	String	False	The type of organization relationship. The allowed values are parent, related.
UpdateTime	Datetime	False	UpdateTime.

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
RelOwnerOrgId	Integer	Real Organization Id.
RelLinkedOrgId	Integer	Real Organization Id.

Organizations

Get details of organizations

Select

The Sync App 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 Sync App.

Id supports the '=' operator.
Address supports the 'LIKE' operator.
Name supports the 'LIKE' 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 Address LIKE '%Cdata%'

SELECT * FROM Organizations WHERE Name LIKE '%Cdata%'

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

OrganizationsFollowers

Get details of organizations followers.

Select

The Sync App 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 Sync App.

OrgId supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM OrganizationsFollowers WHERE OrgId = 6

INSERT

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

INSERT INTO OrganizationsFollowers (UserId,OrgId) values(8230170,1)

DELETE

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

DELETE FROM OrganizationsFollowers WHERE OrgId = 1 AND id = 1

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Integer	True	Id.
AddTime	Datetime	True	AddTime.
OrgId	Integer	True	OrgId.
UserId	Integer	False	UserId.

OrganizationsInternal

Get details of organizations.

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.
OwneractiveFlag	Boolean	True	Owneractive_flag.
OwnerEmail	String	True	OwnerEmail.
OwnerHasPic	Boolean	True	OwnerHasPic.
OwnerId	Integer	False	OwnerId.
OwnerName	String	True	OwnerName.
OwnerPicHash	String	True	OwnerPicHash.
OwnerIdValue	Integer	True	OwnerIdValue.
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.
PictureId	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.

PersonFields

Returns data about all person fields.

Select

The Sync App 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 Sync App.

Id supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM PersonFields WHERE Id = 9039

INSERT

Insert can be executed by specifying the Name and FieldType columns. The columns that are not required can be inserted optionally. For example:

INSERT INTO PersonFields (Name,AddVisibleFlag,FieldType) VALUES ('NameCdataIndia','true','address')

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 PersonFields SET Name = 'My name just started here' WHERE Id = '9062'

DELETE

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

DELETE FROM PersonFields WHERE Id = 9040

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Integer	True	ID of the field.
ActiveFlag	Boolean	True	ActiveFlag.
AddTime	Datetime	True	AddTime.
AddVisibleFlag	Boolean	False	Whether the field is available in 'add new' modal or not (both in web and mobile app). The default value is true.
BulkEditAllowed	Boolean	True	BulkEditAllowed.
DetailsVisibleFlag	Boolean	True	DetailsVisibleFlag.
EditFlag	Boolean	True	EditFlag.
FieldType	String	False	Type of the field. The allowed values are address, date, daterange, double, enum, monetary, org, people, phone, set, text, time, timerange, user, varchar, varchar_auto, visible_to.
FilteringAllowed	Boolean	True	FilteringAllowed.
ImportantFlag	Boolean	True	ImportantFlag.
IndexVisibleFlag	Boolean	True	IndexVisibleFlag.
Key	String	True	Key.
LastUpdatedByUserId	String	True	LastUpdatedByUserId.
MandatoryFlag	Boolean	True	MandatoryFlag.
Name	String	False	Name of the field.
Options	String	False	Options.
OrderNr	Integer	True	OrderNr.
SearchableFlag	Boolean	True	SearchableFlag.
SortableFlag	Boolean	True	SortableFlag.
UpdateTime	Datetime	True	UpdateTime.

PersonFollowers

Get details of persons followers.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Integer	True	Followers id.
AddTime	Datetime	True	Add time.
PersonId	Integer	True	Person id.
UserId	Integer	False	User id.

Persons

Get all details of persons

Select

The Sync App 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 Sync App.

Id supports the '=' operator.
Email supports the 'LIKE' operator.
Name supports the 'LIKE' operator.
FirstChar supports the 'LIKE' operator.
Phone supports the 'LIKE' operator.
FilterId supports the '=' operator.
UserId supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM Persons WHERE Id = 14

SELECT * FROM Persons WHERE Name LIKE '%Cdata%'

SELECT * FROM Persons WHERE Phone LIKE '%9876%'

SELECT * FROM Persons WHERE FirstChar = 'c'

SELECT * FROM Persons WHERE FilterId = 1
 
SELECT * FROM Persons 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 Persons (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 Persons SET Name = 'test123' WHERE Id = 2495

DELETE

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

DELETE FROM Persons WHERE id = 15

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Integer	True	Id
ActiveFlag	Boolean	False	ActiveFlag
ActivitiesCount	Integer	True	ActivitiesCount
AddTime	Datetime	False	Optional creation date time of the person Requires admin user API token. Format: YYYY-MM-DD HH:MM:SS
CcEmail	String	True	CcEmail
ClosedDealsCount	Integer	True	ClosedDealsCount
CompanyId	Integer	True	CompanyId
CustomeField	String	True	CustomeField you will get the result of this column only when criteria filter title is used
DoneActivitiesCount	Integer	True	DoneActivitiesCount
Email	String	False	Email
EmailMessagesCount	Integer	True	EmailMessagesCount
FilesCount	Integer	True	FilesCount
FirstChar	String	True	If supplied, only persons whose name starts with the specified letter will be returned
FirstName	String	True	FirstName
FollowersCount	Integer	True	FollowersCount
Label	Integer	True	Label
LastActivityDate	Date	True	LastActivityDate
LastActivityId	Integer	True	LastActivityId
LastIncomingMailTime	Datetime	True	LastIncomingMailTime
LastName	String	True	LastName
LastOutgoingMailTime	Datetime	True	LastOutgoingMailTime
LostDealsCount	Integer	True	LostDealsCount
Name	String	False	Name
NextActivityDate	Date	True	NextActivityDate
NextActivityId	Integer	True	NextActivityId
NextActivityTime	Time	True	NextActivityTime
Notes	String	True	Notes
NotesCount	Integer	True	NotesCount
OpenDealsCount	Integer	True	OpenDealsCount
OrgActiveFlag	Boolean	True	OrgActiveFlag
OrgAddress	String	True	OrgAddress
OrgccEmail	String	True	OrgccEmail
OrgName	String	True	OrgName
OrgownerId	Integer	True	OrgownerId
OrgpeopleCount	Integer	True	OrgpeopleCount
Orgvalue	Integer	False	Orgvalue
OrgName	String	True	OrgName
OwnerActiveFlag	Boolean	True	OwnerActiveFlag
OwnerEmail	String	True	OwnerEmail
OwnerHasPic	Integer	True	OwnerHasPic
OwnerId	Integer	False	OwnerId
OwnerName	String	True	OwnerName
OwnerPicHash	String	True	OwnerPicHash
OwnerValue	Integer	True	OwnerValue
OwnerName	String	True	OwnerName
ClosedDealscount	Integer	True	ClosedDealscount
OpenDealsCount	Integer	True	OpenDealsCount
Phone	String	False	Phone
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
Picturevalue	Integer	True	Picturevalue
RelatedClosedDealsCount	Integer	True	RelatedClosedDealsCount
RelatedLostDealsCount	Integer	True	RelatedLostDealsCount
RelatedOpenDealsCount	Integer	True	RelatedOpenDealsCount
RelatedWonDealsCount	Integer	True	RelatedWonDealsCount
UndoneActivitiesCount	Integer	True	UndoneActivitiesCount
UpdateTime	Datetime	True	UpdateTime
VisibleTo	String	False	Visibility of the person The allowed values are 1, 3.
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
FilterId	Integer	Filter Id
UserId	Integer	User Id

PersonsInternal

Get all details of persons.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Integer	True	Id.
ActiveFlag	Boolean	False	ActiveFlag.
ActivitiesCount	Integer	True	ActivitiesCount.
AddTime	Datetime	False	Optional creation date time of the person Requires admin user API token. Format: YYYY-MM-DD HH:MM:SS
CcEmail	String	True	CcEmail.
ClosedDealsCount	Integer	True	ClosedDealsCount.
CompanyId	Integer	True	CompanyId.
CustomeField	String	True	CustomeField you will get the result of this column only when criteria filter title is used.
DoneActivitiesCount	Integer	True	DoneActivitiesCount.
Email	String	False	Email.
EmailMessagesCount	Integer	True	EmailMessagesCount.
FilesCount	Integer	True	FilesCount.
FirstChar	String	True	If supplied, only persons whose name starts with the specified letter will be returned.
FirstName	String	True	FirstName.
FollowersCount	Integer	True	FollowersCount.
Label	Integer	True	Label.
LastActivityDate	Date	True	LastActivityDate.
LastActivityId	Integer	True	LastActivityId.
LastIncomingMailTime	Datetime	True	LastIncomingMailTime.
LastName	String	True	LastName.
LastOutgoingMailTime	Datetime	True	LastOutgoingMailTime.
LostDealsCount	Integer	True	LostDealsCount.
Name	String	False	Name.
NextActivityDate	Date	True	NextActivityDate.
NextActivityId	Integer	True	NextActivityId.
NextActivityTime	Time	True	NextActivityTime.
Notes	String	True	Notes.
NotesCount	Integer	True	NotesCount.
OpenDealsCount	Integer	True	OpenDealsCount.
OrgActiveFlag	Boolean	True	OrgActiveFlag.
OrgAddress	String	True	OrgAddress.
OrgccEmail	String	True	OrgccEmail.
OrgName	String	True	OrgName.
OrgownerId	Integer	True	OrgownerId.
OrgpeopleCount	Integer	True	OrgpeopleCount.
Orgvalue	Integer	False	Orgvalue.
OwnerActiveFlag	Boolean	True	OwnerActiveFlag.
OwnerEmail	String	True	OwnerEmail.
OwnerHasPic	Integer	True	OwnerHasPic.
OwnerId	Integer	False	OwnerId.
OwnerName	String	True	OwnerName.
OwnerPicHash	String	True	OwnerPicHash.
OwnerValue	Integer	True	OwnerValue.
ParticipantClosedDealscount	Integer	True	ParticipantClosedDealscount.
ParticipantOpenDealsCount	Integer	True	ParticipantOpenDealsCount.
Phone	String	False	Phone.
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.
Picturevalue	Integer	True	Picturevalue.
RelatedClosedDealsCount	Integer	True	RelatedClosedDealsCount.
RelatedLostDealsCount	Integer	True	RelatedLostDealsCount.
RelatedOpenDealsCount	Integer	True	RelatedOpenDealsCount.
RelatedWonDealsCount	Integer	True	RelatedWonDealsCount.
UndoneActivitiesCount	Integer	True	UndoneActivitiesCount.
UpdateTime	Datetime	True	UpdateTime.
VisibleTo	String	False	Visibility of the person. The allowed values are 1, 3.
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
FilterId	Integer	Filter Id.
UserId	Integer	User Id.

Pipelines

Get all Pipelines.

Select

The Sync App 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 Sync App.

Id supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM Pipelines WHERE Id = 4

INSERT

Insert can be executed by specifying the Name, Active, DealProbability, OrderNr and UrlTitle columns. The columns that are not required can be inserted optionally. For example:

INSERT INTO PipeLines (Name,Active,DealProbability,OrderNr,UrlTitle) VALUES ('Indias PipeLines for Pipedrive','true','0',1,'indiapipedrivepipeline@com')

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 PipeLines SET Name = 'Updating Pipedrive Pipelines1' WHERE Id = 4

DELETE

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

DELETE FROM PipeLines WHERE Id = 5

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Integer	True	ID of the pipeline.
Name	String	False	The name of the Pipeline.
Active	Boolean	False	Whether this Pipeline will be made inactive (hidden) or active.
DealProbability	Integer	False	Whether Deal probability is disabled or enabled for this Pipeline. The allowed values are 0, 1.
OrderNr	Integer	False	Defines the order of Pipelines. The default value is 0.
Selected	Boolean	True	Selected.
UpdateTime	Datetime	True	UpdateTime.
AddTime	Datetime	True	AddTime.
UrlTitle	String	False	UrlTitle.

ProductFields

Returns data about all product fields.

Select

The Sync App 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 Sync App.

Id supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM ProductFields WHERE Id = 28

INSERT

Insert can be executed by specifying the Name and FieldType columns. The columns that are not required can be inserted optionally. For example:

INSERT INTO ProductFields (Name,FieldType) VALUES ('BangaloreCdataIndia123','address')

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 ProductFields SET Name = 'My name just started here' WHERE Id = 28

DELETE

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

DELETE FROM ProductFields WHERE Id = 9040

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Integer	True	ID of the Product Field.
ActiveFlag	Boolean	True	ActiveFlag.
AddTime	Datetime	True	AddTime.
AddVisibleFlag	Boolean	True	AddVisibleFlag.
BulkEditAllowed	Boolean	True	BulkEditAllowed.
DetailsVisibleFlag	Boolean	True	DetailsVisibleFlag.
EditFlag	Boolean	True	EditFlag.
FieldType	String	False	Type of the field. The allowed values are address, date, daterange, double, enum, monetary, org, people, phone, set, text, time, timerange, user, varchar, varchar_auto, visible_to.
FilteringAllowed	Boolean	True	FilteringAllowed.
ImportantFlag	Boolean	True	ImportantFlag.
IndexVisibleFlag	Boolean	True	IndexVisibleFlag.
Key	String	True	Key.
LastUpdatedByUserId	String	True	LastUpdatedByUserId.
MandatoryFlag	Boolean	True	MandatoryFlag.
Name	String	False	Name of the field.
Options	String	False	Options.
OrderNr	Integer	True	OrderNr.
PicklistData	String	True	PicklistData.
SearchableFlag	Boolean	True	SearchableFlag.
SortableFlag	Boolean	True	SortableFlag.
UpdateTime	Datetime	True	UpdateTime.

Products

Get details of Products

Select

The Sync App 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 Sync App.

Id supports the '=' operator.
Code supports the 'LIKE' operator.
Name supports the 'LIKE' operator.
FirstChar supports the '=' operator.
FilterId supports the '=' operator.
UserId supports the '=' operator.
GetSummary supports the '=' operator.
Ids supports the '=,IN' operators.

For example, the following query is processed server side:

SELECT * FROM Products WHERE Id = 14

SELECT * FROM Products WHERE Name LIKE '%Cdata%'

SELECT * FROM Products WHERE code LIKE '%123%'

SELECT * FROM Products WHERE FirstChar = 'c'

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

SELECT * FROM Products WHERE GetSummary = 1

SELECT * FROM Products WHERE Ids IN (1,2)

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 Products (name) VALUES ('tests')

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

DELETE

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

DELETE FROM Products WHERE Id = 15

Columns


Name	Type	ReadOnly	Description
Id	Integer	True	product Id
ActiveFlag	Boolean	True	Whether this product will be made active or not The allowed values are 0, 1. The default value is 1.
AddTime	Datetime	True	Add Time
Category	String	True	category
Code	String	False	Product code.
CustomeField	String	True	CustomeField you will get the result of this column only when criteria filter title is used
Description	String	True	description
FilesCount	String	True	FilesCount
FirstChar	String	True	If supplied only Products whose name starts with the specified letter will be returned
Name	String	False	Name of the product
OwnerActiveFlag	Boolean	True	OwnerActiveFlag
OwnerEmail	String	True	OwnerEmail
OwnerHasPic	Boolean	True	OwnerHasPic
OwnerId	Integer	False	ID of the user who will be marked as the owner of this product
OwnerName	String	True	OwnerName
OwnerPicHash	String	True	OwnerPicHas
Ownervalue	Integer	True	Owner Id
Prices	String	False	Object containing price objects
Selectable	Boolean	False	Whether this product can be selected in Deals or not The allowed values are 0, 1. The default value is 1.
Tax	Integer	False	Tax percentage The default value is 0.
Type	String	True	Type you will get the result of this column only when criteria filter title is used
Unit	String	False	Unit in which this product is sold
UpdateTime	Datetime	True	Update Time
VisibleTo	String	False	Visibility of the product The allowed values are 1, 3, 5, 7.
SummaryTotalCount	String	True	You will get data of this column when Criterial filter is GetSummary is used

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
GetSummary	Boolean	Get SUmmary
Ids	Integer	The Ids of the Products that should be returned in the response

ProductsFollowers

Get details of products followers.

Select

The Sync App 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 Sync App.

ProductId supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM ProductsFollowers WHERE ProductId = 6

INSERT

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

INSERT INTO ProductsFollowers (UserId,ProductId) VALUES (8230170,1)

DELETE

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

DELETE FROM ProductsFollowers WHERE ProductId = 1 AND id = 1

Columns


Name	Type	ReadOnly	Description
Id	Integer	True	Id.
AddTime	Datetime	True	AddTime.
ProductId	Integer	True	ProductId.
UserId	Integer	False	UserId.

Roles

Returns all the role.

Select

The Sync App 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 Sync App.

Id supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM Roles 

SELECT * FROM Roles WHERE Id = 2

INSERT

Insert can be executed by specifying the Name and ParentRoleId columns. The columns that are not required can be inserted optionally. For example:

INSERT INTO Roles (Name,ParentRoleId) VALUES ('BangaloreCdataIndia123','2')

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 Roles SET Name = 'My name just started here' WHERE Id = 1

DELETE

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

DELETE FROM Roles WHERE Id = 1

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Integer	True	ID of the role.
ActiveFlag	Boolean	True	ActiveFlag.
AssignmentCount	String	True	AssignmentCount.
Level	Integer	True	Level.
Name	String	False	The name of the Role.
ParentRoleId	Integer	False	The ID of the parent Role.
SubRoleCount	String	True	SubRoleCount.

RolesAssignments

List assignments for a role.

Select

The Sync App 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 Sync App.

Id supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM RolesAssignments 

SELECT * FROM RolesAssignments WHERE Id = 1

INSERT

Insert can be executed by specifying the Id and UserId columns. The columns that are not required can be inserted optionally. For example:

INSERT INTO RoleAssignments (Id,UserId,RoleId) VALUES (1,'NameCdataIndia','1')

DELETE

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

DELETE FROM RolesAssignments WHERE Id = 1 AND UserId = 1

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Integer	True	ID of the role.
ActiveFlag	Boolean	True	ActiveFlag.
Name	String	True	Name.
ParentRoleId	String	True	ParentRoleId.
RoleId	Integer	False	RoleId.
Type	String	True	Type.
UserId	Integer	False	ID of the user.

RolesSetting

Returns all the roles settings.

Select

The Sync App 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 Sync App.

Id supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM RolesSetting 

SELECT * FROM RolesSetting WHERE Id = 1

INSERT

Insert can be executed by specifying the Name and FieldType columns. The columns that are not required can be inserted optionally. For example:

INSERT INTO RolesSetting (Id,SettingKey,Value) VALUES (1,'deal_default_visibility','1')

UPDATE

Update can be executed by specifying the Id in the WHERE Clause and SettingKey and Value in Body Parameter. The columns that are not read-only can be Updated. For example:

UPDATE RolesSetting SET Value = '3' , SettingKey = 'deal_default_visibility' WHERE Id = 1

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Integer	True	Id.
DealDefaultVisibility	Integer	True	DealDefaultVisibility.
DealAccessLevel	Integer	True	DealAccessLevel.
LeadDefaultVisibility	Integer	True	LeadDefaultVisibility.
OrgDefaultVisibility	Integer	True	OrgDefaultVisibility.
OrgAccessLevel	Integer	True	OrgAccessLevel.
PersonAccessLevel	Integer	True	PersonAccessLevel.
PersonDefaultVisibility	Integer	True	PersonDefaultVisibility.
ProductAccessLevel	Integer	True	ProductAccessLevel.
ProductDefaultVisibility	Integer	True	ProductDefaultVisibility.

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
Value	String	Possible values for the default_visibility setting depending on the subscription plan. The allowed values are 1, 3, 5, 7.
SettingKey	String	SettingKey. The allowed values are deal_default_visibility, lead_default_visibility, org_default_visibility, person_default_visibility, product_default_visibility.

Stages

Returns data about all stages.

Select

The Sync App 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 Sync App.

Id supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM Stages WHERE Id = 7

INSERT

Insert can be executed by specifying the Name, PipelineId, DealProbability and RottenFlag columns. The columns that are not required can be inserted optionally. For example:

INSERT INTO Stages (Name,PipelineId,DealProbability,RottenFlag) VALUES ('BangaloreCdataIndia123','1','1','0')

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 Stages SET Name='My name just started here' WHERE Id = 7

DELETE

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

DELETE FROM Stages WHERE Id = 8

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Integer	True	ID of the stage.
ActiveFlag	Boolean	True	ActiveFlag.
AddTime	Datetime	True	AddTime.
DealProbability	Integer	False	Deal success probability percentage.
Name	String	False	Name of the Stage.
OrderNr	Integer	False	An order number for this stage.
PipelineDealProbability	Integer	True	PipelineDealProbability.
PipelineId	Integer	False	The ID of the Pipeline to add Stage to.
PipelineName	String	True	PipelineName.
RottenDays	String	False	The number of days the Deals not updated in this Stage would become rotten. Applies only if the rotten_flag is set.
RottenFlag	Boolean	False	Whether Deals in this stage can become rotten. The allowed values are 0, 1.
UpdateTime	Datetime	True	UpdateTime.

Subscriptions

Returns details of an installment or a recurring Subscription

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Integer	True	ID of the Subscription.
AddTime	Datetime	True	AddTime.
CadenceType	String	False	Interval between payments. The allowed values are weekly, monthly, quarterly, yearly.
Currency	String	False	The currency of the Installment Subscription. Accepts a 3-character currency code.
CycleAmount	Double	False	Amount of each payment.
CyclesCount	Integer	False	Shows how many payments the Subscription has.
DealId	Integer	False	ID of the Deal this Installment Subscription is associated with.
Description	String	False	Description of the Recurring Subscription.
EndDate	Date	False	EndDate.
FinalStatus	String	True	FinalStatus.
Infinite	Boolean	False	This indicates that the Recurring Subscription will last until it's manually canceled or deleted.
IsActive	Boolean	True	IsActive.
LifetimeValue	Double	True	LifetimeValue.
StartDate	Date	False	Start date of the Recurring Subscription. Format: YYYY-MM-DD
UpdateTime	Datetime	False	UpdateTime.
UserId	Integer	True	UserId.
SubscriptionType	String	True	SubscriptionType. The allowed values are recurring, installment. The default value is recurring.

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
Payments	String	Array of payments.
EffectiveDate	Date	Array of payments.
UpdateDealValue	Boolean	Indicates that the Deal value must be set to Recurring Subscription's MRR value.

Teams

Returns data about teams within the company

Select

The Sync App 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 Sync App.

Id supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM Teams WHERE Id = 7

INSERT

Insert can be executed by specifying the Name and ManagerId columns. The columns that are not required can be inserted optionally. For example:

INSERT INTO Teams (Name,ManagerId,Description) VALUES ('Bangalore123','1','THIS IS YOUR MANAGER')

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 Teams SET Name = 'My name just started here', ManagerId = 2 WHERE Id = 7

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Integer	True	ID of the team.
ActiveFlag	Integer	True	Flag that indicates if the Team is activated. The allowed values are 0, 1.
AddTime	Datetime	True	AddTime.
CreatedByUserId	Integer	True	CreatedByUserId.
DeletedFlag	Integer	True	Flag that indicates if the Team is deleted. The allowed values are 0, 1.
Description	String	False	The Team description.
ManagerId	Integer	False	The Team manager ID.
Name	String	False	The Team name.
Users	String	False	List of User IDs.

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

SkipUsers

String

When enabled, the teams will not include IDs of member users.

The allowed values are 0, 1.

The default value is 1.

TeamsUsers

Usage information for the operation TeamsUsers.rsd.

Select

The Sync App 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 Sync App.

Id supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM TeamsUsers WHERE Id = 7

INSERT

Insert can be executed by specifying the Id and Users columns. The columns that are not required can be inserted optionally. Users should be passed in Array. For example:

INSERT INTO TeamsUsers (Id,Users) VALUES ('1','[1,2,3,4]')

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 TeamsUsers SET Name = 'My name just started here', ManagerId = 2 WHERE Id = 7

DELETE

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

DELETE FROM TeamsUsers WHERE Id = 10

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Integer	True	ID of the team.
Data	String	True	Data.

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
Users	String	List of User IDs

Users

Returns data about all users within the company

Select

The Sync App 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 Sync App.

Id supports the '=' operator.
SearchByEmail supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM Users WHERE Id = 13816635

INSERT

Insert can be executed by specifying the Name, Email and ActiveFlag columns. The columns that are not required can be inserted optionally. For example:

INSERT INTO Users (Name,Email,ActiveFlag) VALUES ('CdataIndiaEngineering','[email protected]','true')

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 Users SET ActiveFlag = 'false' WHERE Id = 13944807

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Integer	True	ID of the user.
Activated	Boolean	False	Activated.
ActiveFlag	Boolean	False	Whether the user is active or not. The default value is true.
Created	Datetime	False	Created.
DefaultCurrency	String	False	DefaultCurrency.
Email	String	False	Email of the user.
Hascreatedcompany	Boolean	False	Hascreatedcompany.
IconUrl	String	False	IconUrl.
IsAdmin	Integer	False	IsAdmin.
IsYou	Boolean	False	IsYou.
Lang	Integer	False	Lang.
LastLogin	Datetime	False	LastLogin.
Locale	String	False	Locale.
Modified	Datetime	False	Modified.
Name	String	False	Name of the user.
Phone	String	False	Phone.
RoleId	Integer	False	ID of the role.
TimezoneName	String	False	TimezoneName.
TimezoneOffset	String	False	TimezoneOffset.

Views

Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Entities that are represented as views are typically read-only entities. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.

Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard.

Dynamic views, such as queries exposed as views, and views for looking up specific combinations of project_team work items are supported.

Pipedrive Connector for CData Sync Views


Name	Description
ActivitiesAttendees	Get all Activities assigned to a particular User
ActivitiesParticipants	Getdetails of activities participants
ActivityFields	Returns all activity fields.
ActivityFieldsOptions	Returns all activity fields.
Currencies	Returns all supported currencies in given account which should be used when saving monetary values with other objects.
DealFieldsOptions	Returns data about all deal fields.
DealsActivities	Get all Deals Activities assigned to a particular User.
DealsActivitiesAttendees	Get Details of Deals Activities Attendees.
DealsActivitiesParticipants	Getdetails of activities participants.
DealsFiles	Get details of deals file.
DealsMailMessages	Get details of Deal mail Messages.
DealsMailMessagesBcc	Get details of Deal mail Messages.
DealsMailMessagesCc	Get details of Deal mail Messages.
DealsMailMessagesFrom	Get details of Deal mail Messages.
DealsMailMessagesTo	Get details of Deal mail Messages.
DealsPermittedUsers	Get details of deals Permitted users
DealsPersonEmails	Get all emails asscociated with persons in deal
DealsPersonPhone	Get all phone asscociated with persons in deal.
DealsPersons	Get details of deals persons.
DealsSummary	Return detils of deals summary.
DealsTimeline	Usage information for the operation DealsTimeline.rsd.
DealsTimelineDeals	Return details of DealsTimeline deals.
DealsUpdates	Get details of deals updates.
DealsUpdatesAttachments	Get details of deals Updates Attachments.
DealsActivitiesAttendees	Get Details of Deals Activities Attendees.
DealsUpdatesBcc	Get details of Deal updates Bcc.
DealsUpdatesCc	Get details of Deals Updates cc.
DealsUpdatesFrom	Get details of Deals Updates From.
DealsUpdatesParticipants	Getdetails of activities participants.
DealsUpdatesTo	Get details of Deals Updates to.
FilterHelpers	Returns all supported filter helpers.
LeadSources	Returns all Lead Sources.
NoteFields	Returns data about all note fields.
OrganizationsActivities	Get details of organizations activities.
OrganizationsDeals	Get details of organization deals.
OrganizationsDealsPersonEmail	get details of deals person email.
OrganizationsDealsPersonphone	get details of deals person phone.
OrganizationsFiles	Get details of deals file.
OrganizationsMailMessages	Get details of organizations mail Messages.
OrganizationsMailMessagesBcc	Get details of organizations mail Messages.
OrganizationsMailMessagesCc	Get details of organizations mail Messages.
OrganizationsMailMessagesFrom	Get details of organizations mail Messages.
OrganizationsMailMessagesTo	Get details of organizations mail Messages.
OrganizationsPermittedUsers	Get details of permitted users of organizations.
OrganizationsPersons	Get details of organizations persons
OrganizationsUpdates	Get details of organizations updates..
OrganizationsUpdatesAttendees	Get details of all attendees of organizations.
OrganizationsUpdatesParticipants	Getdetails of activities participants.
PermissionSets	Get all permissions.
PermissionSetsAssignments	.
PersonsActivities	Get all Persons Activities assigned to a particular Persons.
PersonsActivitiesAttendees	Get Details of Persons Activities Attendees.
PersonsActivitiesParticipants	Get details of Persons activities participants.
PersonsDeals	Get details of Persons deals.
PersonsEmails	Get all emails asscociated with persons.
PersonsFiles	Get details of Persons file.
PersonsMailMessages	Get details of organizations mail Messages.
PersonsMailMessagesBcc	Get details of Persons mail Messages.
PersonsMailMessagesCc	Get details of persons mail Messages.
PersonsMailMessagesFrom	Get details of persons mail Messages.
PersonsMailMessagesTo	Get details of Persons mail Messages.
PersonsPhone	Get all phone asscociated with persons.
PersonsProducts	Get details of Persons Products.
PersonsUpdates	Get details of persons updates.
PersonsUpdatesAttendees	Get details of Deals Activities Attendees.
PersonsUpdatesParticipants	Get details of activities participants
PipelineDeals	Lists deals in a specific pipeline across all its stages.
PipelineDealsConversionRates	Returns statistics for deals movements for given time period.
PipelineDealsMovements	Returns statistics for deals movements for given time period.
PipelineDealsStageConversions	Returns statistics for deals movements for given time period
ProductsDeals	Get details of Products Deals.
ProductsDealsPersonEmail	Get details of Products Deals person email.
ProductsDealsPersonphone	Get details of deals person phone.
ProductsFiles	Get details of Persons file.
ProductsPrices	Get details of Products Prices.
Recents	Returns data about all recent changes occurred after given timestamp.
RolesSubRoles	Returns all the sub roles.
UserConnection	The data of user connections.
UserSettings	List settings of an authorized user.
UsersTeams	Returns data about all teams which have specified user as a member

ActivitiesAttendees

Get all Activities assigned to a particular User

Select

The Sync App 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 Sync App.

Id supports the '=' operator.
Done supports the '=' operator.
Type supports the '=, IN' operators.
UserId supports the '=' operator.
FilterId supports the '=' operator.
StartDate supports the '=' operator.
EndDate supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM ActivitiesAttendees WHERE Id = 246

SELECT * FROM ActivitiesAttendees WHERE Done = 0

SELECT * FROM ActivitiesAttendees WHERE Type IN ('deadline','call')

SELECT * FROM ActivitiesAttendees WHERE EndDate = '2021-12-24'
 
SELECT * FROM ActivitiesAttendees WHERE UserId = 8230170

Columns


Name	Type	Description
Id [KEY]	Integer	Activities ID.
EmailAddress	String	EmailAddress.
IsOrganizer	Integer	IsOrganizer.
Name	String	Name.
PersonId	Integer	PersonId.
Status	String	Status.
UserId	String	UserId.

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
Type	String	Type of the Activity This is in correlation with the key_string parameter of ActivityTypes When value for type is not set, it will be given a default value Call. The default value is Call.
Done	Boolean	Whether the Activity is done or not. 0 = Not done 1 = Done. If omitted, returns both Done and Not done activities. The allowed values are 0, 1.
FilterId	Integer	The ID of the Filter to use.
StartDate	String	Use the Activity due date where you wish to begin fetching Activities from Insert due date in YYYY-MM-DD format.
EndDate	String	Use the Activity due date where you wish to stop fetching Activities from Insert due date in YYYY-MM-DD format.

ActivitiesParticipants

Getdetails of activities participants

Select

The Sync App 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 Sync App.

Id supports the '=' operator.
Done supports the '=' operator.
Type supports the '=, IN' operators.
UserId supports the '=' operator.
FilterId supports the '=' operator.
StartDate supports the '=' operator.
EndDate supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM ActivitiesParticipants WHERE Id = 246

SELECT * FROM ActivitiesParticipants WHERE Done = 0

SELECT * FROM  ActivitiesParticipants WHERE Type IN ('deadline','call')

SELECT * FROM  ActivitiesParticipants WHERE EndDate = '2021-12-24'
 
SELECT * FROM  ActivitiesParticipants WHERE UserId = 8230170

Columns


Name	Type	Description
PersonId [KEY]	Integer	PersonId
Id	Integer	Activities ID.
PrimaryFlag	Boolean	PrimaryFlag

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
Type	String	Type of the Activity This is in correlation with the key_string parameter of ActivityTypes When value for type is not set, it will be given a default value Call The default value is Call.
Done	Boolean	Whether the Activity is done or not 0 = Not done 1 = Done If omitted returns both Done and Not done activities The allowed values are 0, 1.
FilterId	Integer	The ID of the Filter to use
StartDate	String	Use the Activity due date where you wish to begin fetching Activities from Insert due date in YYYY-MM-DD format
EndDate	String	Use the Activity due date where you wish to stop fetching Activities from Insert due date in YYYY-MM-DD format
UserId	String	UserId

ActivityFields

Returns all activity fields.

Select

The Sync App 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 Sync App.

For example, the following query is processed server side:

SELECT * FROM ActivityFields

Columns


Name	Type	Description
Id [KEY]	Integer	Id.
ActiveFlag	Boolean	ActiveFlag.
AddTime	Datetime	AddTime.
AddVisibleFlag	Boolean	AddVisibleFlag.
BulkEditAllowed	Boolean	BulkEditAllowed.
DetailsVisibleFlag	Boolean	DetailsVisibleFlag.
EditFlag	Boolean	EditFlag.
FieldType	String	FieldType.
FilteringAllowed	Boolean	FilteringAllowed.
ImportantFlag	Boolean	ImportantFlag.
IndexVisibleFlag	Boolean	IndexVisibleFlag.
Key	String	Key.
LastUpdatedByUserId	String	LastUpdatedByUserId.
MandatoryFlag	Boolean	MandatoryFlag.
Name	String	Name.
Options	String	Options.
OrderNr	Integer	OrderNr.
SearchableFlag	Boolean	SearchableFlag.
SortableFlag	Boolean	SortableFlag.
UpdateTime	Datetime	UpdateTime.

ActivityFieldsOptions

Returns all activity fields.

Columns


Name	Type	Description
Id [KEY]	String	Id.
Label	String	Label.

Currencies

Returns all supported currencies in given account which should be used when saving monetary values with other objects.

Select

The Sync App 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 Sync App.

Term supports the '=' operator.

For example, the following query is processed server side. Term can be Currencies.Name or/and Currencies.Code:

SELECT * FROM Currencies WHERE Term = 'Armenian Dram'  
SELECT * FROM Currencies WHERE Term = 'AFN'

Columns


Name	Type	Description
Id	Integer	Id.
ActiveFlag	Boolean	ActiveFlag.
Code	String	Code.
DecimalPoints	Integer	DecimalPoints.
IsCustomFlag	Boolean	IsCustomFlag.
Name	String	Name.
Symbol	String	Symbol.

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
Term	String	Optional search term that is searched for from currency's name and/or code.

DealFieldsOptions

Returns data about all deal fields.

Columns


Name	Type	Description
Id	String	Id.
Label	String	Label.

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
Name	String	Name of the field.
FieldType	String	Type of the field. The allowed values are address, date, daterange, double, enum, monetary, org, people, phone, set, text, time, timerange, user, varchar, varchar_auto, visible_to.
AddVisibleFlag	Boolean	AddVisibleFlag.

DealsActivities

Get all Deals Activities assigned to a particular User.

Select

The Sync App 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 Sync App.

DealId supports the '=' operator.
Done supports the '=' operator.
Exclude supports the '=,IN' operators.

For example, the following query is processed server side:

SELECT * FROM DealsActivities WHERE DealId = 246 
SELECT * FROM DealsActivities WHERE DealId = 246 AND done = 0
SELECT * FROM DealsActivities WHERE DealId = 246 AND Exclude IN ('240','241')

Columns


Name	Type	Description
Id [KEY]	Integer	Id.
ActiveFlag	Boolean	Active Flag.
AddTtime	Datetime	Add Ttime.
AssignedToUserId	Integer	Assigned To UserId.
Attendees	String	Attendees.
BusyFlag	Boolean	BusyFlag.
IncludeContext	String	Include Context.
CompanyId	Integer	Company Id.
MeetingClient	String	Meeting Client.
MeetingId	String	Meeting Id.
MeetingUrl	String	Meeting Url.
CreatedByUserId	Integer	CreatedBy UserId.
DealDropboxBcc	String	Deal Dropbox Bcc.
DealId	Integer	Deal Id.
DealTitle	String	Deal Title.
Done	Boolean	Whether the activity is done or not 0 = Not done, 1 = Done If omitted returns both Done and Not done activities. The allowed values are 0, 1.
DueDate	Date	Due Date.
DueTime	Time	Due Time.
Duration	Time	Duration.
FileCleanName	String	FileCleanName.
FileId	String	FileId.
FileUrl	String	FileUrl.
EventId	String	eventId.
CalendarEtag	String	CalendarEtag.
CalendarId	String	Calendar Id.
NotificationTime	Datetime	Notification Time.
NotificationUserId	Integer	Notification UserId.
LeadId	String	Lead Id.
Location	String	Location.
AreaLevel1	String	AreaLevel1.
AreaLevel2	String	AreaLevel2.
Country	String	Country.
FormattedAddress	String	FormattedAddress.
Lat	Double	Lat.
Locality	String	Locality.
Long	Double	Long.
PostalCode	String	PostalCode.
Route	String	Route.
StreetNumber	String	StreetNumber.
Sublocality	String	Sublocality.
Subpremise	String	Subpremise.
MarkedAsDoneTime	Datetime	MarkedAsDoneTime.
Note	String	Note.
NotificationLanguageId	Integer	NotificationLanguageId.
OrgId	Integer	OrgId.
OrgName	String	OrgName.
OwnerName	String	OwnerName.
Participants	String	Participants.
PersonDropboxBcc	String	Person Dropbox Bcc.
PersonId	Integer	PersonId.
PersonName	String	PersonName.
PublicDescription	String	PublicDescription.
MasterActivityId	String	MasterActivityId.
Rule	String	Rule.
RuleExtension	String	RuleExtension.
ReferenceId	Integer	ReferenceId.
ReferenceType	String	ReferenceType.
Series	String	Series.
SourceTimezone	String	SourceTimezone.
Subject	String	Subject.
Type	String	Type.
UpdateTime	Datetime	UpdateTime.
UpdateUserId	Integer	UpdateUserId.
UserId	Integer	UserId.

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
Exclude	String	A comma-separated string of activity IDs to exclude from result.

DealsActivitiesAttendees

Get Details of Deals Activities Attendees.

Select

The Sync App 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 Sync App.

DealId supports the '=' operator.
Done supports the '=' operator.
Exclude supports the '=,IN' operators.

For example, the following query is processed server side:

SELECT * FROM DealsActivitiesAttendees WHERE DealId = 246 
SELECT * FROM DealsActivitiesAttendees WHERE DealId = 246 AND done = 0
SELECT * FROM DealsActivitiesAttendees WHERE DealId = 246 Exclude IN ('240','241')

Columns


Name	Type	Description
DealId	Integer	Deal Id.
EmailAddress	String	EmailAddress.
IsOrganizer	Integer	IsOrganizer.
Name	String	Name.
PersonId	Integer	PersonId.
Status	String	Status.
UserId	String	UserId.

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
Done	Boolean	Whether the activity is done or not 0 = Not done, 1 = Done If omitted returns both Done and Not done activities. The allowed values are 0, 1.
Exclude	String	A comma-separated string of activity IDs to exclude from result.

Get Details of Deals Activities Attendees.

Select

The Sync App 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 Sync App.

DealId supports the '=' operator.
Done supports the '=' operator.
Exclude supports the '=,IN' operators.

For example, the following query is processed server side:

SELECT * FROM DealsActivitiesAttendees WHERE DealId = 246 
SELECT * FROM DealsActivitiesAttendees WHERE DealId = 246 AND done = 0
SELECT * FROM DealsActivitiesAttendees WHERE DealId = 246 Exclude IN ('240','241')

Columns


Name	Type	Description
DealId	Integer	Deal Id.
EmailAddress	String	EmailAddress.
IsOrganizer	Integer	IsOrganizer.
Name	String	Name.
Status	String	Status.
UserId	String	UserId.

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
AllChanges	String	Whether to show custom field updates or not. The allowed values are 1.
Items	String	Item specific updates. The allowed values are Activity, plannedActivity, note, file, change, deal, follower, participant, mailMessage, mailMessageWithAttachment, invoice, activityFile, document.

DealsActivitiesParticipants

Getdetails of activities participants.

Select

The Sync App 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 Sync App.

DealId supports the '=' operator.
Done supports the '=' operator.
Exclude supports the '=,IN' operators.

For example, the following query is processed server side:

SELECT * FROM DealsActivitiesParticipants WHERE DealId = 246 
SELECT * FROM DealsActivitiesParticipants WHERE DealId = 246 AND done = 0
SELECT * FROM DealsActivitiesParticipants WHERE DealId = 246 Exclude IN ('240','241')

Columns


Name	Type	Description
DealId	Integer	Deal Id.
PersonId [KEY]	Integer	PersonId.
PrimaryFlag	Boolean	PrimaryFlag.

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
Done	Boolean	Whether the activity is done or not 0 = Not done, 1 = Done If omitted returns both Done and Not done activities. The allowed values are 0, 1.
Exclude	String	A comma-separated string of activity IDs to exclude from result.

DealsFiles

Get details of deals file.

Select

The Sync App 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 Sync App.

DealId supports the '=' operator.
IncludeDeletedFiles supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM DealsFiles WHERE DealId = 246 
SELECT * FROM DealsFiles WHERE DealId = 246 AND IncludeDeletedFiles = 0

Columns


Name	Type	Description
Id [KEY]	Integer	ID of the deal.
ActiveFlag	Boolean	Active Flag.
ActivityId	String	Activity Id.
AddTime	Datetime	AddTime.
Cid	String	Cid.
DealId	String	Deal Id.
DealName	String	DealName.
Description	String	Description.
FileName	String	File Name.
FileSize	Integer	File Size.
FileType	String	File Type.
InlineFlag	Boolean	Inline Flag.
LogId	String	Log Id.
MailMessageId	String	MailMessage Id.
MailTemplateId	String	MailTemplate Id.
Name	String	Name.
OrgId	Integer	Org Id.
OrgName	String	Org Name.
PeopleName	String	People Name.
PersonId	String	PersonId.
PersonName	String	Person Name.
ProductId	String	Product Id.
ProductName	String	Product Name.
RemoteId	String	Remote Id.
RemoteLocation	String	Remote Location.
S3Bucket	String	S3Bucket.
UpdateTime	Datetime	Update Time.
Url	String	Url.
UserId	Integer	UserId.

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
IncludeDeletedFiles	Integer	When enabled, the list of files will also include deleted files. The allowed values are 0, 1.

DealsMailMessages

Get details of Deal mail Messages.

Select

The Sync App 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 Sync App.

Id supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM DealsMailMessages WHERE Id = 246

Columns


Name	Type	Description
Id [KEY]	Integer	id.
AccountId	String	AccountId.
AddTime	Datetime	addTime.
Bcc	String	Bcc.
BodyUrl	String	bodyUrl.
Cc	String	cc.
CompanyId	Integer	companyId.
DeletedFlag	Integer	DeletedFlag.
Draft	String	Draft.
DraftFlag	Integer	DraftFlag.
ExternalDeletedFlag	Integer	ExternalDeletedFlag.
From	String	From.
AttachmentsFlag	Integer	AttachmentsFlag.
BodyFlag	Integer	BodyFlag.
InlineAttachmentsFlag	Integer	InlineAttachmentsFlag.
RealAttachmentsFlag	Integer	RealAttachmentsFlag.
ItemType	String	ItemType.
TrackingEnabledFlag	Integer	TrackingEnabledFlag.
ThreadId	Integer	ThreadId.
TrackingStatus	String	TrackingStatus.
MessageTime	String	MessageTime.
MessageId	String	MessageId.
NylasId	String	NylasId.
ReadFlag	Integer	ReadFlag.
S3Bucket	String	S3Bucket.
S3BucketPath	String	S3BucketPath.
SentFlag	Integer	SentFlag.
SentFromPipedriveFlag	Integer	SentFromPipedriveFlag.
SmartBccFlag	Integer	SmartBccFlag.
Snippet	String	Snippet.
Subject	String	Subject.
SyncedFlag	Integer	SyncedFlag.
TemplateId	String	TemplateId.
Timestamp	Datetime	Timestamp.
To	String	To.
UpdateTime	Datetime	UpdateTime.
UserId	Integer	UserId.
WriteFlag	Boolean	writeFlag.
Object	String	Object.

DealsMailMessagesBcc

Get details of Deal mail Messages.

Select

The Sync App 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 Sync App.

Id supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM DealsMailMessagesBcc WHERE Id = 246

Columns


Name	Type	Description
Id [KEY]	Integer	id.
EmailAddress	String	EmailAddress.
PersonId	String	PersonId.
PersonName	String	PersonName.
MessagePartyId	Integer	MessagePartyId.
Name	String	Name.

DealsMailMessagesCc

Get details of Deal mail Messages.

Select

The Sync App 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 Sync App.

Id supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM DealsMailMessagesCc WHERE Id = 246

Columns


Name	Type	Description
Id [KEY]	Integer	Id.
EmailAddress	String	EmailAddress.
PersonId	String	PersonId.
PersonName	String	PersonName.
MessagePartyId	Integer	MessagePartyId.
Name	String	Name.

DealsMailMessagesFrom

Get details of Deal mail Messages.

Select

The Sync App 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 Sync App.

Id supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM DealsMailMessagesFrom WHERE Id = 246

Columns


Name	Type	Description
Id [KEY]	Integer	Id.
EmailAddress	String	EmailAddress.
PersonId	String	PersonId.
PersonName	String	PersonName.
MessagePartyId	Integer	MessagePartyId.
Name	String	Name.

DealsMailMessagesTo

Get details of Deal mail Messages.

Select

The Sync App 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 Sync App.

Id supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM DealsMailMessagesTo WHERE Id = 246

Columns


Name	Type	Description
Id [KEY]	Integer	Id.
EmailAddress	String	EmailAddress.
PersonId	String	PersonId.
PersonName	String	PersonName.
MessagePartyId	Integer	MessagePartyId.
Name	String	Name.

DealsPermittedUsers

Get details of deals Permitted users

Columns


Name	Type	Description
Id	String	Id.

DealsPersonEmails

Get all emails asscociated with persons in deal

Columns


Name	Type	Description
Id [KEY]	Integer	Deals ID.
Label	String	Label.
Value	String	Value.
Primary	Boolean	Primary.

DealsPersonPhone

Get all phone asscociated with persons in deal.

Columns


Name	Type	Description
Id [KEY]	Integer	Deals ID.
label	String	Label.
Value	String	Value.
Primary	Boolean	Primary.

DealsPersons

Get details of deals persons.

Columns


Name	Type	Description
Id [KEY]	Integer	Id.
ActivitiesCount	Integer	ActivitiesCount.
ActiveFlag	Boolean	ActiveFlag.
AddTime	Datetime	AddTime.
CcEmail	String	CcEmail.
ClosedDealsCount	Integer	ClosedDealsCount.
CompanyId	Integer	CompanyId.
DoneActivitiesCount	Integer	DoneActivitiesCount.
Email	String	Email.
EmailMessagesCount	Integer	EmailMessagesCount.
FilesCount	Integer	FilesCount.
Label	Integer	label.
LastActivityDate	Date	LastActivityDate.
LastActivityId	Integer	LastActivityId.
LastincomingMailTime	String	LastincomingMailTime.
Lastname	String	Lastname.
LastoutgoingMailTime	String	LastoutgoingMailTime.
LostdealsCount	Integer	LostdealsCount.
Name	String	Name.
NextActivityDate	Date	nextActivityDate.
NextActivityId	Integer	nextActivityId.
NextActivityTime	String	nextActivityTime.
NotesCount	Integer	NotesCount.
OpenDealsCount	Integer	OpenDealsCount.
OrgActiveFlag	Boolean	OrgActiveFlag.
OrgAddress	String	OrgAddress.
OrgCcEmail	String	OrgCcEmail.
OrgName	String	OrgName.
OrgownerId	Integer	OrgownerId.
OrgpeopleCount	Integer	OrgpeopleCount.
OrgId	Integer	OrgId.
OwnerActiveFlag	Boolean	OwnerActiveFlag.
OwnerEmail	String	OwnerEmail.
OwnerHasPic	Integer	OwnerHasPic.
OwnerId	Integer	OwnerId.
OwnerName	String	OwnerName.
OwnerPicHash	String	OwnerPicHash.
OwnerValue	Integer	OwnerValue.
ParticipantClosedDealsCount	Integer	ClosedDealsCount.
ParticipantOpenDealsCount	Integer	OpenDealsCount.
Phone	String	Phone.
PictureActiveFlag	Boolean	PictureActiveFlag.
PictureaddTime	Datetime	PictureaddTime.
PictureaddedByUserId	Integer	PictureaddedByUserId.
PictureItemId	Integer	PictureItemId.
PictureitemType	String	PictureitemType.
Picture128	String	Picture128.
Picture512	String	Picture512.
PictureupdateTime	String	PictureupdateTime.
Picturevalue	Integer	Picturevalue.
PictureId	String	PictureId.
RelatedclosedDealsCount	Integer	RelatedclosedDealsCount.
RelatedlostDealsCount	Integer	RelatedlostDealsCount.
RelatedopenDealsCount	Integer	RelatedopenDealsCount.
RelatedwonDealsCount	Integer	RelatedwonDealsCount.
UndoneActivitiesCount	Integer	UndoneActivitiesCount.
UpdateTime	Datetime	UpdateTime.
VisibleTo	String	visibleTo.
WonDealsCount	Integer	WonDealsCount.

DealsSummary

Return detils of deals summary.

Select

The Sync App 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 Sync App.

Status supports the '=' operator.
UserId supports the '=' operator.
FilterId supports the '=' operator.
StageId supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM DealsSummary WHERE UserId = 8230170

SELECT * FROM DealsSummary WHERE Status = 'open'

SELECT * FROM DealsSummary WHERE StageId = 1
 
SELECT * FROM DealsSummary WHERE FilterId = 1

Columns


Name	Type	Description
TotalCount	Integer	Total Count.
Totalvalue	Double	Total value.
TotalValueFormatted	String	Total Value Formatted.
TotalWeightedValue	Double	Total Weighted Value.
TotalWeightedValueFormatted	String	Total Weighted Value Formatted.
EURCount	Integer	EUR Count.
EURValue	Integer	EUR Value.
EURConverted	Double	EUR Converted.
EURConvertedFormatted	String	EUR Converted Formatted.
EURFormatted	String	EUR Formatted.
USDCount	Integer	USD Count.
USDValue	Integer	USD Value.
USDConverted	Integer	USD Converted.
USDConvertedFormatted	String	USD Converted Formatted.
USDFormatted	String	USD Formatted.
WeightedEURCount	Integer	Weighted EUR Count.
WeightedEURValue	Integer	Weighted EUR Value.
WeightedEURValueFormatted	String	Weighted EUR Value Formatted.
WeightedUSDCount	Integer	Weighted USD Count.
WeightedUSD	Integer	Weighted USD.
WeightedUSDFormatted	String	Weighted USD Formatted.

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.
UserId	Integer	User Id.
StageId	Integer	Stage Id.
Status	String	Status.

DealsTimeline

Usage information for the operation DealsTimeline.rsd.

Select

The Sync App 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 Sync App.

UserId supports the '=' operator.
ConvertCurrency supports the '=' operator.
ExcludeDeals supports the '=' operator.
FilterId supports the '=' operator.
PipelineId supports the '=' operator.
IntervalType supports the '=' operator.
Amount supports the '=' operator.
StartDate supports the '=' operator.
FieldKey supports the '=' operator.
IntervalType supports the '=' operator.

For example, the following query is processed server side:

Required fields: Amount, StartDate, FieldKey and IntervalType is required

SELECT * FROM DealsTimeline WHERE Amount = '3' AND StartDate = '2021-12-12' AND FieldKey = 'add_time' AND IntervalType = 'month'

Columns


Name	Type	Description
Deals	String	Deals
PeriodEnd	Datetime	Period End
PeriodStart	Date	Period Start
Count	Integer	Count
OpenCount	Integer	open Count
OpenValuesEUR	Integer	open Values EUR
ValuesEUR	Integer	Values EUR
ValuesUSD	Integer	Values USD
WeightedOpenValuesEUR	Integer	Weighted Open Values EUR
WeightedValuesEUR	Integer	Weighted Values EUR
WeightedValuesUSD	Integer	Weighted Values USD
WonCount	Integer	Won Count
WonValuesUSD	Integer	Won Values USD

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
StartDate	Date	Date where the first interval starts. Format: YYYY-MM-DD.
IntervalType	String	Type Of Interval. The allowed values are day, week, month, quarter.
Amount	Integer	The number of given intervals, starting from start_date, to fetch E.g 3 months.
FieldKey	String	The date field key which deals will be retrieved from.
UserId	Integer	User id.
FilterId	Integer	Type Of Interval. The allowed values are day, week, month, quarter.
ExcludeDeals	Integer	Whether to exclude deals list 1 or not 0. The allowed values are 0, 1.
ConvertCurrency	String	3-letter currency code of any of the supported currencies.
PipelineId	Integer	Pipeline Id.

DealsTimelineDeals

Return details of DealsTimeline deals.

Columns


Name	Type	Description
Id [KEY]	Integer	Id.
Active	Boolean	Active.
ActivitiesCount	Integer	ActivitiesCount.
AddTime	Datetime	AddTime.
CcEmail	String	CcEmail.
CloseTime	String	CloseTime.
CreatorUserId	Integer	CreatorUserId.
Currency	String	Currency.
Deleted	Boolean	Deleted.
DoneActivitiesCount	Integer	DoneActivitiesCount.
EmailMessagesCount	Integer	EmailMessagesCount.
ExpectedCloseDate	Date	ExpectedCloseDate.
FilesCount	Integer	FilesCount.
FirstWonTime	Datetime	FirstWonTime.
FollowersCount	Integer	FollowersCount.
FormattedValue	String	FormattedValue.
FormattedWeightedValue	String	FormattedWeightedValue.
Label	String	Label.
LastActivityDate	String	LastActivityDate.
LastActivityId	String	LastActivityId.
LastncomingMailTime	Datetime	LastncomingMailTime.
LastoutgoingMailTime	Datetime	LastoutgoingMailTime.
Lostreason	String	Lostreason.
LostTime	String	LostTime.
NextActivityDate	Date	NextActivityDate.
NextActivityDuration	Time	NextActivityDuration.
NextActivityId	Integer	NextActivityId.
NextActivityNote	String	NextActivityNote.
NextActivitySubject	String	NextActivitySubject.
NextActivityTime	Time	NextActivityTime.
NextActivityType	String	NextActivityType.
NotesCount	Integer	NotesCount.
OrgHidden	Boolean	OrgHidden.
OrgId	Integer	OrgId.
OrgName	String	OrgName.
OwnerName	String	OwnerName.
ParticipantsCount	Integer	ParticipantsCount.
PersonHidden	Boolean	PersonHidden.
PersonId	Integer	PersonId.
PersonName	String	PersonName.
PipelineId	Integer	PipelineId.
Probability	String	Probability.
ProductsCount	Integer	ProductsCount.
RottenTime	String	RottenTime.
StageChangeTime	Datetime	StageChangeTime.
StageId	Integer	StageId.
StageOrderNr	Integer	StageOrderNr.
Status	String	Status.
Title	String	Title.
UndoneActivitiesCount	Integer	UndoneActivitiesCount.
UpdateTime	Datetime	UpdateTime.
UserId	Integer	UserId.
Value	Integer	Value.
VisibleTo	String	VisibleTo.
WeightedValue	Integer	WeightedValue.
WeightedValueCurrency	String	WeightedValueCurrency.
WonTime	Datetime	WonTime.

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
StartDate	Date	Date where the first interval starts. Format: YYYY-MM-DD
IntervalType	String	Type Of Interval. The allowed values are day, week, month, quarter.
Amount	Integer	The number of given intervals, starting from start_date, to fetch E.g 3 months.
FieldKey	String	The date field key which deals will be retrieved from.
FilterId	Integer	Type Of Interval. The allowed values are day, week, month, quarter.
ExcludeDeals	Integer	Whether to exclude deals list 1 or not 0. The allowed values are 0, 1.
ConvertCurrency	String	3-letter currency code of any of the supported currencies.

DealsUpdates

Get details of deals updates.

Select

The Sync App 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 Sync App.

DealId supports the '=' operator.
AllChanges supports the '=' operator.
Items supports the '=,IN' operators.

For example, the following query is processed server side:

SELECT * FROM DealsUpdates WHERE DealId = 3 
SELECT * FROM DealsUpdates WHERE DealId = 246 AND AllChanges = 1
SELECT * FROM DealsUpdates WHERE DealId = 246 AND Items IN ('activity' ,'call')

Columns


Name	Type	Description
id	Integer	Id.
AccountId	String	AccountId.
ActiveFlag	Boolean	ActiveFlag.
AddTime	Datetime	AddTime.
AdditionalData	String	AdditionalData.
AssignedToUserId	Integer	AssignedToUserId.
Attachments	String	Attachments.
Attendees	String	Attendees.
Bcc	String	Bcc.
BodyUrl	String	BodyUrl.
BusyFlag	Boolean	BusyFlag.
IncludeContext	String	IncludeContext.
Cc	String	Cc.
ChangeSource	String	ChangeSource.
UserAgent	String	UserAgent.
CompanyId	Integer	CompanyId.
MeetingClient	String	MeetingClient.
MeetingId	String	MeetingId.
MeetingUrl	String	MeetingUrl.
CreatedByUserId	Integer	CreatedByUserId.
DealDropboxBcc	String	DealDropboxBcc.
DealId	Integer	DealId.
DealTitle	String	DealTitle.
DeletedFlag	Integer	DeletedFlag.
Done	Boolean	Done.
Draft	String	Draft.
DraftFlag	Integer	DraftFlag.
DueDate	Date	DueDate.
DueTime	Time	DueTime.
Duration	Time	Duration.
ExternalDeletedFlag	Integer	ExternalDeletedFlag.
FieldKey	String	FieldKey.
CleanName	String	CleanName.
FileId	String	FileId.
Url	String	Url.
From	String	From.
GcalEventId	String	GcalEventId.
GoogleCalendarEtag	String	GoogleCalendarEtag.
GoogleCalendarId	String	GoogleCalendarId.
AttachmentsFlag	Integer	AttachmentsFlag.
BodyFlag	Integer	BodyFlag.
InlineAttachmentsFlag	Integer	InlineAttachmentsFlag.
RealAttachmentsFlag	Integer	RealAttachmentsFlag.
IsBulkUpdateFlag	String	IsBulkUpdateFlag.
ItemId	Integer	ItemId.
ItemType	String	ItemType.
NotificationTime	Datetime	NotificationTime.
NotificationUserId	Integer	NotificationUserId.
LeadId	String	LeadId.
Location	String	Location.
AdminAreaLevel1	String	AdminAreaLevel1.
AdminAreaLevel2	String	AdminAreaLevel2.
Country	String	Country.
FormattedAddress	String	FormattedAddress.
Lat	Double	Lat.
Locality	String	Locality.
Long	Double	Long.
PostalCode	String	PostalCode.
Route	String	Route.
StreetNumber	String	StreetNumber.
Sublocality	String	Sublocality.
Subpremise	String	Subpremise.
LogTime	Datetime	LogTime.
TrackingEnabledFlag	Integer	TrackingEnabledFlag.
MailThreadId	Integer	MailThreadId.
MailTrackingStatus	String	MailTrackingStatus.
MarkedAsDoneTime	Datetime	MarkedAsDoneTime.
MessageTime	String	MessageTime.
MuaMessageId	String	MuaMessageId.
NewValue	String	NewValue.
Note	String	Note.
LanguageId	Integer	LanguageId.
NylasId	String	NylasId.
OldValue	Integer	OldValue.
OrgId	Integer	OrgId.
OrgName	String	OrgName.
OwnerName	String	OwnerName.
Participants	String	Participants.
PersonDropboxBcc	String	PersonDropboxBcc.
PersonId	Integer	PersonId.
PersonName	String	PersonName.
PublicDescription	String	PublicDescription.
ReadFlag	Integer	ReadFlag.
RecActivityId	String	RecActivityId.
RecRule	String	RecRule.
RecRuleExtension	String	RecRuleExtension.
ReferenceId	Integer	ReferenceId.
ReferenceType	String	ReferenceType.
S3Bucket	String	S3Bucket.
S3BucketPath	String	S3BucketPath.
SentFlag	Integer	SentFlag.
SentFromPipedriveFlag	Integer	SentFromPipedriveFlag.
Series	String	Series.
SmartBccFlag	Integer	SmartBccFlag.
Snippet	String	Snippet.
SourceTimezone	String	SourceTimezone.
Subject	String	Subject.
SyncedFlag	Integer	SyncedFlag.
TemplateId	String	TemplateId.
Timestamp	Datetime	Timestamp.
To	String	To.
Type	String	Type.
UpdateTime	Datetime	UpdateTime.
UpdateUserId	Integer	UpdateUserId.
UserId	Integer	UserId.
WriteFlag	Boolean	WriteFlag.
Object	String	Object.

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
AllChanges	String	Whether to show custom field updates or not. The allowed values are 1.
Items	String	Item specific updates. The allowed values are activity, plannedActivity, note, file, change, deal, follower, participant, mailMessage, mailMessageWithAttachment, invoice, activityFile, document.

DealsUpdatesAttachments

Get details of deals Updates Attachments.

Select

The Sync App 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 Sync App.

DealId supports the '=' operator.
AllChanges supports the '=' operator.
Items supports the '=,IN' operators.

For example, the following query is processed server side:

SELECT * FROM DealsUpdatesAttachments WHERE DealId = 3
SELECT * FROM DealsUpdatesAttachments WHERE DealId = 246 AND AllChanges = 1
SELECT * FROM DealsUpdatesAttachments WHERE DealId = 246 AND Items IN ('activity' ,'call')

Columns


Name	Type	Description
Id [KEY]	Integer	Id.
ActiveFlag	Boolean	ActiveFlag.
ActivityId	String	ActivityId.
AddTime	Datetime	AddTime.
Cid	String	Cid.
DealName	String	DealName.
DealId	Integer	dealid.
Description	String	Description.
FileName	String	FileName.
FileSize	Integer	FileSize.
FileType	String	FileType.
InlineFlag	Boolean	InlineFlag.
LogId	String	LogId.
MailMessageId	String	MailMessageId.
MailTemplateId	String	MailTemplateId.
Name	String	Name.
OrgId	Integer	OrgId.
OrgName	String	OrgName.
PeopleName	String	PeopleName.
PersonId	String	PersonId.
PersonName	String	PersonName.
ProductId	String	ProductId.
ProductName	String	ProductName.
RemoteId	String	RemoteId.
RemoteLocation	String	RemoteLocation.
S3Bucket	String	S3Bucket.
UpdateTime	Datetime	UpdateTime.
Url	String	Url.
UserId	Integer	UserId.

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
AllChanges	String	Whether to show custom field updates or not. The allowed values are 1.
Items	String	Item specific updates. The allowed values are Activity, plannedActivity, note, file, change, deal, follower, participant, mailMessage, mailMessageWithAttachment, invoice, activityFile, document.

DealsActivitiesAttendees

Get Details of Deals Activities Attendees.

Select

The Sync App 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 Sync App.

DealId supports the '=' operator.
Done supports the '=' operator.
Exclude supports the '=,IN' operators.

For example, the following query is processed server side:

SELECT * FROM DealsActivitiesAttendees WHERE DealId = 246 
SELECT * FROM DealsActivitiesAttendees WHERE DealId = 246 AND done = 0
SELECT * FROM DealsActivitiesAttendees WHERE DealId = 246 Exclude IN ('240','241')

Columns


Name	Type	Description
DealId	Integer	Deal Id.
EmailAddress	String	EmailAddress.
IsOrganizer	Integer	IsOrganizer.
Name	String	Name.
PersonId	Integer	PersonId.
Status	String	Status.
UserId	String	UserId.

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
Done	Boolean	Whether the activity is done or not 0 = Not done, 1 = Done If omitted returns both Done and Not done activities. The allowed values are 0, 1.
Exclude	String	A comma-separated string of activity IDs to exclude from result.

Get Details of Deals Activities Attendees.

Select

The Sync App 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 Sync App.

DealId supports the '=' operator.
Done supports the '=' operator.
Exclude supports the '=,IN' operators.

For example, the following query is processed server side:

SELECT * FROM DealsActivitiesAttendees WHERE DealId = 246 
SELECT * FROM DealsActivitiesAttendees WHERE DealId = 246 AND done = 0
SELECT * FROM DealsActivitiesAttendees WHERE DealId = 246 Exclude IN ('240','241')

Columns


Name	Type	Description
DealId	Integer	Deal Id.
EmailAddress	String	EmailAddress.
IsOrganizer	Integer	IsOrganizer.
Name	String	Name.
Status	String	Status.
UserId	String	UserId.

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
AllChanges	String	Whether to show custom field updates or not. The allowed values are 1.
Items	String	Item specific updates. The allowed values are Activity, plannedActivity, note, file, change, deal, follower, participant, mailMessage, mailMessageWithAttachment, invoice, activityFile, document.

DealsUpdatesBcc

Get details of Deal updates Bcc.

Select

The Sync App 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 Sync App.

DealId supports the '=' operator.
AllChanges supports the '=' operator.
Items supports the '=,IN' operators.

For example, the following query is processed server side:

SELECT * FROM DealsUpdatesBcc WHERE DealId = 3
SELECT * FROM DealsUpdatesBcc WHERE DealId = 246 AND AllChanges = 1
SELECT * FROM DealsUpdatesBcc WHERE DealId = 246 AND Items IN ('activity' ,'call')

Columns


Name	Type	Description
Id [KEY]	Integer	Id.
DealId	Integer	Deal Id.
EmailAddress	String	EmailAddress.
PersonId	String	PersonId.
PersonName	String	PersonName.
MessagePartyId	Integer	MessagePartyId.
Name	String	Name.

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
AllChanges	String	Whether to show custom field updates or not. The allowed values are 1.
Items	String	item specific updates. The allowed values are Activity, plannedActivity, note, file, change, deal, follower, participant, mailMessage, mailMessageWithAttachment, invoice, activityFile, document.

DealsUpdatesCc

Get details of Deals Updates cc.

Select

The Sync App 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 Sync App.

DealId supports the '=' operator.
AllChanges supports the '=' operator.
Items supports the '=,IN' operators.

For example, the following query is processed server side:

SELECT * FROM DealsUpdatesCc WHERE DealId = 3 
SELECT * FROM DealsUpdatesCc WHERE DealId = 246 AND AllChanges = 1
SELECT * FROM DealsUpdatesCc WHERE DealId = 246 AND Items IN ('activity' ,'call')

Columns


Name	Type	Description
PersonId [KEY]	String	PersonId.
DealId	Integer	Deal Id.
EmailAddress	String	EmailAddress.
PersonName	String	PersonName.
MessagePartyId	Integer	MessagePartyId.
Name	String	Name.

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
AllChanges	String	Whether to show custom field updates or not. The allowed values are 1.
Items	String	item specific updates. The allowed values are Activity, plannedActivity, note, file, change, deal, follower, participant, mailMessage, mailMessageWithAttachment, invoice, activityFile, document.

DealsUpdatesFrom

Get details of Deals Updates From.

Select

The Sync App 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 Sync App.

DealId supports the '=' operator.
AllChanges supports the '=' operator.
Items supports the '=,IN' operators.

For example, the following query is processed server side:

SELECT * FROM DealsUpdatesFrom WHERE DealId = 3 
SELECT * FROM DealsUpdatesFrom WHERE DealId = 246 AND AllChanges = 1
SELECT * FROM DealsUpdatesFrom WHERE DealId = 246 AND Items IN ('activity' ,'call')

Columns


Name	Type	Description
Id [KEY]	Integer	Id.
DealId	Integer	Deal Id.
EmailAddress	String	EmailAddress.
PersonId	String	PersonId.
PersonName	String	PersonName.
MessagePartyId	Integer	MessagePartyId.
Name	String	Name.

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
AllChanges	String	Whether to show custom field updates or not The allowed values are 1.
Items	String	item specific updates The allowed values are Activity, plannedActivity, note, file, change, deal, follower, participant, mailMessage, mailMessageWithAttachment, invoice, activityFile, document.

DealsUpdatesParticipants

Getdetails of activities participants.

Columns


Name	Type	Description
PersonId [KEY]	Integer	PersonId.
DealId	Integer	Deal Id.
PrimaryFlag	Boolean	PrimaryFlag.

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
AllChanges	String	Whether to show custom field updates or not. The allowed values are 1.
Items	String	Item specific updates. The allowed values are Activity, plannedActivity, note, file, change, deal, follower, participant, mailMessage, mailMessageWithAttachment, invoice, activityFile, document.

DealsUpdatesTo

Get details of Deals Updates to.

Select

The Sync App 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 Sync App.

DealId supports the '=' operator.
AllChanges supports the '=' operator.
Items supports the '=,IN' operators.

For example, the following query is processed server side:

SELECT * FROM DealsUpdatesTo WHERE DealId = 3 
SELECT * FROM DealsUpdatesTo WHERE DealId = 246 AND AllChanges = 1
SELECT * FROM DealsUpdatesTo WHERE DealId = 246 AND Items IN ('activity' ,'call')

Columns


Name	Type	Description
Id [KEY]	Integer	Id.
DealId	Integer	Deal Id.
EmailAddress	String	EmailAddress.
PersonId	String	PersonId.
PersonName	String	PersonName.
MessagePartyId	Integer	MessagePartyId.
Name	String	Name.

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
AllChanges	String	Whether to show custom field updates or not. The allowed values are 1.
Items	String	item specific updates. The allowed values are Activity, plannedActivity, note, file, change, deal, follower, participant, mailMessage, mailMessageWithAttachment, invoice, activityFile, document.

FilterHelpers

Returns all supported filter helpers.

Columns


Name	Type	Description
AdminAreaLevel1	String	AdminAreaLevel1.
AdminAreaLevel2	String	AdminAreaLevel2.
Country	String	Country.
FormattedAddress	String	FormattedAddress.
Locality	String	Locality.
PostalCode	String	PostalCode.
Route	String	Route.
StreetNumber	String	StreetNumber.
Sublocality	String	Sublocality.
Subpremise	String	Subpremise.
CurrencyNotEqual	String	CurrencyNotEqual.
CurrencyEqual	String	CurrencyEqual.
DateNotEqual	String	DateNotEqual.
DateLessThan	String	DateLessThan.
DateLessThanOrEqual	String	DateLessThanOrEqual.
DateEqual	String	DateEqual.
DateGreaterThan	String	DateGreaterThan.
DateGreaterThanOrEqual	String	DateGreaterThanOrEqual.
DateISNOTNULL	String	DateISNOTNULL.
DateISNULL	String	DateISNULL.
DateRangeNotEqual	String	DateRangeNotEqual.
DateRangeLessThan	String	DateRangeLessThan.
DateRangeLessThanOrEqual	String	DateRangeLessThanOrEqual.
DateRangeEqual	String	DateRangeEqual.
DateRangeGreaterThan	String	DateRangeGreaterThan.
DateRangeGreaterThanOrEqual	String	DateRangeGreaterThanOrEqual.
DateRangeDoesNotEndAt	String	DateRangeDoesNotEndAt.
DateRangeEndsAfter	String	DateRangeEndsAfter.
DateRangeEndsAt	String	DateRangeEndsAt.
DateRangeEndsBefore	String	DateRangeEndsBefore.
DateRangeEndsEAfter	String	DateRangeEndsEAfter.
DateRangeEndsEBefore	String	DateRangeEndsEBefore.
DateRangeincludes	String	DateRangeincludes.
DateRangeISNOTNULL	String	DateRangeISNOTNULL.
DateRangeISNULL	String	DateRangeISNULL.
DealNotEqual	String	DealNotEqual.
DealEqual	String	DealEqual.
DealISNOTNULL	String	DealISNOTNULL.
DealISNULL	String	DealISNULL.
DoubleNotEqual	String	DoubleNotEqual.
DoubleLessThan	String	DoubleLessThan.
DoubleLessThanOrEqual	String	DoubleLessThanOrEqual.
DoubleEqual	String	DoubleEqual.
DoubleGreaterThan	String	DoubleGreaterThan.
DoubleGreaterThanOrEqual	String	DoubleGreaterThanOrEqual.
DoubleISNOTNULL	String	DoubleISNOTNULL.
DoubleISNULL	String	DoubleISNULL.
EnteredStageNotEqual	String	EnteredStageNotEqual.
EnteredStageLessThan	String	EnteredStageLessThan.
EnteredStageLessThanOrEqual	String	EnteredStageLessThanOrEqual.
EnteredStageEqual	String	EnteredStageEqual.
EnteredStageGreaterThan	String	EnteredStageGreaterThan.
EnteredStageGreaterThanOrEqual	String	EnteredStageGreaterThanOrEqual.
EnumNotEqual	String	EnumNotEqual.
EnumEqual	String	EnumEqual.
EnumISNOTNULL	String	EnumISNOTNULL.
EnumISNULL	String	EnumISNULL.
IntNotEqual	String	IntNotEqual.
IntLessThan	String	IntLessThan.
IntLessThanOrEqual	String	IntLessThanOrEqual.
IntEqual	String	IntEqual.
IntGreaterThan	String	IntGreaterThan.
IntGreaterThanOrEqual	String	IntGreaterThanOrEqual.
IntISNOTNULL	String	IntISNOTNULL.
IntISNULL	String	IntISNULL.
MonetaryNotEqual	String	MonetaryNotEqual.
MonetaryLessThan	String	MonetaryLessThan.
MonetaryLessThanOrEqual	String	MonetaryLessThanOrEqual.
MonetaryEqual	String	MonetaryEqual.
MonetaryGreaterThan	String	MonetaryGreaterThan.
MonetaryGreaterThanOrEqual	String	MonetaryGreaterThanOrEqual.
MonetaryISNOTNULL	String	MonetaryISNOTNULL.
MonetaryISNULL	String	MonetaryISNULL.
OrganizationNotEqual	String	OrganizationNotEqual.
OrganizationEqual	String	OrganizationEqual.
OrganizationISNOTNULL	String	OrganizationISNOTNULL.
OrganizationISNULL	String	OrganizationISNULL.
PersonNotEqual	String	PersonNotEqual.
PersonEqual	String	PersonEqual.
PersonISNOTNULL	String	PersonISNOTNULL.
PersonISNULL	String	PersonISNULL.
PipelineNotEqual	String	PipelineNotEqual.
PipelineEqual	String	PipelineEqual.
ProductNotEqual	String	ProductNotEqual.
ProductEqual	String	ProductEqual.
ProductISNOTNULL	String	ProductISNOTNULL.
ProductISNULL	String	ProductISNULL.
SetNotEqual	String	SetNotEqual.
SetEqual	String	SetEqual.
SetContains	String	SetContains.
SetISNOTNULL	String	SetISNOTNULL.
SetISNULL	String	SetISNULL.
SetNotContains	String	SetNotContains.
StageNotEqual	String	StageNotEqual.
StageEqual	String	StageEqual.
StageHasBeen	String	StageHasBeen.
StatusNotEqual	String	StatusNotEqual.
StatusEqual	String	StatusEqual.
TimeNotEqual	String	TimeNotEqual.
TimeLessThan	String	TimeLessThan.
TimeLessThanOrEqual	String	TimeLessThanOrEqual.
TimeEqual	String	TimeEqual.
TimeGreaterThan	String	TimeGreaterThan.
TimeGreaterThanOrEqual	String	TimeGreaterThanOrEqual.
TimeISNOTNULL	String	TimeISNOTNULL.
TimeISNULL	String	TimeISNULL.
TimerangeNotEqual	String	TimerangeNotEqual.
TimerangeLessThan	String	TimerangeLessThan.
TimerangeLessThanOrEqual	String	TimerangeLessThanOrEqual.
TimerangeEqual	String	TimerangeEqual.
TimerangeGreaterThan	String	TimerangeGreaterThan.
TimerangeGreaterThanOrEqual	String	TimerangeGreaterThanOrEqual.
TimerangedoesNotEndAt	String	TimerangeDoes_not_end_at.
TimerangeEndsAfter	String	TimerangeEndsAfter.
TimerangeEndsAt	String	TimerangeEndsAt.
TimerangeEndsBefore	String	TimerangeEndsBefore.
TimerangeEndsEAfter	String	TimerangeEndsEAfter.
TimerangeEndsEBefore	String	TimerangeEndsEBefore.
TimerangeIncludes	String	TimerangeIncludes.
TimerangeISNOTNULL	String	TimerangeISNOTNULL.
TimerangeISNULL	String	TimerangeISNULL.
TitleEqual	String	TitleEqual.
TitleLIKE'$%'	String	TitleLIKE'$%'.
TitleLIKE'%$'	String	TitleLIKE'%$'.
TitleLIKE'%$%'	String	TitleLIKE'%$%'.
TitleNOTLIKE'$%'	String	TitleNOTLIKE'$%'.
TitleNOTLIKE'%$'	String	TitleNOTLIKE'%$'.
TitleNOTLIKE'%$%'	String	TitleNOTLIKE'%$%'.
UserNotEqual	String	UserNotEqual.
UserEqual	String	UserEqual.
UserBelongsToTeam	String	User.belongs_to_team.
UserISNOTNULL	String	User.IS_NOT_NULL.
UserISNULL	String	User.IS_NULL.
VarcharNotEqual	String	VarcharNotEqual.
VarcharEqual	String	VarcharEqual.
VarcharISNOTNULL	String	VarcharISNOTNULL.
VarcharISNULL	String	VarcharISNULL.
VarcharLIKE'$%'	String	VarcharLIKE'$%'
VarcharLIKE'%$'	String	VarcharLIKE'%$'
VarcharLIKE'%$%'	String	VarcharLIKE'%$%'
VarcharNOTLIKE'$%'	String	VarcharNOTLIKE'$%'
VarcharNOTLIKE'%$'	String	VarcharNOTLIKE'%$'
VarcharNOTLIKE'%$%'	String	VarcharNOTLIKE'%$%'
VisibletoNotEqual	String	VisibletoNotEqual.
VisibletoEqual	String	VisibletoEqual.
RottenTime	String	RottenTime.
LastMonth	String	LastMonth.
LastQuarter	String	LastQuarter.
LastWeek	String	LastWeek.
NextMonth	String	NextMonth.
NextWeek	String	NextWeek.
ThisMonth	String	ThisMonth.
ThisQuarter	String	ThisQuarter.
ThisWeek	String	ThisWeek.
OnemonthsAgo	String	OnemonthsAgo.
OneweekAgo	String	OneweekAgo.
TwoMonthsAgo	String	TwoMonthsAgo.
TwoWeeksAgo	String	TwoWeeksAgo.
ThreeMonthsAgo	String	ThreeMonthsAgo.
ThreeWeeksAgo	String	ThreeWeeksAgo.
FourMonthsAgo	String	FourMonthsAgo.
FiveMonthsAgo	String	FiveMonthsAgo.
SixMonthsAgo	String	SixMonthsAgo.
BeforeToday	String	BeforeToday.
BeforeTomorrow	String	BeforeTomorrow.
InOneMonth	String	InOneMonth.
InOneWeek	String	InOneWeek.
InTwoMonths	String	InTwoMonths.
InTwoWeeks	String	InTwoWeeks.
InThreeMonths	String	InThreeMonths.
InThreeWeeks	String	InThreeWeeks.
InFourMonths	String	InFourMonths.
InFiveMonths	String	InFiveMonths.
InSixMonths	String	InSixMonths.
LaterOrToday	String	LaterOrToday.
LaterOrTomorrow	String	LaterOrTomorrow.
Now	String	Now.
Today	String	Today.
Tomorrow	String	Tomorrow.
Yesterday	String	Yesterday.

LeadSources

Returns all Lead Sources.

Select

The Sync App 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 Sync App.

For example, the following query is processed server side:

SELECT * FROM LeadSources

Columns


Name	Type	Description
Name	String	Name.

NoteFields

Returns data about all note fields.

Select

The Sync App 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 Sync App.

For example, the following query is processed server side:

SELECT * FROM NoteFields

Columns


Name	Type	Description
Id	Integer	Id.
ActiveFlag	Boolean	ActiveFlag.
BulkEditAllowed	Boolean	BulkEditAllowed.
EditFlag	Boolean	EditFlag.
FieldType	String	FieldType.
Key	String	Key.
MandatoryFlag	Boolean	MandatoryFlag.
Name	String	Name.
Options	String	Options.

OrganizationsActivities

Get details of organizations activities.

Select

The Sync App 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 Sync App.

Id supports the '=' operator.
Done supports the '=' operator.
Exclude supports the '=,IN' operators.

For example, the following query is processed server side:

SELECT * FROM OrganizationsActivities WHERE Id = 246 
SELECT * FROM OrganizationsActivities WHERE Id = 246 AND done = 0
SELECT * FROM OrganizationsActivities WHERE Id = 246 AND Exclude IN ('240','241')

Columns


Name	Type	Description
Id [KEY]	Integer	Id.
ActiveFlag	Boolean	ActiveFlag.
AddTime	Datetime	AddTime.
AssignedTouserId	Integer	AssignedTouserId.
Attendees	String	Attendees.
BusyFlag	Boolean	BusyFlag.
IncludeContext	String	IncludeContext.
CompanyId	Integer	CompanyId.
MeetingClient	String	MeetingClient.
MeetingId	String	MeetingId.
MeetingUrl	String	MeetingUrl.
CreatedByUserId	Integer	CreatedByUserId.
DealDropboxBcc	String	DealDropboxBcc.
DealId	Integer	DealId.
DealTitle	String	DealTitle.
Done	Boolean	Done.
DueDate	Date	DueDate.
DueTime	Time	DueTime.
Duration	Time	Duration.
FileCleanName	String	FileCleanName.
FileId	String	FileId.
FileUrl	String	FileUrl.
GcaleventId	String	GcaleventId.
GoogleCalendarEtag	String	GoogleCalendarEtag.
GoogleCalendarId	String	GoogleCalendarId.
LastNotificationTime	Datetime	LastNotificationTime.
LastNotificationUserId	Integer	LastNotificationUserId.
LeadId	String	LeadId.
Location	String	Location.
AdminAreaLevel1	String	AdminAreaLevel1.
AdminAreaLevel2	String	AdminAreaLevel2.
Country	String	Country.
FormattedAddress	String	FormattedAddress.
Lat	Double	Lat.
Locality	String	Locality.
Long	Double	Long.
PostalCode	String	PostalCode.
Route	String	Route.
StreetNumber	String	StreetNumber.
Sublocality	String	Sublocality.
Subpremise	String	Subpremise.
MarkedAsDoneTime	Datetime	MarkedAsDoneTime.
Note	String	Note.
NotificationLanguageId	Integer	NotificationLanguageId.
OrgId	Integer	OrgId.
OrgName	String	OrgName.
OwnerName	String	OwnerName.
Participants	String	Participants.
PersonDropboxBcc	String	PersonDropboxBcc.
PersonId	Integer	PersonId.
PersonName	String	PersonName.
PublicDescription	String	PublicDescription.
MasterActivityId	String	MasterActivityId.
Rule	String	Rule.
RuleExtension	String	RuleExtension.
ReferenceId	Integer	ReferenceId.
ReferenceType	String	ReferenceType.
Series	String	Series.
SourceTimezone	String	SourceTimezone.
Subject	String	Subject.
Type	String	Type.
UpdateTime	Datetime	UpdateTime.
UpdateUserId	Integer	UpdateUserId.
UserId	Integer	UserId.

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
Exclude	String	A comma-separated string of activity IDs to exclude from result.

OrganizationsDeals

Get details of organization deals.

Select

The Sync App 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 Sync App.

Id supports the '=' operator.
Status supports the '=' operator.
OnlyPrimaryAssociation supports the '=,IN' operators.

For example, the following query is processed server side:

SELECT * FROM OrganizationsDeals WHERE Id = 246 
SELECT * FROM OrganizationsDeals WHERE Id = 246 AND Status = 'open'
SELECT * FROM OrganizationsDeals WHERE Id = 246 AND OnlyPrimaryAssociation = 1

Columns


Name	Type	Description
Id [KEY]	Integer	Id.
Active	Boolean	Active.
ActivitiesCount	Integer	ActivitiesCount.
AddTime	Datetime	AddTime.
CcEmail	String	CcEmail.
CloseTime	String	CloseTime.
CreatoractiveFlag	Boolean	CreatoractiveFlag.
Creatoremail	String	Creatoremail.
CreatorhasPic	Boolean	CreatorhasPic.
Creatorid	Integer	Creatorid.
Creatorname	String	Creatorname.
CreatorPicHash	String	CreatorPicHash.
Creatorvalue	Integer	Creatorvalue.
Currency	String	Currency.
Deleted	Boolean	Deleted.
DoneActivitiesCount	Integer	DoneActivitiesCount.
EmailMessagesCount	Integer	EmailMessagesCount.
ExpectedCloseDate	Date	ExpectedCloseDate.
FilesCount	Integer	FilesCount.
FirstWonTime	Datetime	FirstWonTime.
FollowersCount	Integer	FollowersCount.
FormattedValue	String	FormattedValue.
FormattedWeightedValue	String	FormattedWeightedValue.
Label	String	Label.
LastActivityDate	String	LastActivityDate.
LastActivityId	String	LastActivityId.
LastIncomingMailTime	Datetime	LastIncomingMailTime.
LastOutgoingMailTime	Datetime	LastOutgoingMailTime.
LostReason	String	LostReason.
LostTime	String	LostTime.
NextActivityDate	Date	NextActivityDate.
NextActivityDuration	Time	NextActivityDuration.
NextActivityId	Integer	NextActivityId.
NextActivitynote	String	NextActivitynote.
NextActivitysubject	String	NextActivitysubject.
NextActivitytime	Time	NextActivitytime.
NextActivitytype	String	NextActivitytype.
NotesCount	Integer	NotesCount.
OrgHidden	Boolean	OrgHidden.
OrgActive_flag	Boolean	OrgActive_flag.
OrgAddress	String	OrgAddress.
OrgCcEmail	String	OrgCcEmail.
OrgName	String	OrgName.
OrgOwnerId	Integer	OrgOwnerId.
OrgPeopleCount	Integer	OrgPeopleCount.
OrgId	Integer	OrgValue.
OwnerName	String	OwnerName.
ParticipantsCount	Integer	ParticipantsCount.
PersonHidden	Boolean	PersonHidden.
PersonActiveFlag	Boolean	PersonActiveFlag.
PersonEmail	String	PersonEmail.
PersonName	String	PersonName.
PersonPhone	String	PersonPhone.
PersonValue	Integer	PersonValue.
PipelineId	Integer	PipelineId.
Probability	String	Probability.
ProductsCount	Integer	ProductsCount.
RottenTime	String	RottenTime.
StageChangeTime	Datetime	StageChangeTime.
StageId	Integer	StageId.
StageOrderNr	Integer	StageOrderNr.
Status	String	Only fetch deals with specific status.. The allowed values are open, won, lost, deleted, all_not_deleted.
Title	String	Title.
UndoneActivitiesCount	Integer	UndoneActivitiesCount.
UpdateTime	Datetime	UpdateTime.
UserActiveFlag	Boolean	UserActiveFlag.
UserEmail	String	UserEmail.
UserHasPic	Boolean	UserHasPic.
UserId	Integer	UserId.
UserName	String	UserName.
UserPicHash	String	UserPicHash.
UserValue	Integer	UserValue.
Value	Integer	Value.
VisibleTo	String	VisibleTo.
WeightedValue	Integer	WeightedValue.
WeightedValueCurrency	String	WeightedValueCurrency.
WonTime	Datetime	WonTime.

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
OnlyPrimaryAssociation	Integer	If set, only deals that are directly associated to the organization are fetched. The allowed values are 0, 1.

OrganizationsDealsPersonEmail

get details of deals person email.

Select

The Sync App 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 Sync App.

Id supports the '=' operator.
Status supports the '=' operator.
OnlyPrimaryAssociation supports the '=,IN' operators.

For example, the following query is processed server side:

SELECT * FROM OrganizationsDealsPersonEmail WHERE Id = 246
SELECT * FROM OrganizationsDealsPersonEmail WHERE Id = 246 AND Status = 'open'
SELECT * FROM OrganizationsDealsPersonEmail WHERE Id = 246 AND OnlyPrimaryAssociation = 1

Columns


Name	Type	Description
Id [KEY]	Integer	Org Id.
Label	String	Label.
Primary	Boolean	Primary.
Value	String	Value.

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
Status	String	Only fetch deals with specific status. The allowed values are open, won, lost, deleted, all_not_deleted. The default value is all_not_deleted.
OnlyPrimaryAssociation	Integer	If set, only deals that are directly associated to the organization are fetched. The allowed values are 0, 1.

OrganizationsDealsPersonphone

get details of deals person phone.

Select

The Sync App 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 Sync App.

Id supports the '=' operator.
Status supports the '=' operator.
OnlyPrimaryAssociation supports the '=,IN' operators.

For example, the following query is processed server side:

SELECT * FROM OrganizationsDealsPersonphone WHERE Id = 246 
SELECT * FROM OrganizationsDealsPersonphone WHERE Id = 246 AND Status = open
SELECT * FROM OrganizationsDealsPersonphone WHERE Id = 246 AND OnlyPrimaryAssociation = 1

Columns


Name	Type	Description
Id [KEY]	Integer	Org Id.
Label	String	Label.
Primary	Boolean	Primary.
Value	String	Value.

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
Status	String	Only fetch deals with specific status. The allowed values are open, won, lost, deleted, all_not_deleted. The default value is all_not_deleted.
OnlyPrimaryAssociation	Integer	If set, only deals that are directly associated to the organization are fetched The allowed values are 0, 1.

OrganizationsFiles

Get details of deals file.

Select

The Sync App 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 Sync App.

OrgId supports the '=' operator.
IncludeDeletedFiles supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM OrganizationsFiles WHERE OrgId = 6 

SELECT * FROM OrganizationsFiles WHERE OrgId = 6 AND IncludeDeletedFiles = 0

Columns


Name	Type	Description
Id [KEY]	Integer	ID of the organizations.
ActiveFlag	Boolean	Active Flag.
ActivityId	String	Activity Id.
AddTime	Datetime	AddTime.
Cid	String	Cid.
DealId	String	Deal Id.
DealName	String	DealName.
Description	String	Description.
FileName	String	File Name.
FileSize	Integer	File Size.
FileType	String	File Type.
InlineFlag	Boolean	Inline Flag.
LogId	String	Log Id.
MailMessageId	String	MailMessage Id.
MailTemplateId	String	MailTemplate Id.
Name	String	Name.
OrgId	Integer	Org Id.
OrgName	String	Org Name.
PeopleName	String	People Name.
PersonId	String	PersonId.
PersonName	String	Person Name.
ProductId	String	Produc tId.
ProductName	String	Product Name.
RemoteId	String	Remote Id.
RemoteLocation	String	Remote Location.
S3Bucket	String	S3Bucket.
UpdateTime	Datetime	Update Time.
Url	String	Url.
UserId	Integer	UserId.

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
IncludeDeletedFiles	Integer	When enabled, the list of files will also include deleted files. The allowed values are 0, 1.

OrganizationsMailMessages

Get details of organizations mail Messages.

Select

The Sync App 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 Sync App.

OrgId supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM OrganizationsMailMessages WHERE OrgId = 246

Columns


Name	Type	Description
Id [KEY]	Integer	Org id.
OrgId	Integer	Activities ID.
AccountId	String	AccountId.
AddTime	Datetime	addTime.
Bcc	String	Bcc.
BodyUrl	String	bodyUrl.
Cc	String	cc.
CompanyId	Integer	companyId.
DeletedFlag	Boolean	DeletedFlag.
Draft	String	Draft.
DraftFlag	Boolean	DraftFlag.
ExternalDeletedFlag	Boolean	External DeletedFlag.
From	String	From.
AttachmentsFlag	Boolean	AttachmentsFlag.
BodyFlag	Boolean	BodyFlag.
InlineAttachmentsFlag	Boolean	InlineAttachmentsFlag.
RealAttachmentsFlag	Boolean	RealAttachmentsFlag.
ItemType	String	ItemType.
TrackingEnabledFlag	Boolean	TrackingEnabledFlag.
ThreadId	Integer	ThreadId.
TrackingStatus	String	TrackingStatus.
MessageTime	String	MessageTime.
MessageId	String	MessageId.
NylasId	String	NylasId.
ReadFlag	Boolean	ReadFlag.
S3Bucket	String	S3Bucket.
S3BucketPath	String	S3BucketPath.
SentFlag	Boolean	SentFlag.
SentFromPipedriveFlag	Boolean	SentFromPipedriveFlag.
SmartBccFlag	Boolean	SmartBccFlag.
Snippet	String	Snippet.
Subject	String	Subject.
SyncedFlag	Boolean	SyncedFlag.
TemplateId	String	TemplateId.
Timestamp	Datetime	Timestamp.
To	String	To.
UpdateTime	Datetime	UpdateTime.
UserId	Integer	UserId.
WriteFlag	Boolean	writeFlag.
Object	String	Object.

OrganizationsMailMessagesBcc

Get details of organizations mail Messages.

Select

The Sync App 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 Sync App.

OrgId supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM OrganizationsMailMessagesBcc WHERE OrgId = 246

Columns


Name	Type	Description
Id [KEY]	Integer	id.
OrgId	Integer	Org Id.
EmailAddress	String	EmailAddress.
PersonId	Integer	PersonId.
PersonName	String	PersonName.
MessagePartyId	Integer	MessagePartyId.
Name	String	Name.

OrganizationsMailMessagesCc

Get details of organizations mail Messages.

Select

The Sync App 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 Sync App.

OrgId supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM OrganizationsMailMessagesCc WHERE OrgId = 246

Columns


Name	Type	Description
Id [KEY]	Integer	Id.
OrgId	Integer	Org Id.
EmailAddress	String	EmailAddress.
PersonId	String	PersonId.
PersonName	String	PersonName.
MessagePartyId	Integer	MessagePartyId.
Name	String	Name.

OrganizationsMailMessagesFrom

Get details of organizations mail Messages.

Select

The Sync App 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 Sync App.

OrgId supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM OrganizationsMailMessagesFrom WHERE OrgId = 246

Columns


Name	Type	Description
Id [KEY]	Integer	Id.
OrgId	Integer	Org Id.
EmailAddress	String	EmailAddress.
PersonId	String	PersonId.
PersonName	String	PersonName.
MessagePartyId	Integer	MessagePartyId.
Name	String	Name.

OrganizationsMailMessagesTo

Get details of organizations mail Messages.

Select

The Sync App 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 Sync App.

OrgId supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM OrganizationsMailMessagesTo WHERE OrgId = 246

Columns


Name	Type	Description
Id [KEY]	Integer	Id.
OrgId	Integer	Org Id.
EmailAddress	String	EmailAddress.
PersonId	String	PersonId.
PersonName	String	PersonName.
MessagePartyId	Integer	MessagePartyId.
Name	String	Name.

OrganizationsPermittedUsers

Get details of permitted users of organizations.

Select

The Sync App 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 Sync App.

Id supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM OrganizationsPermittedUsers WHERE Id = 10

Columns


Name	Type	Description
Id	Integer	Id.
Orgid	Integer	Org Id.
AddTime	Datetime	Add Time.
UserId	Integer	UserId.

OrganizationsPersons

Get details of organizations persons

Select

The Sync App 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 Sync App.

OrgId supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM OrganizationsPersons WHERE OrgId = 10

Columns


Name	Type	Description
Id [KEY]	Integer	Id
ActivitiesCount	Integer	ActivitiesCount
ActiveFlag	Boolean	ActiveFlag
AddTime	Datetime	AddTime
CcEmail	String	CcEmail
ClosedDealsCount	Integer	ClosedDealsCount
CompanyId	Integer	CompanyId
DoneActivitiesCount	Integer	DoneActivitiesCount
Email	String	Email
EmailMessagesCount	Integer	EmailMessagesCount
FilesCount	Integer	FilesCount
Label	Integer	label
LastActivityDate	Date	LastActivityDate
LastActivityId	Integer	LastActivityId
LastincomingMailTime	String	LastincomingMailTime
Lastname	String	Lastname
LastoutgoingMailTime	String	LastoutgoingMailTime
LostdealsCount	Integer	LostdealsCount
Name	String	Name
NextActivityDate	Date	nextActivityDate
NextActivityId	Integer	nextActivityId
NextActivityTime	String	nextActivityTime
NotesCount	Integer	NotesCount
OpenDealsCount	Integer	OpenDealsCount
OrgActiveFlag	Boolean	OrgActiveFlag
OrgAddress	String	OrgAddress
OrgCcEmail	String	OrgCcEmail
OrgName	String	OrgName
OrgownerId	Integer	OrgownerId
OrgpeopleCount	Integer	OrgpeopleCount
OrgId	Integer	OrgId
OwnerActiveFlag	Boolean	OwnerActiveFlag
OwnerEmail	String	OwnerEmail
OwnerHasPic	Boolean	OwnerHasPic
OwnerId	Integer	OwnerId
OwnerName	String	OwnerName
OwnerPicHash	String	OwnerPicHash
OwnerValue	Integer	OwnerValue
ParticipantClosedDealsCount	Integer	ParticipantClosedDealsCount
ParticipantOpenDealsCount	Integer	ParticipantOpenDealsCount
Phone	String	Phone
PictureActiveFlag	Boolean	PictureActiveFlag
PictureaddTime	Datetime	PictureaddTime
PictureaddedByUserId	Integer	PictureaddedByUserId
PictureItemId	Integer	PictureItemId
PictureitemType	String	PictureitemType
Picture128	String	Picture128
Picture512	String	Picture512
PictureupdateTime	String	PictureupdateTime
Picturevalue	Integer	Picturevalue
PictureId	String	PictureId
RelatedclosedDealsCount	Integer	RelatedclosedDealsCount
RelatedlostDealsCount	Integer	RelatedlostDealsCount
RelatedopenDealsCount	Integer	RelatedopenDealsCount
RelatedwonDealsCount	Integer	RelatedwonDealsCount
UndoneActivitiesCount	Integer	UndoneActivitiesCount
UpdateTime	Datetime	UpdateTime
VisibleTo	String	visibleTo
WonDealsCount	Integer	WonDealsCount

OrganizationsUpdates

Get details of organizations updates..

Select

The Sync App 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 Sync App.

OrgId supports the '=' operator.
AllChanges supports the '=' operator.
Items supports the '=,IN' operators.

For example, the following query is processed server side:

SELECT * FROM OrganizationsUpdates WHERE OrgId = 246 

SELECT * FROM OrganizationsUpdates WHERE OrgId = 10 AND AllChanges = 1

SELECT * FROM OrganizationsUpdates WHERE OrgId = 10 AND Items IN ('activity','plannedActivity')

Columns


Name	Type	Description
Id [KEY]	Integer	Id.
ActiveFlag	Boolean	ActiveFlag.
ActivityId	String	ActivityId.
AddTime	Datetime	AddTime.
NewValueFormatted	String	NewValueFormatted.
OldValueFormatted	String	OldValueFormatted.
AssignedToUserId	Integer	AssignedToUserId.
Attendees	String	Attendees.
BusyFlag	Boolean	BusyFlag.
IncludeContext	String	IncludeContext.
ChangeSource	String	ChangeSource.
User_agent	String	User_agent.
Cid	String	Cid.
CompanyId	Integer	CompanyId.
ConferenceMeetingClient	String	ConferenceMeetingClient.
ConferenceMeetingId	String	ConferenceMeetingId.
ConferenceMeetingUrl	String	ConferenceMeetingUrl.
CreatedByUserId	Integer	CreatedByUserId.
DealDropboxBcc	String	DealDropboxBcc.
DealId	Integer	DealId.
DealName	String	DealName.
DealTitle	String	DealTitle.
Description	String	Description.
Done	Boolean	Done.
DueDate	Date	DueDate.
DueTime	Time	DueTime.
Duration	Time	Duration.
FieldKey	String	FieldKey.
FileCleanName	String	FileCleanName.
FileId	String	FileId.
FileUrl	String	FileUrl.
FileName	String	FileName.
FileSize	Integer	FileSize.
FileType	String	FileType.
GcalEventId	String	GcalEventId.
GoogleCalendarEtag	String	GoogleCalendarEtag.
GoogleCalendarId	String	GoogleCalendarId.
InlineFlag	Boolean	InlineFlag.
IsBulkUpdateFlag	String	IsBulkUpdateFlag.
ItemId	Integer	ItemId.
LastNotificationTime	Datetime	LastNotificationTime.
LastNotificationUserId	Integer	LastNotificationUserId.
LeadId	String	LeadId.
Location	String	Location.
AdminAreaLevel1	String	AdminAreaLevel1.
AdminAreaLevel2	String	AdminAreaLevel2.
Country	String	Country.
FormattedAddress	String	FormattedAddress.
Lat	Double	Lat.
Locality	String	Locality.
Long	Double	Long.
PostalCode	String	PostalCode.
Route	String	Route.
StreetNumber	String	StreetNumber.
Sublocality	String	Sublocality.
Subpremise	String	Subpremise.
LogId	String	LogId.
LogTime	Datetime	LogTime.
MessageId	String	MessageId.
TemplateId	String	TemplateId.
MarkedAsDoneTime	Datetime	MarkedAsDoneTime.
Name	String	Name.
NewValue	String	NewValue.
Note	String	Note.
NotificationLanguageId	Integer	NotificationLanguageId.
OldValue	Integer	OldValue.
OrgId	Integer	OrgId.
OrgName	String	OrgName.
OwnerName	String	OwnerName.
Participants	String	Participants.
PeopleName	String	PeopleName.
PersonDropboxBcc	String	PersonDropboxBcc.
PersonId	Integer	PersonId.
PersonName	String	PersonName.
ProductId	String	ProductId.
ProductName	String	ProductName.
PublicDescription	String	PublicDescription.
RecActivityId	String	RecActivityId.
RecRule	String	RecRule.
RecRuleExtension	String	RecRuleExtension.
ReferenceId	Integer	ReferenceId.
ReferenceType	String	ReferenceType.
RemoteId	String	RemoteId.
RemoteLocation	String	RemoteLocation.
S3Bucket	String	S3Bucket.
Series	String	Series.
Sourcetimezone	String	Sourcetimezone.
Subject	String	Subject.
Type	String	Type.
UpdateTime	Datetime	UpdateTime.
UpdateUserId	Integer	UpdateUserId.
Url	String	Url.
UserId	Integer	UserId.
Object	String	Object.
Timestamp	Datetime	Timestamp.

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
AllChanges	String	Whether to show custom field updates or not. The allowed values are 1.
Items	String	item specific updates. The allowed values are activity, plannedActivity, note, file, change, deal, follower, participant, mailMessage, mailMessageWithAttachment, invoice, activityFile, document.

OrganizationsUpdatesAttendees

Get details of all attendees of organizations.

Select

The Sync App 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 Sync App.

OrgId supports the '=' operator.
AllChanges supports the '=' operator.
Items supports the '=,IN' operators.

For example, the following query is processed server side:

SELECT * FROM OrganizationsUpdatesAttendees WHERE OrgId = 246 

SELECT * FROM OrganizationsUpdatesAttendees WHERE OrgId = 10 AND AllChanges = 1

SELECT * FROM OrganizationsUpdatesAttendees WHERE OrgId = 10 AND Items IN ('activity','plannedActivity')

Columns


Name	Type	Description
OrgId [KEY]	Integer	Activities ID.
EmailAddress	String	EmailAddress.
IsOrganizer	Boolean	IsOrganizer.
Name	String	Name.
PersonId	Integer	PersonId.
Status	String	Status.
UserId	String	UserId.

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
AllChanges	String	Whether to show custom field updates or not. The allowed values are 1.
Items	String	item specific updates. The allowed values are activity, plannedActivity, note, file, change, deal, follower, participant, mailMessage, mailMessageWithAttachment, invoice, activityFile, document.

OrganizationsUpdatesParticipants

Getdetails of activities participants.

Select

The Sync App 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 Sync App.

OrgId supports the '=' operator.
AllChanges supports the '=' operator.
Items supports the '=,IN' operators.

For example, the following query is processed server side:

SELECT * FROM OrganizationsUpdatesParticipants WHERE OrgId = 246 

SELECT * FROM OrganizationsUpdatesParticipants WHERE OrgId = 10 AND AllChanges = 1

SELECT * FROM OrganizationsUpdatesParticipants WHERE OrgId = 10 AND Items IN ('activity','plannedActivity')

Columns


Name	Type	Description
OrgId [KEY]	Integer	Activities ID.
PersonId	Integer	PersonId.
PrimaryFlag	Boolean	PrimaryFlag.

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
AllChanges	String	Whether to show custom field updates or not. The allowed values are 1.
Items	String	item specific updates. The allowed values are activity, plannedActivity, note, file, change, deal, follower, participant, mailMessage, mailMessageWithAttachment, invoice, activityFile, document.

PermissionSets

Get all permissions.

Select

The Sync App 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 Sync App.

Id supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM PermissionSets WHERE Id = 'a3d3f720-154f-11ec-905b-d96b2abf3c60'

Columns


Name	Type	Description
Id	String	ID of the permission set.
AssignmentCount	Integer	AssignmentCount.
Name	String	Name.
Type	String	Type.
OldId	Integer	OldId.

PermissionSetsAssignments

.

Columns


Name	Type	Description
Name	String	Name.
PermissionSetId	String	PermissionSetId.
PermissionSetIdOld	Integer	PermissionSetIdOld.
UserId	Integer	UserId.
Id	String	ID of the permission set.

PersonsActivities

Get all Persons Activities assigned to a particular Persons.

Select

The Sync App 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 Sync App.

PersonId supports the '=' operator.
Done supports the '=' operator.
Exclude supports the '=,IN' operators.

For example, the following query is processed server side:

SELECT * FROM PersonsActivities WHERE PersonId = 113 

SELECT * FROM PersonsActivities WHERE PersonId = 113 AND Done = 0

SELECT * FROM PersonsActivities WHERE PersonId = 113 AND Exclude IN ('240','241')

Columns


Name	Type	Description
Id [KEY]	Integer	Id.
ActiveFlag	Boolean	Active Flag.
AddTtime	Datetime	Add Ttime.
AssignedToUserId	Integer	Assigned To UserId.
Attendees	String	Attendees.
BusyFlag	Boolean	BusyFlag.
IncludeContext	String	Include Context.
CompanyId	Integer	Company Id.
MeetingClient	String	Meeting Client.
MeetingId	String	Meeting Id.
MeetingUrl	String	Meeting Url.
CreatedByUserId	Integer	CreatedBy UserId.
DealDropboxBcc	String	Deal Dropbox Bcc.
DealId	Integer	Deal Id.
DealTitle	String	Deal Title.
Done	Boolean	Whether the activity is done or not 0 = Not done, 1 = Done If omitted returns both Done and Not done activities. The allowed values are 0, 1.
DueDate	Date	Due Date.
DueTime	Time	Due Time.
Duration	Time	Duration.
FileCleanName	String	FileCleanName.
FileId	String	FileId.
FileUrl	String	FileUrl.
EventId	String	eventId.
CalendarEtag	String	CalendarEtag.
CalendarId	String	Calendar Id.
NotificationTime	Datetime	Notification Time.
NotificationUserId	Integer	Notification UserId.
LeadId	String	Lead Id.
Location	String	Location.
AreaLevel1	String	AreaLevel1.
AreaLevel2	String	AreaLevel2.
Country	String	Country.
FormattedAddress	String	FormattedAddress.
Lat	Double	Lat.
Locality	String	Locality.
Long	Double	Long.
PostalCode	String	PostalCode.
Route	String	Route.
StreetNumber	String	StreetNumber.
Sublocality	String	Sublocality.
Subpremise	String	Subpremise.
MarkedAsDoneTime	Datetime	MarkedAsDoneTime.
Note	String	Note.
NotificationLanguageId	Integer	NotificationLanguageId.
OrgId	Integer	OrgId.
OrgName	String	OrgName.
OwnerName	String	OwnerName.
Participants	String	Participants.
PersonDropboxBcc	String	Person Dropbox Bcc.
PersonId	Integer	PersonId.
PersonName	String	PersonName.
PublicDescription	String	PublicDescription.
MasterActivityId	String	MasterActivityId.
Rule	String	Rule.
RuleExtension	String	RuleExtension.
ReferenceId	Integer	ReferenceId.
ReferenceType	String	ReferenceType.
Series	String	Series.
SourceTimezone	String	SourceTimezone.
Subject	String	Subject.
Type	String	Type.
UpdateTime	Datetime	UpdateTime..
UpdateUserId	Integer	UpdateUserId..
UserId	Integer	UserId..

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
Exclude	String	A comma-separated string of activity IDs to exclude from result..

PersonsActivitiesAttendees

Get Details of Persons Activities Attendees.

Select

The Sync App 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 Sync App.

PersonId supports the '=' operator.
Done supports the '=' operator.
Exclude supports the '=,IN' operators.

For example, the following query is processed server side:

SELECT * FROM PersonsActivitiesAttendees WHERE PersonId = 113 

SELECT * FROM PersonsActivitiesAttendees WHERE PersonId = 113 AND Done = 0

SELECT * FROM PersonsActivitiesAttendees WHERE PersonId = 113 AND Exclude IN ('240','241')

Columns


Name	Type	Description
PersonId [KEY]	Integer	PersonId.
EmailAddress	String	EmailAddress.
IsOrganizer	Integer	IsOrganizer.
Name	String	Name.
Status	String	Status.
UserId	String	UserId.

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
Done	Boolean	Whether the activity is done or not 0 = Not done, 1 = Done If omitted returns both Done and Not done activities. The allowed values are 0, 1.
Exclude	String	A comma-separated string of activity IDs to exclude from result.

PersonsActivitiesParticipants

Get details of Persons activities participants.

Select

The Sync App 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 Sync App.

PersonId supports the '=' operator.
Done supports the '=' operator.
Exclude supports the '=,IN' operators.

For example, the following query is processed server side:

SELECT * FROM PersonsActivitiesParticipants WHERE PersonId = 113 

SELECT * FROM PersonsActivitiesParticipants WHERE PersonId = 113 AND Done = 0

SELECT * FROM PersonsActivitiesParticipants WHERE PersonId = 113 AND Exclude IN ('240','241')

Columns


Name	Type	Description
PersonId [KEY]	Integer	PersonId.
PrimaryFlag	Boolean	PrimaryFlag.

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
Done	Boolean	Whether the activity is done or not 0 = Not done, 1 = Done If omitted returns both Done and Not done activities. The allowed values are 0, 1.
Exclude	String	A comma-separated string of activity IDs to exclude from result.

PersonsDeals

Get details of Persons deals.

Select

The Sync App 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 Sync App.

Id supports the '=' operator.
Status supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM PersonsDeals WHERE Id = 246

SELECT * FROM PersonsDeals WHERE Id = 246 AND Status = 'open'

Columns


Name	Type	Description
Id [KEY]	Integer	Id.
Active	Boolean	Active.
ActivitiesCount	Integer	ActivitiesCount.
AddTime	Datetime	AddTime.
CcEmail	String	CcEmail.
CloseTime	String	CloseTime.
CreatoractiveFlag	Boolean	CreatoractiveFlag.
Creatoremail	String	Creatoremail.
CreatorhasPic	Boolean	CreatorhasPic.
Creatorid	Integer	Creatorid.
Creatorname	String	Creatorname.
CreatorPicHash	String	CreatorPicHash.
Creatorvalue	Integer	Creatorvalue.
Currency	String	Currency.
Deleted	Boolean	Deleted.
DoneActivitiesCount	Integer	DoneActivitiesCount.
EmailMessagesCount	Integer	EmailMessagesCount.
ExpectedCloseDate	Date	ExpectedCloseDate.
FilesCount	Integer	FilesCount.
FirstWonTime	Datetime	FirstWonTime.
FollowersCount	Integer	FollowersCount.
FormattedValue	String	FormattedValue.
FormattedWeightedValue	String	FormattedWeightedValue.
Label	String	Label.
LastActivityDate	String	LastActivityDate.
LastActivityId	String	LastActivityId.
LastIncomingMailTime	Datetime	LastIncomingMailTime.
LastOutgoingMailTime	Datetime	LastOutgoingMailTime.
LostReason	String	LostReason.
LostTime	String	LostTime.
NextActivityDate	Date	NextActivityDate.
NextActivityDuration	Time	NextActivityDuration.
NextActivityId	Integer	NextActivityId.
NextActivitynote	String	NextActivitynote.
NextActivitysubject	String	NextActivitysubject.
NextActivitytime	Time	NextActivitytime.
NextActivitytype	String	NextActivitytype.
NotesCount	Integer	NotesCount.
OrgHidden	Boolean	OrgHidden.
OrgActive_flag	Boolean	OrgActive_flag.
OrgAddress	String	OrgAddress.
OrgCcEmail	String	OrgCcEmail.
OrgName	String	OrgName.
OrgOwnerId	Integer	OrgOwnerId.
OrgPeopleCount	Integer	OrgPeopleCount.
OrgValue	Integer	OrgValue.
OwnerName	String	OwnerName.
ParticipantsCount	Integer	ParticipantsCount.
PersonHidden	Boolean	PersonHidden.
PersonActiveFlag	Boolean	PersonActiveFlag.
PersonEmail	String	PersonEmail.
PersonName	String	PersonName.
PersonPhone	String	PersonPhone.
PersonValue	Integer	PersonValue.
PipelineId	Integer	PipelineId.
Probability	String	Probability.
ProductsCount	Integer	ProductsCount.
RottenTime	String	RottenTime.
StageChangeTime	Datetime	StageChangeTime.
StageId	Integer	StageId.
StageOrderNr	Integer	StageOrderNr.
Status	String	Only fetch deals with specific status. The allowed values are open, won, lost, deleted, all_not_deleted. The default value is all_not_deleted.
Title	String	Title.
UndoneActivitiesCount	Integer	UndoneActivitiesCount.
UpdateTime	Datetime	UpdateTime.
UserActiveFlag	Boolean	UserActiveFlag.
UserEmail	String	UserEmail.
UserHasPic	Boolean	UserHasPic.
UserId	Integer	UserId.
UserName	String	UserName.
UserPicHash	String	UserPicHash.
UserValue	Integer	UserValue.
Value	Integer	Value.
VisibleTo	String	VisibleTo.
WeightedValue	Integer	WeightedValue.
WeightedValueCurrency	String	WeightedValueCurrency.
WonTime	Datetime	WonTime.

PersonsEmails

Get all emails asscociated with persons.

Columns


Name	Type	Description
Id [KEY]	Integer	Persons Id.
label	String	Label.
Value	String	Value.
Primary	Boolean	Primary.

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
FirstChar	String	If supplied, only persons whose name starts with the specified letter will be returned.
FilterId	Integer	Filter Id.
UserId	Integer	User Id.

PersonsFiles

Get details of Persons file.

Select

The Sync App 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 Sync App.

PersonId supports the '=' operator.
IncludeDeletedFiles supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM PersonsFiles WHERE PersonId = 6 

SELECT * FROM PersonsFiles WHERE PersonId = 6 AND IncludeDeletedFiles = 0

Columns


Name	Type	Description
Id [KEY]	Integer	Id of the files.
ActiveFlag	Boolean	Active Flag.
ActivityId	String	Activity Id.
AddTime	Datetime	AddTime.
Cid	String	Cid.
DealId	String	Deal Id.
DealName	String	DealName.
Description	String	Description.
FileName	String	File Name.
FileSize	Integer	File Size.
FileType	String	File Type.
InlineFlag	Boolean	Inline Flag.
LogId	String	Log Id.
MailMessageId	String	MailMessage Id.
MailTemplateId	String	MailTemplate Id.
Name	String	Name.
OrgId	Integer	Org Id.
OrgName	String	Org Name.
PeopleName	String	People Name.
PersonId	String	PersonId.
PersonName	String	Person Name.
ProductId	String	Produc tId.
ProductName	String	Product Name.
RemoteId	String	Remote Id.
RemoteLocation	String	Remote Location.
S3Bucket	String	S3Bucket.
UpdateTime	Datetime	Update Time.
Url	String	Url.
UserId	Integer	UserId.

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
IncludeDeletedFiles	Integer	When enabled, the list of files will also include deleted files. The allowed values are 0, 1.

PersonsMailMessages

Get details of organizations mail Messages.

Select

The Sync App 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 Sync App.

PersonId supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM PersonsMailMessages WHERE PersonId = 246

Columns


Name	Type	Description
Id [KEY]	Integer	Id.
PersonId	Integer	Persons Id.
AccountId	String	AccountId.
AddTime	Datetime	addTime.
Bcc	String	Bcc.
BodyUrl	String	bodyUrl.
Cc	String	cc.
CompanyId	Integer	companyId.
DeletedFlag	Boolean	DeletedFlag.
Draft	String	Draft.
DraftFlag	Boolean	DraftFlag.
ExternalDeletedFlag	Boolean	ExternalDeletedFlag.
From	String	From.
AttachmentsFlag	Boolean	AttachmentsFlag.
BodyFlag	Boolean	BodyFlag.
InlineAttachmentsFlag	Boolean	InlineAttachmentsFlag.
RealAttachmentsFlag	Boolean	RealAttachmentsFlag.
ItemType	String	ItemType.
TrackingEnabledFlag	Boolean	TrackingEnabledFlag.
ThreadId	Integer	ThreadId.
TrackingStatus	String	TrackingStatus.
MessageTime	String	MessageTime.
MessageId	String	MessageId.
NylasId	String	NylasId.
ReadFlag	Boolean	ReadFlag.
S3Bucket	String	S3Bucket.
S3BucketPath	String	S3BucketPath.
SentFlag	Boolean	SentFlag.
SentFromPipedriveFlag	Boolean	SentFromPipedriveFlag.
SmartBccFlag	Boolean	SmartBccFlag.
Snippet	String	Snippet.
Subject	String	Subject.
SyncedFlag	Boolean	SyncedFlag.
TemplateId	String	TemplateId.
Timestamp	Datetime	Timestamp.
To	String	To.
UpdateTime	Datetime	UpdateTime.
UserId	Integer	UserId.
WriteFlag	Boolean	writeFlag.
Object	String	Object.

PersonsMailMessagesBcc

Get details of Persons mail Messages.

Select

The Sync App 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 Sync App.

PersonId supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM PersonsMailMessagesBcc WHERE PersonId = 246

Columns


Name	Type	Description
Id [KEY]	Integer	Id.
EmailAddress	String	EmailAddress.
PersonId	String	PersonId.
PersonName	String	PersonName.
MessagePartyId	Integer	MessagePartyId.
Name	String	Name.

PersonsMailMessagesCc

Get details of persons mail Messages.

Select

The Sync App 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 Sync App.

PersonId supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM PersonsMailMessagesCc WHERE PersonId = 246

Columns


Name	Type	Description
Id [KEY]	Integer	Id.
EmailAddress	String	EmailAddress.
PersonId	String	PersonId.
PersonName	String	PersonName.
MessagePartyId	Integer	MessagePartyId.
Name	String	Name.

PersonsMailMessagesFrom

Get details of persons mail Messages.

Select

The Sync App 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 Sync App.

PersonId supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM PersonsMailMessagesFrom WHERE PersonId = 246

Columns


Name	Type	Description
Id [KEY]	Integer	Id.
EmailAddress	String	EmailAddress.
PersonId	String	PersonId.
PersonName	String	PersonName.
MessagePartyId	Integer	MessagePartyId.
Name	String	Name.

PersonsMailMessagesTo

Get details of Persons mail Messages.

Select

The Sync App 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 Sync App.

PersonId supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM PersonsMailMessagesTo WHERE PersonId = 246

Columns


Name	Type	Description
Id [KEY]	Integer	Id.
EmailAddress	String	EmailAddress.
PersonId	String	PersonId.
PersonName	String	PersonName.
MessagePartyId	Integer	MessagePartyId.
Name	String	Name.

PersonsPhone

Get all phone asscociated with persons.

Select

The Sync App 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 Sync App.

Id supports the '=' operator.
Email supports the 'LIKE' operator.
Name supports the 'LIKE' operator.
FirstChar supports the 'LIKE' operator.
Phone supports the 'LIKE' operator.
FilterId supports the '=' operator.
UserId supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM PersonsPhone WHERE Id = 14

SELECT * FROM PersonsPhone WHERE Name LIKE '%Cdata%'

SELECT * FROM PersonsPhone WHERE Phone LIKE '%9876%'

SELECT * FROM PersonsPhone WHERE FirstChar = 'c'

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

Columns


Name	Type	Description
Id [KEY]	Integer	Persons ID.
label	String	Label.
Value	String	Value.
Primary	Boolean	Primary.

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
FirstChar	String	If supplied, only persons whose name starts with the specified letter will be returned.
FilterId	Integer	Filter Id.
UserId	Integer	User Id.

PersonsProducts

Get details of Persons Products.

Select

The Sync App 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 Sync App.

DealPersonId supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM PersonsProducts WHERE DealPersonId = 113

Columns


Name	Type	Description
ProductId [KEY]	Integer	ProductId.
DealActive	Boolean	DealActive.
DealActivitiesCount	Integer	DealActivitiesCount.
DealAddTime	Datetime	DealAddTime.
DealCloseTime	String	DealCloseTime.
DealCompanyId	Integer	DealCompanyId.
DealCreatorUserId	Integer	DealCreatorUserId.
DealCurrency	String	DealCurrency.
DealDeleted	Boolean	DealDeleted.
DealDoneActivitiesCount	Integer	DealDoneActivitiesCount.
DealEmailMessagesCount	Integer	DealEmailMessagesCount.
DealExpectedCloseDate	String	DealExpectedCloseDate.
DealFilesCount	Integer	DealFilesCount.
DealFirstAddtime	Datetime	DealFirstAddtime.
DealFirstWonTime	String	DealFirstWonTime.
DealFollowersCount	Integer	DealFollowersCount.
DealId	Integer	DealId.
DealLabel	String	DealLabel.
DealLastActivityDate	String	DealLastActivityDate.
DealLastActivityId	String	DealLastActivityId.
DealLastIncomingMailTime	Datetime	DealLastIncomingMailTime.
DealLastOutgoingMailTime	Datetime	DealLastOutgoingMailTime.
DealLostReason	String	DealLostReason.
DealLostTime	String	DealLostTime.
DealNextActivityDate	Date	DealNextActivityDate.
DealNextActivityId	Integer	DealNextActivityId.
DealNextActivityTime	String	DealNextActivityTime.
DealNotesCount	Integer	DealNotesCount.
DealOrgId	Integer	DealOrgId.
DealParticipantsCount	Integer	DealParticipantsCount.
DealPersonId	Integer	persons Id.
DealPipelineId	Integer	DealPipelineId.
DealProbability	String	DealProbability.
DealProductsCount	Integer	DealProductsCount.
DealStageChangetime	Datetime	DealStageChangetime.
DealStageId	Integer	DealStageId.
DealStatus	String	DealStatus.
DealTitle	String	DealTitle.
UndoneActivitiescount	Integer	UndoneActivitiescount.
DealUpdateTime	Datetime	DealUpdateTime.
DealUserId	Integer	DealUserId.
DealValue	Double	DealValue.
DealVisibleTo	String	DealVisibleTo.
DealWonTime	String	DealWonTime.
ProductActiveFlag	Boolean	ProductActiveFlag.
ProductAddTime	Datetime	ProductAddTime.
ProductCategory	String	ProductCategory.
ProductCode	String	ProductCode.
ProductCompanyId	Integer	ProductCompanyId.
ProductDealId	Integer	ProductDealId.
ProductDescription	String	ProductDescription.
ProductFilesCount	String	ProductFilesCount.
ProductFirstChar	String	ProductFirstChar.
ProductFollowersCount	Integer	ProductFollowersCount.
ProductName	String	ProductName.
ProductOwnerId	Integer	ProductOwnerId.
ProductSelectable	Boolean	ProductSelectable.
ProductTax	Integer	ProductTax.
ProductUnit	String	ProductUnit.
ProductUpdateTime	Datetime	ProductUpdateTime.
ProductVisibleTo	String	ProductVisibleTo.

PersonsUpdates

Get details of persons updates.

Select

The Sync App 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 Sync App.

PersonId supports the '=' operator.
AllChanges supports the '=' operator.
Items supports the '=,IN' operators.

For example, the following query is processed server side:

SELECT * FROM PersonsUpdates WHERE PersonId = 246 

SELECT * FROM PersonsUpdates WHERE PersonId = 10 AND AllChanges = 1

SELECT * FROM PersonsUpdates WHERE PersonId = 10 AND Items IN ('activity','plannedActivity')

Columns


Name	Type	Description
Id [KEY]	Integer	Id.
ActiveFlag	Boolean	ActiveFlag.
AddTime	Datetime	AddTime.
NewValueFormatted	String	NewValueFormatted.
AssignedToUserId	Integer	AssignedToUserId.
Attendees	String	Attendees.
BusyFlag	Boolean	BusyFlag.
SyncIncludecontext	String	SyncIncludecontext.
changeSource	String	changeSource.
UserAgent	String	UserAgent.
CompanyId	Integer	CompanyId.
MeetingClient	String	MeetingClient.
MeetingId	String	MeetingId.
MeetingUrl	String	MeetingUrl.
CreatedByUserId	Integer	CreatedByUserId.
DealDropboxBcc	String	DealDropboxBcc.
DealId	Integer	DealId.
DealTitle	String	DealTitle.
Done	Boolean	Done.
DueDate	Date	DueDate.
DueTime	Time	DueTime.
Duration	Time	Duration.
FieldKey	String	FieldKey.
Fileclean_name	String	Fileclean_name.
FileId	String	FileId.
FileUrl	String	FileUrl.
GcaleventId	String	GcaleventId.
GoogleCalendarEtag	String	GoogleCalendarEtag.
GoogleCalendarId	String	GoogleCalendarId.
IsBulkUpdateFlag	String	IsBulkUpdateFlag.
ItemId	Integer	ItemId.
NotificationTime	Datetime	NotificationTime.
NotificationUserId	Integer	NotificationUserId.
LeadId	String	LeadId.
Location	String	Location.
AdminAreaLevel1	String	AdminAreaLevel1.
AdminAreaLevel2	String	AdminAreaLevel2.
Country	String	Country.
FormattedAddress	String	FormattedAddress.
Lat	Double	Lat.
Locality	String	Locality.
Long	Double	Long.
PostalCode	String	PostalCode.
Route	String	Route.
StreetNumber	String	StreetNumber.
Sublocality	String	Sublocality.
Subpremise	String	Subpremise.
LogTime	Datetime	LogTime.
MarkedAsDoneTime	Datetime	MarkedAsDoneTime.
NewValue	String	NewValue.
Note	String	Note.
LanguageId	Integer	LanguageId.
OldValue	String	OldValue.
OrgId	Integer	Organizations Id.
OrgName	String	Organizations Name.
OwnerName	String	Owner Name.
Participants	String	Participants.
PersonDropboxBcc	String	Person Dropbox Bcc.
PersonId	Integer	Persons Id.
PersonName	String	PersonName.
Publicdescription	String	Publicdescription.
RecMasterActivityId	String	RecMasterActivityId.
RecRule	String	RecRule.
RecRuleExtension	String	RecRuleExtension.
ReferenceId	Integer	ReferenceId.
ReferenceType	String	ReferenceType.
Series	String	Series.
SourceTimezone	String	SourceTimezone.
Subject	String	Subject.
Type	String	Type.
UpdateTime	Datetime	UpdateTime.
UpdateUserId	Integer	UpdateUserId.
UserId	Integer	UserId.
Object	String	Object.
Timestamp	Datetime	Timestamp.

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
AllChanges	String	Whether to show custom field updates or not. The allowed values are 1.
Items	String	item specific updates. The allowed values are activity, plannedActivity, note, file, change, deal, follower, participant, mailMessage, mailMessageWithAttachment, invoice, activityFile, document.

PersonsUpdatesAttendees

Get details of Deals Activities Attendees.

Select

The Sync App 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 Sync App.

PersonId supports the '=' operator.
AllChanges supports the '=' operator.
Items supports the '=,IN' operators.

For example, the following query is processed server side:

SELECT * FROM PersonsUpdatesAttendees WHERE PersonId = 246 

SELECT * FROM PersonsUpdatesAttendees WHERE PersonId = 10 AND AllChanges = 1

SELECT * FROM PersonsUpdatesAttendees WHERE PersonId = 10 AND Items IN ('activity','plannedActivity')

Columns


Name	Type	Description
PersonId [KEY]	Integer	PersonId.
EmailAddress	String	EmailAddress.
IsOrganizer	Integer	IsOrganizer.
Name	String	Name.
Status	String	Status.
UserId	String	UserId.

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
AllChanges	String	Whether to show custom field updates or not. The allowed values are 1.
Items	String	Item specific updates. The allowed values are activity, plannedActivity, note, file, change, deal, follower, participant, mailMessage, mailMessageWithAttachment, invoice, activityFile, document.

PersonsUpdatesParticipants

Get details of activities participants

Select

The Sync App 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 Sync App.

PersonId supports the '=' operator.
AllChanges supports the '=' operator.
Items supports the '=,IN' operators.

For example, the following query is processed server side:

SELECT * FROM PersonsUpdatesParticipants WHERE PersonId = 10

SELECT * FROM PersonsUpdatesParticipants WHERE PersonId = 10 AND AllChanges = 1

SELECT * FROM PersonsUpdatesParticipants WHERE PersonId = 10 AND Items IN ('activity','plannedActivity')

Columns


Name	Type	Description
PersonId [KEY]	Integer	PersonId.
PrimaryFlag	Boolean	PrimaryFlag.

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
AllChanges	String	Whether to show custom field updates or not The allowed values are 1.
Items	String	item specific updates The allowed values are activity, plannedActivity, note, file, change, deal, follower, participant, mailMessage, mailMessageWithAttachment, invoice, activityFile, document.

PipelineDeals

Lists deals in a specific pipeline across all its stages.

Select

The Sync App 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 Sync App.

Id supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM PipelineDeals WHERE Id = 4

Columns


Name	Type	Description
Id [KEY]	Integer	ID of the pipeline.
Active	Boolean	Active.
ActivitiesCount	Integer	ActivitiesCount.
AddTime	Datetime	AddTime.
CcEmail	String	CcEmail.
CloseTime	String	CloseTime.
CreatorUserId	Integer	CreatorUserId.
Currency	String	Currency.
Deleted	Boolean	Deleted.
DoneActivitiesCount	Integer	DoneActivitiesCount.
EmailMessagesCount	Integer	EmailMessagesCount.
ExpectedCloseDate	Date	ExpectedCloseDate.
FilesCount	Integer	FilesCount.
FirstWonTime	Datetime	FirstWonTime.
FollowersCount	Integer	FollowersCount.
FormattedValue	String	FormattedValue.
FormattedWeightedValue	String	FormattedWeightedValue.
Label	String	Label.
LastActivityDate	String	LastActivityDate.
LastActivityId	String	LastActivityId.
LastIncomingMailTime	Datetime	LastIncomingMailTime.
LastOutgoingMailTime	Datetime	LastOutgoingMailTime.
LostReason	String	LostReason.
LostTime	String	LostTime.
NextActivityDate	Date	NextActivityDate.
NextActivityDuration	Time	NextActivityDuration.
NextActivityId	Integer	NextActivityId.
NextActivityNote	String	NextActivityNote.
NextActivitySubject	String	NextActivitySubject.
NextActivityTime	Time	NextActivityTime.
NextActivityType	String	NextActivityType.
NotesCount	Integer	NotesCount.
OrgHidden	Boolean	OrgHidden.
OrgId	Integer	OrgId.
OrgName	String	OrgName.
OwnerName	String	OwnerName.
ParticipantsCount	Integer	ParticipantsCount.
PersonHidden	Boolean	PersonHidden.
PersonId	Integer	PersonId.
PersonName	String	PersonName.
PipelineId	Integer	PipelineId.
Probability	String	Probability.
ProductsCount	Integer	ProductsCount.
RottenTime	String	RottenTime.
StageChangeTime	Datetime	StageChangeTime.
StageId	Integer	If supplied, only deals within the given stage will be returned.
StageOrderNr	Integer	StageOrderNr.
Status	String	Status.
Title	String	Title.
UndoneActivitiesCount	Integer	UndoneActivitiesCount.
UpdateTime	Datetime	UpdateTime.
UserId	Integer	UserId.
Value	Integer	Value.
VisibleTo	String	VisibleTo.
WeightedValue	Integer	WeightedValue.
WeightedValueCurrency	String	WeightedValueCurrency.
WonTime	Datetime	WonTime.

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	If supplied, only deals matching the given filter will be returned.

PipelineDealsConversionRates

Returns statistics for deals movements for given time period.

Select

The Sync App 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 Sync App.

Id supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM PipelineDealsConversionRates WHERE Id = 4

Columns


Name	Type	Description
Id	Integer	ID of the pipeline.
LostConversion	Integer	LostConversion.
StageConversions	String	StageConversions.
WonConversion	Integer	WonConversion.

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	ID of the user who's pipeline statistics to fetch.
StartDate	Datetime	Start of the period.
EndDate	Datetime	End of the period.

PipelineDealsMovements

Returns statistics for deals movements for given time period.

Select

The Sync App 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 Sync App.

Id supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM PipeLineDealsMovements WHERE Id = 4

Columns


Name	Type	Description
Id	Integer	ID of the pipeline.
AverageAgeInDaysAcrossAllStages	Integer	AverageAgeInDaysAcrossAllStages.
AverageAgeInDaysByStages	String	AverageAgeInDaysByStages.
DealsLeftOpenCount	Integer	DealsLeftOpenCount.
DealsLeftOpenDealsIds	String	DealsLeftOpenDealsIds.
DealsLeftOpenFormattedValuesUSD	String	DealsLeftOpenFormattedValuesUSD.
DealsLeftOpenValuesUSD	Integer	DealsLeftOpenValuesUSD.
LostDealsCount	Integer	LostDealsCount.
LostDealsDealsIds	String	LostDealsDealsIds.
LostDealsFormattedValuesUSD	String	LostDealsFormattedValuesUSD.
LostDealsValuesUSD	Integer	LostDealsValuesUSD.
MovementsBetweenStagesCount	Integer	MovementsBetweenStagesCount.
NewDealsCount	Integer	NewDealsCount.
NewDealsDealsIds	String	NewDealsDealsIds.
NewDealsFormattedValuesUSD	String	NewDealsFormattedValuesUSD.
NewDealsValuesUSD	Integer	NewDealsValuesUSD.
WonDealsCount	Integer	WonDealsCount.
WonDealsDealsIds	String	WonDealsDealsIds.
WonDealsFormattedValuesUSD	String	WonDealsFormattedValuesUSD.
WonDealsValuesUSD	Integer	WonDealsValuesUSD.

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	ID of the user who's pipeline statistics to fetch.
StartDate	Datetime	Start of the period. Date in format of YYYY-MM-DD
EndDate	Datetime	End of the period. Date in format of YYYY-MM-DD

PipelineDealsStageConversions

Returns statistics for deals movements for given time period

Select

The Sync App 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 Sync App.

Id supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM PipelineDealsStageConversions

SELECT * FROM PipelineDealsStageConversions WHERE Id = 4

Columns


Name	Type	Description
Id	Integer	ID of the pipeline
ConversionRate	Integer	ConversionRate
FromStageId	String	FromStageId
ToStageId	Integer	ToStageId

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	ID of the user who's pipeline statistics to fetch
StartDate	Date	Start of the period
EndDate	Date	End of the period

ProductsDeals

Get details of Products Deals.

Select

The Sync App 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 Sync App.

Id supports the '=' operator.
Status supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM ProductsDeals WHERE Id = 10 

SELECT * FROM ProductsDeals WHERE Id = 10 AND status = 'open'

Columns


Name	Type	Description
Id [KEY]	Integer	Id.
Active	Boolean	Active.
ActivitiesCount	Integer	ActivitiesCount.
AddTime	Datetime	AddTime.
CcEmail	String	CcEmail.
CloseTime	String	CloseTime.
CreatorActiveFlag	Boolean	CreatorActiveFlag.
CreatorEmail	String	CreatorEmail.
CreatorHasPic	Boolean	CreatorHasPic.
CreatorId	Integer	CreatorId.
CreatorName	String	CreatorName.
CreatorPicHash	String	CreatorPicHash.
CreatorValue	Integer	CreatorValue.
Currency	String	Currency.
Deleted	Boolean	Deleted.
DoneActivitiesCount	Integer	DoneActivitiesCount.
EmailMessagesCount	Integer	EmailMessagesCount.
ExpectedCloseDate	String	ExpectedCloseDate.
FilesCount	Integer	FilesCount.
FirstWonTime	String	FirstWonTime.
FollowersCount	Integer	FollowersCount.
FormattedValue	String	FormattedValue.
FormattedWeightedValue	String	FormattedWeightedValue.
Label	String	Label.
LastActivityDate	String	LastActivityDate.
LastActivityId	String	LastActivityId.
LastIncomingMailTime	String	LastIncomingMailTime.
LastOutgoingMailTime	String	LastOutgoingMailTime.
LostReason	String	LostReason.
LostTime	String	LostTime.
NextActivityDate	Date	NextActivityDate.
NextActivityDuration	Time	NextActivityDuration.
NextActivityId	Integer	NextActivityId.
NextActivityNote	String	NextActivityNote.
NextActivitySubject	String	NextActivitySubject.
NextActivityTime	Time	NextActivityTime.
NextActivityType	String	NextActivityType.
NotesCount	Integer	NotesCount.
OrgHidden	Boolean	OrgHidden.
OrgId	String	OrgId.
OrgName	String	OrgName.
OwnerName	String	OwnerName.
ParticipantsCount	Integer	ParticipantsCount.
PersonHidden	Boolean	PersonHidden.
PersonActiveFlag	Boolean	PersonActiveFlag.
PersonEmail	String	PersonEmail.
PersonName	String	PersonName.
PersonPhone	String	PersonPhone.
PersonValue	Integer	PersonValue.
PipelineId	Integer	PipelineId.
Probability	String	Probability.
ProductsCount	Integer	ProductsCount.
RottenTime	String	RottenTime.
StageChangeTime	String	StageChangeTime.
StageId	Integer	StageId.
StageOrderNr	Integer	StageOrderNr.
Status	String	Only fetch deals with specific status. The allowed values are open, won, lost, deleted, all_not_deleted. The default value is all_not_deleted.
Title	String	Title.
UndoneActivitiesCount	Integer	UndoneActivitiesCount.
UpdateTime	Datetime	UpdateTime.
UserActiveFlag	Boolean	UserActiveFlag.
UserEmail	String	UserEmail.
UserHasPic	Boolean	UserHasPic.
UserId	Integer	UserId.
UserName	String	UserName.
UserPicHash	String	UserPicHash.
Uservalue	Integer	Uservalue.
Value	Double	Value.
VisibleTo	String	VisibleTo.
WeightedValue	Double	WeightedValue.
WeightedValueCurrency	String	WeightedValueCurrency.
WonTime	String	WonTime.

ProductsDealsPersonEmail

Get details of Products Deals person email.

Select

The Sync App 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 Sync App.

Id supports the '=' operator.
Status supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM ProductsDealsPersonEmail WHERE Id = 10

SELECT * FROM ProductsDealsPersonEmail WHERE Id = 10 AND status = 'open'

Columns


Name	Type	Description
Id [KEY]	Integer	Id.
Label	String	Label.
Primary	Boolean	Primary.
Value	String	Value.

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

Status

String

Only fetch deals with specific status.

The allowed values are open, won, lost, deleted, all_not_deleted.

The default value is all_not_deleted.

ProductsDealsPersonphone

Get details of deals person phone.

Select

The Sync App 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 Sync App.

Id supports the '=' operator.
Status supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM ProductsDealsPersonphone WHERE Id = 10 

SELECT * FROM ProductsDealsPersonphone WHERE Id = 10 AND status = 'open'

Columns


Name	Type	Description
Id [KEY]	Integer	Id.
Label	String	Label.
Primary	Boolean	Primary.
Value	String	Value.

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

Status

String

Only fetch deals with specific status.

The allowed values are open, won, lost, deleted, all_not_deleted.

The default value is all_not_deleted.

ProductsFiles

Get details of Persons file.

Select

The Sync App 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 Sync App.

ProductId supports the '=' operator.
IncludeDeletedFiles supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM ProductsFiles WHERE ProductId = 6 

SELECT * FROM ProductsFiles WHERE ProductId = 6 AND IncludeDeletedFiles = 0

Columns


Name	Type	Description
Id [KEY]	Integer	Id of the products.
ActiveFlag	Boolean	Active Flag.
ActivityId	String	Activity Id.
AddTime	Datetime	AddTime.
Cid	String	Cid.
DealId	String	Deal Id.
DealName	String	DealName.
Description	String	Description.
FileName	String	File Name.
FileSize	Integer	File Size.
FileType	String	File Type.
InlineFlag	Boolean	Inline Flag.
LogId	String	Log Id.
MailMessageId	String	MailMessage Id.
MailTemplateId	String	MailTemplate Id.
Name	String	Name.
OrgId	Integer	Org Id.
OrgName	String	Org Name.
PeopleName	String	People Name.
PersonId	String	PersonId.
PersonName	String	Person Name.
ProductId	String	Product Id.
ProductName	String	Product Name.
RemoteId	String	Remote Id.
RemoteLocation	String	Remote Location.
S3Bucket	String	S3Bucket.
UpdateTime	Datetime	Update Time.
Url	String	Url.
UserId	Integer	UserId.

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
IncludeDeletedFiles	Integer	When enabled, the list of files will also include deleted files. The allowed values are 0, 1.

ProductsPrices

Get details of Products Prices.

Select

The Sync App 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 Sync App.

Id supports the '=' operator.
Code supports the 'LIKE' operator.
Name supports the 'LIKE' operator.
FirstChar supports the '=' operator.
FilterId supports the '=' operator.
UserId supports the '=' operator.
GetSummary supports the '=' operator.
Ids supports the '=,IN' operators.

For example, the following query is processed server side:

SELECT * FROM ProductsPrices WHERE Id = 14

SELECT * FROM ProductsPrices WHERE Name LIKE '%Cdata%'
    
SELECT * FROM ProductsPrices WHERE code LIKE '%123%'
    
SELECT * FROM ProductsPrices WHERE FirstChar = 'c'
    
SELECT * FROM ProductsPrices WHERE FilterId = 1
     
SELECT * FROM ProductsPrices WHERE UserId = 1       
    
SELECT * FROM ProductsPrices WHERE GetSummary = 1
    
SELECT * FROM ProductsPrices WHERE Ids IN (1,2)

Columns


Name	Type	Description
Id [KEY]	Integer	Id.
Cost	Integer	Cost.
Currency	String	Currency.
OverheadCost	String	OverheadCost.
Price	Integer	Price.
ProductId	Integer	ProductId.

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
FirstChar	String	If supplied only Products whose name starts with the specified letter will be returned.
UserId	Integer	User Id.
FilterId	Integer	Filter Id.
GetSummary	Boolean	Get Summary.
Ids	Integer	The Ids of the Products that should be returned in the response.

Recents

Returns data about all recent changes occurred after given timestamp.

Columns


Name	Type	Description
Id	Integer	Id.
DataActive	Boolean	DataActive.
DataActiveFlag	Boolean	DataActiveFlag.
DataActivitiesCount	Integer	DataActivitiesCount.
DataAddTime	Datetime	DataAddTime.
DataAssignedToUserId	Integer	DataAssignedToUserId.
DataAttendees	String	DataAttendees.
DataBusyFlag	String	Data.BusyFlag.
DataCalendarSyncContext	String	DataCalendarSyncContext.
DataCcEmail	String	DataCcEmail.
DataCloseTime	String	DataCloseTime.
DataCompanyId	Integer	DataCompanyId.
DataConferenceMeetingClient	String	DataConferenceMeetingClient.
DataConferenceMeetingId	String	DataConferenceMeetingId.
DataConferenceMeetingUrl	String	DataConferenceMeetingUrl.
DataCreatedByUserId	Integer	DataCreatedByUserId.
DataCreatorUserId	Integer	DataCreatorUserId.
DataCurrency	String	DataCurrency.
DataDealDropboxBcc	String	DataDealDropboxBcc.
DataDealId	String	DataDealId.
DataDealTitle	String	DataDealTitle.
DataDeleted	Boolean	DataDeleted.
DataDone	Boolean	DataDone.
DataDoneActivitiesCount	Integer	DataDoneActivitiesCount.
DataDueDate	Date	DataDueDate.
DataDueTime	Datetime	DataDueTime.
DataDuration	Datetime	DataDuration.
DataEmailMessagesCount	Integer	DataEmailMessagesCount.
DataExpectedCloseDate	Date	DataExpectedCloseDate.
DataFile	String	DataFile.
DataFilesCount	Integer	DataFilesCount.
DataFirstWonTime	String	DataFirstWonTime.
DataFollowersCount	Integer	DataFollowersCount.
DataFormattedValue	String	DataFormattedValue.
DataFormattedWeightedValue	String	DataFormattedWeightedValue.
DataGcalEventId	String	DataGcalEventId.
DataGoogleCalendarEtag	String	DataGoogleCalendarEtag.
DataGoogleCalendarId	String	DataGoogleCalendarId.
DataId	Integer	DataId.
DataLabel	String	DataLabel.
ActivityDate	String	ActivityDate.
ActivityId	String	ActivityId.
IncomingMailTime	String	IncomingMailTime.
LastNotificationTime	String	Last_notification_time.
LastNotificationUserId	String	Last_notification_user_id.
LastOutgoingMailTime	String	Last_outgoing_mail_time.
LeadId	String	LeadId.
LeadTitle	String	LeadTitle.
Location	String	Location.
AreaLevel1	String	AreaLevel1.
AreaLevel2	String	AreaLevel2.
LocationCountry	String	LocationCountry.
LocationFormattedAddress	String	LocationFormattedAddress.
Locationlocality	String	Locationlocality.
LocationPostalCode	String	LocationPostalCode.
LocationRoute	String	LocationRoute.
LocationStreetNumber	String	LocationStreetNumber.
LocationSublocality	String	LocationSublocality.
LocationSubpremise	String	LocationSubpremise.
LostReason	String	LostReason.
LostTime	String	LostTime.
MarkedAsDoneTime	String	MarkedAsDoneTime.
NextActivityDate	String	NextActivityDate.
NextActivityDuration	String	NextActivityDuration.
NextActivityId	String	NextActivityId.
NextActivityNote	String	NextActivityNote.
NextActivitySubject	String	NextActivitySubject.
NextActivityTime	String	NextActivityTime.
NextActivityType	String	NextActivityType.
Note	String	Note.
NotesCount	Integer	NotesCount.
NotificationLanguageId	Integer	NotificationLanguageId.
OrgHidden	Boolean	OrgHidden.
OrgId	Integer	OrgId.
OrgName	String	OrgName.
OwnerName	String	OwnerName.
Participants	String	Participants.
ParticipantsCount	Integer	ParticipantsCount.
PersonDropboxBcc	String	PersonDropboxBcc.
PersonHidden	Boolean	PersonHidden.
PersonId	Integer	PersonId.
PersonName	String	PersonName.
PipelineId	Integer	PipelineId.
Probability	String	Probability.
ProductsCount	Integer	ProductsCount.
PublicDescription	String	PublicDescription.
RecMasterActivityId	String	RecMasterActivityId.
RecRule	String	RecRule.
RecRuleExtension	String	RecRuleExtension.
ReferenceId	String	ReferenceId.
ReferenceType	String	ReferenceType.
RottenTime	String	RottenTime.
Series	String	Series.
SourceTimezone	String	SourceTimezone.
StageChangeTime	String	StageChangeTime.
StageId	Integer	StageId.
StageOrderNr	Integer	StageOrderNr.
Status	String	Status.
Subject	String	Subject.
DataTitle	String	DataTitle.
DataType	String	DataType.
UndoneActivitiesCount	Integer	UndoneActivitiesCount.
UpdateTime	Datetime	UpdateTime.
UpdateUserId	String	UpdateUserId.
UserId	Integer	UserId.
Value	Integer	Value.
VisibleTo	String	VisibleTo.
WeightedValue	Integer	WeightedValue.
WeightedValueCurrency	String	WeightedValueCurrency.
WonTime	String	WonTime.
Item	String	Item.

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
SinceTimestamp	Datetime	Timestamp in UTC. The default value is 2000-01-01 01:29:32.

RolesSubRoles

Returns all the sub roles.

Select

The Sync App 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 Sync App.

Id supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM RolesSubRoles WHERE Id = 1

Columns


Name	Type	Description
Id [KEY]	Integer	Id.
ActiveFlag	Boolean	ActiveFlag.
AssignmentCount	String	AssignmentCount.
Name	String	Name.
ParentRoleId	Integer	ParentRoleId.
SubRoleCount	String	SubRoleCount.

UserConnection

The data of user connections.

Select

The Sync App 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 Sync App

For example, the following query is processed server side:

SELECT * FROM UserConnection

Columns


Name	Type	Description
Google	String	Google.

UserSettings

List settings of an authorized user.

Select

The Sync App 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 Sync App

For example, the following query is processed server side:

SELECT * FROM UserSettings

Columns


Name	Type	Description
ExpectedCloseDate	String	ExpectedCloseDate.
BetaApp	String	BetaApp.
CalltoLink	String	CalltoLink.
FileUploadDestination	String	FileUploadDestination.
ListLimit	Integer	ListLimit.
MarketplaceCustomUrl	String	MarketplaceCustomUrl.
MarketplaceExtensionsVendor	String	MarketplaceExtensionsVendor.
MarketplaceTeam	String	MarketplaceTeam.
PersonDuplicateCondition	String	PersonDuplicateCondition.
SalesphoneCalltoOverride	String	SalesphoneCalltoOverride.

UsersTeams

Returns data about all teams which have specified user as a member

Columns


Name	Type	Description
Id [KEY]	Integer	ID of the team.
ActiveFlag	Integer	Flag that indicates if the Team is activated. The allowed values are 0, 1.
AddTime	Datetime	AddTime.
CreatedByUserId	Integer	CreatedByUserId.
DeletedFlag	Integer	Flag that indicates if the Team is deleted. The allowed values are 0, 1.
Description	String	The Team description.
ManagerId	Integer	The Team manager ID.
Name	String	The Team name.
Users	String	List of User IDs.

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

SkipUsers

String

When enabled, the teams will not include IDs of member users.

The allowed values are 0, 1.

The default value is 1.

Connection String Options

The connection string properties are the various options that can be used to establish a connection. This section provides a complete list of the options you can configure in the connection string for this provider. Click the links for further details.

For more information on establishing a connection, see Establishing a Connection.

Authentication

Property	Description
AuthScheme	Whether to use Basic Authentication or OAuth Authentication when connecting to PipeDrive.
CompanyDomain	The company domain used for accessing your Pipedrive account.
APIToken	The API Token used for accessing your PipeDrive account.

OAuth

Property	Description
OAuthClientId	The client Id assigned when you register your application with an OAuth authorization server.
OAuthClientSecret	The client secret assigned when you register your application with an OAuth authorization server.

SSL

Property	Description
SSLServerCert	The certificate to be accepted from the server when connecting using TLS/SSL.

Firewall

Property	Description
FirewallType	The protocol used by a proxy-based firewall.
FirewallServer	The name or IP address of a proxy-based firewall.
FirewallPort	The TCP port for a proxy-based firewall.
FirewallUser	The user name to use to authenticate with a proxy-based firewall.
FirewallPassword	A password used to authenticate to a proxy-based firewall.

Proxy

Property	Description
ProxyAutoDetect	This indicates whether to use the system proxy settings or not. This takes precedence over other proxy settings, so you'll need to set ProxyAutoDetect to FALSE in order use custom proxy settings.
ProxyServer	The hostname or IP address of a proxy to route HTTP traffic through.
ProxyPort	The TCP port the ProxyServer proxy is running on.
ProxyAuthScheme	The authentication type to use to authenticate to the ProxyServer proxy.
ProxyUser	A user name to be used to authenticate to the ProxyServer proxy.
ProxyPassword	A password to be used to authenticate to the ProxyServer proxy.
ProxySSLType	The SSL type to use when connecting to the ProxyServer proxy.
ProxyExceptions	A semicolon separated list of destination hostnames or IPs that are exempt from connecting through the ProxyServer .

Logging

Property	Description
LogModules	Core modules to be included in the log file.

Schema

Property	Description
Location	A path to the directory that contains the schema files defining tables, views, and stored procedures.
BrowsableSchemas	This property restricts the schemas reported to a subset of the available schemas. For example, BrowsableSchemas=SchemaA,SchemaB,SchemaC.
Tables	This property restricts the tables reported to a subset of the available tables. For example, Tables=TableA,TableB,TableC.
Views	Restricts the views reported to a subset of the available tables. For example, Views=ViewA,ViewB,ViewC.

Miscellaneous

Property	Description
IncludeCustomFields	Set to true to retrieve custom fields values for deals, organizations, persons and products.
MaxRows	Limits the number of rows returned rows when no aggregation or group by is used in the query. This helps avoid performance issues at design time.
Other	These hidden properties are used only in specific use cases.
PseudoColumns	This property indicates whether or not to include pseudo columns as columns to the table.
Timeout	The value in seconds until the timeout error is thrown, canceling the operation.
UserDefinedViews	A filepath pointing to the JSON configuration file containing your custom views.

Authentication

This section provides a complete list of the Authentication properties you can configure in the connection string for this provider.

Property	Description
AuthScheme	Whether to use Basic Authentication or OAuth Authentication when connecting to PipeDrive.
CompanyDomain	The company domain used for accessing your Pipedrive account.
APIToken	The API Token used for accessing your PipeDrive account.

AuthScheme

Whether to use Basic Authentication or OAuth Authentication when connecting to PipeDrive.

Remarks

Whether to use Basic Authentication or OAuth Authentication when connecting to PipeDrive.

CompanyDomain

The company domain used for accessing your Pipedrive account.

Remarks

The company Domain used for accessing your Pipedrive account. You can get it manually from the Pipedrive app by logging into your Developer Sandbox account and seeing the URL.

APIToken

The API Token used for accessing your PipeDrive account.

Remarks

The API Token can be found in PipeDrive by going to account name (on the top right) -> Company settings -> Personal preferences -> API.

OAuth

This section provides a complete list of the OAuth properties you can configure in the connection string for this provider.

Property	Description
OAuthClientId	The client Id assigned when you register your application with an OAuth authorization server.
OAuthClientSecret	The client secret assigned when you register your application with an OAuth authorization server.

OAuthClientId

The client Id assigned when you register your application with an OAuth authorization server.

Remarks

As part of registering an OAuth application, you will receive the OAuthClientId value, sometimes also called a consumer key, and a client secret, the OAuthClientSecret.

OAuthClientSecret

The client secret assigned when you register your application with an OAuth authorization server.

Remarks

As part of registering an OAuth application, you will receive the OAuthClientId, also called a consumer key. You will also receive a client secret, also called a consumer secret. Set the client secret in the OAuthClientSecret property.

SSL

This section provides a complete list of the SSL properties you can configure in the connection string for this provider.

Property	Description
SSLServerCert	The certificate to be accepted from the server when connecting using TLS/SSL.

SSLServerCert

The certificate to be accepted from the server when connecting using TLS/SSL.

Remarks

If using a TLS/SSL connection, this property can be used to specify the TLS/SSL certificate to be accepted from the server. Any other certificate that is not trusted by the machine is rejected.

This property can take the following forms:


Description	Example
A full PEM Certificate (example shortened for brevity)	-----BEGIN CERTIFICATE----- MIIChTCCAe4CAQAwDQYJKoZIhv......Qw== -----END CERTIFICATE-----
A path to a local file containing the certificate	C:\cert.cer
The public key (example shortened for brevity)	-----BEGIN RSA PUBLIC KEY----- MIGfMA0GCSq......AQAB -----END RSA PUBLIC KEY-----
The MD5 Thumbprint (hex values can also be either space or colon separated)	ecadbdda5a1529c58a1e9e09828d70e4
The SHA1 Thumbprint (hex values can also be either space or colon separated)	34a929226ae0819f2ec14b4a3d904f801cbb150d

If not specified, any certificate trusted by the machine is accepted.

Use '*' to signify to accept all certificates. Note that this is not recommended due to security concerns.

Firewall

This section provides a complete list of the Firewall properties you can configure in the connection string for this provider.

Property	Description
FirewallType	The protocol used by a proxy-based firewall.
FirewallServer	The name or IP address of a proxy-based firewall.
FirewallPort	The TCP port for a proxy-based firewall.
FirewallUser	The user name to use to authenticate with a proxy-based firewall.
FirewallPassword	A password used to authenticate to a proxy-based firewall.

FirewallType

The protocol used by a proxy-based firewall.

Remarks

This property specifies the protocol that the Sync App will use to tunnel traffic through the FirewallServer proxy. Note that by default, the Sync App connects to the system proxy; to disable this behavior and connect to one of the following proxy types, set ProxyAutoDetect to false.


Type	Default Port	Description
TUNNEL	80	When this is set, the Sync App opens a connection to Pipedrive and traffic flows back and forth through the proxy.
SOCKS4	1080	When this is set, the Sync App sends data through the SOCKS 4 proxy specified by FirewallServer and FirewallPort and passes the FirewallUser value to the proxy, which determines if the connection request should be granted.
SOCKS5	1080	When this is set, the Sync App sends data through the SOCKS 5 proxy specified by FirewallServer and FirewallPort. If your proxy requires authentication, set FirewallUser and FirewallPassword to credentials the proxy recognizes.

To connect to HTTP proxies, use ProxyServer and ProxyPort. To authenticate to HTTP proxies, use ProxyAuthScheme, ProxyUser, and ProxyPassword.

FirewallServer

The name or IP address of a proxy-based firewall.

Remarks

This property specifies the IP address, DNS name, or host name of a proxy allowing traversal of a firewall. The protocol is specified by FirewallType: Use FirewallServer with this property to connect through SOCKS or do tunneling. Use ProxyServer to connect to an HTTP proxy.

Note that the Sync App uses the system proxy by default. To use a different proxy, set ProxyAutoDetect to false.

FirewallPort

The TCP port for a proxy-based firewall.

Remarks

This specifies the TCP port for a proxy allowing traversal of a firewall. Use FirewallServer to specify the name or IP address. Specify the protocol with FirewallType.

FirewallUser

The user name to use to authenticate with a proxy-based firewall.

Remarks

The FirewallUser and FirewallPassword properties are used to authenticate against the proxy specified in FirewallServer and FirewallPort, following the authentication method specified in FirewallType.

FirewallPassword

A password used to authenticate to a proxy-based firewall.

Remarks

This property is passed to the proxy specified by FirewallServer and FirewallPort, following the authentication method specified by FirewallType.

Proxy

This section provides a complete list of the Proxy properties you can configure in the connection string for this provider.

Property	Description
ProxyAutoDetect	This indicates whether to use the system proxy settings or not. This takes precedence over other proxy settings, so you'll need to set ProxyAutoDetect to FALSE in order use custom proxy settings.
ProxyServer	The hostname or IP address of a proxy to route HTTP traffic through.
ProxyPort	The TCP port the ProxyServer proxy is running on.
ProxyAuthScheme	The authentication type to use to authenticate to the ProxyServer proxy.
ProxyUser	A user name to be used to authenticate to the ProxyServer proxy.
ProxyPassword	A password to be used to authenticate to the ProxyServer proxy.
ProxySSLType	The SSL type to use when connecting to the ProxyServer proxy.
ProxyExceptions	A semicolon separated list of destination hostnames or IPs that are exempt from connecting through the ProxyServer .

ProxyAutoDetect

This indicates whether to use the system proxy settings or not. This takes precedence over other proxy settings, so you'll need to set ProxyAutoDetect to FALSE in order use custom proxy settings.

Remarks

This takes precedence over other proxy settings, so you'll need to set ProxyAutoDetect to FALSE in order use custom proxy settings.

To connect to an HTTP proxy, see ProxyServer. For other proxies, such as SOCKS or tunneling, see FirewallType.

ProxyServer

The hostname or IP address of a proxy to route HTTP traffic through.

Remarks

The hostname or IP address of a proxy to route HTTP traffic through. The Sync App can use the HTTP, Windows (NTLM), or Kerberos authentication types to authenticate to an HTTP proxy.

If you need to connect through a SOCKS proxy or tunnel the connection, see FirewallType.

By default, the Sync App uses the system proxy. If you need to use another proxy, set ProxyAutoDetect to false.

ProxyPort

The TCP port the ProxyServer proxy is running on.

Remarks

The port the HTTP proxy is running on that you want to redirect HTTP traffic through. Specify the HTTP proxy in ProxyServer. For other proxy types, see FirewallType.

ProxyAuthScheme

The authentication type to use to authenticate to the ProxyServer proxy.

Remarks

This value specifies the authentication type to use to authenticate to the HTTP proxy specified by ProxyServer and ProxyPort.

Note that the Sync App will use the system proxy settings by default, without further configuration needed; if you want to connect to another proxy, you will need to set ProxyAutoDetect to false, in addition to ProxyServer and ProxyPort. To authenticate, set ProxyAuthScheme and set ProxyUser and ProxyPassword, if needed.

The authentication type can be one of the following:

BASIC: The Sync App performs HTTP BASIC authentication.
DIGEST: The Sync App performs HTTP DIGEST authentication.
NEGOTIATE: The Sync App retrieves an NTLM or Kerberos token based on the applicable protocol for authentication.
PROPRIETARY: The Sync App does not generate an NTLM or Kerberos token. You must supply this token in the Authorization header of the HTTP request.

If you need to use another authentication type, such as SOCKS 5 authentication, see FirewallType.

ProxyUser

A user name to be used to authenticate to the ProxyServer proxy.

Remarks

The ProxyUser and ProxyPassword options are used to connect and authenticate against the HTTP proxy specified in ProxyServer.

You can select one of the available authentication types in ProxyAuthScheme. If you are using HTTP authentication, set this to the user name of a user recognized by the HTTP proxy. If you are using Windows or Kerberos authentication, set this property to a user name in one of the following formats:

user@domain
domain\user

ProxyPassword

A password to be used to authenticate to the ProxyServer proxy.

Remarks

This property is used to authenticate to an HTTP proxy server that supports NTLM (Windows), Kerberos, or HTTP authentication. To specify the HTTP proxy, you can set ProxyServer and ProxyPort. To specify the authentication type, set ProxyAuthScheme.

If you are using HTTP authentication, additionally set ProxyUser and ProxyPassword to HTTP proxy.

If you are using NTLM authentication, set ProxyUser and ProxyPassword to your Windows password. You may also need these to complete Kerberos authentication.

For SOCKS 5 authentication or tunneling, see FirewallType.

By default, the Sync App uses the system proxy. If you want to connect to another proxy, set ProxyAutoDetect to false.

ProxySSLType

The SSL type to use when connecting to the ProxyServer proxy.

Remarks

This property determines when to use SSL for the connection to an HTTP proxy specified by ProxyServer. This value can be AUTO, ALWAYS, NEVER, or TUNNEL. The applicable values are the following:


AUTO	Default setting. If the URL is an HTTPS URL, the Sync App will use the TUNNEL option. If the URL is an HTTP URL, the component will use the NEVER option.
ALWAYS	The connection is always SSL enabled.
NEVER	The connection is not SSL enabled.
TUNNEL	The connection is through a tunneling proxy. The proxy server opens a connection to the remote host and traffic flows back and forth through the proxy.

ProxyExceptions

A semicolon separated list of destination hostnames or IPs that are exempt from connecting through the ProxyServer .

Remarks

The ProxyServer is used for all addresses, except for addresses defined in this property. Use semicolons to separate entries.

Note that the Sync App uses the system proxy settings by default, without further configuration needed; if you want to explicitly configure proxy exceptions for this connection, you need to set ProxyAutoDetect = false, and configure ProxyServer and ProxyPort. To authenticate, set ProxyAuthScheme and set ProxyUser and ProxyPassword, if needed.

Logging

This section provides a complete list of the Logging properties you can configure in the connection string for this provider.

Property	Description
LogModules	Core modules to be included in the log file.

LogModules

Core modules to be included in the log file.

Remarks

Only the modules specified (separated by ';') will be included in the log file. By default all modules are included.

See the Logging page for an overview.

Schema

This section provides a complete list of the Schema properties you can configure in the connection string for this provider.

Property	Description
Location	A path to the directory that contains the schema files defining tables, views, and stored procedures.
BrowsableSchemas	This property restricts the schemas reported to a subset of the available schemas. For example, BrowsableSchemas=SchemaA,SchemaB,SchemaC.
Tables	This property restricts the tables reported to a subset of the available tables. For example, Tables=TableA,TableB,TableC.
Views	Restricts the views reported to a subset of the available tables. For example, Views=ViewA,ViewB,ViewC.

Location

A path to the directory that contains the schema files defining tables, views, and stored procedures.

Remarks

The path to a directory which contains the schema files for the Sync App (.rsd files for tables and views, .rsb files for stored procedures). The folder location can be a relative path from the location of the executable. The Location property is only needed if you want to customize definitions (for example, change a column name, ignore a column, and so on) or extend the data model with new tables, views, or stored procedures.

If left unspecified, the default location is "%APPDATA%\\CData\\Pipedrive Data Provider\\Schema" with %APPDATA% being set to the user's configuration directory:

BrowsableSchemas

This property restricts the schemas reported to a subset of the available schemas. For example, BrowsableSchemas=SchemaA,SchemaB,SchemaC.

Remarks

Listing the schemas from databases can be expensive. Providing a list of schemas in the connection string improves the performance.

Tables

This property restricts the tables reported to a subset of the available tables. For example, Tables=TableA,TableB,TableC.

Remarks

Listing the tables from some databases can be expensive. Providing a list of tables in the connection string improves the performance of the Sync App.

This property can also be used as an alternative to automatically listing views if you already know which ones you want to work with and there would otherwise be too many to work with.

Specify the tables you want in a comma-separated list. Each table should be a valid SQL identifier with any special characters escaped using square brackets, double-quotes or backticks. For example, Tables=TableA,[TableB/WithSlash],WithCatalog.WithSchema.`TableC With Space`.

Note that when connecting to a data source with multiple schemas or catalogs, you will need to provide the fully qualified name of the table in this property, as in the last example here, to avoid ambiguity between tables that exist in multiple catalogs or schemas.

Views

Restricts the views reported to a subset of the available tables. For example, Views=ViewA,ViewB,ViewC.

Remarks

Listing the views from some databases can be expensive. Providing a list of views in the connection string improves the performance of the Sync App.

This property can also be used as an alternative to automatically listing views if you already know which ones you want to work with and there would otherwise be too many to work with.

Specify the views you want in a comma-separated list. Each view should be a valid SQL identifier with any special characters escaped using square brackets, double-quotes or backticks. For example, Views=ViewA,[ViewB/WithSlash],WithCatalog.WithSchema.`ViewC With Space`.

Note that when connecting to a data source with multiple schemas or catalogs, you will need to provide the fully qualified name of the table in this property, as in the last example here, to avoid ambiguity between tables that exist in multiple catalogs or schemas.

Miscellaneous

This section provides a complete list of the Miscellaneous properties you can configure in the connection string for this provider.

Property	Description
IncludeCustomFields	Set to true to retrieve custom fields values for deals, organizations, persons and products.
MaxRows	Limits the number of rows returned rows when no aggregation or group by is used in the query. This helps avoid performance issues at design time.
Other	These hidden properties are used only in specific use cases.
PseudoColumns	This property indicates whether or not to include pseudo columns as columns to the table.
Timeout	The value in seconds until the timeout error is thrown, canceling the operation.
UserDefinedViews	A filepath pointing to the JSON configuration file containing your custom views.

IncludeCustomFields

Set to true to retrieve custom fields values for deals, organizations, persons and products.

Remarks

Set to true to retrieve custom fields values for deals, organizations, persons and products.

MaxRows

Limits the number of rows returned rows when no aggregation or group by is used in the query. This helps avoid performance issues at design time.

Remarks

Limits the number of rows returned rows when no aggregation or group by is used in the query. This helps avoid performance issues at design time.

Other

These hidden properties are used only in specific use cases.

Remarks

The properties listed below are available for specific use cases. Normal driver use cases and functionality should not require these properties.

Specify multiple properties in a semicolon-separated list.

Integration and Formatting


DefaultColumnSize	Sets the default length of string fields when the data source does not provide column length in the metadata. The default value is 2000.
ConvertDateTimeToGMT	Determines whether to convert date-time values to GMT, instead of the local time of the machine.
RecordToFile=filename	Records the underlying socket data transfer to the specified file.

PseudoColumns

This property indicates whether or not to include pseudo columns as columns to the table.

Remarks

This setting is particularly helpful in Entity Framework, which does not allow you to set a value for a pseudo column unless it is a table column. The value of this connection setting is of the format "Table1=Column1, Table1=Column2, Table2=Column3". You can use the "*" character to include all tables and all columns; for example, "*=*".

Timeout

The value in seconds until the timeout error is thrown, canceling the operation.

Remarks

If Timeout = 0, operations do not time out. The operations run until they complete successfully or until they encounter an error condition.

If Timeout expires and the operation is not yet complete, the Sync App throws an exception.

UserDefinedViews

A filepath pointing to the JSON configuration file containing your custom views.

Remarks

User Defined Views are defined in a JSON-formatted configuration file called UserDefinedViews.json. The Sync App automatically detects the views specified in this file.

You can also have multiple view definitions and control them using the UserDefinedViews connection property. When you use this property, only the specified views are seen by the Sync App.

This User Defined View configuration file is formatted as follows:

Each root element defines the name of a view.
Each root element contains a child element, called query, which contains the custom SQL query for the view.

For example:

{
	"MyView": {
		"query": "SELECT * FROM Deals WHERE MyColumn = 'value'"
	},
	"MyView2": {
		"query": "SELECT * FROM MyTable WHERE Id IN (1,2,3)"
	}
}

Use the UserDefinedViews connection property to specify the location of your JSON configuration file. For example:

"UserDefinedViews", "C:\\Users\\yourusername\\Desktop\\tmp\\UserDefinedViews.json"