DealsTimelineDeals
Returns individual deal records from the deals timeline endpoint, with each row representing a deal that falls within a specified timeline interval.
Columns
| Name | Type | References | Description |
| Id [KEY] | Integer | Unique identifier of the deal. | |
| Active | Boolean | Indicates whether the deal is currently active. | |
| ActivitiesCount | Integer | Total number of activities associated with the deal. | |
| AddTime | Datetime | Date and time when the deal was created. | |
| CcEmail | String | BCC email address used to associate incoming emails with the deal. | |
| CloseTime | String | Date and time when the deal was closed as won or lost. | |
| CreatorUserId | Integer | Identifier of the user who originally created the deal. | |
| Currency | String | Currency code for the deal value. | |
| Deleted | Boolean | Indicates whether the deal has been deleted. | |
| DoneActivitiesCount | Integer | Number of completed activities associated with the deal. | |
| EmailMessagesCount | Integer | Number of email messages associated with the deal. | |
| ExpectedCloseDate | Date | Date by which the deal is expected to be closed. | |
| FilesCount | Integer | Number of files attached to the deal. | |
| FirstWonTime | Datetime | Date and time when the deal was marked as won for the first time. | |
| FollowersCount | Integer | Number of Pipedrive users following this deal. | |
| FormattedValue | String | Deal value formatted as a currency display string. | |
| FormattedWeightedValue | String | Probability-weighted deal value formatted as a currency display string. | |
| Label | String | Label applied to the deal for categorization or visual identification. | |
| LastActivityDate | String | Date of the most recent activity associated with the deal. | |
| LastActivityId | String | Identifier of the most recent activity associated with the deal. | |
| LastncomingMailTime | Datetime | Date and time of the last incoming email message associated with the deal. | |
| LastoutgoingMailTime | Datetime | Date and time of the last outgoing email message associated with the deal. | |
| Lostreason | String | Reason entered when the deal was marked as lost. | |
| LostTime | String | Date and time when the deal was marked as lost. | |
| NextActivityDate | Date | Date of the next scheduled activity associated with the deal. | |
| NextActivityDuration | Time | Duration of the next scheduled activity associated with the deal. | |
| NextActivityId | Integer | Identifier of the next scheduled activity associated with the deal. | |
| NextActivityNote | String | Note text of the next scheduled activity associated with the deal. | |
| NextActivitySubject | String | Subject of the next scheduled activity associated with the deal. | |
| NextActivityTime | Time | Time of the next scheduled activity associated with the deal. | |
| NextActivityType | String | Type of the next scheduled activity, for example call or meeting. | |
| NotesCount | Integer | Number of notes attached to the deal. | |
| OrgHidden | Boolean | Indicates whether the organization linked to this deal is hidden from the current user. | |
| OrgId | Integer | Identifier of the organization linked to the deal. | |
| OrgName | String | Name of the organization linked to the deal. | |
| OwnerName | String | Full name of the user who owns the deal. | |
| ParticipantsCount | Integer | Number of participants associated with the deal. | |
| PersonHidden | Boolean | Indicates whether the person linked to this deal is hidden from the current user. | |
| PersonId | Integer | Identifier of the primary person (contact) linked to the deal. | |
| PersonName | String | Full name of the primary person (contact) linked to the deal. | |
| PipelineId | Integer |
Pipelines.Id | Identifier of the pipeline in which this deal resides. |
| Probability | String | Probability percentage that this deal will be won, used for weighted value calculations. | |
| ProductsCount | Integer | Number of products attached to the deal. | |
| RottenTime | String | Date and time when the deal was marked as rotten due to inactivity. | |
| StageChangeTime | Datetime | Date and time when the deal last moved to a different pipeline stage. | |
| StageId | Integer | Identifier of the pipeline stage in which the deal currently resides. | |
| StageOrderNr | Integer | Display order number of the current pipeline stage. | |
| Status | String | Current status of the deal, for example open, won, or lost. | |
| Title | String | Title or name of the deal. | |
| UndoneActivitiesCount | Integer | Number of incomplete activities associated with the deal. | |
| UpdateTime | Datetime | Date and time when the deal was last updated. | |
| UserId | Integer |
Users.Id | Identifier of the user who owns the deal. |
| Value | Integer | Monetary value of the deal in the deal's currency. | |
| VisibleTo | String | Visibility setting for the deal, controlling which users can see it. | |
| WeightedValue | Integer | Deal value multiplied by the win probability percentage. | |
| WeightedValueCurrency | String | Currency code for the weighted deal value. | |
| WonTime | Datetime | Date and time when the deal was marked as won. |
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 | |
| 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. | |
| 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. |