Tables

The provider models the data in Pipedrive as a list of tables in a relational database that can be queried using standard SQL statements.

CData ADO.NET Provider for Pipedrive Tables


Name	Description
Activities	[DEPRICATED endpoint, use Activities in PipedriveV2 instead.]Returns all activities assigned to a user, including scheduled calls, meetings, tasks, and their associated deals, persons, and organizations.
ActivityTypes	Returns all activity types defined in the Pipedrive account, including built-in and custom types.
CallLogs	Returns all call logs assigned to a particular user.
DealFields	Returns data about all deal fields.
Deals	[DEPRICATED endpoint, use Deals in PipedriveV2 instead.] Get all deals.
DealsFollowers	Returns the users who follow a specific deal, along with the date each follower was added.
DealsParticipants	Returns the persons participating in a specific deal, along with their contact details and relationship data.
DealsProducts	Returns all products attached to deals, including pricing, quantity, discount, and product catalog details. Supports insert, update, and delete operations.
Files	Returns all files attached to deals, persons, organizations, products, leads, or activities in the Pipedrive account.
Filters	Returns all saved filters defined in the Pipedrive account, including their type, ownership, and visibility settings.
Goals	Returns goals defined in the Pipedrive account, including their type, assignee, tracking metric, expected outcome, and active duration.
LeadLabels	Returns all lead labels used for organizing and categorizing leads.
Leads	Returns all leads in the Pipedrive account, including their associated person, organization, labels, and value details.
MailThreads	Returns mail threads from the connected mail account, ordered by the most recent message, and supports updating read status and deleting threads.
NoteComments	Returns comments associated with a specific note, and supports creating, updating, and deleting those comments.
Notes	Returns all notes associated with deals, persons, organizations, and leads, including content, pinning state, and authorship details.
OrganizationFields	Returns data about all organization fields, including built-in and custom field definitions.
OrganizationRelationships	Returns relationship records between organizations, including parent-child and related-organization associations.
Organizations	[DEPRICATED endpoint, use Organizations in PipedriveV2 instead.] Get details of organizations.
OrganizationsFollowers	Returns the list of followers for a specified organization, including each follower's user ID and the timestamp when the follower was added.
PersonFields	Returns data about all person fields.
PersonFollowers	Returns the list of followers for a specified person, including follower user IDs, associated deal IDs, and the timestamp when each follower was added.
Persons	[DEPRICATED endpoint, use Persons in PipedriveV2 instead.] Get all details of persons.
Pipelines	[DEPRICATED endpoint, use Pipelines in PipedriveV2 instead.] Returns all sales pipelines, including their names, ordering, deal probability settings, and active status.
ProductFields	Returns data about all product fields.
Products	[DEPRICATED endpoint, use Products in PipedriveV2 instead.] Get details of Products.
ProductsFollowers	Returns the users who are following a specific product in Pipedrive, and supports adding and removing followers.
Projects	Returns all projects, including their status, assigned board and phase, linked deals and organizations, and timeline dates.
Roles	Returns all roles defined in the account, including their hierarchy level, assignment counts, and parent-child relationships.
RolesAssignments	List assignments for a role.
RolesSetting	Returns all the roles settings.
Tasks	Returns all tasks within projects, including completion status, due dates, assignees, and parent-child task relationships.
Users	Returns data about all users within the company, including their account status, contact details, role assignments, and access settings.