How to work with composite records handling in a QuickBooks source component.

How to work with composite records handling in a QuickBooks source component.

The composite record output contains not only fields from the composite record, but also the parent records. The output will be populated with sets of records, one set for each parent record. Each set of records is separated with a blank row (all NULLs).

In order to retrieve the composite data for the Quickbooks Desktop version, you must include an element similar to the following in the ObjectFilter parameter:


1
2
3
<InvoiceQueryRqType>
  <IncludeLineItems>true</IncludeLineItems>
</InvoiceQueryRqType>

The example above will retrieve item objects associated with the invoice objects.

For additional information about modelling of composite records in SSIS+, please refer to this article.