ProductsFollowers
Returns the users who are following a specific product in Pipedrive, and supports adding and removing followers.
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 |
| ProductId | = |
For example, the following query is processed server-side:
SELECT * FROM ProductsFollowers WHERE ProductId = 6
INSERT
Execute INSERT by specifying the UserId and ProductId columns. You can also insert any columns that are not required.
INSERT INTO ProductsFollowers (UserId, ProductId) VALUES (8230170, 1)
DELETE
Execute DELETE by specifying the Id and ProductId in the WHERE clause.
For example:
DELETE FROM ProductsFollowers WHERE ProductId = 1 AND id = 1
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Integer | True |
The unique identifier of the follower relationship record. | |
| AddTime | Datetime | True |
The date and time when the user started following the product. | |
| ProductId [KEY] | Integer | False |
The ID of the product being followed. | |
| UserId | Integer | False |
The ID of the user who is following the product. |