JDBC Driver for Pipedrive

Build 22.0.8462

Views

Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Entities that are represented as views are typically read-only entities. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.

Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard.

Dynamic views, such as queries exposed as views, and views for looking up specific combinations of project_team work items are supported.

CData JDBC Driver for Pipedrive Views

Name Description
ActivitiesAttendees Get all Activities assigned to a particular User
ActivitiesParticipants Getdetails of activities participants
ActivityFields Returns all activity fields.
ActivityFieldsOptions Returns all activity fields.
Currencies Returns all supported currencies in given account which should be used when saving monetary values with other objects.
DealFieldsOptions Returns data about all deal fields.
DealsActivities Get all Deals Activities assigned to a particular User.
DealsActivitiesAttendees Get Details of Deals Activities Attendees.
DealsActivitiesParticipants Getdetails of activities participants.
DealsFiles Get details of deals file.
DealsMailMessages Get details of Deal mail Messages.
DealsMailMessagesBcc Get details of Deal mail Messages.
DealsMailMessagesCc Get details of Deal mail Messages.
DealsMailMessagesFrom Get details of Deal mail Messages.
DealsMailMessagesTo Get details of Deal mail Messages.
DealsPermittedUsers Get details of deals Permitted users
DealsPersonEmails Get all emails asscociated with persons in deal
DealsPersonPhone Get all phone asscociated with persons in deal.
DealsPersons Get details of deals persons.
DealsSummary Return detils of deals summary.
DealsTimeline Usage information for the operation DealsTimeline.rsd.
DealsTimelineDeals Return details of DealsTimeline deals.
DealsUpdates Get details of deals updates.
DealsUpdatesAttachments Get details of deals Updates Attachments.
DealsActivitiesAttendees Get Details of Deals Activities Attendees.
DealsUpdatesBcc Get details of Deal updates Bcc.
DealsUpdatesCc Get details of Deals Updates cc.
DealsUpdatesFrom Get details of Deals Updates From.
DealsUpdatesParticipants Getdetails of activities participants.
DealsUpdatesTo Get details of Deals Updates to.
FilterHelpers Returns all supported filter helpers.
LeadSources Returns all Lead Sources.
NoteFields Returns data about all note fields.
OrganizationsActivities Get details of organizations activities.
OrganizationsDeals Get details of organization deals.
OrganizationsDealsPersonEmail get details of deals person email.
OrganizationsDealsPersonphone get details of deals person phone.
OrganizationsFiles Get details of deals file.
OrganizationsMailMessages Get details of organizations mail Messages.
OrganizationsMailMessagesBcc Get details of organizations mail Messages.
OrganizationsMailMessagesCc Get details of organizations mail Messages.
OrganizationsMailMessagesFrom Get details of organizations mail Messages.
OrganizationsMailMessagesTo Get details of organizations mail Messages.
OrganizationsPermittedUsers Get details of permitted users of organizations.
OrganizationsPersons Get details of organizations persons
OrganizationsUpdates Get details of organizations updates..
OrganizationsUpdatesAttendees Get details of all attendees of organizations.
OrganizationsUpdatesParticipants Getdetails of activities participants.
PermissionSets Get all permissions.
PermissionSetsAssignments .
PersonsActivities Get all Persons Activities assigned to a particular Persons.
PersonsActivitiesAttendees Get Details of Persons Activities Attendees.
PersonsActivitiesParticipants Get details of Persons activities participants.
PersonsDeals Get details of Persons deals.
PersonsEmails Get all emails asscociated with persons.
PersonsFiles Get details of Persons file.
PersonsMailMessages Get details of organizations mail Messages.
PersonsMailMessagesBcc Get details of Persons mail Messages.
PersonsMailMessagesCc Get details of persons mail Messages.
PersonsMailMessagesFrom Get details of persons mail Messages.
PersonsMailMessagesTo Get details of Persons mail Messages.
PersonsPhone Get all phone asscociated with persons.
PersonsProducts Get details of Persons Products.
PersonsUpdates Get details of persons updates.
PersonsUpdatesAttendees Get details of Deals Activities Attendees.
PersonsUpdatesParticipants Get details of activities participants
PipelineDeals Lists deals in a specific pipeline across all its stages.
PipelineDealsConversionRates Returns statistics for deals movements for given time period.
PipelineDealsMovements Returns statistics for deals movements for given time period.
PipelineDealsStageConversions Returns statistics for deals movements for given time period
ProductsDeals Get details of Products Deals.
ProductsDealsPersonEmail Get details of Products Deals person email.
ProductsDealsPersonphone Get details of deals person phone.
ProductsFiles Get details of Persons file.
ProductsPrices Get details of Products Prices.
Recents Returns data about all recent changes occurred after given timestamp.
RolesSubRoles Returns all the sub roles.
UserConnection The data of user connections.
UserSettings List settings of an authorized user.
UsersTeams Returns data about all teams which have specified user as a member

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