Views

Views are similar to tables in the way that data is represented; however, views are read-only.

Queries can be executed against a view as if it were a normal table.

CData ADO.NET Provider for Pipedrive Views


Name	Description
ActivityFields	Returns all activity fields defined in the Pipedrive account, including both standard and custom field metadata.
ActivityFieldsOptions	Returns the selectable option values for activity fields that use enumeration or set data types.
Currencies	Returns all supported currencies in given account which should be used when saving monetary values with other objects.
CurrentUsers	Returns data about an authorized user within the company with bound company data: company ID, company name, and domain.
DealFieldsOptions	Returns the selectable options for enum and set type deal fields. Each row represents one option value available for a given deal field.
DealsFiles	Returns all files attached to a specific deal, including metadata such as file name, size, type, and storage location.
DealsMailMessages	Returns mail messages linked to a specific deal, including message metadata, tracking flags, and recipient details.
DealsMailMessagesBcc	Returns the BCC recipients for mail messages linked to a specific deal.
DealsMailMessagesCc	Returns the CC recipients for mail messages linked to a specific deal.
DealsMailMessagesFrom	Returns the sender details for mail messages linked to a specific deal.
DealsMailMessagesTo	Returns the primary recipients for mail messages linked to a specific deal.
DealsParticipantsEmail	Returns the email addresses associated with the person field of each deal participant.
DealsParticipantsPersonEmail	Returns the email addresses from the person_id field of each deal participant record.
DealsParticipantsPersonPhone	Returns the phone numbers from the person_id field of each deal participant record.
DealsParticipantsPhone	Returns the phone numbers associated with the person field of each deal participant.
DealsPermittedUsers	Returns the list of user IDs that have permission to access a specific deal.
DealsSummary	Returns aggregated summary statistics for deals, including total count, converted values, and weighted values, optionally filtered by user, stage, status, or filter.
DealsTimeline	Returns deal timeline data grouped into time intervals, showing deal counts and values for each period based on a specified date field.
DealsTimelineDeals	Returns individual deal records from the deals timeline endpoint, with each row representing a deal that falls within a specified timeline interval.
DealsUpdates	Returns the activity feed updates for a specific deal, including field changes, notes, emails, activities, and other deal events.
DealsUpdatesAttachments	Returns the file attachments associated with activity feed updates for a specific deal.
DealsUpdatesAttendees	Returns the attendees for activity feed updates associated with a specific deal.
DealsUpdatesBcc	Returns the BCC recipients for mail message updates in the activity feed of a specific deal.
DealsUpdatesCc	Returns the CC recipients for mail message updates in the activity feed of a specific deal.
DealsUpdatesFrom	Returns the sender details for mail message updates in the activity feed of a specific deal.
DealsUpdatesParticipants	Returns the participants for activity updates in the activity feed of a specific deal.
DealsUpdatesTo	Returns the primary recipients for mail message updates in the activity feed of a specific deal.
FilterHelpers	Returns all supported filter helper values used when constructing Pipedrive filters, including address field components, operator tokens for each data type, and relative date expressions.
FindUsersByName	Finds users by their name.
LeadPermittedUsers	Get all permitted users for leads in a single company
LeadsArchived	Returns all archived leads from the Pipedrive account, including associated person, organization, label, and value details.
LeadSources	Returns all lead source values available in the Pipedrive account for categorizing the origin of leads.
MailMessages	Returns metadata and status flags for mail threads, including sender and recipient parties, folder assignment, timestamps, and linked deal information.
MailThreadMessages	Returns all individual mail messages within a specified mail thread, including sender, recipient, and status details for each message.
MailThreadMessagesFrom	Returns the sender details for each mail message within a specified mail thread, including email address and linked person information.
MailThreadMessagesTo	Returns the recipient details for each mail message within a specified mail thread, including email address and linked person information.
MailThreadsFrom	Returns sender party details for mail threads, including the email address, linked person, and linked organization for each thread sender.
MailThreadsTo	Returns recipient party details for mail threads, including the email address, linked person, and linked organization for each thread recipient.
NoteFields	Returns data about all note fields.
NoteFieldsOptions	Returns the selectable option values for note fields that use enumeration or set data types.
OrganizationFieldsOptions	Returns the predefined option values for enumeration-type organization fields, including each option's ID and display label.
OrganizationsFiles	Returns files attached to a specified organization, including file metadata and links to associated deals, persons, and products.
OrganizationsMailMessages	Returns mail messages associated with a specified organization, including message metadata, flags, and recipient lists.
OrganizationsMailMessagesBcc	Returns the BCC recipients for mail messages associated with a specified organization.
OrganizationsMailMessagesCc	Returns the CC recipients for mail messages associated with a specified organization.
OrganizationsMailMessagesFrom	Returns the sender records for mail messages associated with a specified organization.
OrganizationsMailMessagesTo	Returns the direct recipients for mail messages associated with a specified organization.
OrganizationsPermittedUsers	Returns the identifiers of users who have permission to access a specified organization.
OrganizationsUpdates	Returns the activity and change history for a specified organization, including details about activities, field changes, notes, files, and other timeline events associated with that organization.
OrganizationsUpdatesAttendees	Returns the attendees of activity update events associated with a specified organization, including each attendee's name, email address, organizer status, and attendance status.
OrganizationsUpdatesParticipants	Returns the participants of activity update events associated with a specified organization, including each participant's person ID and whether they are the primary participant.
PermissionSets	Returns all permission sets defined in the company, including their names, types, and user assignment counts.
PermissionSetsAssignments	Returns the users assigned to a specific permission set, showing which users operate under each set of permissions.
PersonFieldsOptions	Returns the selectable options for enum and set type person fields. Each row represents one option value available for a given person field.
PersonsFiles	Returns all files attached to a specific person in Pipedrive, including file metadata and links to associated deals, organizations, and leads.
PersonsMailMessages	Returns all mail messages associated with a specific person in Pipedrive, including message metadata, recipients, tracking status, and storage details.
PersonsMailMessagesBcc	Returns the BCC recipients from mail messages associated with a specific person in Pipedrive.
PersonsMailMessagesCc	Returns the CC recipients from mail messages associated with a specific person in Pipedrive.
PersonsMailMessagesFrom	Returns the sender details from mail messages associated with a specific person in Pipedrive.
PersonsMailMessagesTo	Returns the primary recipients from mail messages associated with a specific person in Pipedrive.
PersonsPermittedUsers	Returns the list of users who have permission to access a specific person record in Pipedrive.
PersonsProducts	Returns all products linked to deals associated with a specific person in Pipedrive, including full deal and product details.
PersonsUpdates	Returns the activity and change history for a specified person, including details about activities, field changes, notes, files, and other timeline events associated with that person.
PersonsUpdatesAttendees	Returns the attendees of activity update events associated with a specified person, including each attendee's name, email address, organizer status, and attendance status.
PersonsUpdatesParticipants	Returns the participants of activity update events associated with a specified person, including each participant's person ID and whether they are the primary participant.
PipelineDealsConversionRates	Returns deal conversion rate statistics for a specific pipeline over a given time period, including won, lost, and stage-to-stage conversion rates.
PipelineDealsMovements	Returns deal movement statistics for a pipeline over a specified time period, including counts and values for new, won, lost, and open deals.
PipelineDealsMovementsAverageAgeInDaysByStages	Returns the average number of days deals spend in each pipeline stage during the specified time period.
PipelineDealsStageConversions	Returns stage-level deal conversion statistics for a specific pipeline over a given time period, showing the conversion rate between each pair of consecutive stages.
ProductFieldsOptions	Returns the selectable options for enum and set type product fields. Each row represents one option value available for a given product field.
ProductsDeals	Returns all deals that include the specified product, with full deal details including participants, activities, and pipeline information.
ProductsDealsPersonEmail	Returns the email addresses of contact persons associated with deals that include the specified product.
ProductsDealsPersonphone	Returns the phone numbers of contact persons associated with deals that include the specified product.
ProductsFiles	Returns all files attached to the specified product, including file metadata and associated entity references.
ProductsPermittedUsers	Returns the list of users who have permission to access the specified product.
ProductsPrices	Returns the pricing entries for products, including price, cost, currency, and overhead cost per price record.
ProjectTemplates	Get the details of a specific project template.
Recents	Returns data about all recent changes occurred after given timestamp.
RecentsAttendees	Returns the attendee details for activities that have been recently changed, filtered by a specified UTC timestamp.
RecentsParticipants	Returns the participant details for activities that have been recently changed, filtered by a specified UTC timestamp.
RolesPipelinesVisibility	Get the list of either visible or hidden pipeline IDs for a specific role.
UserConnection	Returns the external service connections configured for the current user, such as linked Google account details.
UsersAccess	Returns access details for all users in the company.
UserSettings	List settings of an authorized user.
UsersFollowers	Lists the followers of a specific user.
UsersPermissions	Returns the full set of permission flags for a specific user, indicating which actions the user is authorized to perform within Pipedrive.
UsersRoleAssignments	Lists role assignments for a user.
UsersRoleSettings	Lists the settings of user assigned role.