JDBC Driver for Pipedrive

Build 22.0.8462

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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462