Schema Information
This subtopic provides a structured reference to assist you in working with Daton's Pipedrive connector and the associated fields and tables.
Tables/APIs
The following is the list of tables or APIs associated with the Pipedrive connector:
Activities
Retrieve information about activities in Pipedrive, including details such as activity type, due date, and associated deals or contacts.
For more information, see Activities.
FIELDS
| Field Name | Data Type |
|---|---|
id | NUMERIC |
done | BOOLEAN |
type | STRING |
subject | STRING |
company_id | NUMERIC |
user_id | NUMERIC |
due_date | DATE |
busy_flag | BOOLEAN |
add_time | DATETIME |
marked_as_done_time | DATETIME |
org_id | NUMERIC |
person_id | NUMERIC |
deal_id | NUMERIC |
active_flag | BOOLEAN |
update_time | DATETIME |
ActivityFields
Access a list of custom fields associated with activities, providing additional details and customization options.
For more information, see ActivityFields.
FIELDS
| Field Name | Data Type |
|---|---|
id | NUMERIC |
key | STRING |
name | STRING |
order_nr | NUMERIC |
field_type | STRING |
json_column_flag | BOOLEAN |
add_time | DATETIME |
update_time | DATETIME |
edit_flag | BOOLEAN |
details_visible_flag | BOOLEAN |
add_visible_flag | BOOLEAN |
important_flag | BOOLEAN |
bulk_edit_allowed | BOOLEAN |
filtering_allowed | BOOLEAN |
sortable_flag | BOOLEAN |
searchable_flag | BOOLEAN |
active_flag | BOOLEAN |
mandatory_flag | BOOLEAN |
options | RECORD |
is_subfield | BOOLEAN |
parent_id | NUMERIC |
id_suffix | STRING |
Activity_Types
Retrieve a list of activity types available in Pipedrive, offering insights into the various types of activities users can log.
For more information, see Activity_Types.
FIELDS
| Field Name | Data Type |
|---|---|
id | NUMERIC |
order_nr | NUMERIC |
name | STRING |
key_string | STRING |
icon_key | STRING |
active_flag | BOOLEAN |
is_custom_flag | BOOLEAN |
add_time | DATETIME |
Currencies
Access information on currencies used in Pipedrive, facilitating accurate representation and conversion of deal values.
For more information, see Currencies.
FIELDS
| Field Name | Data Type |
|---|---|
id | NUMERIC |
code | STRING |
name | STRING |
symbol | STRING |
decimal_points | NUMERIC |
active_flag | BOOLEAN |
is_custom_flag | BOOLEAN |
Deals
Retrieve details about deals in Pipedrive, including information about deal stages, associated contacts, and relevant activities.
For more information, see Deals.
FIELDS
| Field Name | Data Type |
|---|---|
id | NUMERIC |
creator_user_id | NUMERIC |
user_id | NUMERIC |
person_id | NUMERIC |
org_id | NUMERIC |
stage_id | NUMERIC |
title | STRING |
value | NUMERIC |
currency | STRING |
add_time | DATETIME |
update_time | DATETIME |
status | STRING |
visible_to | STRING |
pipeline_id | NUMERIC |
expected_close_date | DATE |
close_time | DATETIME |
lost_time | DATETIME |
won_time | DATETIME |
Deals_Fields
Access a list of custom fields associated with deals, providing additional customization options for deal-related information.
For more information, see Deals_Fields.
FIELDS
| Field Name | Data Type |
|---|---|
id | NUMERIC |
key | STRING |
name | STRING |
order_nr | NUMERIC |
field_type | STRING |
json_column_flag | BOOLEAN |
add_time | DATETIME |
edit_flag | BOOLEAN |
details_visible_flag | BOOLEAN |
add_visible_flag | BOOLEAN |
important_flag | BOOLEAN |
bulk_edit_allowed | BOOLEAN |
filtering_allowed | BOOLEAN |
sortable_flag | BOOLEAN |
searchable_flag | BOOLEAN |
active_flag | BOOLEAN |
projects_detail_visible_flag | BOOLEAN |
show_in_pipelines | RECORD |
mandatory_flag | RECORD |
mandatory_flag_bl | BOOLEAN |
update_time | DATETIME |
last_updated_by_user_id | NUMERIC |
options | RECORD |
Files
Retrieve information about files attached to items in Pipedrive, facilitating access to relevant documentation or media.
For more information, see Files.
FIELDS
| Field Name | Data Type |
|---|---|
id | NUMERIC |
user_id | NUMERIC |
add_time | DATETIME |
update_time | DATETIME |
file_name | STRING |
active_flag | BOOLEAN |
inline_flag | BOOLEAN |
remote_location | STRING |
remote_id | STRING |
url | STRING |
name | STRING |
file_type | STRING |
Filters
Access and manage filters used in Pipedrive to organize and categorize deals, contacts, or other items based on specific criteria.
For more information, see Filters.
FIELDS
| Field Name | Data Type |
|---|---|
id | NUMERIC |
name | STRING |
active_flag | BOOLEAN |
type | STRING |
user_id | NUMERIC |
add_time | DATETIME |
visible_to | STRING |
Notes
Retrieve information about notes added to items in Pipedrive, offering insights into additional context or updates.
For more information, see Notes.
FIELDS
| Field Name | Data Type |
|---|---|
id | NUMERIC |
user_id | NUMERIC |
deal_id | NUMERIC |
person_id | NUMERIC |
org_id | NUMERIC |
content | STRING |
add_time | DATETIME |
update_time | DATETIME |
active_flag | BOOLEAN |
pinned_to_deal_flag | BOOLEAN |
pinned_to_person_flag | BOOLEAN |
pinned_to_organization_flag | BOOLEAN |
pinned_to_lead_flag | BOOLEAN |
organization | RECORD |
person | RECORD |
deal | RECORD |
user | RECORD |
Notes_Fields
Access a list of custom fields associated with notes, providing additional customization options for note-related information.
For more information, see Note_Fields.
FIELDS
| Field Name | Data Type |
|---|---|
id | NUMERIC |
key | STRING |
name | STRING |
order_nr | NUMERIC |
field_type | STRING |
json_column_flag | BOOLEAN |
add_time | DATETIME |
edit_flag | BOOLEAN |
searchable_flag | BOOLEAN |
active_flag | BOOLEAN |
mandatory_flag | BOOLEAN |
options | RECORD |
Persons
Retrieve details about individuals (persons) associated with deals or contacts in Pipedrive, including contact information and associated deals.
For more information, see Persons.
FIELDS
| Field Name | Data Type |
|---|---|
id | NUMERIC |
company_id | NUMERIC |
owner_id | RECORD |
org_id | RECORD |
name | STRING |
first_name | STRING |
last_name | STRING |
open_deals_count | NUMERIC |
related_open_deals_count | NUMERIC |
closed_deals_count | NUMERIC |
related_closed_deals_count | NUMERIC |
participant_open_deals_count | NUMERIC |
participant_closed_deals_count | NUMERIC |
email_messages_count | NUMERIC |
activities_count | NUMERIC |
done_activities_count | NUMERIC |
undone_activities_count | NUMERIC |
files_count | NUMERIC |
notes_count | NUMERIC |
followers_count | NUMERIC |
won_deals_count | NUMERIC |
related_won_deals_count | NUMERIC |
lost_deals_count | NUMERIC |
related_lost_deals_count | NUMERIC |
active_flag | BOOLEAN |
phone | RECORD |
RECORD | |
first_char | STRING |
update_time | DATETIME |
add_time | DATETIME |
visible_to | STRING |
last_activity_id | NUMERIC |
last_activity_date | DATE |
org_name | STRING |
owner_name | STRING |
primary_email | STRING |
cc_email | STRING |
next_activity_date | DATE |
next_activity_id | NUMERIC |
Organizations
Access information about organizations associated with deals or contacts in Pipedrive, including details such as organization name and associated deals.
For more information, see Organizations.
FIELDS
| Field Name | Data Type |
|---|---|
id | NUMERIC |
owner_id | NUMERIC |
name | STRING |
active_flag | BOOLEAN |
update_time | DATETIME |
add_time | STRING |
visible_to | STRING |
address | STRING |
address_admin_area_level_1 | STRING |
address_country | STRING |
address_formatted_address | STRING |
cc_email | STRING |
address_locality | STRING |
address_postal_code | STRING |
address_admin_area_level_2 | STRING |
address_sublocality | STRING |
address_route | STRING |
address_street_number | STRING |
Last updated