BizTalk Adapter for Zendesk

Build 20.0.7587

Update Schemas

Executing an Update Updategram

The Id is required for updates. The before block specifies which columns to update. The after block declares how the data will change. If multiple before and after blocks are specified, the adapter will execute the updates in bulk.

Update Instance

Below is an instance of an update request.

<ns0:parameters xmlns:ns0="http://www.cdata.com/ZendeskProvider/2020">
  <ns0:sync>
  <ns0:before>
    <ns0:Tickets Id="Id_0" Subject="Subject_0" Size="10" /> 
  </ns0:before>
  <ns0:after>
    <ns0:Tickets Id="Id_0" Subject="Subject_0" Size="10" /> 
  </ns0:after>
  </ns0:sync>
</ns0:parameters>

Update Schema

Below is an update schema. The response contains the number of affected rows.

<?xml version="1.0" encoding="utf-16" ?> 
<xs:schema xmlns:b="http://schemas.microsoft.com/BizTalk/2003" 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="sync">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="before">
                <xs:complexType>
                  <xs:sequence>
                  <xs:element name="Tickets">
                    <xs:complexType>
                      <xs:attribute name="Id" type="xs:string" /> 
                      <xs:attribute name="Subject" type="xs:string" /> 
                      <xs:attribute name="Size" type="xs:double" /> 
                    </xs:complexType>
                  </xs:element>
                  </xs:sequence>
                </xs:complexType>
              </xs:element>
              <xs:element name="after">
                <xs:complexType>
                  <xs:sequence>
                    <xs:element name="Tickets">
                      <xs:complexType>
                        <xs:attribute name="Id" type="xs:string" /> 
                        <xs:attribute name="Subject" type="xs:string" /> 
                        <xs:attribute name="Size" type="xs:double" /> 
                      </xs:complexType>
                    </xs:element>
                  </xs:sequence>
                </xs:complexType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:sequence>
    </xs:complexType>
  </xs:element>
  <xs:element name="table">
    <xs:complexType>
      <xs:attribute name="AffectedRows" type="xs:int" /> 
    </xs:complexType>
  </xs:element>
</xs:schema>

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