Tables
The driver models the data in Pipedrive as a list of tables in a relational database that can be queried using standard SQL statements.
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. |
| MailThreads | Get, Update and Delete mail threads in a specified folder ordered by the most recent message within. |
| NoteComments | Create, Update, Delete and Get the comments associated with a note. |
| 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. |
| PersonFields | Returns data about all person fields. |
| PersonFollowers | Get details of persons followers. |
| Persons | 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. |
| Projects | Get all projects data. |
| Roles | Returns all the role. |
| RolesAssignments | List assignments for a role. |
| RolesSetting | Returns all the roles settings. |
| Stages | Returns data about all stages. |
| Tasks | Get all tasks data. |
| Users | Returns data about all users within the company |