DealsUpdatesAttachments
Returns the file attachments associated with activity feed updates for a specific deal.
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 |
| DealId | = |
| AllChanges | = |
| Items | =,IN |
For example, the following queries are processed server-side:
SELECT * FROM DealsUpdatesAttachments WHERE DealId = 3
SELECT * FROM DealsUpdatesAttachments WHERE DealId = 246 AND AllChanges = 1
SELECT * FROM DealsUpdatesAttachments WHERE DealId = 246 AND Items IN ('activity', 'call')
Columns
| Name | Type | References | Description |
| Id [KEY] | Integer | The unique identifier of the attachment record. | |
| ActiveFlag | Boolean | Indicates whether this attachment record is active. | |
| ActivityId | String | The unique identifier of the activity this attachment is associated with. | |
| AddTime | Datetime | The date and time when this attachment was added. | |
| Cid | String | The content identifier used to reference this attachment within the message body as an inline element. | |
| DealName | String | The title of the deal this attachment is associated with. | |
| DealId | Integer | The unique identifier of the deal whose update attachments are returned. | |
| Description | String | The descriptive text associated with this attachment. | |
| FileName | String | The file name of the attachment as stored in Pipedrive. | |
| FileSize | Integer | The size of the attachment file in bytes. | |
| FileType | String | The MIME type or file type category of the attachment. | |
| InlineFlag | Boolean | Indicates whether this attachment is embedded inline within the message body rather than appended as a separate file. | |
| LogId | String | The identifier of the activity feed log entry this attachment belongs to. | |
| MailMessageId | String | The unique identifier of the mail message this attachment belongs to. | |
| MailTemplateId | String | The identifier of the mail template associated with this attachment, if applicable. | |
| Name | String | The display name of the attachment. | |
| OrgId | Integer | The unique identifier of the organization associated with this attachment. | |
| OrgName | String | The name of the organization associated with this attachment. | |
| PeopleName | String | The name of the person associated with this attachment. | |
| PersonId | String | The unique identifier of the person associated with this attachment. | |
| PersonName | String | The name of the person associated with this attachment. | |
| ProductId | String | The unique identifier of the product associated with this attachment, if applicable. | |
| ProductName | String | The name of the product associated with this attachment, if applicable. | |
| RemoteId | String | The identifier assigned to this attachment by the external storage provider. | |
| RemoteLocation | String | The name of the external storage service where this attachment is hosted, such as s3 or googledrive. | |
| S3Bucket | String | The name of the Amazon S3 bucket where this attachment is stored. | |
| UpdateTime | Datetime | The date and time when this attachment record was last modified. | |
| Url | String | The download URL for this attachment. | |
| UserId | Integer | The unique identifier of the user who added this attachment. | |
| LeadId | Integer | The unique identifier of the lead associated with this attachment, if applicable. | |
| LeadName | Integer | The title of the lead associated with this attachment, if applicable. |
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 | |
| AllChanges | String | Whether to show custom field updates or not.
The allowed values are 1. | |
| Items | String | Item specific updates.
The allowed values are call, activity, plannedActivity, change, note, deal, file, dealChange, personChange, organizationChange, follower, dealFollower, personFollower, organizationFollower, participant, comment, mailMessage, mailMessageWithAttachment, invoice, document, marketing_campaign_stat, marketing_status_change. |