DealsFollowers
Returns the users who follow a specific deal, along with the date each follower was added.
Table-Specific Information
SELECT
The provider uses the Pipedrive API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the provider.
| Column | Supported Operators |
| Id | = |
For example, the following query is processed server-side:
SELECT * FROM DealsFollowers WHERE Id = 2
INSERT
Execute INSERT by specifying the Name and IconKey columns. You can also insert any optional columns.
For example:
INSERT INTO DealsFollowers (UserId, Id) VALUES (8230170, 8)
DELETE
Execute DELETE by specifying the Id and DealId in the WHERE clause.
For example:
DELETE FROM DealsFollowers WHERE Id = 1 AND DealId = 1
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Integer | True |
The unique identifier of the follower record. | |
| AddTime | Datetime | True |
The date and time when this user began following the deal. | |
| UserId | Integer | False |
Users.Id |
The unique identifier of the user following the deal. |
| DealId [KEY] | Integer | False |
Deals.Id |
The unique identifier of the deal being followed. |