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 ODBC Driver for Pipedrive Views
| Name | Description |
| ActivitiesAttendees | Returns the list of attendees for each activity, including their email address, name, organizer status, and attendance status. |
| ActivitiesParticipants | Returns the list of participants for each activity, identifying each person linked to the activity and whether they are the primary contact. |
| ActivityFields | Returns all activity fields defined in the Pipedrive account, including both standard and custom field metadata exposed through the Fields API v2. |
| DealsArchived | Returns data about all archived deals. |
| PersonsEmails | Returns all email addresses associated with persons, including the label, value, and whether each address is the primary contact address. |
| PersonsPhone | Returns all phone numbers associated with persons, including the label, value, and whether each number is the primary contact number. |