2024 is the year of the connector - vote here

Explore the Pipedrive API data model

See how the various Pipedrive endpoints relate to each other, using our handy Entity Relationship Diagram

Try our interactive ERD Or, browse below

Pulling data from the Pipedrive API is only the first part of your reporting. You also need to understand the relationships between different endpoints - something that APIs typically fail to convey.

At SyncHub, we not only sync your Pipedrive API endpoints down into a reportable format, we also describe their relationships (e.g. in terms of foreign keys) so that you can quickly get a grasp of your data and how it fits together. This page is intended as technical documentation of these relationships.

Endpoints

Activity

Documentation: https://developers.pipedrive.com/docs/api/v1/#!/Activities

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Item string - -
CompanyID int - -
UserID int User → ID -
Done boolean - -
Type string - -
ReferenceType string - -
ReferenceID int - -
ConferenceMeetingClient string - -
ConferenceMeetingUrl string - -
DueDate datetime - -
DueTime datetime - -
Duration string - -
BusyFlag boolean - -
MarkedAsDoneTime datetime - -
LastNotificationTime datetime - -
LastNotificationUserID int User → ID -
NotificationLanguageID int - -
Subject string - -
PublicDescription string - -
CalendarSyncIncludeContext string - -
Location string - -
OrgID int Organization → ID -
PersonID int Person → ID -
DealID int Deal → ID -
LeadID guid - -
LeadTitle string - -
UpdateUserID int User → ID -
GcalEventID string - -
GoogleCalendarID string - -
GoogleCalendarEtag string - -
SourceTimezone string - -
RecRule string - -
RecRuleExtension string - -
RecMasterActivityID int - -
ConferenceMeetingID string - -
Note string - -
CreatedByUserID int User → ID -
LocationSubpremise string - -
LocationStreetNumber string - -
LocationRoute string - -
LocationSublocality string - -
LocationLocality string - -
LocationAdminAreaLevel1 string - -
LocationAdminAreaLevel2 string - -
LocationCountry string - -
LocationPostalCode string - -
LocationFormattedAddress string - -
OrgName string - -
PersonName string - -
DealTitle string - -
OwnerName string - -
PersonDropboxBcc string - -
DealDropboxBcc string - -
AssignedToUserID int User → ID -
FileID int File → ID -
AddTime datetime - -
UpdateTime datetime - -
ActiveFlag boolean - -

ActivityType

Documentation: https://developers.pipedrive.com/docs/api/v1/#!/ActivityTypes

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Name string - -
OrderNr int - -
KeyString string - -
IconKey string - -
Color string - -
IsCustomFlag boolean - -
AddTime datetime - -
UpdateTime datetime - -
ActiveFlag boolean - -

DealCustomField

Documentation: https://developers.pipedrive.com/docs/api/v1/#!/DealFields

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int -
  • 21 Jan 2021 The ID field is empty for sub-fields (e.g. date_until, address_city, etc)
Name string - -
Key string -
  • 21 Jan 2021 The key field is present on all fields, and unique for each type (deal, person, etc). For built-in fields, it is a word like 'status' or 'datetime'. But for custom fields, it is a GUID. If the custom field has a sub-property, such as address_city, then this key is in the format [parentguid]_city.
OrderNr int - -
FieldType string - -
AddTime datetime - -
UpdateTime datetime - -
LastUpdatedByUserID int - -
ActiveFlag boolean - -
IsSubfield boolean - -

OrganizationCustomField

Documentation: https://developers.pipedrive.com/docs/api/v1/#!/OrganizationFields

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int -
  • 21 Jan 2021 The ID field is empty for sub-fields (e.g. date_until, address_city, etc)
Name string - -
Key string -
  • 21 Jan 2021 The key field is present on all fields, and unique for each type (deal, person, etc). For built-in fields, it is a word like 'status' or 'datetime'. But for custom fields, it is a GUID. If the custom field has a sub-property, such as address_city, then this key is in the format [parentguid]_city.
OrderNr int - -
FieldType string - -
AddTime datetime - -
UpdateTime datetime - -
LastUpdatedByUserID int - -
ActiveFlag boolean - -
IsSubfield boolean - -

PersonCustomField

Documentation: https://developers.pipedrive.com/docs/api/v1/#!/PersonFields

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int -
  • 21 Jan 2021 The ID field is empty for sub-fields (e.g. date_until, address_city, etc)
Name string - -
Key string -
  • 21 Jan 2021 The key field is present on all fields, and unique for each type (deal, person, etc). For built-in fields, it is a word like 'status' or 'datetime'. But for custom fields, it is a GUID. If the custom field has a sub-property, such as address_city, then this key is in the format [parentguid]_city.
OrderNr int - -
FieldType string - -
AddTime datetime - -
UpdateTime datetime - -
LastUpdatedByUserID int - -
ActiveFlag boolean - -
IsSubfield boolean - -

Deal

Documentation: https://developers.pipedrive.com/docs/api/v1/Deals#getDeals

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
CreatorUserID int User → ID -
UserID int User → ID -
PersonID int Person → ID -
OrgID int Organization → ID -
StageID int Stage → ID -
Title string - -
Value decimal - -
Currency string - -
StageChangeTime datetime - -
Active boolean - -
Deleted boolean - -
Status string - -
Probability string - -
NextActivityDate datetime - -
NextActivityTime datetime - -
NextActivityID int Activity → ID -
LastActivityID int Activity → ID -
LastActivityDate datetime - -
LostReason string - -
VisibleTo string - -
CloseTime datetime - -
PipelineID int Pipeline → ID -
WonTime datetime - -
FirstWonTime datetime - -
LostTime datetime - -
ProductsCount long - -
FilesCount int - -
NotesCount int - -
FollowersCount int - -
EmailMessagesCount int - -
ActivitiesCount int - -
DoneActivitiesCount int - -
UndoneActivitiesCount int - -
ParticipantsCount int - -
ExpectedCloseDate datetime - -
LastIncomingMailTime datetime - -
LastOutgoingMailTime datetime - -
Label string -
  • 7 Dec 2022 If a single label is specified, we have the ID of the created label. If the deal has multiple labels, the IDs are comma-separated
RenewalType string - -
StageOrderNr int - -
PersonName string - -
OrgName string - -
NextActivitySubject string - -
NextActivityType string - -
NextActivityDuration string - -
NextActivityNote string - -
FormattedValue string - -
WeightedValue decimal - -
FormattedWeightedValue string - -
WeightedValueCurrency string - -
RottenTime datetime - -
OwnerName string - -
CcEmail string - -
OrgHidden boolean - -
PersonHidden boolean - -
AverageStageProgress int - -
AddTime datetime - -
UpdateTime datetime - -
ActiveFlag boolean - -

DealModificationHistory

Documentation: https://developers.pipedrive.com/docs/api/v1/#!/Deals/getDealUpdates

Column Type Relates to Notes
RemoteID string - -
DealRemoteID string Deal → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
ItemID int - -
DealID int Deal → ID -
UserID int User → ID -
FieldKey string - -
OldValue string - -
NewValue string - -
IsBulkUpdateFlag boolean - -
LogTime datetime - -
ChangeSource string - -
ChangeSourceUserAgent string - -
AddTime datetime - -
UpdateTime datetime - -
ActiveFlag boolean - -

DealProduct

Documentation: https://developers.pipedrive.com/docs/api/v1/Deals#getDealProducts

Column Type Relates to Notes
RemoteID string - -
DealRemoteID string Deal → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Name string - -
DealID int Deal → ID -
ProductID int Product → ID
  • 7 Sep 2023 We have observed records coming from PD with a null product_id value. This doesn't make sense, as it is supposed to be a deal-product relationship, however the rest of the data looks fine. Perhaps it relates to deleted products?
OrderNr string - -
ProductVariationID int - -
ItemPrice decimal - -
DiscountPercentage decimal - -
Duration decimal - -
DurationUnit string - -
SumNoDiscount decimal - -
Sum decimal - -
Currency string - -
EnabledFlag boolean - -
LastEdit datetime - -
Comments string - -
Tax decimal - -
SumFormatted string - -
QuantityFormatted string - -
Quantity decimal - -
AddTime datetime - -
UpdateTime datetime - -
ActiveFlag boolean - -

File

Documentation: https://developers.pipedrive.com/docs/api/v1/#!/Files

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Name string - -
Description string - -
UserID int User → ID -
DealID int Deal → ID -
PersonID int Person → ID -
OrgID int Organization → ID -
ProductID int Product → ID -
ActivityID int Activity → ID -
LogID int - -
FileName string - -
FileType string - -
FileSize decimal - -
InlineFlag boolean - -
RemoteLocation string - -
FileRemoteID string - -
Cid string - -
S3Bucket string - -
MailMessageID string - -
MailTemplateID string - -
DealName string - -
PersonName string - -
PeopleName string - -
OrgName string - -
ProductName string - -
Url string - -
AddTime datetime - -
UpdateTime datetime - -
ActiveFlag boolean - -

Lead

Documentation: https://developers.pipedrive.com/docs/api/v1/Leads#getLeads

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
Title string - -
Amount decimal - -
Currency string - -
CreatorID int User → ID -
OwnerID int User → ID -
ExpectedCloseDate datetime - -
VisibleTo string -
  • 30 Apr 2022 Possible values differ according to Pipedrive plan type
PersonID int Person → ID -
OrganizationID int Organization → ID -
SourceName string - -
WasSeen boolean - -
NextActivityID int Activity → ID -
LastActivityID int Activity → ID -
AddTime datetime - -
UpdateTime datetime - -
IsArchived boolean - -

LeadLabel

Documentation: https://developers.pipedrive.com/docs/api/v1/LeadLabels#getLeadLabels

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
Name string - -
Color string - -
AddTime datetime - -
UpdateTime datetime - -

Note

Documentation: https://developers.pipedrive.com/docs/api/v1/#!/Notes

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
UserID int User → ID -
DealID int Deal → ID -
PersonID int Person → ID -
OrgID int Organization → ID -
Content string - -
PinnedToDealFlag boolean - -
PinnedToPersonFlag boolean - -
PinnedToOrganizationFlag boolean - -
LastUpdateUserID int User → ID -
AddTime datetime - -
UpdateTime datetime - -
ActiveFlag boolean - -

Organization

Documentation: https://developers.pipedrive.com/docs/api/v1/#!/Organizations

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Name string - -
CompanyID int - -
OwnerID int - -
OpenDealsCount int - -
RelatedOpenDealsCount int - -
ClosedDealsCount int - -
RelatedClosedDealsCount int - -
EmailMessagesCount int - -
PeopleCount int - -
ActivitiesCount int - -
DoneActivitiesCount int - -
UndoneActivitiesCount int - -
FilesCount int - -
NotesCount int - -
FollowersCount int - -
WonDealsCount int - -
RelatedWonDealsCount int - -
LostDealsCount int - -
RelatedLostDealsCount int - -
CategoryID int - -
PictureID int - -
CountryCode string - -
FirstChar string - -
VisibleTo string - -
NextActivityDate datetime - -
NextActivityTime datetime - -
NextActivityID int Activity → ID -
LastActivityID int Activity → ID -
LastActivityDate datetime - -
Label string - -
Address string - -
AddressSubpremise string - -
AddressStreetNumber string - -
AddressRoute string - -
AddressSublocality string - -
AddressLocality string - -
AddressAdminAreaLevel1 string - -
AddressAdminAreaLevel2 string - -
AddressCountry string - -
AddressPostalCode string - -
AddressFormattedAddress string - -
CcEmail string - -
OwnerName string - -
EditName boolean - -
AddTime datetime - -
UpdateTime datetime - -
ActiveFlag boolean - -

Person

Documentation: https://developers.pipedrive.com/docs/api/v1/#!/Persons

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Name string - -
CompanyID int - -
OwnerID int User → ID -
OrgID int Organization → ID -
FirstName string - -
LastName string - -
OpenDealsCount int - -
RelatedOpenDealsCount int - -
ClosedDealsCount int - -
RelatedClosedDealsCount int - -
ParticipantOpenDealsCount int - -
ParticipantClosedDealsCount int - -
EmailMessagesCount int - -
ActivitiesCount int - -
DoneActivitiesCount int - -
UndoneActivitiesCount int - -
FilesCount int - -
NotesCount int - -
FollowersCount int - -
WonDealsCount int - -
RelatedWonDealsCount int - -
LostDealsCount int - -
RelatedLostDealsCount int - -
FirstChar string - -
VisibleTo string - -
PictureID int - -
NextActivityDate datetime - -
NextActivityTime datetime - -
NextActivityID int Activity → ID -
LastActivityID int Activity → ID -
LastActivityDate datetime - -
LastIncomingMailTime datetime - -
LastOutgoingMailTime datetime - -
Label string - -
OrgName string - -
CcEmail string - -
OwnerName string - -
AddTime datetime - -
UpdateTime datetime - -
ActiveFlag boolean - -

Pipeline

Documentation: https://developers.pipedrive.com/docs/api/v1/#!/Pipelines

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Name string - -
UrlTitle string - -
OrderNr int - -
Active boolean - -
DealProbability boolean - -
Selected boolean - -
AddTime datetime - -
UpdateTime datetime - -
ActiveFlag boolean - -

Product

Documentation: https://developers.pipedrive.com/docs/api/v1/#!/Products

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Name string - -
Description string - -
Code string - -
Unit string - -
Tax decimal - -
Category string - -
Selectable boolean - -
FirstChar string - -
VisibleTo string -
  • 20 Nov 2020 1 = Owners & followers, 3 = Entire company, NULL = inherit from parent
OwnerID int User → ID -
FilesCount int - -
FollowersCount int - -
AddTime datetime - -
UpdateTime datetime - -
ActiveFlag boolean - -

Stage

Documentation: https://developers.pipedrive.com/docs/api/v1/#!/Stages

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Name string - -
OrderNr int - -
DealProbability int - -
PipelineID int Pipeline → ID -
RottenFlag boolean - -
RottenDays int - -
PipelineDealProbability boolean - -
AddTime datetime - -
UpdateTime datetime - -
ActiveFlag boolean - -

Subscription

Documentation: https://developers.pipedrive.com/docs/api/v1/Subscriptions

Column Type Relates to Notes
RemoteID string - -
DealRemoteID string Deal → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Description string - -
UserID int User → ID -
DealID int Deal → ID -
IsActive boolean - -
CycleAmount decimal - -
CyclesCount decimal - -
Infinite boolean - -
Currency string - -
StartDate datetime - -
EndDate datetime - -
LifetimeValue decimal - -
CadenceType string - -
FinalStatus string - -
AddTime datetime - -
UpdateTime datetime - -
ActiveFlag boolean - -

SubscriptionPayment

Documentation: https://developers.pipedrive.com/docs/api/v1/Subscriptions

Column Type Relates to Notes
RemoteID string - -
SubscriptionRemoteID string Subscription → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Description string - -
SubscriptionID int Subscription → ID -
DealID int Deal → ID -
IsActive boolean - -
Amount decimal - -
Currency string - -
ChangeAmount decimal - -
DueAt datetime - -
RevenueMovementType string - -
PaymentType string - -
AddTime datetime - -
UpdateTime datetime - -
ActiveFlag boolean - -

User

Documentation: https://developers.pipedrive.com/docs/api/v1/#!/Users

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Name string - -
ActiveFlag boolean - -
DefaultCurrency string - -
TimezoneName string - -
TimezoneOffset string - -
Locale string - -
Email string - -
Created datetime - -
Modified datetime -
  • 7 Sep 2022 In Sep 2022, Pipedrive made the User.modified field available only to those with 'account settings access'
Lang int - -
LastLogin datetime - -
RoleID int - -
HasCreatedCompany boolean - -
Activated boolean - -
IconUrl string - -

ActivityParticipant

Column Type Relates to Notes
RemoteID string - -
ActivityRemoteID string Activity → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PersonID int Person → ID -
PrimaryFlag boolean - -
ActivityID int Activity → ID -

DealCustomFieldOption

Column Type Relates to Notes
RemoteID string - -
DealCustomFieldRemoteID string DealCustomField → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string -
  • 21 Jan 2021 The id field is of type string for e.g. the 'status' type. For non-system types, it is a unique ascending integer value
DealCustomFieldKey string DealCustomField → Key -
Label string - -

OrganizationCustomFieldOption

Column Type Relates to Notes
RemoteID string - -
OrganizationCustomFieldRemoteID string OrganizationCustomField → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string -
  • 21 Jan 2021 The id field is of type string for e.g. the 'status' type. For non-system types, it is a unique ascending integer value
OrganizationCustomFieldKey string OrganizationCustomField → Key -
Label string - -

PersonCustomFieldOption

Column Type Relates to Notes
RemoteID string - -
PersonCustomFieldRemoteID string PersonCustomField → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string -
  • 21 Jan 2021 The id field is of type string for e.g. the 'status' type. For non-system types, it is a unique ascending integer value
PersonCustomFieldKey string PersonCustomField → Key -
Label string - -

DealCustomFieldValue

Column Type Relates to Notes
RemoteID string - -
DealRemoteID string Deal → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
DealCustomFieldKey string DealCustomField → Key -
DealID int Deal → ID -

LeadCustomFieldValue

Column Type Relates to Notes
RemoteID string - -
LeadRemoteID string Lead → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
DealCustomFieldKey string DealCustomField → Key
  • 30 Jul 2021 Lead custom fields are leveraged from the Deals custom fields
LeadID guid Lead → ID -

LeadLabelValue

Column Type Relates to Notes
RemoteID string - -
LeadRemoteID string Lead → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
LeadLabelID guid LeadLabel → ID
  • 30 Jul 2021 Lead custom fields are leveraged from the Deals custom fields
LeadID guid Lead → ID -

OrganizationCustomFieldValue

Column Type Relates to Notes
RemoteID string - -
OrganizationRemoteID string Organization → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
OrganizationCustomFieldKey string OrganizationCustomField → Key -
OrganizationID int Organization → ID -

PersonCustomFieldValue

Column Type Relates to Notes
RemoteID string - -
PersonRemoteID string Person → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PersonCustomFieldKey string PersonCustomField → Key -
PersonID int Person → ID -

PersonPhone

Column Type Relates to Notes
RemoteID string - -
PersonRemoteID string Person → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Label string - -
Value string - -
Primary boolean - -
PersonID int Person → ID -
SortOrder int - -

PersonEmail

Column Type Relates to Notes
RemoteID string - -
PersonRemoteID string Person → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Label string - -
Value string - -
Primary boolean - -
PersonID int Person → ID -
SortOrder int - -

ProductPrice

Column Type Relates to Notes
RemoteID string - -
ProductRemoteID string Product → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
ProductID int Product → ID -
Price decimal - -
Currency string - -
Cost decimal - -
OverheadCost decimal - -

DealCustomFieldValueOption

Column Type Relates to Notes
RemoteID string - -
DealCustomFieldValueRemoteID string DealCustomFieldValue → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
DealCustomFieldOptionID string DealCustomFieldOption → ID
  • 21 Jan 2021 Most field values are just a string (ie. the actual value), but some (e.g. multi-choice / set) have the ID field provided
Value string - -
OrganisationID int Organization → ID -
PersonID int Person → ID -
UserID int User → ID
  • 15 Jan 2020 The options are denormalized - raw values, or foreign keys to complex entities such as Person or Organisation
TimezoneID int - -

LeadCustomFieldValueOption

Column Type Relates to Notes
RemoteID string - -
LeadCustomFieldValueRemoteID string LeadCustomFieldValue → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
LeadCustomFieldOptionID string DealCustomFieldOption → ID
  • 30 Jul 2021 Lead custom fields are leveraged from the Deals custom fields
Value string - -
OrganisationID int Organization → ID -
PersonID int Person → ID -
UserID int User → ID
  • 15 Jan 2020 The options are denormalized - raw values, or foreign keys to complex entities such as Person or Organisation
TimezoneID int - -

OrganizationCustomFieldValueOption

Column Type Relates to Notes
RemoteID string - -
OrganizationCustomFieldValueRemoteID string OrganizationCustomFieldValue → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
OrganizationCustomFieldOptionID string OrganizationCustomFieldOption → ID
  • 29 Jan 2021 Most field values are just a string (ie. the actual value), but some (e.g. multi-choice / set) have the ID field provided
Value string - -
OrganisationID int Organization → ID -
PersonID int Person → ID -
UserID int User → ID
  • 29 Jan 2021 The options are denormalized - raw values, or foreign keys to complex entities such as Person or Organisation
TimezoneID int - -

PersonCustomFieldValueOption

Column Type Relates to Notes
RemoteID string - -
PersonCustomFieldValueRemoteID string PersonCustomFieldValue → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PersonCustomFieldOptionID string PersonCustomFieldOption → ID
  • 10 Feb 2021 Most field values are just a string (ie. the actual value), but some (e.g. multi-choice / set) have the ID field provided
Value string - -
OrganisationID int Organization → ID -
PersonID int Person → ID -
UserID int User → ID
  • 10 Feb 2021 The options are denormalized - raw values, or foreign keys to complex entities such as Person or Organisation
TimezoneID int - -

Need more?

SyncHub lives and breathes APIs and data. Keep exploring using the links below.

Connect your own Pipedrive data Querying Pipedrive using regular SQL