SSIS Components for Blackbaud Raisers Edge NXT

Build 21.0.7930

FundraiserGoals

Returns a list of goals for a fundraiser

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

  • FundraiserId supports the '=' operator.
For example:
	SELECT * FROM FundraiserGoals WHERE FundraiserId = '4'
	

Columns

Name Type References Description
Id [KEY] String The immutable system record ID of the fundraiser goal.
AmountValue Double The fundraiser goal amount.
AppealId String

FundraisingAppeals.Id

The immutable system record ID of the appeal associated with the fundraiser goal.
CampaignId String

Campaigns.Id

The immutable system record ID of the campaign associated with the fundraiser goal.
FundId String

Funds.Id

The immutable system record ID of the fund associated with the fundraiser goal.
FundraiserId String The immutable system record ID of the fundraiser associated with the fundraiser goal.
Type String The fundraiser goal type. Available values are Campaign, Fund, UnspecifiedCategory, and Appeal.
UnspecifiedCategoryName String The unspecified category name for the fundraiser goal.

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