Schema Information
This subtopic provides a structured reference to assist you in working with Daton's Pipedrive connector and the associated fields and tables.
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
- ActivityFields
- Activity_Types
- Currencies
- Deals
- Deals_Fields
- Files
- Filters
- Notes
- Note_Fields
- Persons
- Organizations
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 |
email |
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 |
