Tables
The driver models the data in Pipedrive into a list of tables that can be queried using standard SQL statements.
Generally, querying Pipedrive tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. These types of situations are clearly documented at the top of the table page linked below.
CData JDBC Driver for Pipedrive Tables
| Name | Description |
| Activities | Get all Activities assigned to a particular User. |
| ActivityTypes | Get all ActivityTypes. |
| CallLogs | Returns all call logs assigned to a particular user. |
| DealFields | Returns data about all deal fields. |
| Deals | Get all deals |
| DealsFollowers | Get details of deals followers. |
| DealsParticipants | Get details of deals participants. |
| DealsProducts | Get details of deals products. |
| Files | Returns data about all files. |
| Filters | Returns data about all filters. |
| Goals | Goals help your team meet your sales targets. |
| LeadLabels | Returns details of all Lead Labels. |
| Leads | Returns lead data. |
| Notes | Returns all notes. |
| OrganizationFields | Returns data about all organization fields. |
| OrganizationRelationships | Gets all of the relationships. |
| Organizations | Get details of organizations |
| OrganizationsFollowers | Get details of organizations followers. |
| OrganizationsInternal | Get details of organizations. |
| PersonFields | Returns data about all person fields. |
| PersonFollowers | Get details of persons followers. |
| Persons | Get all details of persons |
| PersonsInternal | Get all details of persons. |
| Pipelines | Get all Pipelines. |
| ProductFields | Returns data about all product fields. |
| Products | Get details of Products |
| ProductsFollowers | Get details of products followers. |
| Roles | Returns all the role. |
| RolesAssignments | List assignments for a role. |
| RolesSetting | Returns all the roles settings. |
| Stages | Returns data about all stages. |
| Subscriptions | Returns details of an installment or a recurring Subscription |
| Teams | Returns data about teams within the company |
| TeamsUsers | Usage information for the operation TeamsUsers.rsd. |
| Users | Returns data about all users within the company |