BlackBaud Raiser's Edge NXT への接続を追加

BlackBaud Raiser's Edge NXT への接続を追加するには：

1. アプリケーションコンソールで、接続ページに移動します。
2. 接続の追加パネルで、追加したい接続のアイコンを選択します。
3. BlackBaud Raiser's Edge NXT アイコンが利用できない場合は、Add More アイコンをクリックしてCData サイトからBlackBaud Raiser's Edge NXT コネクタをダウンロードおよびインストールします。

必須プロパティについては、設定タブを参照してください。

通常必須ではない接続プロパティについては、高度な設定タブを参照してください。

BlackBaud Raiser's Edge NXT への接続

接続を確立する前に、BlackBaud Raiser's Edge NXT プロファイルにあるSubscriptionKey を指定します。

BlackBaud Raiser's Edge NXT への認証

BlackBaud Raiser's Edge NXT は埋め込みOAuth クレデンシャルを提供しており、デスクトップアプリケーション からの接続を簡単にします。 Web アプリケーションから接続するには、カスタムOAuth アプリケーションの作成 で説明するようにカスタムOAuth アプリケーションを作成する必要があります。

接続する場合は、すべての認証フローで以下の手順が必要です。

• AuthScheme をOAuth に設定
• SubscriptionKey をサブスクリプションキーに設定
• 結果を取得するために認証アカウントでBlackBaud Raiser's Edge NXT を有効化

以下のサブセクションでは、利用可能なすべてのOAuth フローでBlackBaud Raiser's Edge NXT へ認証する方法について詳しく説明します。 Web 経由で接続するためのカスタムOAuth アプリケーションの作成については、カスタムOAuth アプリケーションの作成 を参照してください。 BlackBaud Raiser's Edge NXT で利用可能な接続文字列プロパティの全リストは、Connection を参照してください。

Web アプリケーション

Web アプリケーション経由で接続する場合は、BlackBaud Raiser's Edge NXT にカスタムOAuth アプリケーションを作成および登録する必要があります。それからSync App を使用してOAuth トークンの値を取得および管理します。カスタムOAuth アプリケーションを作成し、BlackBaud Raiser's Edge NXT 環境に接続する設定方法については、カスタムOAuth アプリケーションの作成 を参照してください。

OAuth アクセストークンの取得

OAuthAccessToken を取得するには、次のプロパティを設定します。

• OAuthClientId：カスタムOAuth アプリケーションの設定で指定されたクライアントId。
• OAuthClientSecret：カスタムOAuth アプリケーションの設定で指定されたクライアントシークレット。

続いてストアドプロシージャを呼び出し、OAuth 交換を完了します。

1. GetOAuthAuthorizationURL ストアドプロシージャを呼び出します。AuthMode インプットをWEB に設定し、CallbackURL インプットをカスタムOAuth アプリケーションの設定時に指定したリダイレクトURI に設定します。必要に応じて、Permissions パラメータを設定してカスタム権限をリクエストします。ストアドプロシージャがOAuth エンドポイントのURL を返します。
2. ステップ1でストアドプロシージャが返したURL に移動します。カスタムOAuth アプリケーションにログインして、Web アプリケーションを認可します。アプリケーションが認証されると、ブラウザはコールバックURL にリダイレクトします。
3. GetOAuthAccessToken ストアドプロシージャを呼び出します。AuthMode をWEB に、Verifier インプットをコールバックURL のクエリ文字列の"code" パラメータに設定します。必要に応じて、Permissions パラメータを設定してカスタム権限をリクエストします。

OAuthAccessToken 接続プロパティをストアドプロシージャで返されたアクセストークンに設定し、データに接続します。ExpiresIn 秒後に、アクセストークンの期限が切れたときは、GetOAuthAccessToken を再度呼び出し、新しいアクセストークンを取得します。

ヘッドレスマシン

ヘッドレスマシンのユーザーアカウントでOAuth を使用するようにドライバーを設定するには、インターネットブラウザに対応した別の端末で認証する必要があります。

1. 次のオプションのいずれか1つを設定してください。
   • オプション1：後述の「Verifier code を取得および交換」に従い、OAuthVerifier 値を取得します。
   • オプション2：インターネットブラウザに対応したマシンにSync App をインストールし、後述のオプション2：OAuth 設定を転送の説明に従い、通常のブラウザベースのフローで認証後にOAuth 認証値を転送します。
2. 次に、ヘッドレスマシンからアクセストークンを自動的にリフレッシュするようにSync App を設定します。

オプション1：Verifier code を取得および交換

Verifier code を取得するには、OAuth Authorization URL で認証する必要があります。

インターネットブラウザに対応したマシンから認証してOAuthVerifier 接続プロパティを取得する方法は次のとおりです。

1. 以下のオプションから選択します。
   • 埋め込みOAuth アプリケーションを使用する場合は、BlackBaud Raiser's Edge NXT OAuth endpoint をクリックし、ブラウザでエンドポイントを開きます。
   • カスタムOAuth アプリケーションを使用するには、以下のプロパティを設定し、認証URL を作成します。
     • InitiateOAuth：OFF に設定。
     • OAuthClientId：カスタムOAuth アプリケーションで指定されたクライアントId に設定。
     • OAuthClientSecret：カスタムOAuth アプリケーションで指定されたクライアントシークレットに設定。
     次に、適切なCallbackURL を指定してGetOAuthAuthorizationURL ストアドプロシージャを呼び出します。ストアドプロシージャによって返されたURL をブラウザで開きます。
2. ログインして、Sync App にアクセス許可を与えます。すると、verifier code を含むコールバックURL にリダイレクトされます。
3. verifier code の値を保存します。後ほどこれをOAuthVerifier 接続プロパティに設定します。

次に、OAuth verifier code をOAuth リフレッシュトークンおよびアクセストークンと交換する必要があります。

ヘッドレスマシンでは、OAuth 認証値を取得するには次の接続プロパティを設定します。

• InitiateOAuth：REFRESH。
• OAuthVerifier：verifier code。
• OAuthSettingsLocation：暗号化されたOAuth 認証値を指定された場所に永続化。
• カスタムアプリケーションのみ：
  • OAuthClientId：カスタムOAuth アプリケーションの設定で指定されたクライアントId。
  • OAuthClientSecret：カスタムOAuth アプリケーションの設定で指定されたクライアントシークレット。

OAuth 設定ファイルが生成されたら、以下のように接続プロパティをリセットする必要があります。

• InitiateOAuth：REFRESH。
• OAuthSettingsLocation：暗号化されたOAuth 認証値が保存される場所。アクセストークンの自動リフレッシュを有効にするために、この場所がSync App に読み書きのアクセス許可を与えることを確認してください。
• カスタムアプリケーションのみ：
  • OAuthClientId：カスタムOAuth アプリケーションの設定で指定されたクライアントId。
  • OAuthClientSecret：カスタムOAuth アプリケーションの設定で指定されたクライアントシークレット。

オプション2：OAuth 設定を転送

ヘッドレスマシンでの接続に先立ち、インターネットブラウザに対応したデバイスでドライバーとの接続を作成し、インストールする必要があります。上述の「デスクトップアプリケーション」の説明に従って、接続プロパティを設定します。

「デスクトップアプリケーション」の手順が完了すると、生成された認証値は、OAuthSettingsLocation で指定された場所に暗号化されて書き込まれます。デフォルトのファイル名はOAuthSettings.txt です。

接続が正常にテストされたら、OAuth 設定ファイルをヘッドレスマシンにコピーし、以下の接続プロパティを設定してデータに接続します。

• InitiateOAuth：REFRESH。
• OAuthSettingsLocation：OAuth 設定ファイルの場所に設定。アクセストークンの自動リフレッシュを有効にするために、この場所がSync App に読み書きのアクセス許可を与えることを確認してください。
• カスタムアプリケーションのみ：
  • OAuthClientId：カスタムOAuth アプリケーションの設定で指定されたクライアントId。
  • OAuthClientSecret：カスタムOAuth アプリケーションの設定で指定されたクライアントシークレット。

このセクションでは、BlackBaud Raiser's Edge NXT Sync App の高度な機能を厳選して説明します。

ユーザー定義ビュー

Sync App はユーザー定義ビューの使用をサポートします。これは事前設定されたユーザー定義クエリによって内容が決定される仮想テーブルです。 このビューは、ドライバーに発行されるクエリを直接制御できない場合に有効です。 カスタムビューの作成と設定の概要については、ユーザー定義ビュー を参照してください。

SSL の設定

SSL の設定 を使用して、Sync App が証明書のネゴシエーションをどのように扱うかを調整します。さまざまな証明書形式を選択できます。詳しくは、「接続文字列オプション」にあるSSLServerCert プロパティを参照してください。

ファイアウォールとプロキシ

Windows プロキシとHTTP プロキシを含むファイアウォールとプロキシ に合致するようSync App を設定します。トンネル接続を設定することもできます。

クエリ処理

Sync App は、BlackBaud Raiser's Edge NXT にできるだけ多くのSELECT ステートメント処理をオフロードし、残りのクエリをクライアント側のインメモリで処理します。

詳しくは、クエリ処理 を参照してください。

ログ

CData ログを調整するために使用可能な設定の概要については、ログ を参照してください。基本的なロギングに必要なのは2つの接続プロパティだけですが、より詳細なロギングをサポートする多くの機能があり、LogModules 接続プロパティを使用してロギングする情報のサブセットを指定することができます。

SSL 設定のカスタマイズ

デフォルトでは、Sync App はサーバーとのTLS のネゴシエーションを試みます。サーバー証明書は、デフォルトのシステム信頼済み証明書ストアで検証されます。SSLServerCert 接続プロパティを使用して、証明書の検証方法をオーバーライドできます。

別の証明書を指定するには、SSLServerCert 接続プロパティを参照してください。

Firewall またはProxy 経由の接続

HTTP プロキシ

HTTP プロキシへの認証には、以下のように設定します。

• ProxyServer：HTTP トラフィックをルートするプロキシサーバーのホストネームもしくはIP アドレス。
• ProxyPort：プロキシサーバーが起動しているTCP ポート。
• ProxyAuthScheme：プロキシサーバーに対して認証する際にSync App が使用する認証方法。
• ProxyUser：プロキシサーバーに登録されているユーザーアカウントのユーザー名。
• ProxyPassword：ProxyUser に紐付けられたパスワード。

その他のプロキシ

次のプロパティを設定します。

• プロキシベースのファイヤーウォールを使用するには、FirewallType、FirewallServer、およびFirewallPort を設定します。
• 接続をトンネルするには、FirewallType をTUNNEL に設定します。
• 認証するには、FirewallUser とFirewallPassword を設定します。
• SOCKS プロキシへの認証には、さらにFirewallType をSOCKS5 に設定します。

概要

このセクションでは、利用可能なAPI オブジェクトを示し、BlackBaud Raiser's Edge NXT API へのSQL の実行について詳しく説明します。

主要機能

• Sync App はドキュメント、フォルダ、およびグループなどのBlackBaud Raiser's Edge NXT エンティティをリレーショナルビューとしてモデル化し、SQL を記述してBlackBaud Raiser's Edge NXT データをクエリできるようにします。
• ストアドプロシージャを使用するとBlackBaud Raiser's Edge NXT の操作を実行できます。
• これらのオブジェクトへのライブ接続により、Sync App を使用するとBlackBaud Raiser's Edge NXT アカウントへのあらゆる変更が即座に反映されます。

ビュー

ビュー では、利用可能なビューを説明します。ビューは、Actions、Emails、Events などを静的にモデル化するように定義されています。

ストアドプロシージャ

ストアドプロシージャ は、BlackBaud Raiser's Edge NXT のファンクションライクなインターフェースです。ストアドプロシージャを使用すると、オブジェクトのダウンロードやエンベロープの移動など、BlackBaud Raiser's Edge NXT の操作を実行できます。

ビューは、データを示すという点でテーブルに似ていますが、ビューは読み取り専用です。

クエリは、ビューに対して通常のテーブルと同様に実行することができます。

Blackbaud Raisers Edge NXT Connector for CData Sync ビュー

Name	Description
ActionAttachments	Retrieves a list of attachments for an action.
ActionCustomFields	Retrieves custom fields for an action
Actions	Retrieves a list of actions for all constituents and for specified constituent and details of the specified action.
Addresses	Addresses store information about constituent residences and other addresses along with information about where or whether to send mail
Aliases	Retrieves a list of aliases for a constituent
AppealAttachments	Returns a list of attachments for an appeal.
CampaignAttachments	Returns a list of attachments for a campaign.
Campaigns	Campaigns are your organization's overall fundraising efforts or initiatives, such as operating expenses, new buildings, and endowments
ConsentCategories	Returns a list of consent categories.
ConsentChannelCategories	Returns a list of valid consent channel category combinations.
ConsentChannels	Represents the consent channel entity
ConsentSources	Represents the consent source entity
ConstituentAppeals	Returns a list of appeals for a constituent.
ConstituentAttachments	Returns a list of attachments for a constituent.
ConstituentCodes	Constituent codes define the high-level affiliations between constituents and your organization - such as Board member, Vendor, and Volunteer - to provide context for why constituents are in the database
ConstituentConsents	Returns a list of constituent consent records.
ConstituentFundraiserAssignments	Returns a list of fundraiser assignments for a constituent.
Constituents	Returns a paginated list of constituents
ConstituentsCustomFields	Retrieves custom fields for all constituents
ConstituentSolicitCodes	Returns a list of solicit codes for the specified constituent.
Countries	Returns the list of available countries.
Educations	Returns a list of educations for all constituent or a specified constituent
Emails	Returns a list of email addresses of all constituents or a specified constituent.
EventCategories	Returns a list of active event categories.
EventFees	Returns a list of fees for an event.
EventParticipantGuests	The participant's basic summary information
EventParticipantMemberships	The individual's membership category
EventParticipantOptions	Returns the participant options for an event.
EventParticipants	Returns a list of participants for an event.
Events	Returns a list of events
FundAttachments	Returns a list of attachments for a fund.
FundraiserAssignments	Returns a list of assignments for a fundraiser.
FundraiserGoals	Returns a list of goals for a fundraiser
FundraisingAppeals	Returns a list of fundraising appeals.
Funds	Returns a list of funds.
GetPledgeInstallments	This gets the installments of an existing pledge gift.
GetPledgePayments	This gets the payments of an existing pledge gift.
GiftAcknowledgements	Returns a list of acknowledgements for a gift
GiftAttachments	Returns a list of attachments for a gift.
GiftBatches	Returns a list of gift batches.
GiftFundraisers	Returns a list of attachments for a gift.
GiftPayments	Returns payments for a gift.
GiftReceipts	Returns receipts for a gift.
Gifts	Returns a paginated list of gifts
GiftsCustomFields	Retrieves custom fields for all gifts
GiftSoftCredits	Returns soft credits for a gift.
GiftSplits	Returns the splits for a gift.
Giving	Returns the first, latest or greatest gift recorded for a constituent.
GivingAppeals	Returns the giving appeals summary for the constituent
GivingCampaigns	Returns the giving campaigns summary for the constituent
GivingFunds	Returns the giving funds summary for the constituent
LifetimeGiving	Returns the lifetime giving information for a constituent.
Lists	Returns a list of lists for the given list type
Members	Returns the list of members.
Memberships	Returns a list of memberships.
Notes	Returns a list of notes that tracks helpful or important details such as specific interests and special instructions for donations
OnlinePresences	Returns a paginated list of online presences that store a constituent's social media accounts, websites.
Opportunities	Retrieves a list of opportunities
OpportunitiesCustomFields	Retrieves custom fields for an opportunity
OpportunityAttachments	Returns a list of attachments for an opportunity
Packages	Returns a list of packages that contains content and other items for the appeals that organizations use to solicit gifts
ParticipantFeePayments	Returns the fee payments for a participant.
ParticipantFees	Returns a list of fees for a participant.
ParticipantLevels	Returns a list of participation levels for all events.
ParticipantOptions	Returns the participant options for a participant.
Phones	Returns a list of phones for all constituents or a specific constituent
RatingCategories	Returns a list of all available rating categories.
Ratings	Returns a list of ratings for a constituent.
RatingSources	Returns a list of all available rating sources.
Relationships	Returns a list of relationships between constituents and other individuals and organizations such as family, friends, and employers
Tributes	Returns a list of tributes.

Retrieves a list of attachments for an action.

Table Specific Information

Select

The Sync App 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 Sync App.
Note: ActionId is required in order to query ActionAttachments.

• ActionId supports the '=' operator.

For example:

	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.

Retrieves custom fields for an action

Columns

Name	Type	References	Description
Id	String		The immutable system record ID of the custom field.
ActionId	String		The parent object's immutable system record ID.
Value	String		The value of the custom field.
Date	Datetime		The date on the custom field.
Category	String		The category on the custom field.
Commment	String		The date when the custom field was created.
Type	String		The type of data that the custom field represents.

Retrieves a list of actions for all constituents and for specified constituent and details of the specified action.

Table Specific Information

Select

The Sync App 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 Sync App.

• Id supports the '=' operator.
• ComputedStatus supports the '=' operator.
• ConstituentId supports the '=' operator.
• DateAdded supports the '>=,>' operators.
• DateModified supports the '>=,>' operators.
• StatusCode supports the '=,in' operators.

For example:

	
	SELECT * FROM Actions WHERE ConstituentId = '280'
	
	SELECT * FROM Actions WHERE ComputedStatus = 'Completed'
	
	SELECT * FROM Actions WHERE DateAdded >= '2010-06-01 14:03:35'
	

Columns

Name	Type	References	Description
Id [KEY]	String		The immutable system record ID of the action.
Category	String		The channel or intent of the constituent interaction.
Completed	Boolean		Indicates whether the action is complete.
CompletedDate	Datetime		The date when the action was completed.
ComputedStatus	String		The computed action status. 使用できる値は次のとおりです。Open, Completed, PastDue
ConstituentId	String	Constituents.Id	The immutable system record ID of the constituent associated with the action.
Date	Datetime		The action date.
DateAdded	Datetime		The date when the action was created.
DateModified	Datetime		The date when the action was last modified.
Description	String		The detailed explanation that elaborates on the action summary.
Direction	String		The direction of the action.
EndTime	String		The end time of the action.
Fundraisers	String		The set of immutable constituent system record IDs for the fundraisers associated with the action.
Location	String		The location of the action.
OpportunityId	String	Opportunities.Id	The immutable system record ID of the opportunity associated with the action.
Outcome	String		The outcome of the action. Available values are Successful and Unsuccessful.
Priority	String		The priority of the action.
StartTime	String		The start time of the action.
Status	String		The action status.
StatusCode	String		The action status code. This property is only returned when the system is configured to use custom action statuses. 使用できる値は次のとおりです。Closed, Completed, Pending, Not Completed, Open, Sent, Continuous
Summary	String		The short description of the action that appears at the top of the record.
Type	String		Additional description of the action to complement the category.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
ListId	String		Defines a list identifier used to filter the set of actions to those included in the specified list. If this value is set, other specified filters will be ignored.

Addresses store information about constituent residences and other addresses along with information about where or whether to send mail

Table Specific Information

Select

The Sync App 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 Sync App.

• Id supports the '=' operator.
• ConstituentId supports the '=' operator.
• DateAdded supports the '>=,>' operators.
• DateModified supports the '>=,>' operators.
• IncludeInactive supports the '=' operator.

For example:

	
	SELECT * FROM Addresses WHERE ConstituentId = '280'
	
	SELECT * FROM Addresses WHERE DateModified >= '2010-06-01 14:03:35'
	
	SELECT * FROM Addresses WHERE IncludeInactive = true

Columns

Name	Type	References	Description
Id [KEY]	String		The immutable system record ID of the address.
AddressLines	String		The address lines.
City	String		The city of the address.
ConstituentId	String	Constituents.Id	The immutable system record ID of the constituent associated with the address.
Country	String		The country of the address.
County	String		The county of the address.
DateAdded	Datetime		The date when the address was created.
DateModified	Datetime		The date when the address was last modified.
DoNotMail	Boolean		Indicates whether the constituent requests not to be contacted at this address.
End	Datetime		The date when the constituent ceased to reside at this address.
FormattedAddress	String		The date when the constituent ceased to reside at this address.
Inactive	Boolean		This computed field indicates that the address is active if the current date is before any end date.
PostalCode	String		The postal code of the address.
Preferred	Boolean		Indicates whether this is the constituent's preferred address.
SeasonalEndD	Integer		The day of the year ceases to reside at this address.
SeasonalEndM	Integer		The month of the year ceases to reside at this address.
SeasonalEndY	Integer		The year ceases to reside at this address.
SeasonalStartD	Integer		The day of year that the constituent begins residing at this address.
SeasonalStartM	Integer		The month of year that the constituent begins residing at this address.
SeasonalStartY	Integer		The year that the constituent begins residing at this address.
Start	Datetime		The date when the constituent began residing at this address.
State	String		The state of the address.
Suburb	String		The suburb of the address.
Type	String		The address type.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
IncludeInactive	Boolean		If set to true, includes inactive addresses in the result.

Retrieves a list of aliases for a constituent

Table Specific Information

Select

The Sync App 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 Sync App.
Note: ConstituentId is required in order to query Aliases.

• ConstituentId supports the '=' operator.

For example:

	SELECT * FROM Aliases WHERE ConstituentId = '280'

Columns

Name	Type	References	Description
Id [KEY]	String		The immutable system record ID of the alias.
ConstituentId	String	Constituents.Id	The immutable system record ID of the constituent associated with the alias.
Name	String		The name to use as the constituent's alias.
Type	String		The alias type.

Returns a list of attachments for an appeal.

Table Specific Information

Select

The Sync App 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 Sync App.
Note: AppealId is required in order to query AppealAttachments.

• AppealId supports the '=' operator.

For example:

	SELECT * FROM AppealAttachments WHERE AppealId = '2'

Columns

Name	Type	References	Description
Id [KEY]	String		The immutable system record ID of the attachment.
AppealId	String	FundraisingAppeals.Id	The immutable system record ID of the appeal.
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.

Returns a list of attachments for a campaign.

Table Specific Information

Select

The Sync App 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 Sync App.
Note: CampaignId is required in order to query CampaignAttachments.

• CampaignId supports the '=' operator.

For example:

	SELECT * FROM CampaignAttachments WHERE CampaignId = '2'

Columns

Name	Type	References	Description
Id [KEY]	String		The immutable system record ID of the attachment.
CampaignId	String	Campaigns.Id	The immutable system record ID of the campaign.
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.

Campaigns are your organization's overall fundraising efforts or initiatives, such as operating expenses, new buildings, and endowments

Table Specific Information

Select

The Sync App 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 Sync App.

• Id supports the '=' operator.
• DateAdded supports the '>=,>' operators.
• DateModified supports the '>=,>' operators.
• IncludeInactive supports the '=' operators.

For example:

	
	SELECT * FROM Campaigns WHERE DateModified >= '2010-06-01 14:03:35'
	
	SELECT * FROM Campaigns WHERE IncludeInactive = true

Columns

Name	Type	References	Description
Id [KEY]	String		The immutable system record ID of the campaign.
Category	String		The category of the campaign.
DateAdded	Datetime		The date when the campaign was created.
DateModified	Datetime		The date when the campaign was last modified.
Description	String		The display name of the campaign.
EndDate	Datetime		The end date of the campaign.
GoalValue	Double		The monetary goal associated with the campaign.
Inactive	Boolean		This computed field indicates that the campaign is active if the current date is after any start_date and before any end_date.
LookupId	String		The user-defined identifier for the campaign.
StartDate	Datetime		The start date of the campaign.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
IncludeInactive	Boolean		If set to true, includes inactive campaigns in the result.

Returns a list of consent categories.

Table Specific Information

Select

The Sync App 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 Sync App.

• IncludeInactive supports the '=' operator.

For example:

	
	SELECT * FROM ConsentCategories WHERE IncludeInactive = true
	

Columns

Name	Type	References	Description
Description	String		The name of the consent category.
Inactive	Boolean		Indicates whether the consent category is inactive.
Sequence	Integer		The placement of the category in the order of category table values, if defined.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
IncludeInactive	Boolean		If set to true, includes inactive consent categories in the result.

Returns a list of valid consent channel category combinations.

Table Specific Information

Select

The Sync App 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 Sync App.

Columns

Name	Type	References	Description
Category	String		The name of the category included in the channel/category combination.
Channel	String		The name of the channel included in the channel/category combination.
Sequence	Integer		The placement of the channel/category in the order of channel/category table values, if defined.

Represents the consent channel entity

Table Specific Information

Select

The Sync App 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 Sync App.

Columns

Name	Type	References	Description
Description	String		The name of the consent channel.

Represents the consent source entity

Table Specific Information

Select

The Sync App 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 Sync App.

• IncludeInactive supports the '=' operator.

For example:

	
	SELECT * FROM ConsentSources WHERE IncludeInactive = true
	

Columns

Name	Type	References	Description
Description	String		The name of the consent source.
Inactive	Boolean		Indicates whether the consent source is inactive.
Sequence	Integer		The placement of the source in the order of source table values, if defined.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
IncludeInactive	Boolean		If set to true, includes inactive consent sources in the result.

Returns a list of appeals for a constituent.

Table Specific Information

Select

The Sync App 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 Sync App.

• ConstituentId supports the '=' operator.

For example:

	
	SELECT * FROM ConstituentAppeals WHERE ConstituentId = '280'
	

Columns

Name	Type	References	Description
Id [KEY]	String		The immutable system record ID.
AppealCategoryDescription	String		The appeal category description.
AppealCategoryId	String		The immutable system record ID of the appeal category.
AppealCategoryInactive	Boolean		Indicates whether the appeal category is inactive.
AppealDescription	String		The appeal description.
AppealId	String		The immutable system record ID of the appeal.
ConstituentId	String	Constituents.Id	The immutable system record ID of the constituent the appeal is associated to.
Date	Datetime		The date when the appeal was added.
PackageDescription	String		The package description.
PackageId	String		The package Id.

Returns a list of attachments for a constituent.

Table Specific Information

Select

The Sync App 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 Sync App.
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	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.
Type	String		The attachment type.
Url	String		The URL for the attachment.

Constituent codes define the high-level affiliations between constituents and your organization - such as Board member, Vendor, and Volunteer - to provide context for why constituents are in the database

Table Specific Information

Select

The Sync App 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 Sync App.

• Id supports the '=' operator.
• ConstituentId supports the '=' operator.
• DateAdded supports the '>=,>' operators.
• DateModified supports the '>=,>' operators.
• IncludeInactive supports the '=' operator.

For example:

	
	SELECT * FROM ConstituentCodes WHERE Id = '144'

	SELECT * FROM ConstituentCodes WHERE ConstituentId = '280'
	
	SELECT * FROM ConstituentCodes WHERE DateAdded >= '1999-10-26T15:45:27'
	
	SELECT * FROM ConstituentCodes WHERE DateModified >= '1999-10-26T15:45:27'
	
	SELECT * FROM ConstituentCodes WHERE IncludeInactive = true
	

Columns

Name	Type	References	Description
Id [KEY]	String		The immutable system record ID of the constituent code.
ConstituentId	String	Constituents.Id	The immutable system record ID of the constituent associated with the constituent code.
DateAdded	Datetime		The date when the constituent code was created.
DateModified	Datetime		The date when the constituent code was last modified.
Description	String		The description of the constituent code.
Inactive	Boolean		This computed field indicates that the constituent code is active if the current date is after any start date and before any end date.
StartD	Integer		The start day of the constituent code.
StartM	Integer		The start month of the constituent code.
StartY	Integer		The start year of the constituent code.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
IncludeInactive	Boolean		This computed field indicates that the constituent code is active if the current date is after any start date and before any end date.

Returns a list of constituent consent records.

Table Specific Information

Select

The Sync App 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 Sync App.
Note: ConstituentId is required in order to query ConstituentConsents.

• ConstituentId supports the '=' operator.
• Category supports the '=,in' operators.
• Channel supports the '=,in' operators.
• MostRecentOnly supports the '=' operator.

For example:

	
	SELECT * FROM ConstituentConsents WHERE ConstituentId = '280'
	
	SELECT * FROM ConstituentConsents WHERE ConstituentId = '280' AND Channel IN ('Phone', 'Email')
	
	SELECT * FROM ConstituentConsents WHERE ConstituentId = '280' AND Category IN ('Fundraising', 'Newsletter')
	

Columns

Name	Type	References	Description
Id [KEY]	String		The immutable system record ID of the consent record.
ConstituentId	String	Constituents.Id	The immutable system record ID of the constituent the consent is associated to.
Category	String		The category that the consent response applies to.
Channel	String		The channel that the consent response applies to.
ConsentDate	Datetime		The date the consent response was received.
ConsentStatement	String		The statement the constituent responded to when providing consent.
ConstituentConsentResponse	String		How the constituent responded to consent for the specified channel/category.
DateAdded	Datetime		The date the consent response was added.
PrivacyNotice	String		The privacy notice provided to the constituent.
Source	String		The source of the consent response from the constituent.
UserName	String		The user that added the consent response.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
MostRecentOnly	Boolean		If set to true, includes inactive constituent consents in the result.

Returns a list of fundraiser assignments for a constituent.

Table Specific Information

Select

The Sync App 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 Sync App.
Note: ConstituentId is required in order to query ConstituentFundraiserAssignments.

• ConstituentId supports the '=' operator.
• IncludeInactive supports the '=' operator.

For example:

	SELECT * FROM ConstituentFundraiserAssignments WHERE ConstituentId = '280'

Columns

Name	Type	References	Description
Id [KEY]	String		The immutable system record ID of the fundraiser assignment.
AmountValue	Double		The goal amount for the fundraiser to solicit from the assigned constituent.
AppealId	String	FundraisingAppeals.Id	The immutable system record ID of the appeal the fundraiser should use to request gifts.
CampaignId	String	Campaigns.Id	The immutable system record ID of the campaign to apply resulting gifts to.
ConstituentId	String	Constituents.Id	The immutable system record ID of the constituent to apply resulting gifts to.
End	Datetime		The fundraiser assignment end date.
FundId	String	Funds.Id	The immutable system record ID of the fund any resulting gifts should be applied to.
FundraiserId	String		The immutable system record ID of the fundraiser.
Start	Datetime		The fundraiser assignment start date.
Type	String		The type of fundraiser.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
IncludeInactive	Boolean		If set to true, includes inactive assignments in the result.

Returns a paginated list of constituents

Table Specific Information

Select

The Sync App 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 Sync App.

• Id supports the '=,in' operators.
• DateAdded supports the '>=,>' operators.
• DateModified supports the '>=,>' operators.
• FundraiserStatus supports the '=,in' operators.
• ConstituentCode supports the '=' operator.
• CustomFieldCategory supports the '=' operator.
• Fields supports the '=,in' operators.
• IncludeDeceased supports the '=' operator.
• ListId supports the '=' operator.
• IncludeInactive supports the '=' operator.
• PostalCode supports the '=,in' operators.

For example:

	
	SELECT * FROM Constituents WHERE Id = '280'
	
	SELECT * FROM Constituents WHERE ListId = '75e71c26-7288-49db-a767-f9305b704fee'
	
	SELECT * FROM Constituents WHERE FundraiserStatus IN ('Active', 'None')

Columns

Name	Type	References	Description
Id [KEY]	String		The immutable system record ID for the constituent.
AddressLines	String		The address lines.
AddressCity	String		The city of the address.
AddressConstituentId	String		The immutable system record ID of the constituent associated with the address.
AddressCountry	String		The country of the address.
AddressCounty	String		The county of the address.
AddressDateAdded	Datetime		The date when the address was created.
AddressDateModified	Datetime		The date when the address was last modified.
AddressDoNotMail	Boolean		Indicates whether the constituent requests not to be contacted at this address.
AddressEnd	Datetime		The date when the constituent ceased to reside at this address.
AddressFormattedAddress	String		This computed field retrieves the formatted address in the configured format of the country.
AddressId	String		The immutable system record ID of the address.
AddressInactive	Boolean		This computed field indicates that the address is active if the current date is before any end date.
AddressPostalCode	String		The postal code of the address.
AddressPreferred	Boolean		Indicates whether this is the constituent's preferred address.
AddressSeasonalEndD	Integer		The day of the year ceases to reside at this address.
AddressSeasonalEndM	Integer		The month of the year ceases to reside at this address.
AddressSeasonalEndY	Integer		The year ceases to reside at this address.
AddressSeasonalStartD	Integer		The day of year that the constituent begins residing at this address.
AddressSeasonalStartM	Integer		The month of year that the constituent begins residing at this address.
AddressSeasonalStarty	Integer		The year that the constituent begins residing at this address.
AddressStart	Datetime		The date when the constituent began residing at this address.
AddressState	String		The state of the address.
AddressSuburb	String		The suburb of the address.
AddressType	String		The address type.
Age	Integer		This computed field calculates the constituent's age based on the birth date property.
BirthdateD	Integer		The constituent's day of birth.
BirthdateM	Integer		The constituent's month of birth.
BirthdateY	Integer		The constituent's year of birth.
DateAdded	Datetime		The date when the constituent was created.
DateModified	Datetime		The date when the constituent was last modified.
Deceased	Boolean		Indicates whether the constituent is deceased.
DeceasedDateD	Integer		The day of the year when the constituent died.
DeceasedDateM	Integer		The month of year when the constituent died.
DeceasedDateY	Integer		The year when the constituent died.
EmailAddress	String		The email address.
EmailConstituentId	String		The immutable system record ID of the constituent associated with the email address.
EmailDateAdded	Datetime		The date when the email address was created.
EmailDateModified	Datetime		The date when the email address was last modified.
EmailDoNotEmail	Boolean		Indicates whether the constituent requests not to be contacted at this email address.
EmailId	String		The immutable system record ID of the email address.
EmailInactive	Boolean		Indicates whether the email address is inactive.
EmailPrimary	Boolean		Indicates whether this is the constituent's primary email address.
EmailType	String		The type of email address. Available values are the entries in the Phone Types table.
First	String		The constituent's first name.
FormerName	String		The constituent's former name.
FundraiserStatus	String		Indicates whether the constituent is a fundraiser.
Gender	String		The constituent's gender.
GivesAnonymously	Boolean		Indicates whether the constituent gives anonymously.
Inactive	Boolean		Indicates whether the constituent is inactive.
Last	String		The constituent's last name.
LookupId	String		The user-defined identifier for the constituent.
MaritalStatus	String		The constituent's marital status.
Middle	String		The constituent's middle name.
Name	String		If the constituent's type is Individual, this is the full name of the constituent. If the type is Organization, this is the organization's name.
OnlinePresenceAddress	String		The web address for the online presence.
OnlinePresenceConstituentId	String		The immutable system record ID of the constituent associated with the online presence.
OnlinePresenceDateAdded	Datetime		The date when the online presence was created.
OnlinePresenceDateModified	Datetime		The date when the online presence was last modified.
OnlinePresenceId	String		The immutable system record ID of the online presence.
OnlinePresenceInactive	Boolean		Indicates whether the online presence is inactive.
OnlinePresencePrimary	Boolean		Indicates whether this is the constituent's primary online presence.
OnlinePresenceType	String		The online presence type.
PhoneConstituentId	String		The immutable system record ID of the constituent associated with the phone.
PhoneDateAdded	Datetime		The date when the phone was created.
PhoneDateModified	Datetime		The date when the phone was last modified.
PhoneDoNotCall	Boolean		Indicates whether the constituent requests not to be contacted at this number.
PhoneId	String		The immutable system record ID of the phone.
PhoneInactive	Boolean		Indicates whether the phone is inactive.
PhoneNumber	String		The phone number.
PhonePrimary	Boolean		Indicates whether this is the constituent's primary phone.
PhoneType	String		The phone type.
PreferredName	String		The constituent's preferred name.
SpouseFirst	String		This computed field retrieves information about the constituent's spouse using the constituent's relationships.
SpouseId	String		This computed field retrieves information about the constituent's spouse using the constituent's relationships.
SpouseLast	String		This computed field retrieves information about the constituent's spouse using the constituent's relationships.
Suffix	String		The constituent's primary suffix.
Suffix2	String		The constituent's secondary suffix.
Title	String		The constituent's primary title.
Title2	String		The constituent's secondary title.
Type	String		The type of constituent.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
ConstituentCode	String		Represents a list of constituent codes. Returns constituents if any of the specified constituent codes match any of their active constituent codes.
CustomFieldCategory	String		Represents a list of custom field categories. Returns constituents if any of the specified custom field categories match any of their active custom fields.
Fields	String		Represents the fields to include on the returned records.
IncludeDeceased	Boolean		Set this parameter to true to include deceased constituents in the response.
IncludeInactive	Boolean		Set this parameter to true to include inactive constituents in the response.
ListId	String		Defines a list identifier used to filter the set of constituents to those included in the specified list. If this value is set, other specified filters will be ignored.
PostalCode	String		Represents a comma-separated list of postal codes. Returns constituents if any of the specified postal codes match the postal code for their preferred address.

Retrieves custom fields for all constituents

Table Specific Information

Select

The Sync App 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 Sync App.

Columns

Name	Type	References	Description
Id	String		The immutable system record ID of the custom field.
ConstituentId	String		The parent object's immutable system record ID.
Name	String		The custom field category.
Value	String		The value of the custom field.
Comment	String		The comment on the custom field.
DateAdded	Datetime		The date when the custom field was created.
DateModified	Datetime		The date when the custom field was last modified.
Type	String		The type of data that the custom field represents.

Returns a list of solicit codes for the specified constituent.

Table Specific Information

Select

The Sync App 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 Sync App.
Note: ConstituentId is required in order to query ConstituentSolicitCodes.

• ConstituentId supports the '=' operator.

For example:

 
	SELECT * FROM ConstituentSolicitCodes WHERE ConstituentId = '280'
	

Columns

Name	Type	References	Description
Id [KEY]	String		The immutable system record ID of the constituent solicit code.
ConstituentId	String	Constituents.Id	The immutable system record ID of the constituent associated with the solicit code.
EndDate	Datetime		The end date of the solicit code.
SolicitCode	String		Communication instructions and/or restrictions for a constituent.
StartDate	Datetime		The start date of the solicit code.

Returns the list of available countries.

Table Specific Information

Select

The Sync App 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 Sync App.

Columns

Name	Type	References	Description
Id [KEY]	String		The immutable system record ID of the country.
Abbreviation	String		The user-defined abbreviation for the country.
Name	String		The country name.

Returns a list of educations for all constituent or a specified constituent

Table Specific Information

Select

The Sync App 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 Sync App.

• Id supports the '=' operator.
• ConstituentId supports the '=' operator.
• DateAdded supports the '>=,>' operators.
• DateModified supports the '>=,>' operators.

For example:

	
	SELECT * FROM Educations WHERE ConstituentId = '280'
	
	SELECT * FROM Educations WHERE DateAdded >= '2010-06-01 14:03:35'	

Columns

Name	Type	References	Description
Id [KEY]	String		The immutable system record ID of the education.
Campus	String		The campus.
ClassOf	String		The year the constituent graduated.
ClassOfDegree	String		The class of degree.
ConstituentId	String	Constituents.Id	The immutable system record ID of the constituent associated with the education.
DateAdded	Datetime		The date when the education was created.
DateEnteredD	Integer		The first day of attendance.
DateEnteredM	Integer		The first month of attendance.
DateEnteredY	Integer		The first year of attendance.
DateGraduatedD	Integer		The graduation day.
DateGraduatedM	Integer		The graduation month.
DateGraduatedY	Integer		The graduation year.
DateLeftD	Integer		The last day of attendance.
DateLeftM	Integer		The last month of attendance.
DateLeftY	Integer		The last year of attendance.
DateModified	Datetime		The date when the education was last modified.
Degree	String		The degree received.
Department	String		The name of the education department.
Faculty	String		The name of the faculty.
Gpa	Double		The grade point average.
KnownName	String		The known name.
Majors	String		The major courses of study.
Minors	String		The minor courses of study.
Primary	Boolean		Indicates whether this is the constituent's primary school association.
RegistrationNumber	String		The registration number.
School	String		The school name.
SocialOrganization	String		The social organization.
Status	String		The status of the education.
SubjectOfStudy	String		The subject of study.
Type	String		The type of education.

Returns a list of email addresses of all constituents or a specified constituent.

Table Specific Information

Select

The Sync App 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 Sync App.

• ConstituentId supports the '=,in' operators.
• DateAdded supports the '>=,>' operators.
• DateModified supports the '>=,>' operators.
• IncludeInactive supports "=" operator.

For example:

	
	SELECT * FROM Emails WHERE ConstituentId = '280'
	
	SELECT * FROM Emails WHERE DateAdded >= '2010-06-01 14:03:35'

Columns

Name	Type	References	Description
Id [KEY]	String		The immutable system record ID of the email address.
Address	String		The email address.
ConstituentId	String	Constituents.Id	The immutable system record ID of the constituent associated with the email address.
DateAdded	Datetime		The date when the email address was created.
DateModified	Datetime		The date when the email address was last modified.
DoNotEmail	Boolean		Indicates whether the constituent requests not to be contacted at this email address.
Inactive	Boolean		Indicates whether the email address is inactive.
Primary	Boolean		Indicates whether this is the constituent's primary email address.
Type	String		The type of email address.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
IncludeInactive	Boolean		If set to true, includes inactive email addresses in the result.

Returns a list of active event categories.

Table Specific Information

Select

The Sync App 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 Sync App.

• IncludeInactive supports the '=' operator.

For example:

	
	SELECT * FROM EventCategories WHERE IncludeInactive = true

Columns

Name	Type	References	Description
Id [KEY]	String		The ID of the event category.
Inactive	Boolean		Whether the category is inactive. True if inactive.
Name	String		The name of the event category.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
IncludeInactive	Boolean		If set to true, includes inactive campaigns in the result.

Returns a list of fees for an event.

Table Specific Information

Select

The Sync App 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 Sync App.
Note: EventId is required in order to query EventFees.

• EventId supports the '=' operator.

For example:

	SELECT * FROM EventFees WHERE EventId = '2'

Columns

Name	Type	References	Description
Id [KEY]	String		The ID of the event fee.
ContributionAmount	Double		The tax deductible amount for this fee.
Cost	Double		The fee's cost.
EventId	String	Events.Id	The ID of the event the fee is linked to.
Name	String		The name of the event fee.
NumberSold	Integer		The number of fees sold.

The participant's basic summary information

Table Specific Information

Select

The Sync App 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 Sync App.
Note: EventId is required in order to query EventParticipantGuests.

• EventId supports the '=' operator.

For example:

	SELECT * FROM EventParticipantGuests WHERE EventId = '2'

Columns

Name	Type	References	Description
ContactId	String		The ID of the contact attending the event.
EventId	String	Events.Id	The ID of the event which the participant belongs to.
Name	String		The participant's full name.
ParticipantId	String		The ID of the participant.

The individual's membership category

Table Specific Information

Select

The Sync App 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 Sync App.
Note: EventId is required in order to query EventParticipantMemberships.

• EventId supports the '=' operator.

For example:

	SELECT * FROM EventParticipantMemberships WHERE EventId = '2'

Columns

Name	Type	References	Description
CategoryId	String		The ID of the membership category.
CategoryName	String		The name of the membership category.
EventId	String	Events.Id	The ID of the event which the participant belongs to.

Returns the participant options for an event.

Table Specific Information

Select

The Sync App 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 Sync App.
Note: EventId is required in order to query EventParticipantOptions.

• EventId supports the '=' operator.

For example:

	SELECT * FROM EventParticipantOptions WHERE EventId = '2'

Columns

Name	Type	References	Description
Id [KEY]	String		The ID of the event participant option.
EventId	String	Events.Id	The ID of the event which the participant belongs to.
AddedByService	String		The ID of the service who added this option.
AddedByUser	String		The ID of the user that added this option.
DateAdded	Datetime		The date this option was added.
DateUpdated	Datetime		The date this option was updated.
InputType	String		The available types of event participant options.
ListOptions	String		A event participant option list option.
MultiSelect	Boolean		Only valid for List input type, determines if multiple options can be selected.
Name	String		The name of the event participant option.
ParticipantId	String		The ID of the participant.
UpdatedByService	String		The ID of the service who updated this option.
UpdatedByUser	String		The ID of the user who updated this option.
Version	Integer		The version number of the option.

Returns a list of participants for an event.

Table Specific Information

Select

The Sync App 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 Sync App.
Note: EventId is required in order to query EventParticipants.

• Attended supports the '=' operator.
• DateAdded supports the '>=,>' operators.
• DateModified supports the '>=,>' operators.
• EventId supports the '=' operator.
• InvitationStatus supports the '=' operator.
• IsConstituent supports the '=' operator.
• ParticipationLevelName supports the '=,in' operators.
• RsvpStatus supports the '=,in' operators.
• EmailEligible supports the '=' operator.
• PhoneCallEligible supports the '=' operator.
• FeesPaid supports the '=' operator.
• Fields supports the '=' operator.

For example:

	SELECT * FROM EventParticipants WHERE EventId = '2'
	
	SELECT * FROM EventParticipants WHERE EventId = '2' AND DateAdded >= '2010-06-01 14:03:35'

Columns

Name	Type	References	Description
Id [KEY]	String		The ID of the participant.
Attended	Boolean		Whether the participant attended the event.
ClassOf	String		The participant's graduating class.
ContactId	String		The ID of the contact attending the event.
DateAdded	Datetime		The date the participant was created.
DateModified	Datetime		The date when the participant was last modified.
DoNotCall	Boolean		The participant's phone call preference.
DoNotEmail	Boolean		The participant's email preference.
Email	String		The participant's email address.
EventId	String	Events.Id	The ID of the event which the participant belongs to.
FirstName	String		The participant's first name.
FormerName	String		The participant's former name.
HostContactId	String		The ID of the contact attending the event.
HostName	String		The participant's full name.
HostParticipantId	String		The ID of the host participant.
InvitationStatus	String		The possible states for a constituent's invitation to an event.
IsConstituent	Boolean		Indicates whether the participant is a constituent.
LastName	String		The participant's last name.
LookupId	String		The LookupId of the participant.
MiddleName	String		The participant's middle name.
Name	String		The participant's full name.
NameTag	String		The name tag for the participant.
ParticipationLevelId	String		The ID of the participation level.
ParticipationLevelIsInactive	Boolean		Whether the participation level is inactive. True if inactive.
ParticipationLevelName	String		The name of the participation level.
Phone	String		The participant's phone number.
PreferredName	String		The participant's preferred name.
RsvpDateD	Integer		The day in the fuzzy date.
RsvpDateM	Integer		The month in the fuzzy date.
RsvpDateY	Integer		The year in the fuzzy date.
RsvpStatus	String		The possible states for a participant's RSVP for an event.
Seat	String		The seat assignment for the participant.
Suffix	String		The participant's suffix.
Title	String		The participant's title.
TotalPaid	Integer		The sum of the participant's paid gifts with a type of Registration Fees.
TotalRegistrationFees	Integer		The sum of the participant's fee amounts.
SummaryNote	String		summary Notes.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
EmailEligible	Boolean		A filter to include or exclude participants based on whether they have a primary email address that's not marked Do not email.
PhoneCallEligible	Boolean		A filter to include or exclude participants based on whether they have a primary phone number that's not marked Do not call.
FeesPaid	Boolean		A filter to include or exclude participants that have paid or not paid their fees.
Fields	String		Represents a list of fields to include on the returned records.

Returns a list of events

Table Specific Information

Select

The Sync App 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 Sync App.

• Id supports the '=' operator.
• CategoryName supports the '=' operator.
• DateAdded supports the '>=,>' operators.
• DateModified supports the '>=,>' operators.
• Name supports the '=' operator.
• StartDate supports the '>=,<=' operators.
• IncludeInactive supports the '=' operator.
• Fields supports the '=' operator.

For example:

	
	SELECT * FROM Events WHERE Id = '2'
	
	SELECT * FROM Events WHERE StartDate >= '2000-04-06T05:50:00' AND StartDate <= '2020-04-06T06:50:00'
	
	SELECT * FROM Events WHERE DateAdded >= '2010-06-01 14:03:35'

Columns

Name	Type	References	Description
Id [KEY]	String		The ID of the event.
AttendedCount	Integer		The number of event attendees.
AttendingCount	Integer		The number of event participants who plan to attend.
CampaignId	String		The ID of the campaign affiliated with the event.
Capacity	Integer		The number of people that can attend the event.
CategoryId	String		The ID of the event category.
CategoryInactive	Boolean		Whether the category is inactive.
CategoryName	String		The name of the event category.
DateAdded	Datetime		The date when the event was created.
DateModified	Datetime		The date when the event was last modified.
EndDate	Date		The end date of the event.
EndTime	String		The end time of the event.
FundId	String		The ID of the fund affiliated with the event.
Goal	Double		The monetary goal of the event.
Inactive	Boolean		Whether the event is inactive.
InvitedCount	Integer		The number of event invitees.
LocationName	String		The name of the location.
LocationAddressLines	String		The location's address lines.
LocationPostalCode	String		The location's postal code.
LocationLocalityId	String		The record ID of the locality record.
LocationLocalityName	String		The name of the locality.
LocationAdministrativeAreaId	String		The record ID of the administrative area.
LocationAdministrativeAreaName	String		The name of the administrative area.
LocationAdministrativeAreaShortDesc	String		The short description of the administrative area.
LocationSubAdministrativeAreaId	String		The ID of the sub administrative area.
LocationSubAdministrativeAreaName	String		The name of the sub administrative area.
LocationCountryId	String		The ID of the country record.
LocationCountryDisplayName	String		The display name of the country.
LocationCountryIsoAlpha2Code	String		The ISO 3166-1 alpha-2 code for the country.
LocationFormattedAddress	String		The location's formatted address.
LookupId	String		The lookup ID of the event.
Name	String		The name of the event.
StartDate	Date		The start date of the event.
StartTime	String		The start time of the event.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
Fields	String		Represents a list of fields to include on the returned records
IncludeInactive	Boolean		If set to true, includes inactive phones in the result.

Returns a list of attachments for a fund.

Table Specific Information

Select

The Sync App 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 Sync App.
Note: FundId is required in order to query FundAttachments.

• FundId supports the '=' operator.

For example:

	SELECT * FROM FundAttachments WHERE FundId = '4'
	

Columns

Name	Type	References	Description
Id [KEY]	String		The immutable system record ID of the attachment.
FundId	String	Funds.Id	The immutable system record ID of the fund.
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.

Returns a list of assignments for a fundraiser.

Table Specific Information

Select

The Sync App 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 Sync App.
Note: FundraiserId is required in order to query FundraiserAssignments.

• FundraiserId supports the '=' operator.

For example:

	SELECT * FROM FundraiserAssignments WHERE FundraiserId = '4'
	

Columns

Name	Type	References	Description
Id	String		The immutable system record ID of the given assignment.
AmountValue	Double		The goal amount for the fundraiser to solicit from the assigned constituent.
AppealId	String	FundraisingAppeals.Id	The immutable system record ID of the appeal the fundraiser should use to request gifts.
CampaignId	String	Campaigns.Id	The immutable system record ID of the campaign to apply resulting gifts to.
ConstituentId	String	Constituents.Id	The immutable system record ID of the target constituent.
End	Datetime		The fundraiser end date.
FundId	String	Funds.Id	The immutable system record ID of the fund any resulting gifts should be applied to.
FundraiserId	String		The immutable system record ID of the fundraiser assigned to the constituent.
Start	Datetime		The fundraiser start date.
Type	String		The type of fundraiser.

Returns a list of goals for a fundraiser

Table Specific Information

Select

The Sync App 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 Sync App.
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.

Returns a list of fundraising appeals.

Table Specific Information

Select

The Sync App 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 Sync App.

• Id supports the '=,in' operators.
• DateAdded supports the '>=,>' operators.
• DateModified supports the '>=,>' operators.
• IncludeInactive supports the '=' operator.

For example:

	
	SELECT * FROM FundraisingAppeals WHERE Id = '4'
	
	SELECT * FROM FundraisingAppeals WHERE IncludeInactive = true

Columns

Name	Type	References	Description
Id [KEY]	String		The immutable system record ID of the appeal.
Category	String		The category of the appeal.
DateAdded	Datetime		The date when the appeal was created.
DateModified	Datetime		The date when the appeal was last modified.
Description	String		The display name of the appeal.
EndDate	Datetime		The end date of the appeal.
GoalValue	Double		The monetary goal associated with the appeal.
Inactive	Boolean		This computed field indicates that the appeal is active if the current date is after any start_date and before any end_date.
LookupId	String		The user-defined identifier for the appeal.
StartDate	Datetime		The start date of the appeal.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
IncludeInactive	Boolean		If set to true, includes inactive appeals in the result.

Returns a list of funds.

Table Specific Information

Select

The Sync App 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 Sync App.

• Id supports the '=,in' operators.
• DateAdded supports the '>=,>' operators.
• DateModified supports the '>=,>' operators.
• IncludeInactive supports the '=' operator.

For example:

	
	SELECT * FROM Funds WHERE Id = '4'
	
	SELECT * FROM Funds WHERE IncludeInactive = true

Columns

Name	Type	References	Description
Id [KEY]	String		The immutable system record ID of the fund.
Category	String		The category of the fund.
DateAdded	Datetime		The date when the fund was created.
DateModified	Datetime		The date when the fund was last modified.
Description	String		The display name of the fund.
EndDate	Datetime		The end date of the fund.
GoalValue	Double		The monetary goal associated with the fund.
Inactive	Boolean		This computed field indicates that the fund is active if the current date is after any start_date and before any end_date.
LookupId	String		The user-defined identifier for the fund.
StartDate	Datetime		The start date of the fund.
Type	String		The type of the fund.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
IncludeInactive	Boolean		If set to true, includes inactive funds in the result.

This gets the installments of an existing pledge gift.

Columns

Name	Type	References	Description
Id [KEY]	String		ID
GiftId	String	Gifts.Id	The immutable system record ID of the gift the attachments are associated to.
AmountValue	Double		The Amount Value.
Date	Datetime		Date
Sequence	Integer		Sequence
Year	Integer		Year

This gets the payments of an existing pledge gift.

Columns

Name	Type	References	Description
PaymentGiftId [KEY]	String		The Payment Gift Id.
InstallmentId	String		The Id for the installment.
GiftId	String	Gifts.Id	The immutable system record ID of the gift the attachments are associated to.
AmountAppliedValue	Double		The amount applied value.

Returns a list of acknowledgements for a gift

Table Specific Information

Select

The Sync App 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 Sync App.

• GiftId supports the '=' operator.

For example:

	SELECT * FROM GiftAcknowledgements
	SELECT * FROM GiftAcknowledgements WHERE GiftId = '476'

Columns

Name	Type	References	Description
GiftId	String	Gifts.Id	The immutable system record ID of the gift associated with the acknowledgement.
Date	Datetime		The date associated with the acknowledgement.
Letter	String		The letter associated with the acknowledgement.
Status	String		The status of the acknowledgement. Available values are: ACKNOWLEDGED, NEEDSACKNOWLEDGEMENT, and DONOTACKNOWLEDGE.

Returns a list of attachments for a gift.

Table Specific Information

Select

The Sync App 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 Sync App.
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	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.

Returns a list of gift batches.

Table Specific Information

Select

The Sync App 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 Sync App.

• BatchNumber supports the '=' operator.
• CreatedBy supports the '=' operator.
• HasExceptions supports the '=' operator.
• IsApproved supports the '=' operator.
• SearchText supports the '=' operator.

Columns

Name	Type	References	Description
Id [KEY]	String		The batch identifier.
ActualAmount	Double		The actual batch amount.
BatchDescription	String		The batch description.
BatchNumber	String		The batch number.
CreatedBy	String		Created by user name.
AddedBy	String		Added by user name.
CreatedOn	Datetime		The date the batch was created.
DateAdded	Datetime		The date the batch was added.
HasExceptions	Boolean		The has exceptions boolean.
IsApproved	Boolean		Approved boolean.
Approved	Boolean		Approved boolean.
NumberOfGifts	Integer		The number of gifts in the batch.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
SearchText	String		If set to true, includes inactive gift batches in the result.

Returns a list of attachments for a gift.

Table Specific Information

Select

The Sync App uses 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 Sync App.
Note: GiftId are required in order to query GiftFundraisers.

• GiftId supports the '=' operator.

For example:

	SELECT * FROM GiftFundraisers WHERE GiftId = '476'

Columns

Name	Type	References	Description
GiftId	String	Gifts.Id	The immutable system record ID of the gift the fundraisers are associated to.
AmountValue	Decimal		The amount credited to the fundraiser for the gift.
ConstituentId	String		The immutable constituent system record ID for the fundraiser associated with the gift.

Returns payments for a gift.

Table Specific Information

Select

The Sync App 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 Sync App.

• GiftId supports the '=' operator.

For example:

	SELECT * FROM GiftPayments
	SELECT * FROM GiftPayments WHERE GiftId = '476'

Columns

Name	Type	References	Description
GiftId	String	Gifts.Id	The immutable system record ID of the gift associated with the payment.
AccountToken	String		The tokenized account information (e.g. credit card) from the external payment provider. Only applies to payment methods of CreditCard and DirectDebit.
BbpsConfigurationId	String		The bbps configuration ID. Only applies to payment methods of CreditCard and DirectDebit.
BbpsTransactionId	String		The bbps transaction ID. Only applies to payment methods of CreditCard and DirectDebit.
CheckDateD	Integer		The day of the check date. Only applies to payment method of PersonalCheck.
CheckDateM	Integer		The month of the check date. Only applies to payment method of PersonalCheck.
CheckDateY	Integer		The year of the check date. Only applies to payment method of PersonalCheck.
CheckNumber	String		The check number. Only applies to payment method of PersonalCheck.
CheckoutTransactionId	String		The checkout transaction ID. Only applies to payment methods of CreditCard and DirectDebit.
PaymentMethod	String		The payment method.
Reference	String		The reference.
ReferenceDateD	Integer		The day of the reference date.
ReferenceDateM	Integer		The month of the reference date.
ReferenceDateY	Integer		The year of the reference date.

Returns receipts for a gift.

Table Specific Information

Select

The Sync App 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 Sync App.

• GiftId supports the '=' operator.

For example:

	SELECT * FROM GiftReceipts
	SELECT * FROM GiftReceipts WHERE GiftId = '476'

Columns

Name	Type	References	Description
GiftId	String	Gifts.Id	The immutable system record ID of the gift associated with the receipt.
AmountValue	Double		The amount of the receipt.
Date	Datetime		The date on the receipt.
Number	Integer		The number of the receipt.
Status	String		The status of the receipt. Available values are: RECEIPTED, NEEDSRECEIPT, and DONOTRECEIPT.

Returns a paginated list of gifts

Table Specific Information

Select

The Sync App 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 Sync App.

• Id supports the '=' operator.
• ConstituentId supports the '=,in' operators.
• Date supports the '>=,<=' operators.
• DateAdded supports the '>=,>' operators.
• DateModified supports the '>=,>' operators.
• PostStatus supports the '=,in' operators.
• Type supports the '=' operator.
• ListId supports the '=' operator.
• AppealId supports the '=,in' operators.
• FundId supports the '=,in' operators.
• CampaignId supports the '=,in' operators.
• AcknowledgmentStatus supports the '=,in' operators.
• ReceiptStaus supports the '=,in' operators.

For example:

	
	SELECT * FROM Gifts WHERE ConstituentId IN ('280', '281')
	
	SELECT * FROM Gifts WHERE PostStatus = 'Posted'
	
	SELECT * FROM Gifts WHERE Type IN ('Pledge', 'GiftInKind')

Columns

Name	Type	References	Description
Id [KEY]	String		The immutable system record ID of the gift.
AmountValue	Double		The monetary amount of the gift.
BalanceValue	Double		The balance remaining on the gift.
BatchNumber	String		The batch number associated with this gift.
Constituency	String		The constituency of the gift.
ConstituentId	String		The immutable system record ID of the constituent associated with the gift.
Date	Date		The gift date.
DateAdded	Datetime		The date when the gift was created.
DateModified	Datetime		The date when the gift was last modified.
GiftAidAmountValue	Double		This computed field calculates the total qualified amount of tax reclaimed from Gift Aid across all gift_splits for this gift.
GiftAidQualificationStatus	String		This computed field determines the Gift Aid qualification status based on tax declaration information and the database format. Available values are: Qualified, NotQualified, and PartlyQualified. For the UK only.
GiftStatus	String		The status of the gift. Available values are Active, Held, Terminated, Completed, and Cancelled.
IsAnonymous	Bool		Indicates whether the gift is anonymous.
LinkedGifts	String		The identifiers of other gifts that are linked to this gift.
LookupId	String		The user-defined identifier for the gift.
Origin	String		The origin of the gift.
PostDate	Datetime		The date that the gift was posted to general ledger.
PostStatus	String		The general ledger post status of the gift.
RecurringGiftStatusDateD	Integer		The date (D) that the gift status was last modified.
RecurringGiftStatusDateM	Integer		The date (M) that the gift status was last modified.
RecurringGiftStatusDateY	Integer		The date (Y) that the gift status was last modified.
Reference	String		Notes to track special details about a gift such as the motivation behind it or a detailed description of a gift-in-kind.
Subtype	String		The subtype of the gift.
Type	String		The gift type.
GiftCode	String		The gift Code.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
ListId	String		Defines a list identifier used to filter the set of gifts to those included in the specified list. If this value is set, other specified filters will be ignored.
AppealId	String		Returns gifts if any of the specified appeal identifiers match any of their appeals.
FundId	String		Returns gifts if any of the specified fund identifiers match any of their funds.
CampaignId	String		Returns gifts if any of the specified campaign identifiers match any of their campaigns.
AcknowledgmentStatus	String		Returns gifts if their acknowledgement status matches any specified.
ReceiptStaus	String		Returns gifts if their receipt status matches any specified.

Retrieves custom fields for all gifts

Table Specific Information

Select

The Sync App 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 Sync App.

Columns

Name	Type	References	Description
Id	String		The immutable system record ID of the custom field.
GiftId	String		The parent object's immutable system record ID.
Name	String		The custom field category.
Value	String		The value of the custom field.
Comment	String		The comment on the custom field.
DateAdded	Datetime		The date when the custom field was created.
DateModified	Datetime		The date when the custom field was last modified.
Type	String		The type of data that the custom field represents.

Returns soft credits for a gift.

Table Specific Information

Select

The Sync App 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 Sync App.

• GiftId supports the '=' operator.

For example:

	SELECT * FROM GiftSoftCredits
	SELECT * FROM GiftSoftCredits WHERE GiftId = '476'

Columns

Name	Type	References	Description
Id [KEY]	String		The immutable system record ID of the soft credit.
AmountValue	Double		The amount of the soft credit.
ConstituentId	String		The immutable system record ID of the constituent associated with the soft credit.
GiftId	String	Gifts.Id	The immutable system record ID of the gift associated with the soft credit.

Returns the splits for a gift.

Table Specific Information

Select

The Sync App 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 Sync App.

• GiftId supports the '=' operator.

For example:

	SELECT * FROM GiftSplits
	SELECT * FROM GiftSplits WHERE GiftId = '476'

Columns

Name	Type	References	Description
Id [KEY]	String		The immutable system record ID of the gift split.
GiftId	String	Gifts.Id	The immutable system record ID of the gift associated with the gift split.
AmountValue	Decimal		The amount of the gift split.
AppealId	String		The immutable system record ID of the appeal associated with the gift split.
CampaignId	String		The immutable system record ID of the campaign associated with the gift split.
FundId	String		The immutable system record ID of the fund associated with the gift split.
GiftAidAmount	Decimal		The amount of tax reclaimed from gift aid for this gift split. For the UK only.
GiftAidQualificationStatus	String		The gift aid qualification status of the gift split. Available values are: Qualified, and NotQualified. For the UK only.
PackageId	String		The immutable system record ID of the package associated with the gift split.

Returns the first, latest or greatest gift recorded for a constituent.

Table Specific Information

Select

The Sync App 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 Sync App.
Note: ConstituentId and GivingSummaryType are required in order to query Giving.

• ConstituentId supports the '=' operator.
• GivingSummaryType supports the '=' operator.

For example:

	SELECT * FROM Giving WHERE ConstituentId = '280' AND GivingSummaryType = 'greatest'

Columns

Name	Type	References	Description
Id [KEY]	String		The immutable system record ID of the gift.
AmountValue	Double		The gift amount.
Date	Date		The gift date.
Type	String		The gift type.
ConstituentId	String	Constituents.Id	The immutable system record ID of the constituent associated with this giving.
GivingSummaryType	String		The giving summary type. Available values are First, Latest and Greatest. 使用できる値は次のとおりです。first, greatest, latest

Returns the giving appeals summary for the constituent

Table Specific Information

Select

The Sync App 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 Sync App.
Note: ConstituentId and GivingSummaryType are required in order to query GivingAppeals.

• ConstituentId supports the '=' operator.
• GivingSummaryType supports the '=' operator.

For example:

	SELECT * FROM GivingAppeals WHERE ConstituentId = '280' AND GivingSummaryType = 'first'

Columns

Name	Type	References	Description
Id [KEY]	String		The immutable system record ID of the appeal.
Description	String		The description.
ConstituentId	String	Constituents.Id	The immutable system record ID of the constituent associated with this giving.
GivingSummaryType	String		The giving summary type. Available values are First, Latest and Greatest. 使用できる値は次のとおりです。first, greatest, latest

Returns the giving campaigns summary for the constituent

Table Specific Information

Select

The Sync App 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 Sync App.
Note: ConstituentId and GivingSummaryType are required in order to query GivingCampaigns.

• ConstituentId supports the '=' operator.
• GivingSummaryType supports the '=' operator.

For example:

	SELECT * FROM GivingCampaigns WHERE ConstituentId = '280' AND GivingSummaryType = 'greatest'

Columns

Name	Type	References	Description
Id [KEY]	String		The immutable system record ID of the campaign.
Description	String		The campaign description.
ConstituentId	String	Constituents.Id	The immutable system record ID of the constituent associated with this giving.
GivingSummaryType	String		The giving summary type. Available values are First, Latest and Greatest. 使用できる値は次のとおりです。first, greatest, latest

Returns the giving funds summary for the constituent

Table Specific Information

Select

The Sync App 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 Sync App.
Note: ConstituentId and GivingSummaryType are required in order to query GivingFunds.

• ConstituentId supports the '=' operator.
• GivingSummaryType supports the '=' operator.

For example:

	
	SELECT * FROM GivingFunds WHERE ConstituentId = '280' AND GivingSummaryType = 'latest'

Columns

Name	Type	References	Description
Id [KEY]	String		The immutable system record ID of the fund.
Description	String		The fund description.
ConstituentId	String	Constituents.Id	The immutable system record ID of the constituent associated with this giving.
GivingSummaryType	String		The giving summary type. Available values are First, Latest and Greatest. 使用できる値は次のとおりです。first, greatest, latest

Returns the lifetime giving information for a constituent.

Table Specific Information

Select

The Sync App 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 Sync App.
Note: ConstituentId are required in order to query LifetimeGiving.

• ConstituentId supports the '=' operator.

For example:

	SELECT * FROM LifetimeGiving WHERE ConstituentId = '280'

Columns

Name	Type	References	Description
ConsecutiveYearsGiven	Integer		This computed field calculates the number of consecutive years the constituent has given.
ConstituentId	String	Constituents.Id	The immutable system record ID of the constituent associated with the lifetime giving.
TotalCommittedMatchingGiftsValue	Double		This computed field calculates the total amount of matching gift commitments attributed to the constituent.
TotalGivingValue	Double		This computed field calculates the total amount given by the constituent.
TotalPledgeBalanceValue	Double		This computed field calculates the unpaid pledge balance for the constituent.
TotalReceivedGivingValue	Double		This computed field calculates the total received amount given by the constituent.
TotalReceivedMatchingGiftsValue	Double		This computed field calculates the total amount of payments toward matching gift pledges attributed to the constituent.
TotalSoftCreditsValue	Double		This computed field calculates the total amount of soft credits applied to the constituent.
TotalYearsGiven	Integer		This computed field calculates the total number of years the constituent has given.

Returns a list of lists for the given list type

Table Specific Information

Select

The Sync App 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 Sync App.

• ListType supports the '=' operator.

For example:

	SELECT * FROM Lists WHERE ListType = 'Constituent'
	

Columns

Name	Type	References	Description
Id [KEY]	String		The immutable system record ID for the list.
DateModified	Datetime		The date this list was last modified.
Description	String		The description of the list
IsPublic	Boolean		Indicates whether this is a public or private list.
LastModifiedByUserId	String		The ID of the user that last modified the list.
LastModifiedByUserName	String		The name of the user that last modified the list.
Name	String		The name of the list.
RecordCount	Integer		The total number of records defined by this list based on the last time this list was saved.
ListType	String		Type of the list. 使用できる値は次のとおりです。Constituent, Gift, Action, Opportunity

Returns the list of members.

Table Specific Information

Select

The Sync App 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 Sync App.

• ConstituentId supports the '=' operator.

For example:

	SELECT * FROM Members WHERE ConstituentId = '280'

Columns

Name	Type	References	Description
Id [KEY]	String		The immutable system record ID of the member.
ConstituentId	String	Constituents.Id	The immutable system record ID of the constituent associated with the member.
Primary	Boolean		Indicates whether this is the primary member on the membership.

Returns a list of memberships.

Table Specific Information

Select

The Sync App 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 Sync App.

• ConstituentId supports the '=' operator.
• DateAdded supports the '>=,>' operators.
• DateModified supports the '>=,>' operators.

For example:

	
	SELECT * FROM Memberships WHERE ConstituentId = '280'
	
	SELECT * FROM Memberships WHERE DateAdded >= '2010-06-01 14:03:35'

Columns

Name	Type	References	Description
Id [KEY]	String		The immutable system record ID of the membership.
ConstituentId	String	Constituents.Id	The immutable system record ID of the constituent associated with the membership.
Category	String		The membership category.
DateAdded	Datetime		The date when the membership was created.
DateModified	Datetime		The date when the membership was last modified.
DuesValue	Double		The membership dues.
Expires	Datetime		The date when the membership expires.
Joined	Datetime		The date when the membership becomes active.
Program	String		The membership program.
Standing	String		The membership status. Available values are New, Active, Lapsed, and Dropped.
Subcategory	String		The membership subcategory.

Returns a list of notes that tracks helpful or important details such as specific interests and special instructions for donations

Table Specific Information

Select

The Sync App 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 Sync App.

• Id supports the '=' operator.
• ConstituentId supports the '=' operator.
• DateAdded supports the '>=,>' operators.
• DateModified supports the '>=,>' operators.

For example:

	
	SELECT * FROM Notes WHERE ConstituentId = '280'
	
	SELECT * FROM Notes WHERE DateAdded >= '2010-06-01 14:03:35'
	

Columns

Name	Type	References	Description
Id [KEY]	String		The immutable system record ID of the note.
ConstituentId	String	Constituents.Id	The immutable system record ID of the constituent associated with the note.
DateD	Integer		The day of note date.
DateM	Integer		The month of note date.
DateY	Integer		The year of note date.
DateAdded	Datetime		The date when the note was created.
DateModified	Datetime		The date when the note was last modified.
Summary	String		The note summary.
Text	String		The note's contents.
Type	String		The note type.

Returns a paginated list of online presences that store a constituent's social media accounts, websites.

Table Specific Information

Select

The Sync App 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 Sync App.

• ConstituentId supports the '=' operator.
• DateAdded supports the '>=,>' operators.
• DateModified supports the '>=,>' operators.
• IncludeInactive supports the '=' operator.

For example:

	
	SELECT * FROM OnlinePresences WHERE ConstituentId = '280'
	
	SELECT * FROM OnlinePresences WHERE DateAdded >= '2010-06-01 14:03:35'
	
	SELECT * FROM OnlinePresences WHERE IncludeInactive = true

Columns

Name	Type	References	Description
Id [KEY]	String		The immutable system record ID of the online presence.
Address	String		The web address for the online presence.
ConstituentId	String	Constituents.Id	The immutable system record ID of the constituent associated with the online presence.
DateAdded	Datetime		The date when the online presence was created.
DateModified	Datetime		The date when the online presence was last modified.
Inactive	Boolean		Indicates whether the online presence is inactive.
Primary	Boolean		Indicates whether this is the constituent's primary online presence.
Type	String		The online presence type.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
IncludeInactive	Boolean		If set to true, includes inactive online presences in the result.

Retrieves a list of opportunities

Table Specific Information

Select

The Sync App 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 Sync App.

• Id supports the '=' operator.
• ConstituentId supports the '=,in' operators.
• DateAdded supports the '>=,>' operators.
• DateModified supports the '>=,>' operators.
• IncludeInactive supports the '=' operator.

For example:

	
	SELECT * FROM Opportunities WHERE Id = '4'
	
	SELECT * FROM Opportunities WHERE ConstituentId IN ('255', '266')
	
	SELECT * FROM Opportunities WHERE DateAdded >= '1999-06-01 14:03:35'

Columns

Name	Type	References	Description
Id [KEY]	String		The immutable system record ID of the opportunity.
AskAmountValue	Double		The monetary amount solicited from the prospect for the opportunity.
AskDate	Datetime		The date when the solicitation was made.
CampaignId	String	Campaigns.Id	The immutable system record ID of the campaign associated with the opportunity. The campaign sets the overall objectives for raising money.
ConstituentId	String	Constituents.Id	The immutable system record ID of the constituent associated with the opportunity.
DateAdded	Datetime		The date when the opportunity was created.
DateModified	Datetime		The date when the opportunity was last modified.
Deadline	Datetime		The goal date for the opportunity to result in a gift.
ExpectedAmountValue	Double		The monetary amount that is realistically expected to result from the opportunity.
ExpectedDate	Datetime		The date when the prospect is expected to give in response to the opportunity.
FundId	String	Funds.Id	The immutable system record ID of the fund associated with the opportunity.
FundedAmountValue	Double		The monetary amount that the prospect gave in response to the opportunity.
FundedDate	Datetime		The date when the prospect gave in response to the opportunity.
Fundraisers	String		Fundraiser constituents interact with other constituents and prospects on behalf of your organization to cultivate relationships and advance opportunities to secure major gifts.
Inactive	Boolean		Indicates whether the opportunity is inactive.
LinkedGifts	String		The immutable system record IDs of the gifts related to the opportunity.
Name	String		The name that identifies the opportunity throughout the program, such as in lists or on constituent records.
Purpose	String		The intended use for any money raised as a result of the opportunity.
Status	String		The status that indicates where the opportunity is in the solicitation process.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
IncludeInactive	Boolean		If set to true, includes inactive opportunities in the response.
ListId	String		Defines a list identifier used to filter the set of opportunities to those included in the specified list. If this value is set, other specified filters will be ignored.

Retrieves custom fields for an opportunity

Columns

Name	Type	References	Description
Id	String		The immutable system record ID of the custom field.
OpportunityId	String		The parent object's immutable system record ID.
Name	String		The custom field category.
Value	String		The value of the custom field.
Date	Datetime		The date when the custom field was created.
DateAdded	Datetime		The date when the custom field was added.
DateModified	Datetime		The date when the custom field was last modified.
Type	String		The type of data that the custom field represents.

Returns a list of attachments for an opportunity

Table Specific Information

Select

The Sync App 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 Sync App.
Note: OpportunityId is required in order to query OpportunityAttachments.

• OpportunityId supports the '=' operator.

For example:

	SELECT * FROM OpportunityAttachments WHERE OpportunityId = '4'

Columns

Name	Type	References	Description
Id [KEY]	String		The immutable system record ID of the attachment.
OpportunityId	String	Opportunities.Id	The ID of the Opportunity.
Content_type	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. For physical attachments only.
FileSize	Long		The file size in bytes. For physical attachments only.
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. For physical attachments that are images only.
ThumbnailUrl	String		The URL for a thumbnail.
Type	String		The attachment type. Available values are Link and Physical.
Url	String		The URL for the attachment.

Returns a list of packages that contains content and other items for the appeals that organizations use to solicit gifts

Table Specific Information

Select

The Sync App 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 Sync App.

• Id supports the '=' operator.
• AppealId supports the '=,in' operators.
• DateAdded supports the '>=,>' operators.
• DateModified supports the '>=,>' operators.
• IncludeInactive supports the '=' operator.

For example:

	
	SELECT * FROM Packages WHERE Id = '1'
	
	SELECT * FROM Packages WHERE AppealId IN ('17', '18')
	
	SELECT * FROM Packages WHERE DateAdded >= '1999-06-01 14:03:35'

Columns

Name	Type	References	Description
Id [KEY]	String		The immutable system record ID of the package.
AppealId	String	FundraisingAppeals.Id	The immutable system record ID of the appeal associated with this package.
Category	String		The category of the package.
DateAdded	Datetime		The date when the package was created.
DateModified	Datetime		The date when the package was last modified.
DefaultGiftAmountValue	Double		The default amount for gifts associated with this package.
Description	String		The display name of the package.
End	Datetime		The end date of the package.
GoalValue	Double		The goal of this package.
Inactive	Boolean		This computed field indicates that the package is active if the current date is after any start and before any end.
LookupId	String		The user-defined identifier for the package.
Notes	String		The notes on the package.
RecipientCount	Integer		The amount of recipients of the package.
Start	Datetime		The start date of the package.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
IncludeInactive	Boolean		If set to true, includes inactive packages in the response.