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=trueTotalAmt>'1000.0'CompanyName='Adam\'s Candy Shop'GivenName='Greg'GivenName LIKE 'K%h'GivenName LIKE 'Palm%'
Book a Presales Call
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 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 ...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 ...