Tags: 
1.6, Component, Source, QuickBooks

Overview

The QuickBooks Source Component is an SSIS Data Flow Component for consuming data from the QuickBooks service. The configuration parameters are provided in the standard data flow component dialog. A separate output is setup for the main object and each related composite object.


Demonstration


    Setup

    Use the parameters below to set up the component.

    Parameters

    Select an existing QuickBooks connection manager.

    Related Topics: QuickBooks Connection Manager

    Specify the number of rows to be retrieved as a batch. Default is 1000.

    Select a QuickBooks object.

    Edition Description
    Desktop

    Specify query XML. The query should be the same XML format used to serialize QuickBooks query. For example to retrieve all employees with a name starting with "John", use the following query:

    Online

    Specify the WHERE clause of the QuickBooks Online SELECT statement used to retrieve data.


    FAQ

    The composite object output contains not only fields from the composite object, but also the parent objects. 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:

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

    The source object, query and parent are available in the data flow properties list. Follow these steps to set up an expression:

    • Right-click on the data flow canvas and select the Properties menu.
    • Scroll down and find the property named like [QuickBooks Source].[ObjectFilter]. This is the property containing the query.
    • Scroll down and find the Expressions property. Set up an expression to modify the query dynamically.

    Related documentation