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/SAPSuccessFactorsProvider/2020">
  <ns0:sync>
  <ns0:before>
    <ns0:SampleTable_1 Id="Id_0" Column1="Column1_0" AnnualRevenue="10" /> 
  </ns0:before>
  <ns0:after>
    <ns0:SampleTable_1 Id="Id_0" Column1="Column1_0" AnnualRevenue="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/SAPSuccessFactorsProvider/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="SampleTable_1">
                    <xs:complexType>
                      <xs:attribute name="Id" type="xs:string" /> 
                      <xs:attribute name="Column1" type="xs:string" /> 
                      <xs:attribute name="AnnualRevenue" type="xs:double" /> 
                    </xs:complexType>
                  </xs:element>
                  </xs:sequence>
                </xs:complexType>
              </xs:element>
              <xs:element name="after">
                <xs:complexType>
                  <xs:sequence>
                    <xs:element name="SampleTable_1">
                      <xs:complexType>
                        <xs:attribute name="Id" type="xs:string" /> 
                        <xs:attribute name="Column1" type="xs:string" /> 
                        <xs:attribute name="AnnualRevenue" 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>