LeadsArchived
Returns all archived leads from the Pipedrive account, including associated person, organization, label, and value details.
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 |
| OrganizationId | = |
| OwnerId | = |
| PersonId | = |
| FilterId | = |
For example, the following queries are processed server-side:
SELECT * FROM LeadsArchived
SELECT * FROM LeadsArchived WHERE OrganizationId = 4
SELECT * FROM LeadsArchived WHERE OwnerId = 28073042
SELECT * FROM LeadsArchived WHERE PersonId = 1
SELECT * FROM LeadsArchived WHERE FilterId = 1
Order by is supported server-side for following columns: Id, AddTime, CreatorId, ExpectedCloseDate, NextActivityId, OwnerId, Title, UpdateTime, WasSeen.
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The ID of the Lead. | |
| AddTime | Datetime | The date and time when the lead was created. | |
| ArchiveTime | Datetime | The date and time when the lead was archived. | |
| CcEmail | String | The BCC email address associated with this lead, used to automatically log emails sent to it. | |
| CreatorId | Integer | The ID of the user who created the lead. | |
| ExpectedCloseDate | Date | The date of when the Deal which will be created from the Lead is expected to be closed. | |
| IsArchived | Boolean | A flag indicating whether the Lead is archived or not. | |
| LabelIds | String | The IDs of the Lead Labels which will be associated with the Lead. | |
| NextActivityId | Integer | The ID of the next scheduled activity linked to this lead. | |
| OrganizationId | Integer | The ID of an Organization which this Lead will be linked to. | |
| OwnerId | Integer | The ID of the User which will be the owner of the created Lead. | |
| PersonId | Integer | The ID of a Person which this Lead will be linked to. | |
| SourceName | String | The name of the channel or integration that was the source of this lead. | |
| Title | String | The name of the Lead. | |
| UpdateTime | Datetime | The date and time when the lead was last updated. | |
| Amount | Integer | The potential value of the Lead. | |
| Currency | String | The ISO 4217 currency code for the lead's monetary value. | |
| VisibleTo | String | The visibility level of the lead, controlling which users can see it. Accepted values: 1 (owner only), 3 (owner's visibility group), 5 (owner's and sub-groups), 7 (entire company).
The allowed values are 1, 3, 5, 7. | |
| WasSeen | Boolean | A flag indicating whether the Lead was seen by someone in the Pipedrive UI. | |
| Origin | String | The origin of the lead. | |
| OriginId | String | The optional ID to further distinguish the origin of the lead. | |
| Channel | Integer | The ID of Marketing channel this lead was created from. | |
| ChannelId | String | The optional ID to further distinguish the Marketing channel. |
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 | |
| FilterId | Integer | Filter Id |