OpportunityAttachments
Returns a list of attachments for an opportunity
Table Specific Information
Select
The cmdlet will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the cmdlet.
Note: OpportunityId is required in order to query OpportunityAttachments.
- OpportunityId supports the '=' operator.
SELECT * FROM OpportunityAttachments WHERE OpportunityId = '4'
Columns
Name | Type | References | Description |
Id [KEY] | String | The immutable system record ID of the attachment. | |
OpportunityId | String | The ID of the Opportunity. | |
Content_type | String | The content type. For physical attachments only. | |
Date | Datetime | The date of the attachment. | |
FileId | String | The identifier of the file. | |
FileName | String | The file name. For physical attachments only. | |
FileSize | Integer | The file size in bytes. For physical attachments only. | |
Name | String | The name of the attachment. | |
ParentId | String | The parent object's immutable system record ID. | |
Tags | String | The tags associated with the attachment. | |
ThumbnailId | String | The identifier of the thumbnail. For physical attachments that are images only. | |
ThumbnailUrl | String | The URL for a thumbnail. | |
Type | String | The attachment type. Available values are Link and Physical. | |
Url | String | The URL for the attachment. |