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

Bulk Updategrams

CData BizTalk Adapter for QuickBooks Online 2019 - Build 19.0.7354

You can generate updategrams to take advantage of the batch processing capabilities of the QuickBooks Online API in BizTalk.

Bulk Insert Schema

A bulk insert updategram has multiple after blocks, which specify how the data will change, in the sync block. Below is an example of a bulk insert request.

<ns0:parameters xmlns:ns0="http://www.cdata.com/QuickBooksOnlineProvider/2019">
  <ns0:sync>
    <ns0:before></ns0:before>
    <ns0:after>
      <ns0:Customers GivenName="GivenName_1" AnnualRevenue="10" /> 
    </ns0:after>
    <ns0:after>
      <ns0:Customers GivenName="GivenName_2" AnnualRevenue="20" /> 
    </ns0:after>
  </ns0:sync>
</ns0:parameters>

Bulk Update Schema

A bulk update updategram has multiple before and blocks in the sync block. A before block specifies which columns to update. An after block specifies how the data will change. Below is an example of a bulk update request.
<ns0:parameters xmlns:ns0="http://www.cdata.com/QuickBooksOnlineProvider/2019">
  <ns0:sync>
  <ns0:before>
    <ns0:Customers Id="Id_1" GivenName="GivenName_x" AnnualRevenue="10" /> 
  </ns0:before>
  <ns0:after>
    <ns0:Customers Id="Id_1" GivenName="GivenName_y" AnnualRevenue="20" /> 
  </ns0:after>
  <ns0:before>
    <ns0:Customers Id="Id_2" GivenName="GivenName_x" AnnualRevenue="10" /> 
  </ns0:before>
  <ns0:after>
    <ns0:Customers Id="Id_2" GivenName="GivenName_y" AnnualRevenue="20" /> 
  </ns0:after>
  </ns0:sync>
</ns0:parameters>

Bulk Delete Schema

A bulk delete updategram has multiple before blocks, which identify the items to be deleted, and empty after blocks. Below is an example of a bulk delete request.
<ns0:parameters xmlns:ns0="http://www.cdata.com/QuickBooksOnlineProvider/2019">
  <ns0:sync>
    <ns0:before>
      <ns0:Customers Id="Id_1"></ns0:Customers>
    </ns0:before>
    <ns0:before>
      <ns0:Customers Id="Id_2"></ns0:Customers>
    </ns0:before>
    <ns0:after></ns0:after>
  </ns0:sync>
</ns0:parameters>

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