DealsProducts
Get details of deals products.
Select
The add-in will use 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 add-in.
- Id and DealId support the '=' operator.
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 | Id. | |
| IsEnabled | Boolean | Is enabled. | |
| AddTime | Datetime | AddTime. | |
| UpdateTime | Datetime | UpdateTime. | |
| Comments | String | Any textual comment associated with this product-deal attachment. | |
| Currency | String | Currency. | |
| Discount | Double | Discount. | |
| DealId | Integer | Deal id. | |
| ItemPrice | Double | Price at which this product will be added to the deal. | |
| Name | String | Name. | |
| BillingFrequency | String | Billing frequency. | |
| BillingFrequencyCycles | Integer | Billing frequency cycles. | |
| BillingStartDate | Datetime | Billing start date. | |
| TaxMethod | String | Tax method. | |
| DiscountType | String | Discount Type. | |
| 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 | Sum. | |
| Tax | Double | Tax percentage.
The default value is 0. |