Page History

QuickBooksOnline SQL Queries

Note: Knowledge of QuickBooksOnline QuickBooks and QBXML is required for mapping and creating process for integrating with QuickBooksOnlineQuickBooks

QuickBooks Online Adapter provides interfaces for

• Reader: reading from QuickBooksOnline QuickBooks with a SQL like query
• Writer: writing into QuickBooksOnlineQuickBooks
• Metadata query: navigating through QuickBooksOnline QuickBooks objects

You can build the queries of QBOE or QB 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 in batches of 100 which have been changed since the last successful run of the process.

select * from Customer where Customer.MaxReturned=500

• MaxReturned suggests how many records to be retrieved from QuickBooksOnlineQuickBooks.
• FromModifiedDate suggests the filter for selection the Customers which 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 QBXML, which is available in DBSync2 Conf folder. The XML Structures of all QBOE QB Objects are specified in this file.

...

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

Select * from ItemService where ItemService.MaxReturned=500

...