How to specify ObjectFilter on QuickBooks Source Component for QuickBooks Online?

How to specify ObjectFilter on QuickBooks Source Component for QuickBooks Online?

For ObjectFilter you should specify a WHERE clause statement that is similar to SQL Syntax. Only the part that is in the WHERE clause should be included.

Examples:

TxnDate = '2020-09-29'
Active in (True, False)
CustomerRef ='123'
Active=true
TotalAmt>'1000.0'
CompanyName='Adam\'s Candy Shop'
GivenName='Greg'
GivenName LIKE 'K%h'
GivenName LIKE 'Palm%'





    • Related Articles

    • Where can I find the documentation for the Quickbooks Online Connection?

      You can find documentation related to all the COZYROC SSIS+ Component Suite components from the main products page.  Specific documentation for the Quickbooks Online Connection can be found at the following link.  For many of the components you can ...
    • Where can I find the documentation for the QuickBooks Source?

      You can find documentation related to all the COZYROC SSIS+ Component Suite components from the main products page.  Specific documentation for the QuickBooks Source can be found at the following link.  For many of the components you can find ...
    • Where can I find the documentation for the QuickBooks Destination?

      You can find documentation related to all the COZYROC SSIS+ Component Suite components from the main products page.  Specific documentation for the QuickBooks Destination can be found at the following link.  For many of the components you can find ...
    • 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 ...
    • How to get QuickBooks Online Token

      The token setup process is organized as a wizard consisting of two steps Step: Authorize COZYROC SSIS+ to connect to specific QuickBooks instance. If the token retrieve succeeds, the second wizard step will have the access token, secret and realm ...