Tables
The add-in models the data in Pipedrive as a list of tables in a relational database that can be queried using standard SQL statements.
CData Excel Add-In for Pipedrive Tables
| Name | Description |
| Activities | Returns all activities assigned to the current user, including calls, meetings, tasks, and other scheduled interactions linked to deals, leads, persons, and organizations. |
| DealFields | Returns data about all deal fields, including both standard and custom field definitions for deals exposed through the Fields API v2. |
| DealFieldsOptions | Returns the selectable options for enum and set type deal fields in the Pipedrive V2 API. |
| Deals | Returns all active deals in the Pipedrive account, including their values, ownership, pipeline stage, and associated activity and contact counts. |
| DealsDiscounts | Returns the discounts applied to deals, including the discount type, amount, description, and the users who created and last updated each discount. |
| DealsProducts | Returns all products attached to deals, including pricing, quantity, discount, and billing details for each product-deal attachment. |
| OrganizationFields | Returns data about all organization fields, including both standard and custom field definitions for organizations exposed through the Fields API v2. |
| OrganizationFieldsOptions | Returns the selectable options for enum and set type organization fields in the Pipedrive V2 API. |
| Organizations | Get all organizations. |
| PersonFields | Returns data about all person fields, including both standard and custom field definitions for persons exposed through the Fields API v2. |
| PersonFieldsOptions | Returns the selectable options for enum and set type person fields in the Pipedrive V2 API. |
| Persons | Get all persons. |
| Pipelines | Returns all pipelines, including configuration, ordering, and deal probability settings. |
| ProductFields | Returns data about all product fields, including both standard and custom field definitions for products exposed through the Fields API v2. |
| ProductFieldsOptions | Returns the selectable options for enum and set type product fields in the Pipedrive V2 API. |
| Products | Get all products. |
| ProductVariations | Returns all variations for a given product, including variant names and their associated pricing data. |
| Stages | Returns all pipeline stages, including configuration for deal probability, rotten deal detection, and stage ordering. |