GiftAttachments
Returns a list of attachments for a gift.
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: GiftId are required in order to query GiftAttachments.
- GiftId supports the '=' operator.
SELECT * FROM GiftAttachments WHERE GiftId = '476'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The immutable system record ID of the attachment. | |
| GiftId | String |
Gifts.Id | The immutable system record ID of the gift the attachments are 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 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. |