CampaignAttachments
Returns a list of attachments for a campaign.
Table Specific Information
Select
The driver 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 driver.
Note: CampaignId is required in order to query CampaignAttachments.
- CampaignId supports the '=' operator.
SELECT * FROM CampaignAttachments WHERE CampaignId = '2'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The immutable system record ID of the attachment. | |
| CampaignId | String |
Campaigns.Id | The immutable system record ID of the campaign. |
| ContentType | 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. | |
| FileSize | Integer | The file size in bytes. | |
| 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. | |
| ThumbnailUrl | String | The URL for a thumbnail. | |
| Type | String | The attachment type. | |
| Url | String | The URL for the attachment. |