BizTalk Adapter for Zendesk

Build 20.0.7587

UPDATE Command Schemas

Executing an UPDATE

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

UPDATE [Tickets] SET Subject=@Subject WHERE Id = @Id

Mapping the Update Schema to the Request and Response

An UPDATE schema for a solicit-response port contains sections for input parameters and the response. Solicit-response send ports return the rows affected by an update.

Schemas for a one-way send port have the same request section, so the request is the same; however, there is no response section so a one-way send port does not return the affected rows.

UPDATE Schema

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

<?xml version="1.0"?>
<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" targetNamespace="http://www.cdata.com/ZendeskProvider/2020" xmlns:xs="http://www.w3.org/2001/XMLSchema">
  <xs:element name="parameters">
    <xs:complexType>
      <xs:sequence>
        <xs:element name="Subject" type="xs:string" />
        <xs:element name="Id" 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 name="Id">
                <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>

UPDATE Request

Below is the input instance:

<ns0:parameters xmlns:ns0="http://www.cdata.com/ZendeskProvider/2020">
  <ns0:Subject>Subject_0</ns0:Subject> 
  <ns0:Id>Id_0</ns0:Id> 
</ns0:parameters>

UPDATE Response

Below is an instance of the response returned by the adapter:

<ns0:table AffectedRows="3" xmlns:ns0="http://www.cdata.com/ZendeskProvider/2020">
  <ns0:row>
    <ns0:Id IsNull="true">Id_0</ns0:Id> 
  </ns0:row>
  <ns0:row>
    <ns0:Id IsNull="true">Id_0</ns0:Id> 
  </ns0:row>
  <ns0:row>
    <ns0:Id IsNull="true">Id_0</ns0:Id> 
  </ns0:row>
</ns0:table>

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