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

必須プロパティは［設定］タブにリストされています。［Advanced］タブには、通常は必要ない接続プロパティが表示されます。

BlackBaud Raiser's Edge NXT への接続

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

BlackBaud Raiser's Edge NXT への認証

BlackBaud Raiser's Edge NXT はOAuth 認証標準を利用しています。埋め込みクレデンシャル を使用すると、接続プロパティを設定せずにBlackBaud Raiser's Edge NXT に接続できます。

あるいは、カスタムOAuth アプリの作成 で認証して、OAuthClientId、OAuthClientSecret、およびCallbackURL 接続プロパティを取得することもできます。

認証方法については、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 はサーバーの証明書をシステムの信頼できる証明書ストアと照合してSSL / TLS のネゴシエーションを試みます。

別の証明書を指定するには、利用可能なフォーマットについてSSLServerCert プロパティを参照してください。

Firewall またはProxy 経由の接続

HTTP プロキシ

Windows のシステムプロキシ経由の接続では、接続プロパティを追加で設定する必要はありません。他のプロキシに接続するには、ProxyAutoDetect をfalse に設定します。

さらにHTTP プロキシへの認証には、ProxyServer とProxyPort に加えてProxyAuthScheme、ProxyUser、およびProxyPassword を設定します。

その他のプロキシ

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

• プロキシベースのファイヤーウォールを使用するには、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 の操作を実行できます。

ビューは、カラムと疑似カラムで構成されます。ビューは、データを示すという点でテーブルに似ていますが、ビューでは更新はサポートされません。通常、ビューとして表されるエンティティは、読み取り専用のエンティティです。多くの場合、これらのデータはストアドプロシージャを使用することで更新できます（その機能がデータソースに適用できる場合）。

ビューに対しては、通常のテーブルと同じようにクエリを実行でき、このときに返されるデータも同様です。

ビューとして公開されるクエリなどの動的ビューや、project_team ワークアイテムの特定の組み合わせを検索するためのビューがサポートされています。

Blackbaud Raisers Edge NXT Connector for CData Sync ビュー

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.

	SELECT * FROM ActionAttachments WHERE ActionId = '335'

Columns

Retrieves custom fields for an action

Columns

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.

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

Columns

Pseudo-Columns

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

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.

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

Columns

Pseudo-Columns

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

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.

	SELECT * FROM Aliases WHERE ConstituentId = '280'

Columns

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.

	SELECT * FROM AppealAttachments WHERE AppealId = '2'

Columns

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.

	SELECT * FROM CampaignAttachments WHERE CampaignId = '2'

Columns

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.

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

Columns

Pseudo-Columns

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

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.

	
	SELECT * FROM ConsentCategories WHERE IncludeInactive = true
	

Columns

Pseudo-Columns

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

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

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

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.

	
	SELECT * FROM ConsentSources WHERE IncludeInactive=true
	

Columns

Pseudo-Columns

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

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.

	
	SELECT * FROM ConstituentAppeals WHERE ConstituentId='280'
	

Columns

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.

	SELECT * FROM ConstituentAttachments WHERE ConstituentId = '280'
	

Columns

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.

	
	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

Pseudo-Columns

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

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.

	
	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

Pseudo-Columns

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

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.

	SELECT * FROM ConstituentFundraiserAssignments WHERE ConstituentId = '280'

Columns

Pseudo-Columns

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

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.

	
	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

Pseudo-Columns

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

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

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.

 
	SELECT * FROM ConstituentSolicitCodes WHERE ConstituentId = '280'
	

Columns

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

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.

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

Columns

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.

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

Columns

Pseudo-Columns

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

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.

	
	SELECT * FROM EventCategories WHERE IncludeInactive = true

Columns

Pseudo-Columns

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

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.

	SELECT * FROM EventFees WHERE EventId = '2'

Columns

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.

	SELECT * FROM EventParticipantGuests WHERE EventId = '2'

Columns

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.

	SELECT * FROM EventParticipantMemberships WHERE EventId = '2'

Columns

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.

	SELECT * FROM EventParticipantOptions WHERE EventId = '2'

Columns

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.

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

Columns

Pseudo-Columns

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

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.

	
	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

Pseudo-Columns

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

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.

	SELECT * FROM FundAttachments WHERE FundId = '4'
	

Columns

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.

	SELECT * FROM FundraiserAssignments WHERE FundraiserId = '4'
	

Columns

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.

	SELECT * FROM FundraiserGoals WHERE FundraiserId = '4'
	

Columns

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.

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

Columns

Pseudo-Columns

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

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.

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

Columns

Pseudo-Columns

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

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

• GiftId supports the '=' operator.

	SELECT * FROM GiftAcknowledgements WHERE GiftId = '476'

Columns

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.

	SELECT * FROM GiftAttachments WHERE GiftId = '476'

Columns

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

Pseudo-Columns

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

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

• GiftId supports the '=' operator.

	SELECT * FROM GiftPayments WHERE GiftId = '476'

Columns

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

• GiftId supports the '=' operator.

	SELECT * FROM GiftReceipts WHERE GiftId = '476'

Columns

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.

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

Columns

Pseudo-Columns

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

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

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

• GiftId supports the '=' operator.

	SELECT * FROM GiftSoftCredits WHERE GiftId = '476'

Columns

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

• GiftId supports the '=' operator.

	SELECT * FROM GiftSplits WHERE GiftId = '476'

Columns

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.

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

Columns

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.

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

Columns

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.

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

Columns

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.

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

Columns

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.

	SELECT * FROM LifetimeGiving WHERE ConstituentId = '280'

Columns

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.

	SELECT * FROM Lists WHERE ListType = 'Constituent'
	

Columns

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.

	SELECT * FROM Members WHERE ConstituentId = '280'

Columns

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.

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

Columns

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.

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

Columns

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.

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

Columns

Pseudo-Columns

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

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.

	
	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

Pseudo-Columns

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

Retrieves custom fields for an opportunity

Columns

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.

	SELECT * FROM OpportunityAttachments WHERE OpportunityId = '4'

Columns

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.

	
	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

Pseudo-Columns

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

Returns the fee payments for a participant.

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

• ParticipantId supports the '=' operator.

	SELECT * FROM ParticipantFeePayments WHERE ParticipantId = '197'

Columns

Returns a list of fees for a participant.

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

• ParticipantId supports the '=' operator.

	SELECT * FROM ParticipantFees WHERE ParticipantId = '197'

Columns

Returns a list of participation levels for all 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.

• IncludeInactive supports the '=' operator.