Adding a Connection to BlackBaud Raiser's Edge NXT

To add a connection to BlackBaud Raiser's Edge NXT:

1. In the application console, navigate to the Connections page.
2. At the Add Connections panel, select the icon for the connection you want to add.
3. If the BlackBaud Raiser's Edge NXT icon is not available, click the Add More icon to download and install the BlackBaud Raiser's Edge NXT connector from the CData site.

For required properties, see the Settings tab.

For connection properties that are not typically required, see the Advanced tab.

Connecting to BlackBaud Raiser's Edge NXT

Before establishing a connection, supply the SubscriptionKey, found in the BlackBaud Raiser's Edge NXT Profile.

Authenticating to BlackBaud Raiser's Edge NXT

BlackBaud Raiser's Edge NXT provides embedded OAuth credentials that simplify connection from a Desktop application . To connect from a Web application, you must create a custom OAuth application, as described in Creating a Custom OAuth Application.

To connect from all authentication flows, you must:

• set AuthScheme to OAuth
• set the SubscriptionKey to your Subscription Key
• enable BlackBaud Raiser's Edge NXT on an authorization account to retrieve results

The following subsections describe how to authenticate to BlackBaud Raiser's Edge NXT from all available OAuth flows. For information about how to create a custom OAuth application to connect via the Web, see Creating a Custom OAuth Application. For a complete list of connection string properties available in BlackBaud Raiser's Edge NXT, see Connection.

Web Applications

When connecting via a Web application, you must create and register a custom OAuth application with BlackBaud Raiser's Edge NXT. You can then use the Sync App to acquire and manage the OAuth token values. For information about how to create a custom OAuth application and set it up so that it connects properly to your BlackBaud Raiser's Edge NXT environment, see Creating a Custom OAuth Application.

Get an OAuth Access Token

To obtain the OAuthAccessToken, set these properties:

• OAuthClientId: The Client Id specified in your custom OAuth application settings.
• OAuthClientSecret: The Client Secret specified in your custom OAuth application settings.

Then call stored procedures to complete the OAuth exchange:

1. Call the GetOAuthAuthorizationURL stored procedure. Set the AuthMode input to WEB and set the CallbackURL input to the Redirect URI you specified when you configured your custom OAuth application. If necessary, set the Permissions parameter to request custom permissions. The stored procedure returns the URL to the OAuth endpoint.
2. Navigate to the URL that the stored procedure returned in Step 1. Log in to the custom OAuth application and authorize the web application. Once the application has been authenticated, the browser redirects you to the callback URL.
3. Call the GetOAuthAccessToken stored procedure. Set AuthMode to WEB and the Verifier input to the "code" parameter in the query string of the callback URL. If necessary, set the Permissions parameter to request custom permissions.

To connect to data, set the OAuthAccessToken connection property to the access token returned by the stored procedure. When the access token expires after ExpiresIn seconds, call GetOAuthAccessToken again to obtain a new access token.

Headless Machines

To configure the driver to use OAuth with a user account on a headless machine, you must authenticate on another device that has an internet browser.

1. Choose one of the following options:
   • Option 1: Obtain the OAuthVerifier value as described in Obtain and Exchange a Verifier Code, below.
   • Option 2: Install the Sync App on a machine with an Internet browser and transfer the OAuth authentication values after you authenticate through the usual browser-based flow, as described in Option 2: Transfer OAuth Settings, below.
2. Then configure the Sync App to automatically refresh the access token on the headless machine.

Option 1: Obtain and Exchange a Verifier Code

To obtain a verifier code, you must authenticate at the OAuth authorization URL.

Follow the steps below to authenticate from the machine with an Internet browser and obtain the OAuthVerifier connection property.

1. Choose one of these options:
   • If you are using the Embedded OAuth Application click BlackBaud Raiser's Edge NXT OAuth endpoint to open the endpoint in your browser.
   • If you are using a custom OAuth application, create the Authorization URL by setting the following properties:
     • InitiateOAuth: Set to OFF.
     • OAuthClientId: Set to the client Id specified in your custom OAuth application.
     • OAuthClientSecret: Set to the client secret specified in your custom OAuth application.
     Then call the GetOAuthAuthorizationURL stored procedure with the appropriate CallbackURL. Open the URL returned by the stored procedure in a browser.
2. Log in and grant permissions to the Sync App. You are then redirected to the callback URL, which contains the verifier code.
3. Save the value of the verifier code. Later you will set this in the OAuthVerifier connection property.

Next, you must exchange the OAuth verifier code for OAuth refresh and access tokens.

On the headless machine, to obtain the OAuth authentication values, set these connection properties:

• InitiateOAuth: REFRESH.
• OAuthVerifier: The verifier code.
• OAuthSettingsLocation: Persist the encrypted OAuth authentication values to the specified location.
• Custom applications only:
  • OAuthClientId: The Client Id specified in your custom OAuth application settings.
  • OAuthClientSecret: The Client Secret specified in your custom OAuth application settings.

After the OAuth settings file is generated, you must re-set the following properties to connect:

• InitiateOAuth: REFRESH.
• OAuthSettingsLocation: The location containing the encrypted OAuth authentication values. Make sure this location gives read and write permissions to the Sync App to enable the automatic refreshing of the access token.
• Custom applications only:
  • OAuthClientId: The client Id specified in your custom OAuth application settings.
  • OAuthClientSecret: The client secret specified in your custom OAuth application settings.

Option 2: Transfer OAuth Settings

Before you can connect on a headless machine, you need to create and install a connection with the driver on a device that supports an Internet browser. Set the connection properties as described in Desktop Applications, above.

After completing the instructions in Desktop Applications, the resulting authentication values are encrypted and written to the location specified by OAuthSettingsLocation. The default filename is OAuthSettings.txt.

Once you have successfully tested the connection, copy the OAuth settings file to your headless machine, then set the following connection properties to connect to data:

• InitiateOAuth: REFRESH.
• OAuthSettingsLocation: Set this to the location of your OAuth settings file. Make sure this location gives read and write permissions to the Sync App to enable the automatic refreshing of the access token.
• Custom applications only:
  • OAuthClientId: The client Id specified in your custom OAuth application settings.
  • OAuthClientSecret: The client secret specified in your custom OAuth application settings.

This section details a selection of advanced features of the BlackBaud Raiser's Edge NXT Sync App.

User Defined Views

The Sync App allows you to define virtual tables, called user defined views, whose contents are decided by a pre-configured query. These views are useful when you cannot directly control queries being issued to the drivers. See User Defined Views for an overview of creating and configuring custom views.

SSL Configuration

Use SSL Configuration to adjust how Sync App handles TLS/SSL certificate negotiations. You can choose from various certificate formats; see the SSLServerCert property under "Connection String Options" for more information.

Firewall and Proxy

Configure the Sync App for compliance with Firewall and Proxy, including Windows proxies and HTTP proxies. You can also set up tunnel connections.

Query Processing

The Sync App offloads as much of the SELECT statement processing as possible to BlackBaud Raiser's Edge NXT and then processes the rest of the query in memory (client-side).

See Query Processing for more information.

Logging

See Logging for an overview of configuration settings that can be used to refine CData logging. For basic logging, you only need to set two connection properties, but there are numerous features that support more refined logging, where you can select subsets of information to be logged using the LogModules connection property.

Customizing the SSL Configuration

By default, the Sync App attempts to negotiate SSL/TLS by checking the server's certificate against the system's trusted certificate store.

To specify another certificate, see the SSLServerCert property for the available formats to do so.

Connecting Through a Firewall or Proxy

HTTP Proxies

To connect through the Windows system proxy, you do not need to set any additional connection properties. To connect to other proxies, set ProxyAutoDetect to false.

In addition, to authenticate to an HTTP proxy, set ProxyAuthScheme, ProxyUser, and ProxyPassword, in addition to ProxyServer and ProxyPort.

Other Proxies

Set the following properties:

• To use a proxy-based firewall, set FirewallType, FirewallServer, and FirewallPort.
• To tunnel the connection, set FirewallType to TUNNEL.
• To authenticate, specify FirewallUser and FirewallPassword.
• To authenticate to a SOCKS proxy, additionally set FirewallType to SOCKS5.

Overview

This section shows the available API objects and provides more information on executing SQL to BlackBaud Raiser's Edge NXT APIs.

Key Features

• The Sync App models BlackBaud Raiser's Edge NXT entities like documents, folders, and groups as relational views, allowing you to write SQL to query BlackBaud Raiser's Edge NXT data.
• Stored procedures allow you to execute operations to BlackBaud Raiser's Edge NXT.
• Live connectivity to these objects means any changes to your BlackBaud Raiser's Edge NXT account are immediately reflected when using the Sync App.

Views

Views describes the available views. Views are statically defined to model Actions, Emails, Events, etc..

Stored Procedures

Stored Procedures are function-like interfaces to BlackBaud Raiser's Edge NXT. Stored procedures allow you to execute operations to BlackBaud Raiser's Edge NXT, including downloading documents and moving envelopes.

Views are similar to tables in the way that data is represented; however, views are read-only.

Queries can be executed against a view as if it were a normal table.

Blackbaud Raisers Edge NXT Connector for CData Sync Views

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

Retrieves a list of attachments for an action.

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.
Note: ActionId is required in order to query ActionAttachments.

• ActionId supports the '=' operator.

For example:

	SELECT * FROM ActionAttachments WHERE ActionId = '335'

Columns

Name	Type	References	Description
Id [KEY]	String		The immutable system record ID of the attachment.
ActionId	String	Actions.Id	The immutable system record ID of the action this attachment is associated to.
ContentType	String		The content type. For physical attachments only.
Date	Datetime		The date of the attachment.
FileId	String		The identifier of the file.
FileName	String		The file name.
FileSize	Integer		The file size in bytes.
Name	String		The name of the attachment.
ParentId	String		The parent object's immutable system record ID.
Tags	String		The parent object's immutable system record ID.
ThumbnailId	String		The identifier of the thumbnail.
ThumbnailUrl	String		The URL for a thumbnail.
Type	String		The attachment type.
Url	String		The URL for the attachment.

Retrieves custom fields for an action

Columns

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

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

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.

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

For example:

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

Columns

Name	Type	References	Description
Id [KEY]	String		The immutable system record ID of the action.
Category	String		The channel or intent of the constituent interaction.
Completed	Boolean		Indicates whether the action is complete.
CompletedDate	Datetime		The date when the action was completed.
ComputedStatus	String		The computed action status. The allowed values are Open, Completed, PastDue.
ConstituentId	String	Constituents.Id	The immutable system record ID of the constituent associated with the action.
Date	Date		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. The allowed values are 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

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

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

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

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.

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

For example:

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

Columns

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

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

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

Retrieves a list of aliases for a constituent

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.
Note: ConstituentId is required in order to query Aliases.

• ConstituentId supports the '=' operator.

For example:

	SELECT * FROM Aliases WHERE ConstituentId = '280'

Columns

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

Returns a list of attachments for an appeal.

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.
Note: AppealId is required in order to query AppealAttachments.

• AppealId supports the '=' operator.

For example:

	SELECT * FROM AppealAttachments WHERE AppealId = '2'

Columns

Name	Type	References	Description
Id [KEY]	String		The immutable system record ID of the attachment.
AppealId	String	FundraisingAppeals.Id	The immutable system record ID of the appeal.
ContentType	String		The content type. For physical attachments only.
Date	Datetime		The date of the attachment.
FileId	String		The identifier of the file.
FileName	String		The file name.
FileSize	Integer		The file size in bytes.
Name	String		The name of the attachment.
ParentId	String		The parent object's immutable system record ID.
Tags	String		The tags associated with the attachment.
ThumbnailId	String		The identifier of the thumbnail.
ThumbnailUrl	String		The URL for a thumbnail.
Type	String		The attachment type.
Url	String		The URL for the attachment.

Returns a list of attachments for a campaign.

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.
Note: CampaignId is required in order to query CampaignAttachments.

• CampaignId supports the '=' operator.

For example:

	SELECT * FROM CampaignAttachments WHERE CampaignId = '2'

Columns

Name	Type	References	Description
Id [KEY]	String		The immutable system record ID of the attachment.
CampaignId	String	Campaigns.Id	The immutable system record ID of the campaign.
ContentType	String		The content type. For physical attachments only.
Date	Datetime		The date of the attachment.
FileId	String		The identifier of the file.
FileName	String		The file name.
FileSize	Integer		The file size in bytes.
Name	String		The name of the attachment.
ParentId	String		The parent object's immutable system record ID.
Tags	String		The tags associated with the attachment.
ThumbnailId	String		The identifier of the thumbnail.
ThumbnailUrl	String		The URL for a thumbnail.
Type	String		The attachment type.
Url	String		The URL for the attachment.

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

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.

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

For example:

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

Columns

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

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

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

Returns a list of consent categories.

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.

• IncludeInactive supports the '=' operator.

For example:

	
	SELECT * FROM ConsentCategories WHERE IncludeInactive = true
	

Columns

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

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

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

Returns a list of valid consent channel category combinations.

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.

Columns

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

Represents the consent channel entity

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.

Columns

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

Represents the consent source entity

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.

• IncludeInactive supports the '=' operator.

For example:

	
	SELECT * FROM ConsentSources WHERE IncludeInactive = true
	

Columns

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

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

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

Returns a list of appeals for a constituent.

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.

• ConstituentId supports the '=' operator.

For example:

	
	SELECT * FROM ConstituentAppeals WHERE ConstituentId = '280'
	

Columns

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

Returns a list of attachments for a constituent.

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.
Note: ConstituentId is required in order to query ConstituentAttachments.

• ConstituentId supports the '=' operator.

For example:

	SELECT * FROM ConstituentAttachments WHERE ConstituentId = '280'
	

Columns

Name	Type	References	Description
Id [KEY]	String		The immutable system record ID of the attachment.
ConstituentId	String		The immutable system record ID of the constituent associated with the attachment.
ContentType	String		The content type.
Date	Datetime		The date of the attachment.
FileId	String		The identifier of the file.
FileName	String		The file name.
FileSize	Integer		The file size in bytes.
Name	String		The name of the attachment.
ParentId	String		The parent object's immutable system record ID.
Tags	String		The tags associated with the attachment.
Type	String		The attachment type.
Url	String		The URL for the attachment.

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

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.

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

For example:

	
	SELECT * FROM ConstituentCodes WHERE Id = '144'

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

Columns

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

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

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

Returns a list of constituent consent records.

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.
Note: ConstituentId is required in order to query ConstituentConsents.

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

For example:

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

Columns

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

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

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

Returns a list of fundraiser assignments for a constituent.

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.
Note: ConstituentId is required in order to query ConstituentFundraiserAssignments.

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

For example:

	SELECT * FROM ConstituentFundraiserAssignments WHERE ConstituentId = '280'

Columns

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

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

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

Returns a paginated list of constituents

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.

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

For example:

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

Columns

Name	Type	References	Description
Id [KEY]	String		The immutable system record ID for the constituent.
AddressLines	String		The address lines.
AddressCity	String		The city of the address.
AddressConstituentId	String		The immutable system record ID of the constituent associated with the address.
AddressCountry	String		The country of the address.
AddressCounty	String		The county of the address.
AddressDateAdded	Datetime		The date when the address was created.
AddressDateModified	Datetime		The date when the address was last modified.
AddressDoNotMail	Boolean		Indicates whether the constituent requests not to be contacted at this address.
AddressEnd	Datetime		The date when the constituent ceased to reside at this address.
AddressFormattedAddress	String		This computed field retrieves the formatted address in the configured format of the country.
AddressId	String		The immutable system record ID of the address.
AddressInactive	Boolean		This computed field indicates that the address is active if the current date is before any end date.
AddressPostalCode	String		The postal code of the address.
AddressPreferred	Boolean		Indicates whether this is the constituent's preferred address.
AddressSeasonalEndD	Integer		The day of the year ceases to reside at this address.
AddressSeasonalEndM	Integer		The month of the year ceases to reside at this address.
AddressSeasonalEndY	Integer		The year ceases to reside at this address.
AddressSeasonalStartD	Integer		The day of year that the constituent begins residing at this address.
AddressSeasonalStartM	Integer		The month of year that the constituent begins residing at this address.
AddressSeasonalStarty	Integer		The year that the constituent begins residing at this address.
AddressStart	Date		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	String		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

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

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

Retrieves custom fields for all constituents

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.

Columns

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

Returns a list of solicit codes for the specified constituent.

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.
Note: ConstituentId is required in order to query ConstituentSolicitCodes.

• ConstituentId supports the '=' operator.

For example:

 
	SELECT * FROM ConstituentSolicitCodes WHERE ConstituentId = '280'
	

Columns

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

Returns the list of available countries.

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.

Columns

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

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

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.

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

For example:

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

Columns

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

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

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.

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

For example:

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

Columns

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

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

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

Returns a list of active event categories.

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.

• IncludeInactive supports the '=' operator.

For example:

	
	SELECT * FROM EventCategories WHERE IncludeInactive = true

Columns

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

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

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

Returns a list of fees for an event.

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.
Note: EventId is required in order to query EventFees.

• EventId supports the '=' operator.

For example:

	SELECT * FROM EventFees WHERE EventId = '2'

Columns

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

The participant's basic summary information

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.
Note: EventId is required in order to query EventParticipantGuests.

• EventId supports the '=' operator.

For example:

	SELECT * FROM EventParticipantGuests WHERE EventId = '2'

Columns

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

The individual's membership category

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.
Note: EventId is required in order to query EventParticipantMemberships.

• EventId supports the '=' operator.

For example:

	SELECT * FROM EventParticipantMemberships WHERE EventId = '2'

Columns

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

Returns the participant options for an event.

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.
Note: EventId is required in order to query EventParticipantOptions.

• EventId supports the '=' operator.

For example:

	SELECT * FROM EventParticipantOptions WHERE EventId = '2'

Columns

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

Returns a list of participants for an event.

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.
Note: EventId is required in order to query EventParticipants.

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

For example:

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

Columns

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

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

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

Returns a list of events

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.

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

For example:

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

Columns

Name	Type	References	Description
Id [KEY]	String		The ID of the event.
AttendedCount	Integer		The number of event attendees.
AttendingCount	Integer		The number of event participants who plan to attend.
CampaignId	String		The ID of the campaign affiliated with the event.
Capacity	Integer		The number of people that can attend the event.
CategoryId	String		The ID of the event category.
CategoryInactive	Boolean		Whether the category is inactive.
CategoryName	String		The name of the event category.
DateAdded	Datetime		The date when the event was created.
DateModified	Datetime		The date when the event was last modified.
EndDate	Datetime		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

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

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

Returns a list of attachments for a fund.

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.
Note: FundId is required in order to query FundAttachments.

• FundId supports the '=' operator.

For example:

	SELECT * FROM FundAttachments WHERE FundId = '4'
	

Columns

Name	Type	References	Description
Id [KEY]	String		The immutable system record ID of the attachment.
FundId	String	Funds.Id	The immutable system record ID of the fund.
ContentType	String		The content type. For physical attachments only.
Date	Datetime		The date of the attachment.
FileId	String		The identifier of the file.
FileName	String		The file name.
FileSize	Integer		The file size in bytes.
Name	String		The name of the attachment.
ParentId	String		The parent object's immutable system record ID.
Tags	String		The tags associated with the attachment.
ThumbnailId	String		The identifier of the thumbnail.
ThumbnailUrl	String		The URL for a thumbnail.
Type	String		The attachment type.
Url	String		The URL for the attachment.

Returns a list of assignments for a fundraiser.

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.
Note: FundraiserId is required in order to query FundraiserAssignments.

• FundraiserId supports the '=' operator.

For example:

	SELECT * FROM FundraiserAssignments WHERE FundraiserId = '4'
	

Columns

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

Returns a list of goals for a fundraiser

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.
Note: FundraiserId is required in order to query FundraiserGoals.

• FundraiserId supports the '=' operator.

For example:

	SELECT * FROM FundraiserGoals WHERE FundraiserId = '4'
	

Columns

Name	Type	References	Description
Id [KEY]	String		The immutable system record ID of the fundraiser goal.
AmountValue	Double		The fundraiser goal amount.
AppealId	String	FundraisingAppeals.Id	The immutable system record ID of the appeal associated with the fundraiser goal.
CampaignId	String	Campaigns.Id	The immutable system record ID of the campaign associated with the fundraiser goal.
FundId	String	Funds.Id	The immutable system record ID of the fund associated with the fundraiser goal.
FundraiserId	String		The immutable system record ID of the fundraiser associated with the fundraiser goal.
Type	String		The fundraiser goal type. Available values are Campaign, Fund, UnspecifiedCategory, and Appeal.
UnspecifiedCategoryName	String		The unspecified category name for the fundraiser goal.

Returns a list of fundraising appeals.

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.

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

For example:

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

Columns

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

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

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

Returns a list of funds.

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.

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

For example:

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

Columns

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

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

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

This gets the installments of an existing pledge gift.

Columns

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

This gets the payments of an existing pledge gift.

Columns

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

Returns a list of acknowledgements for a gift

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.
Note: GiftId are required in order to query GiftAcknowledgements.

• GiftId supports the '=' operator.

For example:

	SELECT * FROM GiftAcknowledgements WHERE GiftId = '476'

Columns

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

Returns a list of attachments for a gift.

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.
Note: GiftId are required in order to query GiftAttachments.

• GiftId supports the '=' operator.

For example:

	SELECT * FROM GiftAttachments WHERE GiftId = '476'

Columns

Name	Type	References	Description
Id [KEY]	String		The immutable system record ID of the attachment.
GiftId	String	Gifts.Id	The immutable system record ID of the gift the attachments are associated to.
ContentType	String		The content type. For physical attachments only.
Date	Datetime		The date of the attachment.
FileId	String		The identifier of the file.
FileName	String		The file name.
FileSize	Integer		The file size in bytes.
Name	String		The name of the attachment.
ParentId	String		The parent object's immutable system record ID.
Tags	String		The tags associated with the attachment.
ThumbnailId	String		The identifier of the thumbnail.
ThumbnailUrl	String		The URL for a thumbnail.
Type	String		The attachment type.
Url	String		The URL for the attachment.

Returns a list of gift batches.

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.

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

Columns

Name	Type	References	Description
Id [KEY]	String		The batch identifier.
ActualAmount	Integer		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

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

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

Returns payments for a gift.

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.
Note: GiftId are required in order to query GiftPayments.

• GiftId supports the '=' operator.

For example:

	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	String		The day of the check date. Only applies to payment method of PersonalCheck.
CheckDateM	String		The month of the check date. Only applies to payment method of PersonalCheck.
CheckDateY	String		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	String		The day of the reference date.
ReferenceDateM	String		The month of the reference date.
ReferenceDateY	String		The year of the reference date.

Returns receipts for a gift.

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.
Note: GiftId are required in order to query GiftReceipts.

• GiftId supports the '=' operator.

For example:

	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	Integer		The amount of the receipt.
Date	Datetime		The date on the receipt.
Number	Integer		The number of the receipt.
Status	String		The status of the receipt. Available values are: RECEIPTED, NEEDSRECEIPT, and DONOTRECEIPT.

Returns a paginated list of gifts

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.

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

For example:

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

Columns

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

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

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

Retrieves custom fields for all gifts

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.

Columns

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

Returns soft credits for a gift.

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.
Note: GiftId are required in order to query GiftSoftCredits.

• GiftId supports the '=' operator.

For example:

	SELECT * FROM GiftSoftCredits WHERE GiftId = '476'

Columns

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

Returns the splits for a gift.

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.
Note: GiftId are required in order to query GiftSplits.

• GiftId supports the '=' operator.

For example:

	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	Integer		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	String		The amount of tax reclaimed from gift aid for this gift split. For the UK only.
GiftAidQualificationStatus	String		The gift aid qualification status of the gift split. Available values are: Qualified, and NotQualified. For the UK only.
PackageId	String		The immutable system record ID of the package associated with the gift split.

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

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.
Note: ConstituentId and GivingSummaryType are required in order to query Giving.

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

For example:

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

Columns

Name	Type	References	Description
Id [KEY]	String		The immutable system record ID of the gift.
AmountValue	Double		The gift amount.
Date	Date		The gift date.
Type	String		The gift type.
ConstituentId	String	Constituents.Id	The immutable system record ID of the constituent associated with this giving.
GivingSummaryType	String		The giving summary type. Available values are First, Latest and Greatest. The allowed values are first, greatest, latest.

Returns the giving appeals summary for the constituent

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.
Note: ConstituentId and GivingSummaryType are required in order to query GivingAppeals.

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

For example:

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

Columns

Name	Type	References	Description
Id [KEY]	String		The immutable system record ID of the appeal.
Description	String		The description.
ConstituentId	String	Constituents.Id	The immutable system record ID of the constituent associated with this giving.
GivingSummaryType	String		The giving summary type. Available values are First, Latest and Greatest. The allowed values are first, greatest, latest.

Returns the giving campaigns summary for the constituent

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.
Note: ConstituentId and GivingSummaryType are required in order to query GivingCampaigns.

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

For example:

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

Columns

Name	Type	References	Description
Id [KEY]	String		The immutable system record ID of the campaign.
Description	String		The campaign description.
ConstituentId	String	Constituents.Id	The immutable system record ID of the constituent associated with this giving.
GivingSummaryType	String		The giving summary type. Available values are First, Latest and Greatest. The allowed values are first, greatest, latest.

Returns the giving funds summary for the constituent

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.
Note: ConstituentId and GivingSummaryType are required in order to query GivingFunds.

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

For example:

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

Columns

Name	Type	References	Description
Id [KEY]	String		The immutable system record ID of the fund.
Description	String		The fund description.
ConstituentId	String	Constituents.Id	The immutable system record ID of the constituent associated with this giving.
GivingSummaryType	String		The giving summary type. Available values are First, Latest and Greatest. The allowed values are first, greatest, latest.

Returns the lifetime giving information for a constituent.

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.
Note: ConstituentId are required in order to query LifetimeGiving.

• ConstituentId supports the '=' operator.

For example:

	SELECT * FROM LifetimeGiving WHERE ConstituentId = '280'

Columns

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

Returns a list of lists for the given list type

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.

• ListType supports the '=' operator.

For example:

	SELECT * FROM Lists WHERE ListType = 'Constituent'
	

Columns

Name	Type	References	Description
Id [KEY]	String		The immutable system record ID for the list.
DateModified	Datetime		The date this list was last modified.
Description	String		The description of the list
IsPublic	Boolean		Indicates whether this is a public or private list.
LastModifiedByUserId	String		The ID of the user that last modified the list.
LastModifiedByUserName	String		The name of the user that last modified the list.
Name	String		The name of the list.
RecordCount	Integer		The total number of records defined by this list based on the last time this list was saved.
ListType	String		Type of the list. The allowed values are Constituent, Gift, Action, Opportunity.

Returns the list of members.

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.

• ConstituentId supports the '=' operator.

For example:

	SELECT * FROM Members WHERE ConstituentId = '280'

Columns

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

Returns a list of memberships.

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.

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

For example:

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

Columns

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

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

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.

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

For example:

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

Columns

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

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

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.

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

For example:

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

Columns

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

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

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

Retrieves a list of opportunities

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.

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

For example:

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

Columns

Name	Type	References	Description
Id [KEY]	String		The immutable system record ID of the opportunity.
AskAmountValue	Double		The monetary amount solicited from the prospect for the opportunity.
AskDate	Date		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

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

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

Retrieves custom fields for an opportunity

Columns

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

Returns a list of attachments for an opportunity

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.
Note: OpportunityId is required in order to query OpportunityAttachments.

• OpportunityId supports the '=' operator.

For example:

	SELECT * FROM OpportunityAttachments WHERE OpportunityId = '4'

Columns

Name	Type	References	Description
Id [KEY]	String		The immutable system record ID of the attachment.
OpportunityId	String	Opportunities.Id	The ID of the Opportunity.
Content_type	String		The content type. For physical attachments only.
Date	Datetime		The date of the attachment.
FileId	String		The identifier of the file.
FileName	String		The file name. For physical attachments only.
FileSize	Integer		The file size in bytes. For physical attachments only.
Name	String		The name of the attachment.
ParentId	String		The parent object's immutable system record ID.
Tags	String		The tags associated with the attachment.
ThumbnailId	String		The identifier of the thumbnail. For physical attachments that are images only.
ThumbnailUrl	String		The URL for a thumbnail.
Type	String		The attachment type. Available values are Link and Physical.
Url	String		The URL for the attachment.

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

Table Specific Information

Select

The Sync App will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.

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

For example:

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

Columns

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

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

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