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 |