DealsTimeline
Return details of deals timeline
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.
- UserId supports the '=' operator.
- ConvertCurrency supports the '=' operator.
- ExcludeDeals supports the '=' operator.
- FilterId supports the '=' operator.
- PipelineId supports the '=' operator.
- IntervalType supports the '=' operator.
- Amount supports the '=' operator.
- StartDate supports the '=' operator.
- FieldKey supports the '=' operator.
- IntervalType supports the '=' operator.
For example, the following query is processed server side:
Required fields: Amount, StartDate, FieldKey and IntervalType is required
SELECT * FROM DealsTimeline WHERE Amount = '3' AND StartDate = '2021-12-12' AND FieldKey = 'add_time' AND IntervalType = 'month'
Columns
| Name | Type | Description |
| Deals | String | Deals |
| PeriodEnd | Datetime | Period End |
| PeriodStart | Date | Period Start |
| Count | Integer | Count |
| OpenCount | Integer | open Count |
| OpenValuesEUR | Integer | open Values EUR |
| ValuesEUR | Integer | Values EUR |
| ValuesUSD | Integer | Values USD |
| WeightedOpenValuesEUR | Integer | Weighted Open Values EUR |
| WeightedValuesEUR | Integer | Weighted Values EUR |
| WeightedValuesUSD | Integer | Weighted Values USD |
| WonCount | Integer | Won Count |
| WonValuesUSD | Integer | Won Values USD |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| StartDate | Date | Date where the first interval starts. Format: YYYY-MM-DD. |
| IntervalType | String | Type Of Interval.
The allowed values are day, week, month, quarter. |
| Amount | Integer | The number of given intervals, starting from start_date, to fetch E.g 3 months. |
| FieldKey | String | The date field key which deals will be retrieved from. |
| UserId | Integer | User id. |
| FilterId | Integer | Type Of Interval.
The allowed values are day, week, month, quarter. |
| ExcludeDeals | Integer | Whether to exclude deals list 1 or not 0.
The allowed values are 0, 1. |
| ConvertCurrency | String | 3-letter currency code of any of the supported currencies. |
| PipelineId | Integer | Pipeline Id. |