MuleSoft Connector for Blackbaud Raisers Edge NXT

Build 21.0.7930

Memberships

Returns a list of memberships.

Table Specific Information

Select

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

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

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