GrantContacts
Returns the list of contacts for the specified grant.
The connector will use the Blackbaud Financial Edge NXT API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the connector.
- GrantId supports the '=' operator.
SELECT * FROM GrantContacts WHERE GrantId = 1
Columns
| Name | Type | References | Description |
| GrantId [KEY] | Integer | The identifier of the grant. | |
| ContactId [KEY] | Integer | The identifier for this contact. | |
| FirstName | String | The first name of the contact. | |
| MiddleName | String | The middle name of the contact. | |
| LastName | String | The last name of the contact. | |
| Title | String | The title of the contact. | |
| Suffix | String | The suffix of the contact. | |
| Position | String | The position of the contact. | |
| Description | String | The description for this contact. | |
| AddressLine | String | The street address for this contact. | |
| City | String | The city for this contact. | |
| County | String | The county for this contact. | |
| State | String | The state or province for this contact. | |
| Postal | String | The postal code for this contact. | |
| Country | String | The country for this contact. | |
| AddressContactMethods | String | The contact methods for this contact. |