Page History

...

QuickBooks Online Adapter provides Desktop" adapter/connector provides interfaces for:

• Reader: reading from QuickBooks with an SQL like query.
• Writer: writing into QuickBooks.
• Metadata query: navigating through QuickBooks objects.

You can build the queries of QuickBooksOE QuickBooks or QuickBooks Desktop Adapter from the Reader Section of the Process Definition. You can build the queries similar to SQL, which includes the straightforward query.

...

The following is a query to extract all Customer Customers in batches of 100 that have been changed since the last successful run of the process.

selectSelect * from Customer where Customer.MaxReturned=500
100 and Customer.FromModifiedDate=$last_success_run

• MaxReturned suggests how many records to be retrieved from QuickBooks.
• FromModifiedDate suggests the filter for selection Customers that are edited or created after the previous sync run.
• $last_success_run is a process specific variable that gets setup whenever the ETL process is successfully completed.

Note: Refer the filters from the QuickBooksXML. This is available in DBSync2 Conf DBSync On-Premise version under this DBSync2\src\www\WEB-INF\conf folder. The XML Structures of all QuickBooks Objects are specified in this file.

...

Select * from ItemService where ItemService.MaxReturned=500
100 and ItemService.FromModifiedDate=$last_success_run

Complex query with a join

select * from Invoice,Customer where Invoice.MaxReturned=500100 and Invoice.ModifiedDateRangeFilter.FromModifiedDate=$last_success_run
and Invoice.IncludeLineItems=true and Invoice.OwnerID=0 join on Invoice.CustomerRef.FullName=Customer.FullName

The above query joins Invoice and Customer QuickBooksXML responses into one XML. As a result, the transformation engine can avoid multiple processes. This is done to optimize data flow to and from QuickBooks.