Events
Returns a list of events
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.
- Id supports the '=' operator.
- CategoryName supports the '=' operator.
- DateAdded supports the '>=,>' operators.
- DateModified supports the '>=,>' operators.
- Name supports the '=' operator.
- StartDate supports the '>=,<=' operators.
- IncludeInactive supports the '=' operator.
- Fields supports the '=' operator.
SELECT * FROM Events WHERE Id = '2' SELECT * FROM Events WHERE StartDate >= '2000-04-06T05:50:00' AND StartDate <= '2020-04-06T06:50:00' SELECT * FROM Events WHERE DateAdded >= '2010-06-01 14:03:35'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The ID of the event. | |
| AttendedCount | Integer | The number of event attendees. | |
| AttendingCount | Integer | The number of event participants who plan to attend. | |
| CampaignId | String | The ID of the campaign affiliated with the event. | |
| Capacity | Integer | The number of people that can attend the event. | |
| CategoryId | String | The ID of the event category. | |
| CategoryInactive | Boolean | Whether the category is inactive. | |
| CategoryName | String | The name of the event category. | |
| DateAdded | Datetime | The date when the event was created. | |
| DateModified | Datetime | The date when the event was last modified. | |
| EndDate | Date | The end date of the event. | |
| EndTime | String | The end time of the event. | |
| FundId | String | The ID of the fund affiliated with the event. | |
| Goal | Double | The monetary goal of the event. | |
| Inactive | Boolean | Whether the event is inactive. | |
| InvitedCount | Integer | The number of event invitees. | |
| LocationName | String | The name of the location. | |
| LocationAddressLines | String | The location's address lines. | |
| LocationPostalCode | String | The location's postal code. | |
| LocationLocalityId | String | The record ID of the locality record. | |
| LocationLocalityName | String | The name of the locality. | |
| LocationAdministrativeAreaId | String | The record ID of the administrative area. | |
| LocationAdministrativeAreaName | String | The name of the administrative area. | |
| LocationAdministrativeAreaShortDesc | String | The short description of the administrative area. | |
| LocationSubAdministrativeAreaId | String | The ID of the sub administrative area. | |
| LocationSubAdministrativeAreaName | String | The name of the sub administrative area. | |
| LocationCountryId | String | The ID of the country record. | |
| LocationCountryDisplayName | String | The display name of the country. | |
| LocationCountryIsoAlpha2Code | String | The ISO 3166-1 alpha-2 code for the country. | |
| LocationFormattedAddress | String | The location's formatted address. | |
| LookupId | String | The lookup ID of the event. | |
| Name | String | The name of the event. | |
| StartDate | Date | The start date of the event. | |
| StartTime | String | The start time of the event. |
Pseudo-Columns
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. |