# Schema Information

## Tables/APIs 

The following is the list of tables or APIs associated with the Pipedrive connector:

* [Activities](#activities) 
* [ActivityFields](#activityfields) 
* [Activity\_Types](#activity_types) 
* [Currencies](#currencies) 
* [Deals](#deals) 
* [Deals\_Fields](#deals_fields) 
* [Files](https://daton-sarasanalytics.gitbook.io/daton/integrations/data-sources/files) 
* [Filters](#filters) 
* [Notes](#notes) 
* [Note\_Fields](#notes_fields) 
* [Persons](#persons) 
* [Organizations](#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](https://developers.pipedrive.com/docs/api/v1/Activities#getActivities).

**FIELDS**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>done</td><td>BOOLEAN</td></tr><tr><td>type</td><td>STRING</td></tr><tr><td>subject</td><td>STRING</td></tr><tr><td>company_id</td><td>NUMERIC</td></tr><tr><td>user_id</td><td>NUMERIC</td></tr><tr><td>due_date</td><td>DATE</td></tr><tr><td>busy_flag</td><td>BOOLEAN</td></tr><tr><td>add_time</td><td>DATETIME</td></tr><tr><td>marked_as_done_time</td><td>DATETIME</td></tr><tr><td>org_id</td><td>NUMERIC</td></tr><tr><td>person_id</td><td>NUMERIC</td></tr><tr><td>deal_id</td><td>NUMERIC</td></tr><tr><td>active_flag</td><td>BOOLEAN</td></tr><tr><td>update_time</td><td>DATETIME</td></tr></tbody></table>

### ActivityFields&#x20;

Access a list of custom fields associated with activities, providing additional details and customization options.

For more information, see [ActivityFields](https://developers.pipedrive.com/docs/api/v1/ActivityFields).

**FIELDS**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>key</td><td>STRING</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>order_nr</td><td>NUMERIC</td></tr><tr><td>field_type</td><td>STRING</td></tr><tr><td>json_column_flag</td><td>BOOLEAN</td></tr><tr><td>add_time</td><td>DATETIME</td></tr><tr><td>update_time</td><td>DATETIME</td></tr><tr><td>edit_flag</td><td>BOOLEAN</td></tr><tr><td>details_visible_flag</td><td>BOOLEAN</td></tr><tr><td>add_visible_flag</td><td>BOOLEAN</td></tr><tr><td>important_flag</td><td>BOOLEAN</td></tr><tr><td>bulk_edit_allowed</td><td>BOOLEAN</td></tr><tr><td>filtering_allowed</td><td>BOOLEAN</td></tr><tr><td>sortable_flag</td><td>BOOLEAN</td></tr><tr><td>searchable_flag</td><td>BOOLEAN</td></tr><tr><td>active_flag</td><td>BOOLEAN</td></tr><tr><td>mandatory_flag</td><td>BOOLEAN</td></tr><tr><td>options</td><td>RECORD</td></tr><tr><td>is_subfield</td><td>BOOLEAN</td></tr><tr><td>parent_id</td><td>NUMERIC</td></tr><tr><td>id_suffix</td><td>STRING</td></tr></tbody></table>

### Activity\_Types&#x20;

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](https://developers.pipedrive.com/docs/api/v1/ActivityTypes).

**FIELDS**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>order_nr</td><td>NUMERIC</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>key_string</td><td>STRING</td></tr><tr><td>icon_key</td><td>STRING</td></tr><tr><td>active_flag</td><td>BOOLEAN</td></tr><tr><td>is_custom_flag</td><td>BOOLEAN</td></tr><tr><td>add_time</td><td>DATETIME</td></tr></tbody></table>

### Currencies&#x20;

Access information on currencies used in Pipedrive, facilitating accurate representation and conversion of deal values.

For more information, see [Currencies](https://developers.pipedrive.com/docs/api/v1/Currencies).

**FIELDS**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>code</td><td>STRING</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>symbol</td><td>STRING</td></tr><tr><td>decimal_points</td><td>NUMERIC</td></tr><tr><td>active_flag</td><td>BOOLEAN</td></tr><tr><td>is_custom_flag</td><td>BOOLEAN</td></tr></tbody></table>

### Deals&#x20;

Retrieve details about deals in Pipedrive, including information about deal stages, associated contacts, and relevant activities.

For more information, see [Deals](https://developers.pipedrive.com/docs/api/v1/Deals).

**FIELDS**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>creator_user_id</td><td>NUMERIC</td></tr><tr><td>user_id</td><td>NUMERIC</td></tr><tr><td>person_id</td><td>NUMERIC</td></tr><tr><td>org_id</td><td>NUMERIC</td></tr><tr><td>stage_id</td><td>NUMERIC</td></tr><tr><td>title</td><td>STRING</td></tr><tr><td>value</td><td>NUMERIC</td></tr><tr><td>currency</td><td>STRING</td></tr><tr><td>add_time</td><td>DATETIME</td></tr><tr><td>update_time</td><td>DATETIME</td></tr><tr><td>status</td><td>STRING</td></tr><tr><td>visible_to</td><td>STRING</td></tr><tr><td>pipeline_id</td><td>NUMERIC</td></tr><tr><td>expected_close_date</td><td>DATE</td></tr><tr><td>close_time</td><td>DATETIME</td></tr><tr><td>lost_time</td><td>DATETIME</td></tr><tr><td>won_time</td><td>DATETIME</td></tr></tbody></table>

### Deals\_Fields&#x20;

Access a list of custom fields associated with deals, providing additional customization options for deal-related information.

For more information, see [Deals\_Fields](https://developers.pipedrive.com/docs/api/v1/DealFields).

**FIELDS**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>key</td><td>STRING</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>order_nr</td><td>NUMERIC</td></tr><tr><td>field_type</td><td>STRING</td></tr><tr><td>json_column_flag</td><td>BOOLEAN</td></tr><tr><td>add_time</td><td>DATETIME</td></tr><tr><td>edit_flag</td><td>BOOLEAN</td></tr><tr><td>details_visible_flag</td><td>BOOLEAN</td></tr><tr><td>add_visible_flag</td><td>BOOLEAN</td></tr><tr><td>important_flag</td><td>BOOLEAN</td></tr><tr><td>bulk_edit_allowed</td><td>BOOLEAN</td></tr><tr><td>filtering_allowed</td><td>BOOLEAN</td></tr><tr><td>sortable_flag</td><td>BOOLEAN</td></tr><tr><td>searchable_flag</td><td>BOOLEAN</td></tr><tr><td>active_flag</td><td>BOOLEAN</td></tr><tr><td>projects_detail_visible_flag</td><td>BOOLEAN</td></tr><tr><td>show_in_pipelines</td><td>RECORD</td></tr><tr><td>mandatory_flag</td><td>RECORD</td></tr><tr><td>mandatory_flag_bl</td><td>BOOLEAN</td></tr><tr><td>update_time</td><td>DATETIME</td></tr><tr><td>last_updated_by_user_id</td><td>NUMERIC</td></tr><tr><td>options</td><td>RECORD</td></tr></tbody></table>

### Files&#x20;

Retrieve information about files attached to items in Pipedrive, facilitating access to relevant documentation or media.

For more information, see [Files](https://developers.pipedrive.com/docs/api/v1/Files).

**FIELDS**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>user_id</td><td>NUMERIC</td></tr><tr><td>add_time</td><td>DATETIME</td></tr><tr><td>update_time</td><td>DATETIME</td></tr><tr><td>file_name</td><td>STRING</td></tr><tr><td>active_flag</td><td>BOOLEAN</td></tr><tr><td>inline_flag</td><td>BOOLEAN</td></tr><tr><td>remote_location</td><td>STRING</td></tr><tr><td>remote_id</td><td>STRING</td></tr><tr><td>url</td><td>STRING</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>file_type</td><td>STRING</td></tr></tbody></table>

### Filters&#x20;

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](https://developers.pipedrive.com/docs/api/v1/Filters).

**FIELDS**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>active_flag</td><td>BOOLEAN</td></tr><tr><td>type</td><td>STRING</td></tr><tr><td>user_id</td><td>NUMERIC</td></tr><tr><td>add_time</td><td>DATETIME</td></tr><tr><td>visible_to</td><td>STRING</td></tr></tbody></table>

### Notes&#x20;

Retrieve information about notes added to items in Pipedrive, offering insights into additional context or updates.

For more information, see [Notes](https://developers.pipedrive.com/docs/api/v1/Notes).

**FIELDS**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>user_id</td><td>NUMERIC</td></tr><tr><td>deal_id</td><td>NUMERIC</td></tr><tr><td>person_id</td><td>NUMERIC</td></tr><tr><td>org_id</td><td>NUMERIC</td></tr><tr><td>content</td><td>STRING</td></tr><tr><td>add_time</td><td>DATETIME</td></tr><tr><td>update_time</td><td>DATETIME</td></tr><tr><td>active_flag</td><td>BOOLEAN</td></tr><tr><td>pinned_to_deal_flag</td><td>BOOLEAN</td></tr><tr><td>pinned_to_person_flag</td><td>BOOLEAN</td></tr><tr><td>pinned_to_organization_flag</td><td>BOOLEAN</td></tr><tr><td>pinned_to_lead_flag</td><td>BOOLEAN</td></tr><tr><td>organization</td><td>RECORD</td></tr><tr><td>person</td><td>RECORD</td></tr><tr><td>deal</td><td>RECORD</td></tr><tr><td>user</td><td>RECORD</td></tr></tbody></table>

### Notes\_Fields&#x20;

Access a list of custom fields associated with notes, providing additional customization options for note-related information.

For more information, see [Note\_Fields](https://developers.pipedrive.com/docs/api/v1/NoteFields).

**FIELDS**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>key</td><td>STRING</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>order_nr</td><td>NUMERIC</td></tr><tr><td>field_type</td><td>STRING</td></tr><tr><td>json_column_flag</td><td>BOOLEAN</td></tr><tr><td>add_time</td><td>DATETIME</td></tr><tr><td>edit_flag</td><td>BOOLEAN</td></tr><tr><td>searchable_flag</td><td>BOOLEAN</td></tr><tr><td>active_flag</td><td>BOOLEAN</td></tr><tr><td>mandatory_flag</td><td>BOOLEAN</td></tr><tr><td>options</td><td>RECORD</td></tr></tbody></table>

### Persons&#x20;

Retrieve details about individuals (persons) associated with deals or contacts in Pipedrive, including contact information and associated deals.

For more information, see [Persons](https://developers.pipedrive.com/docs/api/v1/Persons).

**FIELDS**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>company_id</td><td>NUMERIC</td></tr><tr><td>owner_id</td><td>RECORD</td></tr><tr><td>org_id</td><td>RECORD</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>first_name</td><td>STRING</td></tr><tr><td>last_name</td><td>STRING</td></tr><tr><td>open_deals_count</td><td>NUMERIC</td></tr><tr><td>related_open_deals_count</td><td>NUMERIC</td></tr><tr><td>closed_deals_count</td><td>NUMERIC</td></tr><tr><td>related_closed_deals_count</td><td>NUMERIC</td></tr><tr><td>participant_open_deals_count</td><td>NUMERIC</td></tr><tr><td>participant_closed_deals_count</td><td>NUMERIC</td></tr><tr><td>email_messages_count</td><td>NUMERIC</td></tr><tr><td>activities_count</td><td>NUMERIC</td></tr><tr><td>done_activities_count</td><td>NUMERIC</td></tr><tr><td>undone_activities_count</td><td>NUMERIC</td></tr><tr><td>files_count</td><td>NUMERIC</td></tr><tr><td>notes_count</td><td>NUMERIC</td></tr><tr><td>followers_count</td><td>NUMERIC</td></tr><tr><td>won_deals_count</td><td>NUMERIC</td></tr><tr><td>related_won_deals_count</td><td>NUMERIC</td></tr><tr><td>lost_deals_count</td><td>NUMERIC</td></tr><tr><td>related_lost_deals_count</td><td>NUMERIC</td></tr><tr><td>active_flag</td><td>BOOLEAN</td></tr><tr><td>phone</td><td>RECORD</td></tr><tr><td>email</td><td>RECORD</td></tr><tr><td>first_char</td><td>STRING</td></tr><tr><td>update_time</td><td>DATETIME</td></tr><tr><td>add_time</td><td>DATETIME</td></tr><tr><td>visible_to</td><td>STRING</td></tr><tr><td>last_activity_id</td><td>NUMERIC</td></tr><tr><td>last_activity_date</td><td>DATE</td></tr><tr><td>org_name</td><td>STRING</td></tr><tr><td>owner_name</td><td>STRING</td></tr><tr><td>primary_email</td><td>STRING</td></tr><tr><td>cc_email</td><td>STRING</td></tr><tr><td>next_activity_date</td><td>DATE</td></tr><tr><td>next_activity_id</td><td>NUMERIC</td></tr></tbody></table>

### Organizations&#x20;

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](https://developers.pipedrive.com/docs/api/v1/Organizations).

**FIELDS**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>owner_id</td><td>NUMERIC</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>active_flag</td><td>BOOLEAN</td></tr><tr><td>update_time</td><td>DATETIME</td></tr><tr><td>add_time</td><td>STRING</td></tr><tr><td>visible_to</td><td>STRING</td></tr><tr><td>address</td><td>STRING</td></tr><tr><td>address_admin_area_level_1</td><td>STRING</td></tr><tr><td>address_country</td><td>STRING</td></tr><tr><td>address_formatted_address</td><td>STRING</td></tr><tr><td>cc_email</td><td>STRING</td></tr><tr><td>address_locality</td><td>STRING</td></tr><tr><td>address_postal_code</td><td>STRING</td></tr><tr><td>address_admin_area_level_2</td><td>STRING</td></tr><tr><td>address_sublocality</td><td>STRING</td></tr><tr><td>address_route</td><td>STRING</td></tr><tr><td>address_street_number</td><td>STRING</td></tr></tbody></table>