ODBC Driver for Pipedrive

Build 24.0.9111

DealsProducts

Get details of deals products.

Select

The 本製品 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 本製品.

  • 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.

デフォルト値は0です。

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9111