Executing an Insert Updategram

Insert updategrams have only an after block, which specifies how the data will change.

Insert Instance

Below is an instance of an insert request.

<ns0:parameters xmlns:ns0="http://www.cdata.com/GoogleContactsProvider/2020">
  <ns0:sync>
    <ns0:before></ns0:before>
    <ns0:after>
      <ns0:[My Contacts] Fullname="Fullname_0" WinProb="10" /> 
    </ns0:after>
  </ns0:sync>
</ns0:parameters>

Insert Schema

Below is an insert schema. The response contains the Id of the newly inserted record and the number of rows affected.

<?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/GoogleContactsProvider/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="after">
                <xs:complexType>
                  <xs:sequence>
                    <xs:element name="[My Contacts]">
                      <xs:complexType>
                        <xs:attribute name="Fullname" type="xs:string" /> 
                        <xs:attribute name="Id" type="xs:string" /> 
                      </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:sequence>
        <xs:element minOccurs="0" maxOccurs="unbounded" name="row">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" type="xs:string" /> 
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:sequence>
      <xs:attribute name="AffectedRows" type="xs:int" /> 
    </xs:complexType>
  </xs:element>
</xs:schema>