The contacts for a project.
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.
- ProjectId supports the '=' operator. This column is the only supported filter.
SELECT * FROM ProjectContacts WHERE ProjectId = 1You can turn off client-side execution by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will result in unfiltered data being pushed.
|The identifier for this project.|
|ContactId [KEY]||Integer||The identifier for this contact.|
|Description||String||The description for this address.|
|Country||String||The country for the address.|
|City||String||The city for the address.|
|County||String||The county for this address.|
|State||String||The state or province (or suburb in NZ) for the address.|
|Postal||String||Refers to the Postal Code or ZIP of the address.|
|Title||String||The title for the primary contact.|
|FirstName||String||The first name of the primary contact.|
|MiddleName||String||The middle initial or name of the primary contact.|
|LastName||String||The last name of the primary contact.|
|Suffix||String||The suffix of the primary contact.|
|Position||String||The position of the primary contact.|