DealsProducts
Returns all products attached to deals, including pricing, quantity, discount, and product catalog details. Supports insert, update, and delete operations.
Table-Specific Information
SELECT
The component 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 component.
| Column | Supported Operators |
| DealId | = |
For example, the following query is processed server-side:
SELECT * FROM DealsProducts WHERE DealId = 9
INSERT
Execute INSERT by specifying the required columns. You can also insert any optional columns.
For example:
INSERT INTO DealsProducts (DealId, ProductId, ItemPrice, quantity) VALUES (2, 2, 20000, 1)
UPDATE
Execute UPDATE by specifying the Id and DealId in the WHERE clause. You can update any columns that are not read-only.
For example:
UPDATE DealsProducts SET quantity = 20 WHERE Id = 15 AND DealId = 2
DELETE
Execute DELETE by specifying the Id and DealId in the WHERE clause.
For example:
DELETE FROM DealsProducts WHERE Id = 15 AND DealId = 2
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Integer | True |
Unique identifier of the deal-product attachment record. | |
| ActiveFlag | Boolean | True |
Indicates whether this deal-product attachment is active. | |
| AddTime | Datetime | True |
Date and time when the product was attached to the deal. | |
| Comments | String | False |
Any textual comment associated with this product-deal attachment. | |
| Currency | String | True |
Currency code for the product price on this deal. | |
| DealId [KEY] | Integer | False |
Deals.Id |
The Id of the deal to which the product is attached. |
| DiscountPercentage | Double | True |
The discount percentage applied to this product on the deal. The default value is 0. | |
| Duration | Integer | True |
The duration of the product. The default value is 1. | |
| DurationUnit | String | True |
Unit of time used for the product duration, for example month or year. | |
| EnabledFlag | Boolean | True |
Indicates whether the product is enabled on the deal. The allowed values are 0, 1. | |
| ItemPrice | Integer | False |
The price at which this product is added to the deal. | |
| LastEdit | String | True |
Date and time when this deal-product attachment was last edited. | |
| Name | String | True |
Display name of the deal-product attachment record. | |
| OrderNr | Integer | True |
Ordering index used to control the display sequence of products on the deal. | |
| ProductActiveFlag | Boolean | True |
Indicates whether the product in the catalog is active. | |
| ProductAddTime | Datetime | True |
Date and time when the product was added to the catalog. | |
| Category | String | True |
Category assigned to the product in the catalog. | |
| code | String | True |
Internal code or SKU identifying the product in the catalog. | |
| description | String | True |
Text description of the product as defined in the product catalog. | |
| FilesCount | String | True |
Number of files attached to the product in the catalog. | |
| FirstChar | String | True |
First character of the product name, used for alphabetical grouping. | |
| ProductsId | Integer | True |
The Id of the product in the Pipedrive product catalog. | |
| ProductName | String | True |
Name of the product as defined in the product catalog. | |
| OwnerActiveFlag | Boolean | True |
Indicates whether the owner user account of the product is active. | |
| OwnerEmail | String | True |
Email address of the user who owns the product in the catalog. | |
| OwnerHasPic | Boolean | True |
Indicates whether the product owner user has a profile picture. | |
| OwnerId | Integer | True |
The Id of the user who owns the product in the catalog. | |
| OwnerName | String | True |
Full name of the user who owns the product in the catalog. | |
| OwnerPicHash | String | True |
Hash value of the product owner's profile picture, used for cache-busting. | |
| OwnerValue | Integer | True |
Numeric identifier value for the owner of the product. | |
| Selectable | Boolean | True |
Indicates whether the product can be selected and attached to deals. | |
| ProductTax | Integer | True |
Default tax rate percentage defined for the product in the catalog. | |
| unit | String | True |
Unit of measure for the product, for example hours, licenses, or items. | |
| UpdateTime | Datetime | True |
Date and time when the product record in the catalog was last updated. | |
| VisibleTo | String | True |
Visibility setting for the product, controlling which users can see it in the catalog. | |
| ProductId | Integer | False |
Products.id |
The Id of the product to attach. |
| VariationId | String | False |
The Id of the product variation. | |
| Quantity | Integer | False |
The number of items of this product to add to the deal. | |
| QuantityFormatted | String | True |
Quantity formatted as a display string including the unit of measure. | |
| Sum | Double | True |
Total value of this product line after applying quantity and discount. | |
| SumFormatted | String | True |
Total value of this product line formatted as a currency string. | |
| SumNoDiscount | Integer | True |
Total value of this product line before any discount is applied. | |
| Tax | Integer | False |
The tax percentage applied to this product. The default value is 0. | |
| ProductPrices | String | True |
The price information for the product. |