ActionAttachments
Retrieves a list of attachments for an action.
Table Specific Information
Select
The connector 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 connector.
Note: ActionId is required in order to query ActionAttachments.
- ActionId supports the '=' operator.
SELECT * FROM ActionAttachments WHERE ActionId = '335'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The immutable system record ID of the attachment. | |
| ActionId | String |
Actions.Id | The immutable system record ID of the action this attachment is associated to. |
| 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 | Long | 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 parent object's immutable system record ID. | |
| 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. |