ProjectContacts

The contacts for a project.

The 本製品 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 本製品.

ProjectId supports the '=' operator. This column is the only supported filter.

For example, the following query is processed server side:

SELECT * FROM ProjectContacts WHERE ProjectId = 1

Columns


Name	Type	References	Description
ProjectId [KEY]	Integer	Projects.ProjectId	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.
Address_line	String		The street information / address line for this 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.

Power BI Connector for Blackbaud Financial Edge NXT

ProjectContacts

Columns