DealsFiles
Returns all files attached to a specific deal, including metadata such as file name, size, type, and storage location.
View-Specific Information
SELECT
The provider uses the Pipedrive API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the provider.
| Column | Supported Operators |
| DealId | = |
For example, the following query is processed server-side:
SELECT * FROM DealsFiles WHERE DealId = 246
Columns
| Name | Type | References | Description |
| Id [KEY] | Integer | Unique identifier of the file attachment. | |
| ActiveFlag | Boolean | Indicates whether the file attachment is active and has not been deleted. | |
| ActivityId | String | Identifier of the activity to which this file is attached, if applicable. | |
| AddTime | Datetime | Date and time when the file was uploaded. | |
| Cid | String | Content identifier of the file, used when the file is embedded inline in email messages. | |
| DealId | String | Identifier of the deal to which this file is attached. | |
| DealName | String | Title of the deal to which this file is attached. | |
| Description | String | Optional description or note associated with the file attachment. | |
| FileName | String | Original name of the uploaded file, including its extension. | |
| FileSize | Integer | Size of the file in bytes. | |
| FileType | String | MIME type or general type category of the file, for example image or document. | |
| InlineFlag | Boolean | Indicates whether the file is embedded inline in an email message rather than attached as a separate file. | |
| LogId | String | Identifier of the activity log entry associated with this file. | |
| MailMessageId | String | Identifier of the email message to which this file is attached. | |
| MailTemplateId | String | Identifier of the email template associated with this file. | |
| Name | String | Display name of the file as shown in the Pipedrive interface. | |
| OrgId | Integer | Identifier of the organization associated with this file. | |
| OrgName | String | Name of the organization associated with this file. | |
| PeopleName | String | Name of the person (contact) associated with this file. | |
| PersonId | String | Identifier of the person (contact) associated with this file. | |
| PersonName | String | Full name of the person (contact) associated with this file. | |
| ProductId | String | Identifier of the product associated with this file, if applicable. | |
| ProductName | String | Name of the product associated with this file, if applicable. | |
| RemoteId | String | Identifier of the file in the remote storage system, such as Google Drive. | |
| RemoteLocation | String | Name of the remote storage service where the file is stored, for example googledrive or dropbox. | |
| S3Bucket | String | Name of the Amazon S3 bucket where the file is stored. | |
| UpdateTime | Datetime | Date and time when the file record was last updated. | |
| Url | String | URL to download or access the file. | |
| UserId | Integer | Identifier of the user who uploaded the file. | |
| LeadId | String | Identifier of the lead associated with this file, if applicable. | |
| LeadName | String | Title of the lead associated with this file, if applicable. |