DealsProducts
Get details of deals products.
Select
The connector 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 connector.
- 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. |