Tables
The provider models the data in Pipedrive as a list of tables in a relational database that can be queried using standard SQL statements.
CData ADO.NET Provider 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. |
| 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. |
| Organizations | Get all organizations. |
| Persons | Get all persons. |
| Pipelines | Returns all pipelines, including configuration, ordering, and deal probability settings. |
| 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. |