はじめに

このページでは、CData Cloud でのBlackBaud Raiser's Edge NXT への接続の確立のガイド、利用可能なリソースに関する情報、および使用可能な接続プロパティのリファレンスについて説明します。

BlackBaud Raiser's Edge NXT への接続

接続の確立は、CData Cloud にデータベースを作成するためのBlackBaud Raiser's Edge NXT への認証方法と必要な接続プロパティの設定方法について示します。

CData Cloud サービスからデータにアクセス

利用可能な標準サービスを経由してBlackBaud Raiser's Edge NXT からデータにアクセスする方法と、CData Cloud の管理については、CData Cloud ドキュメントで詳しく説明します。

接続の確立

Database タブで対応するアイコンを選択して、BlackBaud Raiser's Edge NXT に接続します。必須プロパティはSettings にリストされています。Advanced タブには、通常は必要ない接続プロパティが表示されます。

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

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

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

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

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

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

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

ヘッドレスマシン

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

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

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

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

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

以下のオプションから選択します。
- 埋め込みOAuth アプリケーションを使用する場合は、BlackBaud Raiser's Edge NXT OAuth endpoint をクリックし、ブラウザでエンドポイントを開きます。
- カスタムOAuth アプリケーションを使用するには、以下のプロパティを設定し、認証URL を作成します。
  - InitiateOAuth：OFF に設定。
  - OAuthClientId：カスタムOAuth アプリケーションで指定されたクライアントId に設定。
  - OAuthClientSecret：カスタムOAuth アプリケーションで指定されたクライアントシークレットに設定。
  次に、適切なCallbackURL を指定してGetOAuthAuthorizationURL ストアドプロシージャを呼び出します。ストアドプロシージャによって返されたURL をブラウザで開きます。
ログインして、Cloud にアクセス許可を与えます。すると、verifier code を含むコールバックURL にリダイレクトされます。
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 認証値が保存される場所。アクセストークンの自動リフレッシュを有効にするために、この場所がCloud に読み書きのアクセス許可を与えることを確認してください。
カスタムアプリケーションのみ：
- OAuthClientId：カスタムOAuth アプリケーションの設定で指定されたクライアントId。
- OAuthClientSecret：カスタムOAuth アプリケーションの設定で指定されたクライアントシークレット。

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

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

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

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

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

カスタムOAuth アプリケーションの作成

Creating a Custom OAuth Application

CData embeds OAuth Application Credentials with CData branding that can be used when connecting to BlackBaud Raiser's Edge NXT via a desktop application or a headless machine.

However, you must create a custom OAuth application to connect to BlackBaud Raiser's Edge NXT via the Web. And since custom OAuth applications seamlessly support all three commonly-used auth flows, you might want to create custom OAuth applications (use your own OAuth Application Credentials) for those auth flows anyway.

Custom OAuth applications are useful if you want to:

control branding of the authentication dialog;
control the redirect URI that the application redirects the user to after the user authenticates; or
customize the permissions that you are requesting from the user.

The following sections desribe how to create and register a custom OAuth application, and how to connect it to your BlackBaud Raiser's Edge NXT environment.

Create and Register the Custom Application

To create an application to obtain the OAuth client credentials, the OAuthClientId and OAuthClientSecret:

Go to BlackBaud Sign Up.
Set up a developer account and get a subscription key, as described in the BlackBaud Getting Started documentation.
Log in at https://app.blackbaud.com/subscriptions.
To request a subscription to an API, select SKY API Standard Edition.
Select Subscribe. A confirmation screen appears.
To submit your request, select Confirm.

BlackBaud sends an email notification when your request is approved. After it is approved, you can view the subscription key within your developer profile.

To register the custom OAuth application:

From My Applications (see https://developer.blackbaud.com/apps), select Register app.
Enter your application details, including the redirect URI:
- For Desktop applications, use http://localhost:33333 or another port of your choice.
- For Web applications, use a URL where you want users to land after granting access to your custom application.
Click Save. Your application details are now available in the Blackbaud Marketplace.

Connect the Custom Application to Your Environment

Once the new application is configured and registered in the Blackbaud Marketplace, an environment administrator must connect it to the environment where it will be used.

They should:

Navigate to the Blackbaud Marketplace at https://app.blackbaud.com/marketplace/.
Visit the Manage page.
Select Connect app and specify the application ID of the custom OAuth application that was just created.
Select Connect.

The new application displays on the Manage page.

SSL の設定

SSL 設定のカスタマイズ

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

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

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

Firewall またはProxy 経由の接続

HTTP プロキシ

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

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

その他のプロキシ

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

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

データモデル

概要

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

主要機能

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

ビュー

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

ストアドプロシージャ

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

ビュー

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

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

CData Cloud - Blackbaud Raisers Edge NXT ビュー


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.

ActionAttachments

Retrieves a list of attachments for an action.

Table Specific Information

Select

The Cloud 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 Cloud.
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.

ActionCustomFields

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.

Actions

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

Table Specific Information

Select

The Cloud 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 Cloud.

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

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

Table Specific Information

Select

The Cloud 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 Cloud.

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.

Aliases

Retrieves a list of aliases for a constituent

Table Specific Information

Select

The Cloud 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 Cloud.
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.

AppealAttachments

Returns a list of attachments for an appeal.

Table Specific Information

Select

The Cloud 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 Cloud.
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.

CampaignAttachments

Returns a list of attachments for a campaign.

Table Specific Information

Select

The Cloud 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 Cloud.
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

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

Table Specific Information

Select

The Cloud 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 Cloud.

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.

ConsentCategories

Returns a list of consent categories.

Table Specific Information

Select

The Cloud 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 Cloud.

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.

ConsentChannelCategories

Returns a list of valid consent channel category combinations.

Table Specific Information

Select

The Cloud 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 Cloud.

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.

ConsentChannels

Represents the consent channel entity

Table Specific Information

Select

The Cloud 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 Cloud.

Columns


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

ConsentSources

Represents the consent source entity

Table Specific Information

Select

The Cloud 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 Cloud.

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.

ConstituentAppeals

Returns a list of appeals for a constituent.

Table Specific Information

Select

The Cloud 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 Cloud.

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.

ConstituentAttachments

Returns a list of attachments for a constituent.

Table Specific Information

Select

The Cloud 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 Cloud.
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.

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

Table Specific Information

Select

The Cloud 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 Cloud.

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.

ConstituentConsents

Returns a list of constituent consent records.

Table Specific Information

Select

The Cloud 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 Cloud.
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.

ConstituentFundraiserAssignments

Returns a list of fundraiser assignments for a constituent.

Table Specific Information

Select

The Cloud 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 Cloud.
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.

Constituents

Returns a paginated list of constituents

Table Specific Information

Select

The Cloud 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 Cloud.

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.

ConstituentsCustomFields

Retrieves custom fields for all constituents

Table Specific Information

Select

The Cloud 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 Cloud.

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.

ConstituentSolicitCodes

Returns a list of solicit codes for the specified constituent.

Table Specific Information

Select

The Cloud 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 Cloud.
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.

Countries

Returns the list of available countries.

Table Specific Information

Select

The Cloud 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 Cloud.

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.

Educations

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

Table Specific Information

Select

The Cloud 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 Cloud.

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.

Emails

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

Table Specific Information

Select

The Cloud 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 Cloud.

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.

EventCategories

Returns a list of active event categories.

Table Specific Information

Select

The Cloud 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 Cloud.

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.

EventFees

Returns a list of fees for an event.

Table Specific Information

Select

The Cloud 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 Cloud.
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.

EventParticipantGuests

The participant's basic summary information

Table Specific Information

Select

The Cloud 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 Cloud.
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.

EventParticipantMemberships

The individual's membership category

Table Specific Information

Select

The Cloud 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 Cloud.
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.

EventParticipantOptions

Returns the participant options for an event.

Table Specific Information

Select

The Cloud 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 Cloud.
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.

EventParticipants

Returns a list of participants for an event.

Table Specific Information

Select

The Cloud 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 Cloud.
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.

Events

Returns a list of events

Table Specific Information

Select

The Cloud 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 Cloud.

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.

FundAttachments

Returns a list of attachments for a fund.

Table Specific Information

Select

The Cloud 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 Cloud.
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.

FundraiserAssignments

Returns a list of assignments for a fundraiser.

Table Specific Information

Select

The Cloud 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 Cloud.
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.

FundraiserGoals

Returns a list of goals for a fundraiser

Table Specific Information

Select

The Cloud 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 Cloud.
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.

FundraisingAppeals

Returns a list of fundraising appeals.

Table Specific Information

Select

The Cloud 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 Cloud.

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.

Funds

Returns a list of funds.

Table Specific Information

Select

The Cloud 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 Cloud.

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.

GetPledgeInstallments

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

GetPledgePayments

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.

GiftAcknowledgements

Returns a list of acknowledgements for a gift

Table Specific Information

Select

The Cloud 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 Cloud.

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.

GiftAttachments

Returns a list of attachments for a gift.

Table Specific Information

Select

The Cloud 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 Cloud.
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.

GiftBatches

Returns a list of gift batches.

Table Specific Information

Select

The Cloud 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 Cloud.

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.

GiftFundraisers

Returns a list of attachments for a gift.

Table Specific Information

Select

The Cloud 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 Cloud.
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.

GiftPayments

Returns payments for a gift.

Table Specific Information

Select

The Cloud 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 Cloud.

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.

GiftReceipts

Returns receipts for a gift.

Table Specific Information

Select

The Cloud 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 Cloud.

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.

Gifts

Returns a paginated list of gifts

Table Specific Information

Select

The Cloud 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 Cloud.

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.

GiftsCustomFields

Retrieves custom fields for all gifts

Table Specific Information

Select

The Cloud 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 Cloud.

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.

GiftSoftCredits

Returns soft credits for a gift.

Table Specific Information

Select

The Cloud 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 Cloud.

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.

GiftSplits

Returns the splits for a gift.

Table Specific Information

Select

The Cloud 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 Cloud.

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.

Giving

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

Table Specific Information

Select

The Cloud 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 Cloud.
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

GivingAppeals

Returns the giving appeals summary for the constituent

Table Specific Information

Select

The Cloud 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 Cloud.
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

GivingCampaigns

Returns the giving campaigns summary for the constituent

Table Specific Information

Select

The Cloud 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 Cloud.
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

GivingFunds

Returns the giving funds summary for the constituent

Table Specific Information

Select

The Cloud 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 Cloud.
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

LifetimeGiving

Returns the lifetime giving information for a constituent.

Table Specific Information

Select

The Cloud 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 Cloud.
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.

Lists

Returns a list of lists for the given list type

Table Specific Information

Select

The Cloud 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 Cloud.

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

Members

Returns the list of members.

Table Specific Information

Select

The Cloud 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 Cloud.

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.

Memberships

Returns a list of memberships.

Table Specific Information

Select

The Cloud 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 Cloud.

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.

Notes

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 Cloud 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 Cloud.

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.

OnlinePresences

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

Table Specific Information

Select

The Cloud 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 Cloud.

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.

Opportunities

Retrieves a list of opportunities

Table Specific Information

Select

The Cloud 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 Cloud.

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.

OpportunitiesCustomFields

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.

OpportunityAttachments

Returns a list of attachments for an opportunity

Table Specific Information

Select

The Cloud 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 Cloud.
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.

Packages

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 Cloud 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 Cloud.

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.

ParticipantFeePayments

Returns the fee payments for a participant.

Table Specific Information

Select

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

ParticipantId supports the '=' operator.

For example:

	SELECT * FROM ParticipantFeePayments WHERE ParticipantId = '197'

Columns


Name	Type	References	Description
Id [KEY]	String		The ID of the participant fee.
ParticipantId	String	EventParticipants.Id	The ID of the participant that the participant fee is linked to.
AppliedAmount	Double		The applied amount of the participant fee payment.
GiftId	String		The ID of the gift that the participant fee is linked to.

ParticipantFees

Returns a list of fees for a participant.

Table Specific Information

Select

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

ParticipantId supports the '=' operator.

For example:

	SELECT * FROM ParticipantFees WHERE ParticipantId = '197'

Columns


Name	Type	References	Description
Id [KEY]	String		The ID of the participant fee.
ParticipantId	String	EventParticipants.Id	The ID of the record that the participant fee is linked to.
DateD	Integer		The day in the fuzzy date.
DateM	Integer		The month in the fuzzy date.
DateY	Integer		The year in the fuzzy date.
EventFeeContributionAmount	Double		The tax deductible amount for this fee.
EventFeeCost	Double		The fee's cost.
EventFeeEventId	String		The ID of the event the fee is linked to.
EventFeeId	String		The ID of the event fee.
EventFeeName	String		The name of the event fee.
EventFeeNumberSold	Integer		The number of fees sold.
FeeAmount	Double		The amount of the participant fee.
Quantity	Integer		The quantity purchased.
TaxReceiptableAmount	Double		The tax receiptable amount of the participant fee.

ParticipantLevels

Returns a list of participation levels for all events.

Table Specific Information

Select

The Cloud 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 Cloud.

IncludeInactive supports the '=' operator.

For example:

	
	SELECT * FROM ParticipantLevels WHERE IncludeInactive = true

Columns


Name	Type	References	Description
Id [KEY]	String		The ID of the participation level.
IsInactive	Boolean		Whether the participation level is inactive. True if inactive.
Name	String		The name of the participation level.

Pseudo-Columns

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


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

ParticipantOptions

Returns the participant options for a participant.

Table Specific Information

Select

The Cloud 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 Cloud.
Note: ParticipantId is required in order to query ParticipantOptions.

ParticipantId supports the '=' operator.

For example:

	SELECT * FROM ParticipantOptions WHERE ParticipantId = '197'

Columns


Name	Type	References	Description
Id [KEY]	String		The ID of the participant option.
ParticipantId	String	EventParticipants.Id	The ID of the participant.
AddedByService	String		The name of the service that added this participant option.
AddedByUser	String		The ID of the user that added the participant option.
DateAdded	Datetime		The date the participant option was added.
DateUpdated	Datetime		The date the participant option was updated.
EventId	String		The ID of the event.
EventParticipantOptionId	String		The ID of the event participant option.
OptionValue	String		The participant's response to the option.
UpdatedByService	String		The name of the service that updated this participant option.
UpdatedByUser	String		The ID of the user who updated the participant option.

Phones

Returns a list of phones for all constituents or a specific constituent

Table Specific Information

Select

The Cloud 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 Cloud.

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

For example:

	
	SELECT * FROM Phones WHERE Id = '1'
	
	SELECT * FROM Phones WHERE ConstituentId IN ('280', '281')
	
	SELECT * FROM Phones WHERE DateAdded >= '2010-06-01 14:03:35'

Columns


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

Pseudo-Columns

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


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

RatingCategories

Returns a list of all available rating categories.

Table Specific Information

Select

The Cloud 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 Cloud.

IncludeInactive supports the '=' operator.
SourceName supports the '=' operator.

For example:

	
	SELECT * FROM RatingCategories WHERE SourceName = 'Econometrics'
	
	SELECT * FROM RatingCategories WHERE IncludeInactive = true

Columns


Name	Type	References	Description
Inactive	Boolean		Indicates whether the category is inactive.
Name	String		The name of the rating category.
SourceName	String		The source of the category.
Type	String		The type of the rating category.

Pseudo-Columns

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


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

Ratings

Returns a list of ratings for a constituent.

Table Specific Information

Select

The Cloud 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 Cloud.
Note: ConstituentId is required in order to query Ratings.

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

For example:

	
	SELECT * FROM Ratings WHERE ConstituentId = '280'
	
	SELECT * FROM Ratings WHERE IncludeInactive = true
	
	SELECT * FROM Ratings WHERE MostRecentlyUsed = true

Columns


Name	Type	References	Description
Id [KEY]	String		The immutable system record ID of the rating.
Category	String		The category of the rating.
Comment	String		A comment about the rating.
ConstituentId	String	Constituents.Id	The immutable system record ID of the constituent associated with the rating.
Date	Datetime		The date of the rating.
Inactive	Boolean		This computed field indicates that the rating is active if the category is active.
Source	String		The source of the rating.
Type	String		This computed field indicates the type of data that the rating represents based on the category property.
Value	String		The value of the rating.

Pseudo-Columns

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


Name	Type	Description
IncludeInactive	Boolean		If set to true, includes inactive ratings in the result.
MostRecentOnly	Boolean		If set to true, includes only most recent ratings in the result.

RatingSources

Returns a list of all available rating sources.

Table Specific Information

Select

The Cloud 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 Cloud.

IncludeInactive supports the '=' operator.

For example:

	
	SELECT * FROM RatingSources WHERE IncludeInactive = true

Columns


Name	Type	References	Description
Inactive	Boolean		Indicates whether the rating source is inactive.
Name	String		The name of the rating source.

Pseudo-Columns

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


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

Relationships

Returns a list of relationships between constituents and other individuals and organizations such as family, friends, and employers

Table Specific Information

Select

The Cloud 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 Cloud.

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

For example:

	SELECT * FROM Relationships WHERE Id = '1'
	
	SELECT * FROM Relationships WHERE ConstituentId = '280'

Columns


Name	Type	References	Description
Id [KEY]	String		The immutable system record ID of the relationship.
Comment	String		The comment on the relationship.
ConstituentId	String	Constituents.Id	The immutable system record ID of the constituent associated with the relationship.
DateAdded	Datetime		The date when the relationship was created.
DateModified	Datetime		The date when the relationship was last modified.
EndD	Integer		The end day for the relationship.
EndM	Integer		The end month for the relationship.
EndY	Integer		The end year for the relationship.
IsOrganizationContact	Boolean		Indicates whether the related individual represents the organization as a contact.
IsPrimaryBusiness	Boolean		Indicates whether the related organization is the individual's primary business.
IsSpouse	Boolean		Indicates whether the related constituent is the constituent's spouse.
Name	String		The name of the related constituent.
OrganizationContactType	String		Provides context for interactions with the related individual who represents the organization as a contact.
Position	String		The individual's position in the organization.
ReciprocalRelationshipId	String		The identifier for the reciprocal relationship record.
ReciprocalType	String		Describes the constituent's relationship to the related constituent.
RelationId	String		The immutable system record ID of the related individual or organization.
StartD	Integer		The start day for the relationship.
StartM	Integer		The start month for the relationship.
StartY	Integer		The start year for the relationship.
Type	String		The type of relation that the relationship represents.
FirstName	String		The first name of the constituent. For individuals only.
LastName	String		The last name of the constituent. For individuals only.
IsSpouseHeadOfHousehold	Boolean		Indicates whether the spouse constituent is the head household. Only applies to spousal relationships between individuals.
IsConstituentHeadOfHousehold	Boolean		Indicates whether the constituent is the head of household. Only applies to spousal relationships between individuals.

Tributes

Returns a list of tributes.

Table Specific Information

Select

All the filters are executed client side within the Cloud. For example:

	
	SELECT * FROM Tributes
	
	SELECT * FROM Tributes WHERE Id = 2

Columns


Name	Type	References	Description
Id [KEY]	Integer		The tribute ID.
ConstituentRecordId	Integer		The system record ID of the constituent.
DefaultFundId	Integer		The default fund ID.
Description	String		The tribute description.
EndDateD	Integer		The day of the end date.
EndDateM	Integer		The month of the end date.
EndDateY	Integer		The year of the end date.
IsActive	Boolean		The active status of the tribute.
Notes	String		The tribute notes.
StartDateD	Integer		The day of the start date.
StartDateM	Integer		The month of the start date.
StartDateY	Integer		The year of the start date.
TributeTypeId	Integer		The tribute type code ID.

ストアドプロシージャ

ストアドプロシージャはファンクションライクなインターフェースで、BlackBaud Raiser's Edge NXT の単純なSELECT 処理にとどまらずCloud の機能を拡張します。

ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにBlackBaud Raiser's Edge NXT から関連するレスポンスデータを返します。

CData Cloud - Blackbaud Raisers Edge NXT ストアドプロシージャ


Name	Description
AutomateRecurringGift	Converts a manual recurring gift to an automated recurring gift in the web view
SellStockGift	This updates a stock gift to sold with the given details.
UpdateGiftReceipt	Edits a gift receipt
UpdateGiftStatus	Edit the status of a recurring gift.

AutomateRecurringGift

Converts a manual recurring gift to an automated recurring gift in the web view

Input


Name	Type	Required	Description
GiftId	String	True	The immutable system record ID of the recurring gift to convert.
BBPSConfigurationId	String	True	BBPS Configuration Id to put on the gift.

Result Set Columns


Name	Type	Description
Success	String	Execution status of the stored procedure.

SellStockGift

This updates a stock gift to sold with the given details.

Input


Name	Type	Required	Description
GiftId	String	True	The immutable system record ID of the recurring gift to convert.
BrokerFee	String	False	The Broker Fee.
PostDate	String	False	The Post Date.
PostStatus	String	False	The Post Status.
StockIssuerIssuer	String	False	StockIssuerIssuer.
StockIssuerSymbol	String	False	StockIssuerSymbol.
StockIssuerUnits	String	False	StockIssuerUnits.
StockIssuerUnitPrice	String	False	StockIssuerUnitPrice.
Notes	String	False	Notes.
StockSaleDate	String	False	StockSaleDate.
StockSaleValue	String	False	StockSaleValue.

Result Set Columns


Name	Type	Description
Success	String	Execution status of the stored procedure.

UpdateGiftReceipt

Edits a gift receipt

Stored Procedures Specific Information

Process of Update Gift Receipt

BlackBaud Raiser's Edge NXT allows only a small subset of columns to be used in the EXEC query. These columns can typically be used with only = comparison. The available columns for UpdateGiftReceipt are ReceiptId, Amount, Date, Number and Status. For example:

EXECUTE UpdateGiftReceipt ReceiptId = '372', Amount = 0.0, Date = '2018-12-31T00:00:00', Number = 123456, Status = 'Receipted'

Input


Name	Type	Required	Description
ReceiptId	String	True	The immutable system record ID of the gift receipt to edit. It uses the parent gift's ID as its value.
Amount	Double	True	The amount of the receipt.
Date	String	True	The date on the receipt
Number	Integer	True	The number of the receipt.
Status	String	True	The receipt status of the gift. Available values are: RECEIPTED, NEEDSRECEIPT, and DONOTRECEIPT. When receipt_status is set to NEEDSRECEIPT or DONOTRECEIPT, receipt_date should be null.

Result Set Columns


Name	Type	Description
Success	String	Execution status of the stored procedure

UpdateGiftStatus

Edit the status of a recurring gift.

Stored Procedures Specific Information

Process of Update Gift Status

BlackBaud Raiser's Edge NXT allows only a small subset of columns to be used in the EXEC query. These columns can typically be used with only = comparison. The available columns for UpdateGiftStatus are GiftId and GiftStatus. For example:

EXECUTE UpdateGiftStatus GiftId = '281', GiftStatus = 'Held'

Input


Name	Type	Required	Description
GiftId	String	True	The immutable system record ID of the recurring gift to update.
GiftStatus	String	True	The new status of the recurring gift. Available values are Active, Held, Terminated, Completed, and Cancelled.

Result Set Columns


Name	Type	Description
Success	String	Execution status of the stored procedure

システムテーブル

このセクションで説明されているシステムテーブルをクエリして、スキーマ情報、データソース機能に関する情報、およびバッチ操作の統計にアクセスできます。

スキーマテーブル

以下のテーブルは、BlackBaud Raiser's Edge NXT のデータベースメタデータを返します。

sys_catalogs：利用可能なデータベースをリスト。
sys_schemas：利用可能なスキーマをリスト。
sys_tables：利用可能なテーブルおよびビューをリスト。
sys_tablecolumns：利用可能なテーブルおよびビューのカラムについて説明。
sys_procedures：利用可能なストアドプロシージャについて説明。
sys_procedureparameters：ストアドプロシージャパラメータについて説明。
sys_keycolumns：主キーおよび外部キーについて説明。
sys_indexes：利用可能なインデックスについて説明。

データソーステーブル

以下のテーブルは、データソースへの接続方法およびクエリ方法についての情報を返します。

sys_connection_props：利用可能な接続プロパティについての情報を返す。
sys_sqlinfo：Cloud がデータソースにオフロードできるSELECT クエリについて説明。

クエリ情報テーブル

次のテーブルは、データ変更クエリのクエリ統計を返します。

sys_identity：バッチ処理または単一の更新に関する情報を返す。

sys_catalogs

利用可能なデータベースをリストします。

次のクエリは、接続文字列で決定されるすべてのデータベースを取得します。

SELECT * FROM sys_catalogs

Columns


Name	Type	Description
CatalogName	String	データベース名。

sys_schemas

利用可能なスキーマをリストします。

次のクエリは、すべての利用可能なスキーマを取得します。

          SELECT * FROM sys_schemas

Columns


Name	Type	Description
CatalogName	String	データベース名。
SchemaName	String	スキーマ名。

sys_tables

利用可能なテーブルをリストします。

次のクエリは、利用可能なテーブルおよびビューを取得します。

          SELECT * FROM sys_tables

Columns


Name	Type	Description
CatalogName	String	テーブルまたはビューを含むデータベース。
SchemaName	String	テーブルまたはビューを含むスキーマ。
TableName	String	テーブル名またはビュー名。
TableType	String	テーブルの種類（テーブルまたはビュー）。
Description	String	テーブルまたはビューの説明。
IsUpdateable	Boolean	テーブルが更新可能かどうか。

sys_tablecolumns

利用可能なテーブルおよびビューのカラムについて説明します。

次のクエリは、Constituents テーブルのカラムとデータ型を返します。

SELECT ColumnName, DataTypeName FROM sys_tablecolumns WHERE TableName='Constituents'

Columns


Name	Type	Description
CatalogName	String	テーブルまたはビューを含むデータベースの名前。
SchemaName	String	テーブルまたはビューを含むスキーマ。
TableName	String	カラムを含むテーブルまたはビューの名前。
ColumnName	String	カラム名。
DataTypeName	String	データ型の名前。
DataType	Int32	データ型を示す整数値。この値は、実行時に環境に基づいて決定されます。
Length	Int32	カラムのストレージサイズ。
DisplaySize	Int32	指定されたカラムの通常の最大幅（文字数）。
NumericPrecision	Int32	数値データの最大桁数。文字データおよび日時データの場合は、カラムの長さ（文字数）。
NumericScale	Int32	カラムのスケール（小数点以下の桁数）。
IsNullable	Boolean	カラムがNull を含められるかどうか。
Description	String	カラムの簡単な説明。
Ordinal	Int32	カラムのシーケンスナンバー。
IsAutoIncrement	String	カラムに固定増分値が割り当てられるかどうか。
IsGeneratedColumn	String	生成されたカラムであるかどうか。
IsHidden	Boolean	カラムが非表示かどうか。
IsArray	Boolean	カラムが配列かどうか。
IsReadOnly	Boolean	カラムが読み取り専用かどうか。
IsKey	Boolean	sys_tablecolumns から返されたフィールドがテーブルの主キーであるかどうか。

sys_procedures

利用可能なストアドプロシージャをリストします。

次のクエリは、利用可能なストアドプロシージャを取得します。

          SELECT * FROM sys_procedures

Columns


Name	Type	Description
CatalogName	String	ストアドプロシージャを含むデータベース。
SchemaName	String	ストアドプロシージャを含むスキーマ。
ProcedureName	String	ストアドプロシージャの名前。
Description	String	ストアドプロシージャの説明。
ProcedureType	String	PROCEDURE やFUNCTION などのプロシージャのタイプ。

sys_procedureparameters

ストアドプロシージャパラメータについて説明します。

次のクエリは、UpdateGiftStatus ストアドプロシージャのすべての入力パラメータについての情報を返します。

SELECT * FROM sys_procedureparameters WHERE ProcedureName='UpdateGiftStatus' AND Direction=1 OR Direction=2

Columns


Name	Type	Description
CatalogName	String	ストアドプロシージャを含むデータベースの名前。
SchemaName	String	ストアドプロシージャを含むスキーマの名前。
ProcedureName	String	パラメータを含むストアドプロシージャの名前。
ColumnName	String	ストアドプロシージャパラメータの名前。
Direction	Int32	パラメータのタイプに対応する整数値：input (1)。input/output (2)、またはoutput(4)。input/output タイプパラメータは、入力パラメータと出力パラメータの両方になれます。
DataTypeName	String	データ型の名前。
DataType	Int32	データ型を示す整数値。この値は、実行時に環境に基づいて決定されます。
Length	Int32	文字データの場合は、許可される文字数。数値データの場合は、許可される桁数。
NumericPrecision	Int32	数値データの場合は最大精度。文字データおよび日時データの場合は、カラムの長さ（文字数）。
NumericScale	Int32	数値データの小数点以下の桁数。
IsNullable	Boolean	パラメータがNull を含められるかどうか。
IsRequired	Boolean	プロシージャの実行にパラメータが必要かどうか。
IsArray	Boolean	パラメータが配列かどうか。
Description	String	パラメータの説明。
Ordinal	Int32	パラメータのインデックス。

sys_keycolumns

主キーおよび外部キーについて説明します。

次のクエリは、Constituents テーブルの主キーを取得します。

         SELECT * FROM sys_keycolumns WHERE IsKey='True' AND TableName='Constituents'

Columns


Name	Type	Description
CatalogName	String	キーを含むデータベースの名前。
SchemaName	String	キーを含むスキーマの名前。
TableName	String	キーを含むテーブルの名前。
ColumnName	String	キーカラムの名前
IsKey	Boolean	カラムがTableName フィールドで参照されるテーブル内の主キーかどうか。
IsForeignKey	Boolean	カラムがTableName フィールドで参照される外部キーかどうか。
PrimaryKeyName	String	主キーの名前。
ForeignKeyName	String	外部キーの名前。
ReferencedCatalogName	String	主キーを含むデータベース。
ReferencedSchemaName	String	主キーを含むスキーマ。
ReferencedTableName	String	主キーを含むテーブル。
ReferencedColumnName	String	主キーのカラム名。

sys_foreignkeys

外部キーについて説明します。

次のクエリは、他のテーブルを参照するすべての外部キーを取得します。

         SELECT * FROM sys_foreignkeys WHERE ForeignKeyType = 'FOREIGNKEY_TYPE_IMPORT'

カラム


名前	タイプ	説明
CatalogName	String	キーを含むデータベースの名前。
SchemaName	String	キーを含むスキーマの名前。
TableName	String	キーを含むテーブルの名前。
ColumnName	String	キーカラムの名前
PrimaryKeyName	String	主キーの名前。
ForeignKeyName	String	外部キーの名前。
ReferencedCatalogName	String	主キーを含むデータベース。
ReferencedSchemaName	String	主キーを含むスキーマ。
ReferencedTableName	String	主キーを含むテーブル。
ReferencedColumnName	String	主キーのカラム名。
ForeignKeyType	String	外部キーがインポート（他のテーブルを指す）キーかエクスポート（他のテーブルから参照される）キーかを指定します。

sys_primarykeys

主キーについて説明します。

次のクエリは、すべてのテーブルとビューから主キーを取得します。

         SELECT * FROM sys_primarykeys

Columns


Name	Type	Description
CatalogName	String	キーを含むデータベースの名前。
SchemaName	String	キーを含むスキーマの名前。
TableName	String	キーを含むテーブルの名前。
ColumnName	String	キーカラムの名前。
KeySeq	String	主キーのシーケンス番号。
KeyName	String	主キーの名前。

sys_indexes

利用可能なインデックスについて説明します。インデックスをフィルタリングすることで、より高速なクエリ応答時間でセレクティブクエリを記述できます。

次のクエリは、主キーでないすべてのインデックスを取得します。

          SELECT * FROM sys_indexes WHERE IsPrimary='false'

Columns


Name	Type	Description
CatalogName	String	インデックスを含むデータベースの名前。
SchemaName	String	インデックスを含むスキーマの名前。
TableName	String	インデックスを含むテーブルの名前。
IndexName	String	インデックス名。
ColumnName	String	インデックスに関連付けられたカラムの名前。
IsUnique	Boolean	インデックスが固有の場合はTrue。そうでない場合はFalse。
IsPrimary	Boolean	インデックスが主キーの場合はTrue。そうでない場合はFalse。
Type	Int16	インデックスタイプに対応する整数値：statistic (0)、clustered (1)、hashed (2)、またはother (3)。
SortOrder	String	並べ替え順序：A が昇順、D が降順。
OrdinalPosition	Int16	インデックスのカラムのシーケンスナンバー。

sys_connection_props

利用可能な接続プロパティと、接続文字列に設定されている接続プロパティに関する情報を返します。

次のクエリは、接続文字列に設定されている、あるいはデフォルト値で設定されているすべての接続プロパティを取得します。

SELECT * FROM sys_connection_props WHERE Value <> ''

Columns


Name	Type	Description
Name	String	接続プロパティ名。
ShortDescription	String	簡単な説明。
Type	String	接続プロパティのデータ型。
Default	String	明示的に設定されていない場合のデフォルト値。
Values	String	可能な値のカンマ区切りリスト。別な値が指定されていると、検証エラーがスローされます。
Value	String	設定した値またはあらかじめ設定されたデフォルト。
Required	Boolean	プロパティが接続に必要かどうか。
Category	String	接続プロパティのカテゴリ。
IsSessionProperty	String	プロパティが、現在の接続に関する情報を保存するために使用されるセッションプロパティかどうか。
Sensitivity	String	プロパティの機密度。これは、プロパティがロギングおよび認証フォームで難読化されているかどうかを通知します。
PropertyName	String	キャメルケースの短縮形の接続プロパティ名。
Ordinal	Int32	パラメータのインデックス。
CatOrdinal	Int32	パラメータカテゴリのインデックス。
Hierarchy	String	このプロパティと一緒に設定する必要がある、関連のある依存プロパティを表示します。
Visible	Boolean	プロパティが接続UI に表示されるかどうかを通知します。
ETC	String	プロパティに関するその他のさまざまな情報。

sys_sqlinfo

Cloud がデータソースにオフロードできるSELECT クエリ処理について説明します。

SQL 構文の詳細については、SQL 準拠を参照してください。

データソースのSELECT 機能

以下はSQL 機能のサンプルデータセットです。 SELECT 機能のいくつかの側面がサポートされている場合には、カンマ区切りのリストで返されます。サポートされていない場合、カラムにはNO が入ります。


名前	説明	有効な値
AGGREGATE_FUNCTIONS	サポートされている集計関数。	AVG, COUNT, MAX, MIN, SUM, DISTINCT
COUNT	COUNT 関数がサポートされているかどうか。	YES, NO
IDENTIFIER_QUOTE_OPEN_CHAR	識別子をエスケープするための開始文字。	[
IDENTIFIER_QUOTE_CLOSE_CHAR	識別子をエスケープするための終了文字。	]
SUPPORTED_OPERATORS	サポートされているSQL 演算子。	=, >, <, >=, <=, <>, !=, LIKE, NOT LIKE, IN, NOT IN, IS NULL, IS NOT NULL, AND, OR
GROUP_BY	GROUP BY がサポートされているかどうか。サポートされている場合、どのレベルでサポートされているか。	NO, NO_RELATION, EQUALS_SELECT, SQL_GB_COLLATE
OJ_CAPABILITIES	サポートされている外部結合の種類。	NO, LEFT, RIGHT, FULL, INNER, NOT_ORDERED, ALL_COMPARISON_OPS
OUTER_JOINS	外部結合がサポートされているかどうか。	YES, NO
SUBQUERIES	サブクエリがサポートされているかどうか。サポートされていれば、どのレベルでサポートされているか。	NO, COMPARISON, EXISTS, IN, CORRELATED_SUBQUERIES, QUANTIFIED
STRING_FUNCTIONS	サポートされている文字列関数。	LENGTH, CHAR, LOCATE, REPLACE, SUBSTRING, RTRIM, LTRIM, RIGHT, LEFT, UCASE, SPACE, SOUNDEX, LCASE, CONCAT, ASCII, REPEAT, OCTET, BIT, POSITION, INSERT, TRIM, UPPER, REGEXP, LOWER, DIFFERENCE, CHARACTER, SUBSTR, STR, REVERSE, PLAN, UUIDTOSTR, TRANSLATE, TRAILING, TO, STUFF, STRTOUUID, STRING, SPLIT, SORTKEY, SIMILAR, REPLICATE, PATINDEX, LPAD, LEN, LEADING, KEY, INSTR, INSERTSTR, HTML, GRAPHICAL, CONVERT, COLLATION, CHARINDEX, BYTE
NUMERIC_FUNCTIONS	サポートされている数値関数。	ABS, ACOS, ASIN, ATAN, ATAN2, CEILING, COS, COT, EXP, FLOOR, LOG, MOD, SIGN, SIN, SQRT, TAN, PI, RAND, DEGREES, LOG10, POWER, RADIANS, ROUND, TRUNCATE
TIMEDATE_FUNCTIONS	サポートされている日付および時刻関数。	NOW, CURDATE, DAYOFMONTH, DAYOFWEEK, DAYOFYEAR, MONTH, QUARTER, WEEK, YEAR, CURTIME, HOUR, MINUTE, SECOND, TIMESTAMPADD, TIMESTAMPDIFF, DAYNAME, MONTHNAME, CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, EXTRACT
REPLICATION_SKIP_TABLES	レプリケーション中にスキップされたテーブルを示します。
REPLICATION_TIMECHECK_COLUMNS	レプリケーション中に更新判断のカラムとして使用するかどうかを、（指定された順に）チェックするカラムのリストを含む文字列の配列。
IDENTIFIER_PATTERN	識別子としてどの文字列が有効かを示す文字列値。
SUPPORT_TRANSACTION	プロバイダーが、コミットやロールバックなどのトランザクションをサポートしているかどうかを示します。	YES, NO
DIALECT	使用するSQL ダイアレクトを示します。
KEY_PROPERTIES	Uniform データベースを特定するプロパティを示します。
SUPPORTS_MULTIPLE_SCHEMAS	プロバイダー用に複数のスキームが存在するかどうかを示します。	YES, NO
SUPPORTS_MULTIPLE_CATALOGS	プロバイダー用に複数のカタログが存在するかどうかを示します。	YES, NO
DATASYNCVERSION	このドライバーにアクセスするために必要な、CData Sync のバージョン。	Standard, Starter, Professional, Enterprise
DATASYNCCATEGORY	このドライバーのCData Sync カテゴリ。	Source, Destination, Cloud Destination
SUPPORTSENHANCEDSQL	API で提供されている以上の、追加SQL 機能がサポートされているかどうか。	TRUE, FALSE
SUPPORTS_BATCH_OPERATIONS	バッチ操作がサポートされているかどうか。	YES, NO
SQL_CAP	このドライバーでサポートされているすべてのSQL 機能。	SELECT, INSERT, DELETE, UPDATE, TRANSACTIONS, ORDERBY, OAUTH, ASSIGNEDID, LIMIT, LIKE, BULKINSERT, COUNT, BULKDELETE, BULKUPDATE, GROUPBY, HAVING, AGGS, OFFSET, REPLICATE, COUNTDISTINCT, JOINS, DROP, CREATE, DISTINCT, INNERJOINS, SUBQUERIES, ALTER, MULTIPLESCHEMAS, GROUPBYNORELATION, OUTERJOINS, UNIONALL, UNION, UPSERT, GETDELETED, CROSSJOINS, GROUPBYCOLLATE, MULTIPLECATS, FULLOUTERJOIN, MERGE, JSONEXTRACT, BULKUPSERT, SUM, SUBQUERIESFULL, MIN, MAX, JOINSFULL, XMLEXTRACT, AVG, MULTISTATEMENTS, FOREIGNKEYS, CASE, LEFTJOINS, COMMAJOINS, WITH, LITERALS, RENAME, NESTEDTABLES, EXECUTE, BATCH, BASIC, INDEX
PREFERRED_CACHE_OPTIONS	使用したいcacheOptions を指定する文字列値。
ENABLE_EF_ADVANCED_QUERY	ドライバーがEntity Framework の高度なクエリをサポートしているかどうかを示します。サポートしていなければ、クエリはクライアントサイドで処理されます。	YES, NO
PSEUDO_COLUMNS	利用可能な疑似カラムを示す文字列の配列。
MERGE_ALWAYS	値がtrue であれば、CData Sync 内でMerge Model が強制的に実行されます。	TRUE, FALSE
REPLICATION_MIN_DATE_QUERY	レプリケート開始日時を返すSELECT クエリ。
REPLICATION_MIN_FUNCTION	サーバーサイドでmin を実行するために使用する式名を、プロバイダーが指定できるようになります。
REPLICATION_START_DATE	レプリケート開始日を、プロバイダーが指定できるようになります。
REPLICATION_MAX_DATE_QUERY	レプリケート終了日時を返すSELECT クエリ。
REPLICATION_MAX_FUNCTION	サーバーサイドでmax を実行するために使用する式名を、プロバイダーが指定できるようになります。
IGNORE_INTERVALS_ON_INITIAL_REPLICATE	初回のレプリケートで、レプリケートをチャンクに分割しないテーブルのリスト。
CHECKCACHE_USE_PARENTID	CheckCache 構文を親キーカラムに対して実行するかどうかを示します。	TRUE, FALSE
CREATE_SCHEMA_PROCEDURES	スキーマファイルの生成に使用できる、ストアドプロシージャを示します。

次のクエリは、WHERE 句で使用できる演算子を取得します。

SELECT * FROM sys_sqlinfo WHERE Name = 'SUPPORTED_OPERATORS'

WHERE 句では、個々のテーブルの制限や要件が異なる場合がありますので注意してください。詳しくは、データモデルセクションを参照してください。

Columns


Name	Type	Description
NAME	String	SQL 構文のコンポーネント、またはサーバー上で処理できる機能。
VALUE	String	サポートされるSQL またはSQL 構文の詳細。

sys_identity

試行された変更に関する情報を返します。

次のクエリは、バッチ処理で変更された行のId を取得します。

         SELECT * FROM sys_identity

Columns


Name	Type	Description
Id	String	データ変更処理から返された、データベース生成Id。
Batch	String	バッチの識別子。1 は単一処理。
Operation	String	バッチ内の処理の結果：INSERTED、UPDATED、またはDELETED。
Message	String	SUCCESS、またはバッチ内の更新が失敗した場合のエラーメッセージ。

sys_information

利用可能なシステム情報を説明します。

次のクエリは、すべてのカラムを取得します。

SELECT * FROM sys_information

Columns


Name	Type	Description
Product	String	製品名。
Version	String	製品のバージョン番号。
Datasource	String	製品が接続するデータソースの名前。
NodeId	String	製品がインストールされているマシンの固有識別子。
HelpURL	String	製品のヘルプドキュメントのURL。
License	String	製品のライセンス情報。（この情報が利用できない場合、この項目は空白のままか「N/A」と表示されます。）
Location	String	製品のライブラリが格納されているファイルパスの場所。
Environment	String	製品が現在稼働している環境またはランタイムのバージョン。
DataSyncVersion	String	本コネクタを使用するために必要なCData Sync のティア。
DataSyncCategory	String	CData Sync 機能のカテゴリ（例：Source、Destination）。

接続文字列オプション

接続文字列プロパティは、接続を確立するために使用できるさまざまなオプションです。このセクションでは、本プロバイダーの接続文字列で設定できるオプションの一覧を示します。詳細については各リンクをクリックしてください。

OAuth

プロパティ	説明
OAuthClientId	カスタムOAuth アプリケーションの作成時に割り当てられたクライアントId を指定します。（コンシューマーキーとも呼ばれます。）このID は、カスタムアプリケーションをOAuth 認可サーバーに登録します。
OAuthClientSecret	カスタムOAuth アプリケーションの作成時に割り当てられたクライアントシークレットを指定します。（コンシューマーシークレットとも呼ばれます。）このシークレットは、カスタムアプリケーションをOAuth 認可サーバーに登録します。
SubscriptionKey	Subscription key which provides access to the API. Found in your Developer Profile.

SSL

プロパティ	説明
SSLServerCert	TLS/SSL を使用して接続する際に、サーバーが受け入れ可能な証明書を指定します。

Logging

プロパティ	説明
Verbosity	ログファイルのVerbosity レベルを指定し、記録される情報の詳細度を制御します。サポートされる値の範囲は1から5までです。

Schema

プロパティ	説明
BrowsableSchemas	レポートされるスキーマを利用可能なすべてのスキーマのサブセットに制限するオプション設定。例えば、 BrowsableSchemas=SchemaA,SchemaB,SchemaC です。

Miscellaneous

プロパティ	説明
IncludeCustomFields	Set to true to retrieve custom fields values for Constituents, Actions, Opportunities, and Gifts.
MaxRows	集計やGROUP BY を使用しないクエリで返される最大行数を指定します。
PageSize	The number of results to return per page of data retrieved from BlackBaud Raiser's Edge NXT.
PseudoColumns	テーブルカラムとして公開する擬似カラムを指定します。'TableName=ColumnName;TableName=ColumnName' という形式を使用します。デフォルトは空の文字列で、このプロパティを無効にします。
Timeout	provider がタイムアウトエラーを返すまでにサーバーからの応答を待機する最大時間を秒単位で指定します。デフォルトは60秒です。タイムアウトを無効にするには0を設定します。

OAuth

このセクションでは、本プロバイダーの接続文字列で設定可能なOAuth プロパティの全リストを提供します。

プロパティ	説明
OAuthClientId	カスタムOAuth アプリケーションの作成時に割り当てられたクライアントId を指定します。（コンシューマーキーとも呼ばれます。）このID は、カスタムアプリケーションをOAuth 認可サーバーに登録します。
OAuthClientSecret	カスタムOAuth アプリケーションの作成時に割り当てられたクライアントシークレットを指定します。（コンシューマーシークレットとも呼ばれます。）このシークレットは、カスタムアプリケーションをOAuth 認可サーバーに登録します。
SubscriptionKey	Subscription key which provides access to the API. Found in your Developer Profile.

Request a subscription to an API from the Products page (https://developer.sky.blackbaud.com/products/), select SKY API Standard Edition.
Select Subscribe. A confirmation screen appears.
To submit your request, select Confirm. You will get an email notification when your request is approved.
After it is approved, you can view the subscription key within your developer profile.

SSL

このセクションでは、本プロバイダーの接続文字列で設定可能なSSL プロパティの全リストを提供します。

プロパティ	説明
SSLServerCert	TLS/SSL を使用して接続する際に、サーバーが受け入れ可能な証明書を指定します。

SSLServerCert

TLS/SSL を使用して接続する際に、サーバーが受け入れ可能な証明書を指定します。

データ型

string

デフォルト値

""

解説

TLS/SSL 接続を使用する場合は、このプロパティを使用して、サーバーが受け入れるTLS/SSL 証明書を指定できます。コンピュータによって信頼されていない他の証明書はすべて拒否されます。

このプロパティは、次のフォームを取ります：


説明	例
フルPEM 証明書（例では省略されています）	-----BEGIN CERTIFICATE----- MIIChTCCAe4CAQAwDQYJKoZIhv......Qw== -----END CERTIFICATE-----
証明書を保有するローカルファイルへのパス。	C:\cert.cer
公開鍵（例では省略されています）	-----BEGIN RSA PUBLIC KEY----- MIGfMA0GCSq......AQAB -----END RSA PUBLIC KEY-----
MD5 Thumbprint （hex 値はスペースおよびコロン区切り）	ecadbdda5a1529c58a1e9e09828d70e4
SHA1 Thumbprint （hex 値はスペースおよびコロン区切り）	34a929226ae0819f2ec14b4a3d904f801cbb150d

これを指定しない場合は、マシンが信用するすべての証明書が受け入れられます。

すべての証明書の受け入れを示すには、'*'を使用します。セキュリティ上の理由から、これはお勧めできません。

Logging

このセクションでは、本プロバイダーの接続文字列で設定可能なLogging プロパティの全リストを提供します。

プロパティ	説明
Verbosity	ログファイルのVerbosity レベルを指定し、記録される情報の詳細度を制御します。サポートされる値の範囲は1から5までです。

Verbosity

ログファイルのVerbosity レベルを指定し、記録される情報の詳細度を制御します。サポートされる値の範囲は1から5までです。

データ型

string

デフォルト値

"1"

解説

このプロパティは、Cloud がログファイルに含める詳細レベルを定義します。 Verbosity レベルを高くするとログに記録される情報の詳細が増えますが、ログファイルが大きくなり取り込まれるデータが増えるためパフォーマンスが低下する可能性があります。

デフォルトのVerbosity レベルは1で、通常の運用にはこれが推奨されます。より高いVerbosity レベルは主にデバッグを目的としています。各レベルの詳細については、ログを参照してください。

LogModules プロパティと組み合わせることで、Verbosity は特定の情報カテゴリに対するログの詳細度を調整できます。

Schema

このセクションでは、本プロバイダーの接続文字列で設定可能なSchema プロパティの全リストを提供します。

プロパティ	説明
BrowsableSchemas	レポートされるスキーマを利用可能なすべてのスキーマのサブセットに制限するオプション設定。例えば、 BrowsableSchemas=SchemaA,SchemaB,SchemaC です。

BrowsableSchemas

レポートされるスキーマを利用可能なすべてのスキーマのサブセットに制限するオプション設定。例えば、 BrowsableSchemas=SchemaA,SchemaB,SchemaC です。

データ型

string

デフォルト値

""

解説

利用可能なデータベーススキーマをすべてリストすると余分な時間がかかり、パフォーマンスが低下します。接続文字列にスキーマのリストを指定することで、時間を節約しパフォーマンスを向上させることができます。

Miscellaneous

このセクションでは、本プロバイダーの接続文字列で設定可能なMiscellaneous プロパティの全リストを提供します。

プロパティ	説明
IncludeCustomFields	Set to true to retrieve custom fields values for Constituents, Actions, Opportunities, and Gifts.
MaxRows	集計やGROUP BY を使用しないクエリで返される最大行数を指定します。
PageSize	The number of results to return per page of data retrieved from BlackBaud Raiser's Edge NXT.
PseudoColumns	テーブルカラムとして公開する擬似カラムを指定します。'TableName=ColumnName;TableName=ColumnName' という形式を使用します。デフォルトは空の文字列で、このプロパティを無効にします。
Timeout	provider がタイムアウトエラーを返すまでにサーバーからの応答を待機する最大時間を秒単位で指定します。デフォルトは60秒です。タイムアウトを無効にするには0を設定します。

デフォルト値

60

解説

このプロパティは、Cloud が操作をキャンセルする前に操作の完了を待機する最大時間を秒単位で制御します。操作の完了前にタイムアウト時間が経過すると、Cloud は操作をキャンセルして例外をスローします。

タイムアウトは、クエリや操作全体ではなくサーバーとの個々の通信に適用されます。例えば、各ページング呼び出しがタイムアウト制限内に完了する場合、クエリは60秒を超えて実行を続けることができます。

このプロパティを0に設定するとタイムアウトが無効になり、操作が成功するか、サーバー側のタイムアウト、ネットワークの中断、またはサーバーのリソース制限などの他の条件で失敗するまで無期限に実行されます。このプロパティは慎重に使用してください。長時間実行される操作がパフォーマンスを低下させたり、応答しなくなる可能性があるためです。

Cloud

Blackbaud Raisers Edge NXT - CData Cloud

概要

主要機能

はじめに

BlackBaud Raiser's Edge NXT への接続

CData Cloud サービスからデータにアクセス

接続の確立

BlackBaud Raiser's Edge NXT への接続

BlackBaud Raiser's Edge NXT への認証

Web アプリケーション

ヘッドレスマシン

カスタムOAuth アプリケーションの作成

Creating a Custom OAuth Application

Create and Register the Custom Application

Connect the Custom Application to Your Environment

SSL の設定

SSL 設定のカスタマイズ

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

Firewall またはProxy 経由の接続

HTTP プロキシ

その他のプロキシ

データモデル

概要

主要機能

ビュー

ストアドプロシージャ

ビュー

CData Cloud - Blackbaud Raisers Edge NXT ビュー

ActionAttachments

Table Specific Information

Select

Columns

ActionCustomFields

Columns

Actions

Table Specific Information

Select

Columns

Pseudo-Columns

Addresses

Table Specific Information

Select

Columns

Pseudo-Columns

Aliases

Table Specific Information

Select

Columns

AppealAttachments

Table Specific Information

Select

Columns

CampaignAttachments

Table Specific Information

Select

Columns

Campaigns

Table Specific Information

Select

Columns

Pseudo-Columns

ConsentCategories

Table Specific Information

Select

Columns

Pseudo-Columns

ConsentChannelCategories

Table Specific Information

Select

Columns

ConsentChannels

Table Specific Information

Select

Columns

ConsentSources

Table Specific Information

Select

Columns

Pseudo-Columns