SSIS Components for Blackbaud Raisers Edge NXT

Build 21.0.7930

ConstituentAttachments

Returns a list of attachments for a constituent.

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: ConstituentId is required in order to query ConstituentAttachments.

  • ConstituentId supports the '=' operator.
For example:
	SELECT * FROM ConstituentAttachments WHERE ConstituentId = '280'
	

Columns

Name Type References Description
Id [KEY] String The immutable system record ID of the attachment.
ConstituentId String The immutable system record ID of the constituent associated with the attachment.
ContentType String The content type.
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.
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