BizTalk Adapter for Blackbaud Financial Edge NXT

Build 20.0.7587

Send Port SELECT Schemas

Executing Parameterized SELECT Statements

The following sections show the schema, instance, and response for the following parameterized query:

SELECT AccountId, AccountNumber FROM Accounts WHERE ModifiedBy = @ModifiedBy

Mapping the SELECT Schema to the Request and Response

SELECT schemas in solicit-response send ports have both a response section and an input parameters section.

SELECT Schema

Below is an example schema for a parameterized query executed from a solicit-response send port.

<?xml version="1.0" encoding="utf16" ?> 
<xs:schema xmlns:b="http://schemas.microsoft.com/BizTalk/2003" attributeFormDefault="unqualified" elementFormDefault="qualified" targetAccountNumberspace="http://www.cdata.com/FinancialEdgeNXTProvider/2020" xmlns:xs="http://www.w3.org/2001/XMLSchema">
  <xs:element name="parameters">
    <xs:complexType>
      <xs:sequence>
        <xs:element name="ModifiedBy" type="xs:string" /> 
      </xs:sequence>
    </xs:complexType>
  </xs:element>
  <xs:element name="table">
    <xs:complexType>
      <xs:sequence>
        <xs:element minOccurs="0" maxOccurs="unbounded" name="row">
          <xs:complexType>
            <xs:sequence>
              <xs:element minOccurs="0" name="AccountId">
                <xs:complexType>
                  <xs:simpleContent>
                    <xs:extension base="xs:string">
                      <xs:attribute name="IsNull" type="xs:boolean" /> 
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <xs:element name="AccountNumber">
                <xs:complexType>
                  <xs:simpleContent>
                    <xs:extension base="xs:string">
                      <xs:attribute name="IsNull" type="xs:boolean" /> 
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:sequence>
      <xs:attribute name="AffectedRows" type="xs:int" /> 
    </xs:complexType>
  </xs:element>
</xs:schema>

SELECT Request

Below is the input instance:

<ns0:parameters xmlns:ns0="http://www.cdata.com/FinancialEdgeNXTProvider/2020">
  <ns0:ModifiedBy>ModifiedBy_0</ns0:ModifiedBy> 
</ns0:parameters>

SELECT Response

Below is the response:

<ns0:table AffectedRows="3" xmlns:ns0="http://www.cdata.com/FinancialEdgeNXTProvider/2020">
  <ns0:row>
    <ns0:AccountId IsNull="true">AccountId_0</ns0:AccountId> 
    <ns0:AccountNumber IsNull="true">AccountNumber_0</ns0:AccountNumber> 
  </ns0:row>
  <ns0:row>
    <ns0:AccountId IsNull="true">AccountId_0</ns0:AccountId> 
    <ns0:AccountNumber IsNull="true">AccountNumber_0</ns0:AccountNumber> 
  </ns0:row>
  <ns0:row>
    <ns0:AccountId IsNull="true">AccountId_0</ns0:AccountId> 
    <ns0:AccountNumber IsNull="true">AccountNumber_0</ns0:AccountNumber> 
  </ns0:row>
</ns0:table>

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