SSIS Components for Blackbaud Raisers Edge NXT

Build 21.0.7930

GiftAttachments

Returns a list of attachments for a gift.

Table Specific Information

Select

The component 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 component.
Note: GiftId are required in order to query GiftAttachments.

  • GiftId supports the '=' operator.
For example:
	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 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.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930