BizTalk Adapter for Blackbaud Financial Edge NXT

Build 20.0.7587

ProjectContacts

The contacts for a project.

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

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

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

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587