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 supports the '=' operator.
For example, the following query is processed server side:
SELECT * FROM DealsProducts WHERE Id = 9
INSERT
Insert can be executed by specifying the Content and PersonId columns. The columns that are not required can be inserted optionally.
For example:
INSERT INTO DealsProducts (DealId, ProductId, ItemPrice, quantity) VALUES (2, 2, 20000, 1)
UPDATE
Update can be executed by specifying the Id and Dealid in the WHERE Clause. The columns that are not read-only can be Updated.
For example:
UPDATE DealsProducts SET quantity = 20 WHERE id = 15 AND Dealid = 2
DELETE
Delete can be executed by specifying the Id, DealId in the WHERE Clause.
For example:
DELETE FROM DealsProducts WHERE id = 15 AND Dealid = 2
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | Integer | True |
Id. |
| ActiveFlag | Boolean | True |
ActiveFlag. |
| AddTime | Datetime | True |
AddTime. |
| Comments | String | False |
Any textual comment associated with this product-deal attachment. |
| Currency | String | True |
Currency. |
| DealId | Integer | False |
Deal id. |
| Duration | Integer | True |
Duration of the product. The default value is 1. |
| DurationUnit | String | True |
DurationUnit. |
| EnabledFlag | Boolean | False |
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 |
LastEdit. |
| Name | String | True |
Name. |
| OrderNr | Integer | True |
OrderNr. |
| ProductActiveFlag | Boolean | True |
Product ActiveFlag. |
| ProductAddTime | Datetime | True |
Product AddTime. |
| Category | String | True |
Category. |
| code | String | True |
Code. |
| description | String | True |
Description. |
| FilesCount | String | True |
FilesCount. |
| FirstChar | String | True |
FirstChar. |
| ProductsId | Integer | True |
ProductsId. |
| ProductName | String | True |
ProductName. |
| OwnerActiveFlag | Boolean | True |
OwnerActiveFlag. |
| OwnerEmail | String | True |
OwnerEmail. |
| OwnerHasPic | Boolean | True |
OwnerHasPic. |
| OwnerId | Integer | True |
OwnerId. |
| OwnerName | String | True |
OwnerName. |
| OwnerPicHash | String | True |
OwnerPicHash. |
| OwnerValue | Integer | True |
OwnerValue. |
| EURCost | Integer | True |
EURCost. |
| EURCurrency | String | True |
EURCurrency. |
| EURId | Integer | True |
EURId. |
| EUROverheadCost | Integer | True |
EUROverheadCost. |
| EURPrice | Integer | True |
EURPrice. |
| EURProductId | Integer | True |
EURProductId. |
| Selectable | Boolean | True |
selectable. |
| ProductTax | Integer | True |
ProductTax. |
| unit | String | True |
unit. |
| UpdateTime | Datetime | True |
UpdateTime. |
| VisibleTo | String | True |
VisibleTo. |
| ProductId | Integer | False |
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 |
QuantityFormatted. |
| Sum | Double | True |
Sum. |
| SumFormatted | String | True |
SumFormatted. |
| Tax | Integer | False |
Tax percentage. The default value is 0. |
| Discount | Integer | False |
The value of the discount. |
| DiscountType | String | False |
The type of the discount's value(percentage or amount). |
| TaxMethod | String | False |
The tax option to be applied to the products (inclusive, exclusive or none). |