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 | References | Description |
| Deals | String | Deals | |
| PeriodEnd | Datetime | Period End | |
| PeriodStart | Date | Period Start | |
| TotalValues | String | Total Values |
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. |