QuickBooks Data Extraction Queries
QuickBooks Queries
Knowledge of QuickBooks and QuickBooksXML is required for mapping and creating a process for integrating with QuickBooks.
QuickBooks 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 QuickBooks or QuickBooks Desktop Adapter from the Reader Section of the Process Definition. You can build queries similar to SQL, which includes the straightforward query.
Reader Query Examples:
Customer Query
The following is a query to extract all Customers in batches of 100 that have been changed since the last successful run of the process.
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.
ItemService Query
The following is a query to extract all ItemService in batches of 100 that have been changed since the last successful run of the process.
Other items - such as ItemNonInventory, ItemInventory, ItemDiscount - are not supported in QuickBooks Online Edition.
Complex query with a join
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.
Last updated