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

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 - -

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 - -

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 - -

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 - -

ActivityV2

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 - -
Subject string - -
Type string - -
OwnerID int User → ID -
CreatorUserID int User → ID -
DealID int DealV2 → ID -
LeadID guid Lead → ID -
PersonID int PersonV2 → ID -
OrgID int OrganizationV2 → ID -
ProjectID int - -
DueDate string - -
DueTime string - -
Duration string - -
Busy boolean - -
Done boolean - -
MarkedAsDoneTime datetime - -
ConferenceMeetingClient string - -
ConferenceMeetingUrl string - -
ConferenceMeetingID string - -
PublicDescription string - -
Priority int - -
Note string - -
LocationValue string - -
LocationCountry string - -
LocationAdminAreaLevel1 string - -
LocationAdminAreaLevel2 string - -
LocationLocality string - -
LocationSublocality string - -
LocationRoute string - -
LocationStreetNumber string - -
LocationPostalCode string - -
AddTime datetime - -
UpdateTime datetime - -

PersonCustomFieldV2

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 - -
Description string - -
FieldName string - -
FieldCode string - -
FieldType string - -
IsCustomField boolean - -
IsOptionalResponseField boolean - -
AddVisibleFlag boolean - -
DetailsVisibleFlag boolean - -
ShowInAddDealDialog boolean - -
AddDealDialogOrder int - -
ImportantFieldsEnabled boolean - -
RequiredFieldsEnabled boolean - -

DealCustomFieldV2

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 - -
Description string - -
FieldName string - -
FieldCode string - -
FieldType string - -
IsCustomField boolean - -
IsOptionalResponseField boolean - -
AddVisibleFlag boolean - -
DetailsVisibleFlag boolean - -
ShowInAddDealDialog boolean - -
AddDealDialogOrder int - -
ImportantFieldsEnabled boolean - -
RequiredFieldsEnabled boolean - -

OrganizationCustomFieldV2

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 - -
Description string - -
FieldName string - -
FieldCode string - -
FieldType string - -
IsCustomField boolean - -
IsOptionalResponseField boolean - -
AddVisibleFlag boolean - -
DetailsVisibleFlag boolean - -
ShowInAddDealDialog boolean - -
AddDealDialogOrder int - -
ImportantFieldsEnabled boolean - -
RequiredFieldsEnabled boolean - -

ProductCustomFieldV2

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

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
FieldName string - -
FieldCode string - -
FieldType string - -
IsCustomField boolean - -
IsOptionalResponseField boolean - -
AddVisibleFlag boolean - -
DetailsVisibleFlag boolean - -
ShowInAddDealDialog boolean - -
AddDealDialogOrder int - -
ImportantFieldsEnabled boolean - -
RequiredFieldsEnabled boolean - -

DealV2

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

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
PipelineID int PipelineV2 → ID -
CreatorUserID int User → ID -
OwnerID int User → ID -
PersonID int PersonV2 → ID -
OrgID int OrganizationV2 → ID -
StageID int - -
Title string - -
ArchiveTime datetime - -
StageChangeTime datetime - -
CloseTime datetime - -
WonTime datetime - -
LostTime datetime - -
IsArchived boolean - -
Value decimal - -
Probability decimal - -
Acv decimal - -
Arr decimal - -
Mrr decimal - -
Currency string - -
Status string - -
LostReason string - -
Origin string - -
OriginID string - -
ChannelID string - -
Channel string - -
VisibleTo int - -
LocalWonDate string - -
LocalLostDate string - -
LocalCloseDate string - -
ExpectedCloseDate string - -
AddTime datetime - -
UpdateTime datetime - -

DealV2ModificationHistory

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

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

DealV2Product

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

Column Type Relates to Notes
RemoteID string - -
DealV2RemoteID string DealV2 → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Name string - -
DealID int DealV2 → ID -
ProductID int ProductV2 → 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 int - -
ProductVariationID int - -
ItemPrice decimal - -
Discount decimal - -
Quantity decimal - -
Comments string - -
Currency string - -
TaxMethod string - -
DiscountType string - -
BillingFrequency string - -
BillingFrequencyCycles string - -
IsEnabled boolean - -
AddTime datetime - -
UpdateTime datetime - -

OrganizationV2

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 - -
OwnerID int User → ID -
OrgID int OrganizationV2 → ID -
VisibleTo int - -
AddressValue string - -
AddressCountry string - -
AddressAdminAreaLevel1 string - -
AddressAdminAreaLevel2 string - -
AddressLocality string - -
AddressSublocality string - -
AddressRoute string - -
AddressStreetNumber string - -
AddressPostalCode string - -
AddTime datetime - -
UpdateTime datetime - -

PersonV2

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 - -
FirstName string - -
LastName string - -
Notes string - -
Birthday string - -
JobTitle string - -
VisibleTo int - -
PictureID int - -
OwnerID int User → ID -
OrgID int OrganizationV2 → ID -
PostalAddressValue string - -
PostalAddressCountry string - -
PostalAddressAdminAreaLevel1 string - -
PostalAddressAdminAreaLevel2 string - -
PostalAddressLocality string - -
PostalAddressSublocality string - -
PostalAddressRoute string - -
PostalAddressStreetNumber string - -
PostalAddressPostalCode string - -
AddTime datetime - -
UpdateTime datetime - -

PipelineV2

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 - -
IsDealProbabilityEnabled boolean - -
OrderNr int - -
AddTime datetime - -
UpdateTime datetime - -

ProductV2

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 - -
OrderNr int - -
OwnerID int User → ID -
Code string - -
Unit string - -
IsLinkable boolean - -
AddTime datetime - -
UpdateTime datetime - -

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 -

ActivityV2Attendee

Column Type Relates to Notes
RemoteID string - -
ActivityV2RemoteID string ActivityV2 → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ActivityV2ID int ActivityV2 → ID -
PersonID int PersonV2 → ID -
Primary boolean - -

ActivityV2Participant

Column Type Relates to Notes
RemoteID string - -
ActivityV2RemoteID string ActivityV2 → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ActivityV2ID int ActivityV2 → ID -
PersonID int PersonV2 → ID -
IsOrganizer boolean - -

PersonCustomFieldV2Option

Column Type Relates to Notes
RemoteID string - -
PersonCustomFieldV2RemoteID string PersonCustomFieldV2 → 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
PersonCustomFieldCode string PersonCustomFieldV2 → FieldCode -
Label string - -
Color string - -

PersonCustomFieldV2Subfield

Column Type Relates to Notes
RemoteID string - -
PersonCustomFieldV2RemoteID string PersonCustomFieldV2 → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PersonCustomFieldV2Code string PersonCustomFieldV2 → FieldCode -
FieldName string - -
FieldCode string - -
FieldType string - -

PersonCustomFieldV2ImportantFieldStage

Column Type Relates to Notes
RemoteID string - -
PersonCustomFieldV2RemoteID string PersonCustomFieldV2 → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PersonCustomFieldCode string PersonCustomFieldV2 → FieldCode -
StageID int Stage → ID -

DealCustomFieldV2Option

Column Type Relates to Notes
RemoteID string - -
DealCustomFieldV2RemoteID string DealCustomFieldV2 → 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
DealCustomFieldCode string DealCustomFieldV2 → FieldCode -
Label string - -
Color string - -

DealCustomFieldV2Subfield

Column Type Relates to Notes
RemoteID string - -
DealCustomFieldV2RemoteID string DealCustomFieldV2 → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
DealCustomFieldV2Code string DealCustomFieldV2 → FieldCode -
FieldName string - -
FieldCode string - -
FieldType string - -

DealCustomFieldV2ImportantFieldStage

Column Type Relates to Notes
RemoteID string - -
DealCustomFieldV2RemoteID string DealCustomFieldV2 → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
DealCustomFieldCode string DealCustomFieldV2 → FieldCode -
StageID int Stage → ID -

OrganizationCustomFieldV2Option

Column Type Relates to Notes
RemoteID string - -
OrganizationCustomFieldV2RemoteID string OrganizationCustomFieldV2 → 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
OrganizationCustomFieldCode string OrganizationCustomFieldV2 → FieldCode -
Label string - -
Color string - -

OrganizationCustomFieldV2Subfield

Column Type Relates to Notes
RemoteID string - -
OrganizationCustomFieldV2RemoteID string OrganizationCustomFieldV2 → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
OrganizationCustomFieldV2Code string OrganizationCustomFieldV2 → FieldCode -
FieldName string - -
FieldCode string - -
FieldType string - -

OrganizationCustomFieldV2ImportantFieldStage

Column Type Relates to Notes
RemoteID string - -
OrganizationCustomFieldV2RemoteID string OrganizationCustomFieldV2 → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
OrganizationCustomFieldCode string OrganizationCustomFieldV2 → FieldCode -
StageID int Stage → ID -

ProductCustomFieldV2Option

Column Type Relates to Notes
RemoteID string - -
ProductCustomFieldV2RemoteID string ProductCustomFieldV2 → 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
ProductCustomFieldCode string ProductCustomFieldV2 → FieldCode -
Label string - -
Color string - -

ProductCustomFieldV2Subfield

Column Type Relates to Notes
RemoteID string - -
ProductCustomFieldV2RemoteID string ProductCustomFieldV2 → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ProductCustomFieldV2Code string ProductCustomFieldV2 → FieldCode -
FieldName string - -
FieldCode string - -
FieldType string - -

ProductCustomFieldV2ImportantFieldStage

Column Type Relates to Notes
RemoteID string - -
ProductCustomFieldV2RemoteID string ProductCustomFieldV2 → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ProductCustomFieldCode string ProductCustomFieldV2 → FieldCode -
StageID int Stage → ID -

DealV2Label

Column Type Relates to Notes
RemoteID string - -
DealV2RemoteID string DealV2 → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
DealV2ID int DealV2 → ID -
LabelID string DealCustomFieldOption → ID -

DealV2CustomFieldValue

Column Type Relates to Notes
RemoteID string - -
DealV2RemoteID string DealV2 → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
DealV2ID int DealV2 → ID -
FieldCode string DealCustomFieldV2 → FieldCode -
Value string - -
DecimalValue decimal - -
DateValue datetime - -

OrganizationV2Label

Column Type Relates to Notes
RemoteID string - -
OrganizationV2RemoteID string OrganizationV2 → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
OrganizationV2ID int OrganizationV2 → ID -
LabelID string OrganizationCustomFieldV2Option → ID -

OrganizationV2CustomFieldValue

Column Type Relates to Notes
RemoteID string - -
OrganizationV2RemoteID string OrganizationV2 → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
OrganizationV2ID int OrganizationV2 → ID -
FieldCode string OrganizationCustomFieldV2 → FieldCode -
Value string - -
DecimalValue decimal - -
DateValue datetime - -

PersonV2Phone

Column Type Relates to Notes
RemoteID string - -
PersonV2RemoteID string PersonV2 → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Label string - -
Primary boolean - -
Value string - -
PersonV2ID int PersonV2 → ID -

PersonV2Email

Column Type Relates to Notes
RemoteID string - -
PersonV2RemoteID string PersonV2 → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Label string - -
Primary boolean - -
Value string - -
PersonV2ID int PersonV2 → ID -

PersonV2IM

Column Type Relates to Notes
RemoteID string - -
PersonV2RemoteID string PersonV2 → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Label string - -
Primary boolean - -
Value string - -
PersonV2ID int PersonV2 → ID -

PersonV2Label

Column Type Relates to Notes
RemoteID string - -
PersonV2RemoteID string PersonV2 → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PersonV2ID int PersonV2 → ID -
LabelID string PersonCustomFieldV2Option → ID -

PersonCustomFieldV2Value

Column Type Relates to Notes
RemoteID string - -
PersonV2RemoteID string PersonV2 → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PersonV2ID int PersonV2 → ID -
FieldCode string PersonCustomFieldV2 → FieldCode -
Value string - -
DecimalValue decimal - -
DateValue datetime - -

ProductV2CustomFieldValue

Column Type Relates to Notes
RemoteID string - -
ProductV2RemoteID string ProductV2 → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ProductV2ID int ProductV2 → ID -
FieldCode string ProductCustomFieldV2 → FieldCode -
Value string - -
DecimalValue decimal - -
DateValue datetime - -

ProductV2Price

Column Type Relates to Notes
RemoteID string - -
ProductV2RemoteID string ProductV2 → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ProductID int ProductV2 → ID -
Iterator int - -
Price decimal - -
Cost decimal - -
DirectCost decimal - -
Currency string - -
Notes string - -

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 - -

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