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.
Book a Presales Call
Related Articles
How to work with composite records handling in a QuickBooks destination component.
The composite record input accepts sets of records, one set for each parent record. Each set of records must be separated with a blank row (all NULLs). The parent object will not finish processing its record until all composite object children have ...
How to work with composite records handling in a REST 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 rows, one set for each parent record. Each set of rows is separated with blank row (all NULLs). ...
How to work with composite records handling in a Dynamics GP source component.
The composite object output contains not only properties from the composite record, but also the parent record. The output will be populated with sets of records, one set for each parent record. Each set of records is separated with blank row (all ...
How to work with composite records handling in a Sage source component.
The composite record output contains not only properties from the composite entity, but also the parent entities. The output will be populated with sets of records, one set for each parent record. Each set of records is separated with blank row (all ...
How to work with composite records handling in a MongoDB source component.
For each array in the document, regardless of the depth of nesting, there will be created a composite output that enables retrieving the field values of its items. This output contains not only the fields of the array items, but also the fields from ...