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 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 |
| 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 |
Deal id. |
| DiscountPercentage | Double | True |
Discount %. The default value is 0. | |
| Duration | Integer | True |
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 |
Whether the product is enabled on the deal or not. The allowed values are 0, 1. | |
| ItemPrice | Integer | False |
Price at which this product will be 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 |
Identifier 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 |
Identifier 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 |
ID of the product that will be attached. |
| VariationId | String | False |
ID of the product variation. | |
| Quantity | Integer | False |
How many items of this product will be added 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 |
Tax percentage. The default value is 0. | |
| ProductPrices | String | True |
Product Prices |