CData BizTalk Adapter for HubSpot 2019 - Online Help
Questions / Feedback?

Send Port SELECT Schemas

CData BizTalk Adapter for HubSpot 2019 - Build 19.0.7424

Executing Parameterized SELECT Statements

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

SELECT City, Country FROM Contacts WHERE VID = @VID

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" targetCountryspace="http://www.cdata.com/HubSpotProvider/2019" xmlns:xs="http://www.w3.org/2001/XMLSchema">
  <xs:element name="parameters">
    <xs:complexType>
      <xs:sequence>
        <xs:element name="VID" 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="City">
                <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="Country">
                <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/HubSpotProvider/2019">
  <ns0:VID>VID_0</ns0:VID> 
</ns0:parameters>

SELECT Response

Below is the response:

<ns0:table AffectedRows="3" xmlns:ns0="http://www.cdata.com/HubSpotProvider/2019">
  <ns0:row>
    <ns0:City IsNull="true">City_0</ns0:City> 
    <ns0:Country IsNull="true">Country_0</ns0:Country> 
  </ns0:row>
  <ns0:row>
    <ns0:City IsNull="true">City_0</ns0:City> 
    <ns0:Country IsNull="true">Country_0</ns0:Country> 
  </ns0:row>
  <ns0:row>
    <ns0:City IsNull="true">City_0</ns0:City> 
    <ns0:Country IsNull="true">Country_0</ns0:Country> 
  </ns0:row>
</ns0:table>

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