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. The rest of the filter is executed client-side within the provider.
| Column | Supported Operators |
| Id | = |
| DealId | = |
For example, the following query is processed server-side:
SELECT * FROM DealsProductsV2 WHERE Id = 9 AND DealId = 10;
Columns
| Name | Type | References | Description |
| Id [KEY] | Integer | The unique identifier of the product-deal attachment. | |
| IsEnabled | Boolean | Whether this product-deal attachment is enabled and active. | |
| AddTime | Datetime | The date and time when the product was attached to the deal. | |
| UpdateTime | Datetime | The date and time when the product-deal attachment was last updated. | |
| Comments | String | Any textual comment associated with this product-deal attachment. | |
| Currency | String | The currency code for the product price in this deal, for example USD or EUR. | |
| Discount | Double | The discount applied to this product in the deal, expressed as a percentage or fixed amount depending on DiscountType. | |
| DealId | Integer | The unique identifier of the deal this product is attached to. | |
| ItemPrice | Double | Price at which this product will be added to the deal. | |
| Name | String | The name of the product attached to the deal. | |
| BillingFrequency | String | The frequency at which the product is billed, for example monthly or annually. | |
| BillingFrequencyCycles | Integer | The number of billing cycles for the product in this deal. | |
| BillingStartDate | Datetime | The date on which billing for this product in the deal begins. | |
| TaxMethod | String | The method used to apply tax to this product, for example exclusive or inclusive. | |
| DiscountType | String | The type of discount applied, for example percentage or amount. | |
| ProductId | Integer | ID of the product that will be attached. | |
| ProductVariationId | Integer | ID of the product variation. | |
| Quantity | Double | How many items of this product will be added to the deal. | |
| Sum | Double | The total sum for this product line in the deal after applying quantity, price, and discount. | |
| Tax | Double | Tax percentage.
The default value is 0. |