ProductsPrices
Returns the pricing entries for products, including price, cost, currency, and overhead cost per price record.
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 | = |
| Code | LIKE |
| Name | LIKE |
| FirstChar | = |
| FilterId | = |
| UserId | = |
| GetSummary | = |
| Ids | =,IN |
For example, the following queries are processed server-side:
SELECT * FROM ProductsPrices WHERE Id = 14
SELECT * FROM ProductsPrices WHERE Name LIKE '%Cdata%'
SELECT * FROM ProductsPrices WHERE code LIKE '%123%'
SELECT * FROM ProductsPrices WHERE FirstChar = 'c'
SELECT * FROM ProductsPrices WHERE FilterId = 1
SELECT * FROM ProductsPrices WHERE UserId = 1
SELECT * FROM ProductsPrices WHERE GetSummary = 1
SELECT * FROM ProductsPrices WHERE Ids IN (1, 2)
Columns
| Name | Type | References | Description |
| Id [KEY] | Integer | The unique identifier of the price entry. | |
| Cost | Integer | The cost amount for the product at this price point. | |
| Currency | String | The currency code for the price entry, for example USD or EUR. | |
| OverheadCost | String | The overhead cost allocated to the product at this price point. | |
| Price | Integer | The sale price of the product for this price entry. | |
| ProductId | Integer | The unique identifier of the product this price entry belongs to. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description | |
| FirstChar | String | If supplied only Products whose name starts with the specified letter will be returned. | |
| UserId | Integer | User Id. | |
| FilterId | Integer | Filter Id. | |
| GetSummary | Boolean | Get Summary. | |
| Ids | Integer | The Ids of the Products that should be returned in the response. |