SQL Command Schemas

You can use SQL command schemas to process and validate the response from NetSuite; for example, processing NetSuite data retrieved using the RSSBus BizTalk Adapter. The schema will map to the types in the results from the query.

Both receive locations and send ports can execute SQL commands. See Adapter Configuration for more information on using the adapter with receive locations and send ports.

Below is an example schema for the following query:

SELECT InternalId, AcctName FROM Account

<?xml version="1.0" encoding="utf-16" ?>
<xs:schema xmlns:b="http://schemas.microsoft.com/BizTalk/2003" attributeFormDefault="unqualified" elementFormDefault="qualified" targetNamespace="http://www.rssbus.com/NetSuiteProvider" xmlns:xs="http://www.w3.org/2001/XMLSchema">
  <xs:element name="table">
    <xs:complexType>
      <xs:sequence>
        <xs:element minOccurs="0" maxOccurs="unbounded" name="row">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" type="xs:string" /> 
              <xs:element name="AcctName" type="xs:string" /> 
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:sequence>
    </xs:complexType>
  </xs:element>
</xs:schema>