2022
Note: Knowledge of QuickBooksOnline and QBXML is required for mapping and creating process for integrating with QuickBooksOnline
QuickBooks Online Adapter provides interfaces for
You can build the queries of QBOE Adapter from the Reader Section of the Process Definition. You can build the queries similar to SQL, which includes the straightforward query.
Reader Query Examples:
Customer 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
Note: Refer the filters from the QBXML, which is available in DBSync2 Conf folder. The XML Structures of all QBOE Objects are specified in this file.
ItemService Query
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
Other items such as ItemNonInventory, ItemInventory, ItemDiscount are not supported in QuickBooksOnlineEdition.