DealsProducts
Returns all products attached to deals, including pricing, quantity, discount, and billing details for each product-deal attachment.
View-Specific Information
SELECT
The provider uses the Pipedrive API to process WHERE clause conditions built with the following columns and operators.
| Column | Supported Operators |
| Id | = |
| DealId | = |
For example, the following query is processed server-side:
SELECT * FROM DealsProducts WHERE Id = 9 AND DealId = 10
The rest of the filter is executed client-side within the provider.
INSERT
Execute INSERT by specifying the DealId, ItemPrice, ProductId, and Quantity columns. All columns that are not required are optional.
For example:
INSERT INTO DealsProducts (DealId, ProductId, ItemPrice, Quantity) VALUES (1, 2, 750, 4)
DELETE
Execute DELETE by specifying the Id and DealId in the WHERE clause.
For example:
DELETE FROM DealsProducts WHERE Id = 1 and DealId = 2
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Integer | True |
The unique identifier of the product-deal attachment. | |
| IsEnabled | Boolean | True |
Indicates whether this product-deal attachment is enabled and active. | |
| AddTime | Datetime | True |
The date and time when the product was attached to the deal. | |
| UpdateTime | Datetime | True |
The date and time when the product-deal attachment was last updated. | |
| Comments | String | False |
Any textual comment associated with this product-deal attachment. | |
| Currency | String | True |
The currency code for the product price in this deal, for example USD or EUR. | |
| Discount | Double | False |
The discount applied to this product in the deal, expressed as a percentage or fixed amount depending on DiscountType. | |
| DealId | Integer | False |
The unique identifier of the deal this product is attached to. | |
| ItemPrice | Double | False |
The price at which this product is added to the deal. | |
| Name | String | True |
The name of the product attached to the deal. | |
| BillingFrequency | String | False |
The frequency at which the product is billed, for example monthly or annually. | |
| BillingFrequencyCycles | Integer | False |
The number of billing cycles for the product in this deal. | |
| BillingStartDate | Datetime | False |
The date on which billing for this product in the deal begins. | |
| TaxMethod | String | False |
The method used to apply tax to this product, for example exclusive or inclusive. | |
| DiscountType | String | False |
The type of discount applied, for example percentage or amount. | |
| ProductId | Integer | False |
The Id of the product to attach. | |
| ProductVariationId | Integer | False |
The Id of the product variation. | |
| Quantity | Double | False |
The number of items of this product to add to the deal. | |
| Sum | Double | True |
The total sum for this product line in the deal after applying quantity, price, and discount. | |
| Tax | Double | False |
The tax percentage applied to this product. The default value is 0. |